Exporting data from a .rpt file for use in another

[bobbydale81]

I am a total newbie to Crystal Reports, but that doesn't matter to my boss!

I received a .rpt file to print invoices from. I edited the design view of the file until it printed correctly on the invoice.

Now, the client has sent me another .rpt file to use and plans to do this on a daily basis. I don't have time to edit the design view to fit the invoice everyday.

Is there a way to use the original design view for future .rpt files? I could export the data from the new file and import into the old file?

As I said I am a total newbie, so any assistance is much appreciated!!!

 

[IdoMillet]

You can export to ODBC. This creates a Table that can then be used by another report that uses the same ODBC DSN...

hth,
- Ido

Visual CUT & DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[bobbydale81]

I figured out how to export data into an Excel spreadsheet to be re-imported later; however, the Crystal Report that I am <i>wanting</i> to export data from says that it cannot because the database is read-only.

How can I turn this off?

 

[bobbydale81]

Also, I do not have a SQL server, so would exporting via ODBC DSN still be a viable option?

THANKS!!!

 

[IdoMillet]

Make sure the excel spreadsheet you are exporting to is not open when you try to export to it.

Export to ODBC DSN can be done using ANY ODBC data source. You could use a MS Access database for example.

hth,
- Ido

Visual CUT & DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com