automatically exporting as an Excel spreadsheet 1

[wiplash]

Using BO R1 and Crystal Reports 11

We have a report generated with CR11 and thru BO R1. First, I should say that actually we have two versions of the same report; one for viewing and/or printing and the other used exclusively to export as an Excel spreadsheet (so the data can be sliced and diced as desired by our customer).

We would like to know if it's possible, and if so how, to automatically export the report as an Excel spreadsheet from Business Objects (r1). Or if that's not possible, is there a better or easier alternative to the way in which the spreadsheet gets created currently (which basically is just running the Crystal Report thru BO and then manually exporting the report)?

Thanks!

 

[hilfy]

You could set up the "Unmanaged Disk" destination (I think that's available in r1) - set it up on both the Destination Server and the Crystal Reports Job Server. You would then schedule the report to run as an Excel format to a network destination. If your BO system is running under the default "local services" account instead of a network services account, you may have security issues accessing the network location. If you're running under a network services account, that account must have access to the folder where the report is scheduled to export.

-Dell

A computer only does what you actually told it to do - not what you thought you told it to do.

 

[wiplash]

Thanks! That's exactly what we did and it seems to work just fine. Appreciate the help.