Skip to Content
0
Former Member
Jan 11, 2008 at 07:57 PM

Executing a stored procedure containing multiple Select statements

141 Views

Post Author: Beverly

CA Forum: General

I am using Crystal 10.0 against a MS SQL 2000 server.

I am trying to create a report based on a stored procedure that contains multiple select statements. The sp requires a single parameter (Claim number) and contains 17 Select statements that produce results.

I am able to use the Add command and execute the sp with the parameter, but I am only getting the results of the first select statement in the sp back in my data set. Is there a way to have the data from each Select statement returned to my report?

I have used Crystal for a while, but pretty much for straight-forward reporting. I am familiar with the basics of SQL.

I would appreciate any help anyone can offer.

Thanks.