CODEWITHSUNDEEP
reporting-services
anonymous
anonymous

Reputation: 65

Hide Column on Display, Show on Export ssrs

I want to Hide Column on Display, Show on excel Export SSRS On visibility options,I have used expression

=IIF(Globals!RenderFormat.Name = "Excel", True,False)

But on preview it still appears.

Upvotes: 2

Views: 3663

Answers (2)

Louie
Louie

Reputation: 538

I have just tested your expression on my machine. The reason why it doesnt work is because the value is case sensitive. To fix, right click the column you want to hide > Visibility > Show or hide based on an expression

Instead of:

=IIF(Globals!RenderFormat.Name = "Excel", True,False)

Use:

=IIF(Globals!RenderFormat.Name = "EXCEL", True,False)

Upvotes: 3

bitnine
bitnine

Reputation: 1782

Note that the visibility description reads:

Set expression for: Hidden

So having this evaluate to true when exporting to Excel will cause it to be hidden in that case.

Additionally, depending on the version of SSRS being used the Excel renderer may be for EXCEL or EXCELOPENXML.

Upvotes: 1

Related Questions