Export to Excel and then Inputing that file in another Crystal Report

[former_member607865]

The end user will be running two Crystal Reports. After the first report is generated, the user will need to exporte the data to excel. The user will then run the second report, which uses the excel file created in the first report. FYI: Because of the complexities of the requirements and the structure of the data, I was not able to use sub-reports.

The running of the two reports works locally on my machine, but my questions deal with moving these reports to production. My two questions follow:

1. Is there a way for the first report to store the excel file in a certain location?

2. How would you get the second report to import the excel from that particular location without having to be recreate? (Because currently to location is on my local computer)

Thank you for your assistance in this matter.

[DellSC]

How will the reports be run in production? Are you connecting directly to Excel or are you using an ODBC connection to it?

-Dell

[former_member607865]

The reports will be placed and executed in Lawson's LBI. Connection to Excel will be using an ODBC.

[former_member11696]

Open the report and set location to a common folder the User has access to for exporting, save the report. Open the DSN on the Work station and set location to the common folder.

The second report should then load the Excel data source according to the DSN.

[former_member607865]

Thank you for your answer. Will this need to be done for every user that will run these two reports?