Two Stored Procedures in single Crystal Report

[former_member309127]

Hi,

I have two Stored procedures in one crystal report. Both having same parameters.
But when One stored procedure data is NULL then other stored procedure data is not visible on report which has data in it.

If I do Browse Data for another stored procedure which has data then the data is clearly visible in Browse Data Dialogue box but not on report.

For example, refer the attached report link : https://drive.google.com/open?id=0By-_z66pGEGrb3RtVHd6cTNPLXc

[former_member292966 · Accepted solution]

Hi Sailee,

Crystal doesn't like using 2 stored procedures in the same report. Crystal was designed to work with relation databases using standard relational sql. You can't call two procedures in a query and link the same as you can with tables or views. The same is with Crystal.

The procedures return a result set but after that, from a SQL point of view, they can't be linked. You should have gotten a message from the Database Expert when you added the second procedure.

If you can, use a subreport for the second procedure.

Brian

[former_member309127]

Thank you Brian And Abhilash for your feedback. I managed to avoid such situations.

[abhilash_kumar]

Hi Sailee,

Change the Join Type from Inner to Left/Right depending on which SP beings in data.

Go to the Database Expert > Links tab to do this.

-Abhilash