question

Tony Bater avatar image
Tony Bater asked

Non-printing objects in Report Builder 3?

I raised this subject last week in the Reporting Services 2008 Development forum but have not yet had any replies. So I will try here! Is it possible to set the properties of an object on an SSRS report so that it is not rendered when printed or exported to PDF? I am duplicating some pre-printed report pro-formas, and I have a 'command button' which invokes a sub report which I do not want to be visible when the report is printed or exported to PDF. The only elements I want visible on printouts are those on the original pro-formas. Does any one have any ideas on how I may accomplish this? Any suggestions would be welcome.
ssrsreport-builder
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

I was hoping for some sort of global report variable which may indicate that the status is 'printing' or 'exporting'
0 Likes 0 ·
WilliamD avatar image
WilliamD answered
The only way that I know would work, would be to have a parameter, defaulting to "view". This would be used to control the visibility of the items you want to hide. You set their visibility according to how the parameter is set. When you want to print, and hide these items, you offer a hyperlink called print, which calls the same report again but sets the paramter from "view" to "print" and thus hides the items you want to hide. It is a little clunky, but the only way I know of that would achieve what you want to do.
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Thanks for this answer. I can see how that would work. I might try adding a 'Command button Status' parameter (values show/hide, and then suers can make their choice beofre running the reports. Tony
0 Likes 0 ·
Remeli avatar image
Remeli answered
You can use an expression for the "Hidden" property of an object. If you put "**=Not(Globals!RenderFormat.IsInteractive)"** as the formula SSRS then renders the object only when you show the report on the screen but hides it when printing or exporting to PDF or XLS. It's working for me with SSRS 2008 R2.
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.