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!

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

2 different data sources on 2 different servers

Status
Not open for further replies.

Montana751

Programmer
Aug 14, 2001
64
US
Crystal XI
1st datasource are SQL tables on Server A
2nd datasource is QuickBooks on Server B

Is there a way to join these (log in, etc.) WITHOUT USING
~ a subreport
~ creating a Crystal SQL query
~ creating a SQL Union

I have 3 fields that are the same in each datasource that need to be the same in order for the correct records to return. I can do it with a subreport, but prefer not to, as I have to create a form with lines and stuff that all have to line up in the Details section. The SQL data is on the left side of the details section and the right side's data is going to come from Quickbooks.

Any ideas??
 
With Crystal XI, just click on Database -> Create New Connection and add the 2nd datasource
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top