Hi 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. Kanth itdiligent

The below links may help http://www.codeproject.com/KB/reporting-services/DynamicReport.aspx http://social.msdn.microsoft.com/forums/en-US/sqlreportingservices/thread/3d554275-4be5-46f6-9c90-9568011a9b98 http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/276e4eec-b434-43ea-bd64-182334f39266 http://sivakrishnakuchi.blogspot.com/2010/02/how-to-show-dynamic-columns-in-sql.html

i already gone through those links..i couldn't find anything related to my problem. please suggest me any other solutionKanth itdiligent

I am afraid , there is no other solution for this scenario. BTW cant you add the columns and make the visibility based on the number of columns in the output as mentioned in the first link ?

Can any one tell me is that possible with other ways like C# programming..etc. if it is possible tell me how to do?Kanth itdiligent

Hi Kanth, I strongly recommand that you change the stored procedure without any pivot function, and then use Matrix control to populate the data. The table can't control the dynamic dataset fields in the current reporting services. thanks, Jerry