CODEWITHSUNDEEP
reporting-servicespivot
JackSmith
JackSmith

Reputation: 55

SSRS Dynamic Pivot Format Columns

I have a report that uses the Matrix to create a pivot on my data. The data looks like this

enter image description here

The report looks like this

enter image description here

The pivot is on the Question column. When I export this report to excel I want the columns with Score to format as number and not as text. How can I do this?

Thanks.

Upvotes: 0

Views: 325

Answers (2)

zoe zhi
zoe zhi

Reputation: 164

If you don't need calculate in Excel, just want to show number in right of cell(text is show in left), you could use expression like below in TextAlign properties(=IIF(IsNumeric(Fields!answer.Value), "Right","Left"))

enter image description here

And other workaround is that you could change this in Excel (click cell to change type manually)

Zoe

Upvotes: 1

junketsu
junketsu

Reputation: 531

do make sure to do this to each cell. Once you do it to one cell; you can go down to properties window towards the bottom right and look for 'Format' property; the actual format value should be stored there. That way you can just copy paste the format on desired cells. enter image description here

Upvotes: 0

Related Questions