Multiple Queries in Reports

Question

Multiple Queries in Reports

venkatarami.desireddy

Old Hand

Points: 308
More actions
March 21, 2009 at 7:34 am

#384181

How generate reports from multiple queries

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Gift Peddie SSC Guru Points: 73570 More actions · Answer 1

You have two options use Subreports to execute the other queries or use sp_executesql to call your other queries, there maybe other options but these two are standard operations.

Kind regards,
Gift Peddie

Martin Stephenson SSCrazy Points: 2950 More actions · Answer 2

Using SSRS you can have multiple datasets each with an individual query, you can even have them querying separate database servers

SSSolice SSCommitted Points: 1907 More actions · Answer 3

From within BIDS - Report Designer, on the Data tab click the dataset drop-down and choose new dataset to create as many datasets (queries) as needed. Each query may then be associated with different elements of your report(s). For example, a single report may have multiple tables each with its own dataset (query). HTH.