Crystal Reports [VB.NEt 2008] Two Datasources

Report Design
Crystal Reports Forum : Crystal Reports for Visual Studio 2005 and Newer : Report Design

Topic: [VB.NEt 2008] Two Datasources

Author	Message
mac-duff Newbie Joined: 22 Apr 2010 Location: Spain Online Status: Offline Posts: 21	Topic: [VB.NEt 2008] Two Datasources 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
	IP Logged

lockwelle Moderator Joined: 21 Dec 2007 Online Status: Offline Posts: 4372	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
	IP Logged

mac-duff Newbie Joined: 22 Apr 2010 Location: Spain Online Status: Offline Posts: 21	Posted: 17 May 2010 at 10:20pm
	Hi, but this means I have to do an export of the database before create a Report?
	IP Logged

lockwelle Moderator Joined: 21 Dec 2007 Online Status: Offline Posts: 4372	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.
	IP Logged

Post Reply

Post New Topic

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

This page was generated in 0.031 seconds.