Hi
I created a report that export to multiple excel worksheets using this helpful link( http://stackoverflow.com/questions/462902/reporting-services-export-to-excel-with-multiple-worksheets)
The problem is that the client wants some columns be hidden on some worksheet.
To be more clear there are 6 columns(months) in 6 worksheet showing sales Volume, if we run the report in March, the March worksheet should just show February column while November should show 6 columns for 6 months.