CODEWITHSUNDEEP
reporting-servicesexport-to-excel
Alex
Alex

Reputation: 15

SSRS - different values in exports

is it possible to export other values to Excel than displayed in the report?

For Example: Report Displays Hours (5) -> Export shows Minutes (300)

thank you in advance

Upvotes: 1

Views: 212

Answers (1)

BJones
BJones

Reputation: 2460

This works for SSRS 2012 and Excel 2016. Use an expression in the text box that you want to change.

=IIF(Globals!RenderFormat.Name = "EXCELOPENXML","Minute Value","Hour Value")

Upvotes: 2

Related Questions