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
UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: Wednesday, January 7, 2015 12:55 AM
Points: 1,463, Visits: 86
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
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, July 8, 2015 9:01 AM
Points: 53, Visits: 261
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: Yesterday @ 2:36 AM
Points: 5,225, Visits: 5,143
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


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Tuesday, July 14, 2015 4:36 PM
Points: 544, Visits: 946
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