Print Page | Close Window

Two data sets returned from a Stored Procedure

Printed From: Crystal Reports Book
Category: Crystal Reports for Visual Studio 2005 and Newer
Forum Name: Data Connectivity
Forum Discription: How to connect to data sources and export reports
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=5882
Printed Date: 02 May 2025 at 10:14am


Topic: Two data sets returned from a Stored Procedure
Posted By: burak33
Subject: Two data sets returned from a Stored Procedure
Date Posted: 24 Mar 2009 at 12:14pm

Hello,

I am converting a  Crystal report tied to an Access database to point to a SQL Server stored procedure.

The stored procedure has 2 select statements in it that return different number/types of fields, so I can't do a union.

The crystal report only sees the result set from the 1st select statement, not the 2nd.

How can I get Crystal reports to see these two select statement return sets, without creatinga temp table in the stored procedure and dumping the results of the 2 select statements in it?

Thank you,

Burak


Print Page | Close Window