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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Problem-Using 2 diff data sources from 2 different servers

Status
Not open for further replies.

markajem

Programmer
Dec 20, 2001
564
US
I am attempting to use two different data sources from two different servers. I am able to get the report to work if I use a main report for one data source and then a subreport for the second datasource. But is there a way to do this without using a subreport.

Everytime I try I get a ODBC error.

Thanks
Mark
Mark
Email: markanas333@hotmail.com
 
Mark,

Add your first table to the report. The add your second, using a separate data source. Do not attempt to add both tables at once, and then change the location of one of the 2 tables or you may get in trouble.



Software Sales, Training and Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top