SQLTeam.com | Weblogs | Forums

Multiple queries in one SSRS report


Hi all,.

I'm looking for a way to run multiple SQL queries in one SSRS report.

For example:

I want to have a report show the number of shipments we had in a given month, that number would hyperlink into a detailed version that would show PART NUMBER, CUSTOMER, etc.

I think it's pretty straight forward but am having a hard time figuring it out in SSRS.



SSRS allows you to have multiple data sets in one report. You can have a drill-through report, or sub-report. It sounds like what you need might be a sub-report. There are tutorials available on the web that walks you through the process.