Multiple select queries in One report - not subreports

[MattDavies51]

Hi
I am using SQL Server 2000/ Crystal Reports 8.

I have a stored procedure with 3 select statements returning 3 recordsets of data.

Is it possible to display all 3 in a Crystal report without having to split into 3 stored procedures/3 subreports?

Also, I dont want to use a union statement.

Any help will be appreciated.

Matt

 

[synapsevampire]

If you're using an SP, just append the 3 selects into a temp table and then do a select from the temp at the end of the SP.

Crystal does not handle multiple datasets from a single source.

-k