ReportViewer: Datasource Structure keeps changing. What can I do ? RRS feed

  • Question

  • User-775831949 posted

    I have a ReportViewer. I have a sqldatasource and its SQL is on-demand. ie, on buttonclick, sqldatasource.selectCommand = "Select XXX", meaning the SQL and so the structure of output keeps changing. I want the ReportViewer to display this changing SQL results.

    Is there a good reference showing how to do this ? Is this even possible for ReportViewer ? Thanks


    Tuesday, June 21, 2011 10:15 PM


  • User1471008070 posted

    Hi hkbeer,

    There is no build-in feature to support this requirement in reporting services, as we cannot change the field on the table dynamically at report's run time. To work around the issue, you can refer to this work around at this link http://sqlserverbiblog.wordpress.com/tag/ssrs-dynamic-columns/ 

    Hope this helps

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Wednesday, June 22, 2011 11:14 PM