I have a report whose columns are populated based on a stored procedure call.
The call is like this.
CALL SP_RPT_88R(ID,S_ID,TYPE). S_ID is always 0 for this procedure.
Now, i have another procedure SP_RPT_89R(ID,S_ID,TYPE). for this, S_ID is always greater than zero.
These two stored procedures have very identical result sets.
I need to conditionally call the procedures in the Crystal reports, based on the S_ID.
How can i do that? Please help.