Monday, December 1, 2014

SSRS Parameters\Filters should be displayed only in print.

My business users wanted to display parameters(Country, Street, Phone) on the page header only when it is printed and they do not want to show it while rendering the SSRS report.

To achieve this I did the following

1) Inserted a rectangle in the page header and added the parameters.
2) In the rectangle properties -> Visibility -> Enable Show hide based on an expression.
3) In the expression window add the following expression and save the report.
=IIF(Globals!RenderFormat.Name = "IMAGE", False, True)

Thus the country, street and phone parameters are shown only during print and they are not shown during report rendering.

Hope this helps!!!

No comments:

Post a Comment