I have a report created in SSRS 2005.
Issue is that I am getting dynamic number of columns returned from my stored procedure.
For ex, Col1, col2 are static whereas col3, col4, col5 are dynamic. They may or may not appear in resut set.
This would be decided at run time.
How to do this using matrix report in ssrs?