Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: use multiple select query in report Post Reply Post New Topic
Author Message
mszka
Newbie
Newbie


Joined: 30 Sep 2012
Location: Pakistan
Online Status: Offline
Posts: 1
Quote mszka Replybullet Topic: use multiple select query in report
     Posted: 30 Sep 2012 at 8:52pm
is there any way we can use multiple select query results in crystal report database field.
Or more than one Datasource(SP) for one report. I am newbie .Thanks for help in advance.
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet Posted: 01 Oct 2012 at 5:50am
What do you mean by "multiple select query results"?  Yes, you can use more than one SP in a report.  However, this is generally not recommended unless the resulting datasets are fairly small.  Any joins between the two result sets have to be processed by Crystal in memory as they can't be pushed down to the database.  A better option would be to create a third SP that will combine the results of the first two in order to provide the data for your report.
 
-Dell
IP IP Logged
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum