I would like to exclude a column from the output when the report is printed, but have the column remain visible on the web page view. Any ideas on how this can be done?
Thanks in advance.
asked Feb 21, 2012 at 06:56 PM in Default
But it is definitely possible in 2008 R2 though. :) Globals!RenderFormat.Name can be used against Hidden property expression. Sadly, the OP is using ssrs 2008.
answered Feb 22, 2012 at 02:20 PM
Don't know about any automatic way, but you can can mae a clicable element in the report which will show or hide the column when clicked. Then prior printing you can hide the column.
Other possibility could be have one report for displaying with the column visible and second with column hidden. (this can be easily done by single report - introducing a hidden parameter which will specify whether column is showed or hidden and then create a Linked Report with different parameter setting from default - eg. default value wihll show the column, overriden value from linked report will hide the column).
answered Feb 22, 2012 at 07:07 AM
Pretty certain there is no way to do this via Reports Manager, if you are accessing the reports via a custom application then you could do it programmatically via code behind the Print button.
I'm actually not 100% sure that Pavel's solution will work, something makes me think that when you print all areas are expanded.
answered Feb 22, 2012 at 02:11 PM