Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

consolidate data

Status
Not open for further replies.
back2tek

back2tek

Technical User
Jan 12, 2006
64
US
Hi all,
I am using Cr9 on Informix database. I have no access to create views or Stored procedure. I would like to pull and consolidate data from 2 typical tables on 2 different servers.
My question is how to use add command feature in CR9 with 2 data source to return all records from both tables(Union all).

Thanks in advance to everyone,
Back2tek
 
Sort by date Sort by votes
Link to both data sources from MS Access. Do the uNION ALL query in Access. Crystal can use the MS Access as if it was a table.

- Ido

view, e-mail, export, burst, distribute, and schedule Crystal Reports.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

anandm19
  • Locked
  • Question
Crystal report byte array data to Unicode data format export issue
Replies
0
Views
292
anandm19
anandm19
tlbrown88
  • Locked
  • Question
How to duplicate data from main report lines for sorting purposes
Replies
2
Views
302
lbass
lbass
1tufgt
  • Locked
  • Question
Detail data in Header?
Replies
1
Views
166
dgillz
dgillz
PremHealth1
  • Locked
  • Question
How do I drill into a report footer summary value to display all detail data?
Replies
5
Views
229
lbass
lbass
cpjeffm
  • Locked
  • Question
Alert user if data they entered into a parameter doesn't exist in the database 1
Replies
19
Views
467
cpjeffm
cpjeffm

Part and Inventory Search

Sponsor

Back
Top