Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2008 Forums  Analysis Server and Reporting Services (2008)  dynamic columns in SSRS

Author  Topic  nidabp Starting Member 15 Posts Posted - 2011-05-04 : 06:37:32 Hi, My report should show the data from the current month to May of last year. For eg. If the current month is feb, the data to be shown in the report are feb2011data, jan2011data,....June2010data,May2010data. Currently my approach is to have static column headers having the columns as apr2011data,mar2011data,.....May2010data.The hide logic (along with the year name) is written in the code of the report, and called in the visibility expression of the column headers. The problem with the above approach is that I am unable to export the report to csv as columns with hide/show logic are ignored and exported csv files does not have all the columns, properly exported. Can anyone please suggest me a method to get the required columns with out hide/show logic. (might be to have my dataset containing all the headers as well as data...not sure of how to have them populated as column headers) Thanx