I have a stored procedure which is built on PIVOT fuction. I am using the stored procedure to generate a report.
some time the stored procedure will generate the variable no of colomns, in ssrs dataet is updating with variable no of colomns, at that time report is not supporting.
i am using table control in SSRS. some one suggested me matrix control, but i need to change my stored procedure to work with matirx control.
i dont want to change the stored procedure.
can any one suggest me how to resolve this in SSRS.
View Complete Post