CODEWITHSUNDEEP
asp.netreporting-servicesssrs-2008-r2
par
par

Reputation: 1121

Hide textbox on export

I have one textbox in SSRS report which I need to hide on export. I added expression for Hidden property to =IIF(Globals!RenderFormat.Name <> "RPL", True, False). but it always hiding textbox in ReportViewer as well as any type of export file.
Currently I have temporary fixed using = IIF(Globals!RenderFormat.IsInteractive OrElse Globals!RenderFormat.Name = "MHTML", False, True)
but wondering Why the first expression not working? and what is the solution for it?

Edit: Globals!RenderFormat.IsInteractive working. Globals!RenderFormat.Name = "MHTML" is not working so main statement stricked out in original post.

Upvotes: 0

Views: 443

Answers (1)

alejandro zuleta
alejandro zuleta

Reputation: 14108

While it is not explicitely detailed in the documentation. Globals!RenderFormat.Name is only accessible during different parts of the processing and rendering cycle.

On the other hand Globals!RenderFormat.IsInteractive is populated before the render request, hence before the Hidden property expression of your textbox is evaluated.

Check these links:

REFERENCE 1
REFERENCE 2

Let me know if this helps.

Upvotes: 2

Related Questions