In an existing SSRS 2008 r2 report, I have a question about how to display certain columns: 1. I want selected columns to display when running the SSRS reports, 2. I want the columns in the ssrs report plus 4 other columns displayed when the report is exported to excel. 3. I want a subset of columns selected when the ssrs report is exported as a PDF document.
Thus can you tell me if what I am requesting is possible? If this is possbile, can you tell me, show me, and/or point to a url that explains how to accomplsh this task?
1. you can either add them as static columns and then add expression for visbility property to determine which of them needs to be hidden and which of them to show. 2.you can add place holders for that in the report for 4 columns. what will they be displaying? static text or parameter based info? 3. you need to add a separate version of report with only the required columns for that. then call report through URL with format being passed as PDF.
The above points all are based on static column selection. If you attempt is to have maximum flexibility and choose columns at run time etc then you need to use report builder application to create the report. For that you need to have a report model being deployed to the server.