0 Replies - 2941 Views - Last Post: 24 March 2009 - 12:26 PM Rate Topic: -----

#1 burak33   User is offline

  • New D.I.C Head

Reputation: 1
  • View blog
  • Posts: 1
  • Joined: 24-March 09

Crystal Report issue with stored procedure that returns multiple data

Posted 24 March 2009 - 12:26 PM


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,


Is This A Good Question/Topic? 1

Page 1 of 1