Multiple result sets _OR_ multiple non-nested groups in Crystal Reports.
Posted on 2008-09-29
I've got a MS SQL 7 Stored Procedure.
It creates 7 temporary tables for its operation.
6 of these are returned as multiple result sets.
I would like to report upon the result sets in Crystal Reports.
The stored procedure generates snapshot data so I cannot run it 7 times and each time ask for a different result set.
I suppose I COULD store the result sets tagged to the user on the first run and each other run return the different set, but what a palaver!
I think that CR does _NOT_ support multiple result sets. At least that is what I've seen in action (no way to indicate multiple sets and in EE and Google searching).
So, I think my only option is to create a unified single result set with a marker to indicate the result set.
If that is the only way, how do I get different headers for each marker to indicate a different result set.
The result sets are not the same, so there would be lots of dead columns per marker.
Assuming this is the only way to go, how do I create multiple sections in CR so that section 1 is for marker 1, section 2 is for marker 2, etc.
Some markers may be empty, some over multiple pages, etc. A bit like sub reports but for a single stored procedure.