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.
| Author |
Topic |
|
nidabp
Starting Member
15 Posts |
 Posted - 2011-04-25 : 06:06:08
|
| 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 asapr2011data,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 |
|
|
ajthepoolman
Constraint Violating Yak Guru
384 Posts |
Posted - 2011-04-25 : 08:53:58
|
| Have you tried using the matrix control?Hey, it compiles. |
 |
|
|
|
|
|
dynamic columns in SSRS