In SQL Server Reporting Services, how do I display the hidden columns when printing or downloading as a file (csv, pdf etc) -

I have a situation where I need to hide the report column, but when the file is printed or Downloading requires columns to be displayed. Hiding the columns is not a problem, it's just that there is no way to display hidden columns when printed / downloaded.

I do not want to create 2 separate reports for this.

Thanks

Whatever I do in these situations, for the report Creating the parameter that says something like "Display hidden columns"? Or "Show Printable View?" And then wire the visibility property of that column to the column. Yes, they may have to run the report again, but it keeps you in for a separate report yourself