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!

Crystal Reports with ODBC Question

Status
Not open for further replies.

knagy

Technical User
Apr 6, 2005
13
US
I am using Crystal Reports 8.5 with an ODBC connection. I have written a report that is using the data source "Timberline Data Source" with this data source pointing to a specific folder (H:\LNW). My problem is that I need to run a version of my report for a different folder (H:\HHP) but it will not work because ODBC is pointing to the first folder. The reason there are two different folders is that the two folders represent two different companies. So my question is, is there code that I can put in my Crystal Report that will automatically set the folder for the data source. I should note that I have tried to create another data source in ODBC for the second folder, but the Timberline program which is what is being used to view the report only looks at the Timberline Data Source. Thanks in advance for any help.
 
Use OLE DB instead of ODBC. You can dynamically create the path using OLE DB.
 
An alternative would be to repoint the ODBC data source each time you need to run the report.

-k
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top