Having Multiple SPs

[CRNew]

Hi,

I am using Crystal Report 8.5 and connecting it to Informix database.

In my report I want to use 2 SPs. I have included them in the report. However, through the visual linking expert I have not created any connection between them.

I want to know if any one of you have used a similiar kind of a thing? In my report the order in which the SPs have been added produces different results. SP1 will always get me 1 row and SP2 will give me multiple records.

In the report if I add SP1 first then in the report I get only 1 record from the execution of SP2 also, even though it might be getting multiple records.
And if I add SP2 first then if SP2 is not returning anything then I dont get the values being returned from SP1. Why ???

I have included the SP1 fields in report header and SP2 fields in details section.

Thanks,

 

[synapsevampire]

Crystal expects a single recordset, not several.

If you want to display 2 recordsets in a single report, create a subreport for one of the SP's and include it in the Main report.

Otherwise create a single SP to return data.

-k