Crystal Reports 10 and Excel 2003

[DataGirl67]

Here's the issue:

I've created a stored procedure in SQL Server. In Crystal Reports, I've created a report based on the stored procedure. Now, I need to export the report via Crystal into Excel. This report will be read by an application I didn't develop, nor am I allowed to make changes to.

Now, this application for whatever reason cannot read the default worksheet name: Sheet1.

I have two alternatives:

1) Change the spreadsheet name when it created in Crystal.
or
2) Place the report header on one worksheet and the report itself on a second worksheet (the app can read data from Sheet2).

I've all ready lost the battle to have the app changed AND since this'll really amount to 28 different reports (don't ask) running on a daily basis, changing the worksheet name to something by hand is NOT an option.

Any help would be greatly appreciated!

 

[Tatertot45]

I am not aware of this type of functionality from any version of Crystal. YOu may need a 3rd part program to export the data to excel, from Crystal. I use Visual Cut, but i'm not sure if it will rename a tab for you. I'm sure Crystal can not do this.