1208799 - Can stored procedures return multiple result sets in Crystal Reports?

• Stored Procedure returns different result set depending on the parameter value entered.
• When reporting off a stored procedure that returns multiple result set, it generates error in Crystal Reports, or inconsistant results.
• In Crystal Reports, is it possible to report off a stored procedure that returns multiple result sets?
     
      
• Note: Example provided in this SAP Knowledge Base Article is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

• SAP Crystal Reports 2016
• SAP Crystal Reports 2020
• SAP Crystal Reports 2025

STORED PROCEDURE MULTIPLE RESULT SETS Seagate Crystal Reports Stored Procedure Support Seagate Crystal Query Stored Procedure Parameters , c2001503 , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem