Crystal Reports Union two tables from two datasources

Technical Questions

Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions

Topic: Union two tables from two datasources

Post Reply

Post New Topic

Author	Message
kaledev Newbie Joined: 16 May 2011 Online Status: Offline Posts: 1	Topic: Union two tables from two datasources Posted: 25 May 2011 at 7:55am
	I am attempting to union together two different tables, which exist as two different commands in Crystal, into one. They exist as two different commands because one is from a Teradata DB, and the other is from a DB2 DB. I need to actually do this completely inside of Crystal if at all possible. Anyone have any ideas? Thanks!
	IP Logged


IdoMillet Groupie Joined: 26 Oct 2007 Location: United States Online Status: Offline Posts: 99	Posted: 30 May 2011 at 2:14pm
	Link to these two data sources via MS Access. Do the UNION in Access. Use that MS Access query as your data source. Same logic can be used by linking from 1 source to the other, using SSIS, etc.
	view, e-mail, export, burst, distribute, and schedule Crystal Reports. www.MilletSoftware.com
	IP Logged

Dewald Groupie Joined: 02 Jun 2011 Location: South Africa Online Status: Offline Posts: 47	Posted: 02 Jun 2011 at 10:42pm
	You could use a sub-report for one and a main report for the other.
	Dewald Botha http://www.ITClarity.co.za
	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