Burst & schedule Crystal Report, Append result to Excel same sheet/tab

[sajisher]

Hi All,

Have a Crystal Report developed in 9.0.
Need to schedule this report -

1. the report has to burst for each Group 1 (GH1) ID and appended to Excel file in the same sheet1/tab but not in different tabs. like below. There are about 6 IDs.

- the report need to be picked from location \\server1\Pickupfoler\filename.rpt
- result Excel file to be placed in location - \\server1\Resultfolder\excelfile.xls


ID 1
Name Dept
abc fin
xyz pay

Total 2

ID 2
Name Dept
mno hr
jkl pay
rst sw

Total 3

Looks the report scheduler, Visual Cut can burst but writes to Excel in different Tab for each Group.

Does anyone know if Business Object can append to same Excel file and sheet/tab or any other tool which will do this Step 1. If it is possible from BO, which version should I install in my machine and in production server

Thanks
Saj.

 

[IdoMillet]

One of the tools you mentioned above can append to existing tabs. In the user manual, look for TabInOldFile!

Cheers,
- Ido

view, export, burst, email, and schedule Crystal Reports.

http://www.MilletSoftware.com