Hello,

I am converting a  Crystal report tied to an Access database to point to a SQL Server stored procedure.

The stored procedure has 2 select statements in it that return different number/types of fields, so I can't do a union.

The crystal report only sees the result set from the 1st select statement, not the 2nd.

How can I get Crystal reports to see these two select statement return sets, without creatinga temp table in the stored procedure and dumping the results of the 2 select statements in it?

Thank you,

Burak