CODEWITHSUNDEEP
reporting-servicesssrs-2008-r2
user2171512
user2171512

Reputation: 561

How to show show or hide text boxes in SSRS

How can I show or hide text boxes when i export to CSV or EXCEL in SSRS ?

I have parameter called Reports_Export which tells to show or hide those text boxes when i export to csv or excel.

If Reports_export = 1 show otherwise hide when export.

Upvotes: 1

Views: 1528

Answers (1)

Sébastien Sevrin
Sébastien Sevrin

Reputation: 5405

Hide a TextBox based on an expression

  1. Right click on the TextBox => Text Box Properties
  2. In Visibility, select Show or hide based on an expression
  3. Enter your formula

If you want to hide the Text Box based on the output format, you may consider using the Globals!RenderFormat.Name variable.

Example:

=Iif(Globals!RenderFormat.Name = "CSV" Or Globals!RenderFormat.Name = "EXCEL", True, False)

Here is an article on this:

That way you won't rely on a parameter to hide the elements.

Upvotes: 3

Related Questions