Print Page | Close Window

[VB.NEt 2008] Two Datasources

Printed From: Crystal Reports Book
Category: Crystal Reports for Visual Studio 2005 and Newer
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=10029
Printed Date: 29 Apr 2024 at 2:30pm


Topic: [VB.NEt 2008] Two Datasources
Posted By: mac-duff
Subject: [VB.NEt 2008] Two Datasources
Date Posted: 14 May 2010 at 7:48am
Hello,

is it possible to add two datasources to one report and also activate the report option: Select Distinct Records?

Thanks


Replies:
Posted By: lockwelle
Date Posted: 17 May 2010 at 3:19am
Not that I know of.  You could get the data via a stored proc and combine the outputs so that it is in 1 dataset, then set the datasource to the one dataset...have the stored proc do the select distinct
 
at least, that is how I attack the problem.
 
HTH

Posted By: mac-duff
Date Posted: 17 May 2010 at 10:20pm
Hi,
but this means I have to do an export of the database before create a Report?

Posted By: lockwelle
Date Posted: 18 May 2010 at 3:09am
No...you just need to create a stored proc that returns 2 tables (select statements).  Either you can have CR pull the data via the stored proc or you can have an application pull the data and push it to CR.


Print Page | Close Window