Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

display dataset query in report Expand / Collapse
Posted Sunday, November 4, 2012 11:25 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, March 12, 2014 5:45 AM
Points: 1,231, Visits: 84

1.How to display report dataset query in main report.pls any one give right information.

Post #1380882
Posted Tuesday, November 6, 2012 3:49 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, September 15, 2014 10:10 AM
Points: 46, Visits: 230
Hi Vivek,

I was going to point you to the SQL Reporting stairway series

Unfortunately I've just noticed its SQL Reporting 2008
Post #1381473
Posted Tuesday, November 6, 2012 3:51 AM



Group: General Forum Members
Last Login: Today @ 6:49 AM
Points: 5,216, Visits: 5,110
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.

Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger

Post #1381474
Posted Tuesday, March 5, 2013 7:43 PM



Group: General Forum Members
Last Login: Saturday, September 27, 2014 5:20 AM
Points: 467, Visits: 868
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.
Post #1427126
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse