Last post Jun 22, 2011 11:14 PM by You-Hu Fu
Jun 21, 2011 10:15 PM|hkbeer|LINK
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
Jun 22, 2011 11:14 PM|You-Hu Fu|LINK
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
Hope this helps