Stored procedure returning multiple tables

[stuartgmilton]

Hey guys,

So, I'm completely stuck!!

I require my report to be based on a stored proc, this is so it can create a temporary table which the report will in effect be based on. This table will contain the time frame for the report. However, I require to report on multiple datasets ie project, bids and resources seperatly, so I though I could return 3 table types out of the stored proc? I hope someone understands what I mean??

Oh the temporary table is linked using left outer join to my projects or bids or resources table.

Help....
Stu

 

[synapsevampire]

No, one recordset is all that Crystal handles.

Posting technical information is key, we have no idea what data is being returned by the SP, nor the output required, or even the basic version of Crystal and the database being used.

I suggest that you create a single recordset out of the data, which is often the point of using an SP in Ccrystal.

If you want good help, show examples of what the SP is returning and what you need to supply in the report.

-k