November 4, 2012 at 11:25 pm
Hi,
1.How to display report dataset query in main report.pls any one give right information.
Thanks,
Vivek.
November 6, 2012 at 3:49 am
Hi Vivek,
I was going to point you to the SQL Reporting stairway series
http://www.sqlservercentral.com/stairway/72382/
Unfortunately I've just noticed its SQL Reporting 2008
November 6, 2012 at 3:51 am
Are 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.
March 5, 2013 at 7:43 pm
What 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.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply