Hi All !
from this forum only i got help in developing dynamic sql query to render different result sets with dynamic columns.
Now i would like to design a layout for this report.
The sql query is a Stored Procedure, having 2 parameters, a date and variable. on execution will result in either 6 cols or 5 cols based on the value passed to the variable.
Here i tried to use this SP as a dataset in ssrs, but no columns are displayed as they appear only at the time of execution. Now i need some guidance here how to design a layout for such reports??
Kindly do help me !!
Thanks,