InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 14:04:30 GMT20http://www.sqlservercentral.com/Forums/Topic1380882-1063-1.aspxWhat is the query in the report? Can you post it here?If the report is a static query, just create a text box and paste the query in there. If the query is a stored proc then that won't work, and what Anthony suggested won't work either because the XML will just give you the stored proc command.If the query has parameters, you can use an expression to build a string with the query="select columns from table where field = '" + Parameters!Parameter1.value "'"Why do you want to do this? Most users should not be looking at the query, just it's results. If you want to show what parameters have been selected, just add them to the report header or text boxes like "Parameters!Parameter1.value"If it's for debugging purposes then why not just intercept the query in SQL Profiler.Tue, 05 Mar 2013 19:43:16 GMTdavoscollectivehttp://www.sqlservercentral.com/Forums/Topic1380882-1063-1.aspxAre you any good in shredding XML? If so, build a second data set which uses the global report name parameter and query the reportserver database for the XML of the report your using then get it to pull out the correct nodes of the XML for the T-SQL dataset you want to show in the report.Tue, 06 Nov 2012 03:51:22 GMTanthony.greenhttp://www.sqlservercentral.com/Forums/Topic1380882-1063-1.aspxHi Vivek,I was going to point you to the SQL Reporting stairway series [url]http://www.sqlservercentral.com/stairway/72382/[/url]Unfortunately I've just noticed its SQL Reporting 2008Tue, 06 Nov 2012 03:49:23 GMTDon.http://www.sqlservercentral.com/Forums/Topic1380882-1063-1.aspxHi,1.How to display report dataset query in main report.pls any one give right information.Thanks,Vivek.Sun, 04 Nov 2012 23:25:12 GMTviveksvkola