Two Stored Procedures in single Crystal Report

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
Purchasing_IssuePurchaseOrderReport.rpt
Sailee GovekarStudentAsked:
Who is Participating?
 
mlmccCommented:
It happens because you have the SPs joined with an inner join.  In that case if either SP fails to have data you will not have any records returned.

Will one of the stored procedures ALWAYS have data?
If so you can make that one the main SP and join it to the other with a LEFT OUTER JOIN.

If it is possible for either SP to return no data you can try changing the join you have to FULL OUTER if your database supports that.

mlmcc
1
 
Sailee GovekarStudentAuthor Commented:
Thank you for your valuable feedback.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.