display dataset query in report

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Reporting Services » Reporting Services 2005 Development » display dataset query in report

display dataset query in report

Rate Topic

Display Mode

Topic Options

Author

Message

viveksvkola

Posted Sunday, November 04, 2012 11:25 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, May 09, 2013 10:37 AM
Points: 146, Visits: 75

Hi,

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

Thanks,
Vivek.

Post #1380882

Don.

Posted Tuesday, November 06, 2012 3:49 AM

SSC Rookie

Group: General Forum Members
Last Login: Friday, April 05, 2013 2:38 AM
Points: 35, Visits: 179

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

anthony.green

Posted Tuesday, November 06, 2012 3:51 AM

SSCertifiable

Group: General Forum Members
Last Login: Friday, April 12, 2013 3:51 AM
Points: 5,075, Visits: 4,831

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

davoscollective

Posted Tuesday, March 05, 2013 7:43 PM

SSC-Addicted

Group: General Forum Members
Last Login: Today @ 8:01 PM
Points: 408, Visits: 688

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 »

Permissions