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
Author
Message
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,203, Visits: 84
Hi,

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

Thanks,
Vivek.
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: Thursday, July 24, 2014 6:30 AM
Points: 46, Visits: 229
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
Post #1381473
Posted Tuesday, November 6, 2012 3:51 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Wednesday, August 27, 2014 8:53 AM
Points: 5,218, Visits: 5,072
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


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Tuesday, August 12, 2014 10:57 PM
Points: 458, Visits: 857
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