Convert DataList to Pivot mode

ReportServer (EN)
1

Hi,

I have converted the DataList view to Pivot mode to display the graphic report.

But when I converted then I go to Pivot/Preview and then the refresh symbol always refresh. Sometime it displays the connection time out (there is no problem to display as DataList)

I really appreciate for your help.

Best Regards,
Sothea

2

Hi Sothea,

did you configure the report to be used in pivot mode? When using a Dynamic List in pivot mode you must define which attributes are dimensions and which are measures. Have a look at https://reportserver.net/en/guides/user/chapters/Pivot-Mode-of-the-Dynamic-List/ for more information.

Regards,
Thomas

3

Hi Thomas,

I read the instruction but still can’t convert to pivot mode. I defined measure and dimensions but still not preview the data (it displays refresh page).

Would you please give me some simple step to generate the pivot?

I really appreciate for your help.

Best Regards,
Sothea

4

Hi Sothea,

could you prepare a couple of screenshots explaining the problem?

Best Regards,
Thomas

5

Hi Thomas,

I have the following data:

Bundle Name Price
10 GB Unlimited 2000
10 GB Unlimited 2000
2GB + 2GB Package 1000
Daily Unlimited Package 1000
10 GB Unlimited 2000
2GB + 2GB Package 1000

When preview as list, it displays the data in the list. But when I convert it to pivot mode, then when I go to Pivot/Preview there is refresh icon that always display the refresh.

On the other hand, I don’t know how to upload image to the forum.

I really appreciate if you can explain me on how to use the pivot mode.

Best Regards,
Sothea

6

To upload files to the forum, upload them to an image server (for example, http://snag.gy/). You can then embed images via

[img]URL TO IMAGE[/img]

Cheers,
Arno