Hide SSRS Report Items while exporting...

While exporting to PDF, EXCEL or any other format in SSRS report, we may need to hide some images or some contents of the report.
We can set the Visibility of that report content using the below expression for the "Show or hide based on an expression" option

=IIF(Globals!RenderFormat.Name="EXCEL" OR Globals!RenderFormat.Name="PDF", true, false)

Here I just set the visibility for EXCEL and PDF format only, but you can add other formats as well.

Also please note the if it is not working for render format value as "EXCEL", check it with Globals!RenderFormat.Name="EXCELOPENXML"

No comments:

Post a Comment

Stop running SSIS Script Task after some time...

There is a SSIS Script Task which use to run another program. But due to the errors in the other program, some times script task is in the ...