Union two tables from two datasources
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=13327
Printed Date: 02 May 2024 at 8:38am
Topic: Union two tables from two datasources
Posted By: kaledev
Subject: Union two tables from two datasources
Date 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!
|
Replies:
Posted By: IdoMillet
Date 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
|
Posted By: Dewald
Date 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
|
|