Sometimes we dont know the number of columns in a ssrs report at design time and would like to be able to generate columns and rows dynamically during runtime similar to crystal reports.
Though this is not directly possible with SSRS report builder (or visual studio SSRS reports project), the workaround is to generate .rdl file dynamically. rdl files are xml files and hence can be easily generated using code.
The following download is one such sample C# project.
http://gotreportviewer.com/DynamicTable.zip
Though this is not directly possible with SSRS report builder (or visual studio SSRS reports project), the workaround is to generate .rdl file dynamically. rdl files are xml files and hence can be easily generated using code.
The following download is one such sample C# project.
http://gotreportviewer.com/DynamicTable.zip