SQL that generates multiple result sets
Hi All, I've created a report (via Report Wizard) wherein the query will generate 1 or more result sets, all with the same columns. However when I run the report, only the 1st resultset is displayed. How can I get all of them displayed as separate tables, one after the other? Sincere thanks in advance, Tamim. T Sadikali
March 10th, 2011 12:58pm

There is no way to do what you are wanting to do. Reporting Services will only look at the first result set. You will need to break your query into seperate queries and create one dataset for each query.Russel Loski, MCT
Free Windows Admin Tool Kit Click here and download it now
March 10th, 2011 1:29pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics