I am trying to create a excel output with multiple sheets and burst it using ReportCaster in a single Excel file.
When i run the below code separately, a single XLSX output file with multiple tabs is created, but when bursting through ReportCaster i am receiving multiple excel files as attachments. Can anyone help me with this. Thanks in advance.

 
SET COMPOUND=OPEN

TABLE FILE CAR
SUM
SALES
BY COUNTRY NOPRINT
BY BODYTYPE
ON TABLE PCHOLD FORMAT XLSX
END

TABLE FILE CAR
SUM
SALES
BY COUNTRY NOPRINT
BY MODEL
ON TABLE PCHOLD FORMAT XLSX
END

SET COMPOUND=CLOSE

TABLE FILE CAR
SUM
SALES
BY COUNTRY NOPRINT
BY CAR
ON TABLE PCHOLD FORMAT XLSX
END

This message has been edited. Last edited by: FP Mod Chuck,

With XLSX format I use a template with multiple sheets and not the COMPOUND feature. Then I loop to feed each sheet with proper data.
It work perfectly with RC bursting.

Martin, thanks for the response. I am trying to take the compound approach because it works good with our current requirement

quote:

I am trying to take the compound approach because it works good with our current requirement

Seems not because RC cannot burst properly as you wish.

If I remember well using EXL2K with the COMPOUND it will burst properly, but with XLSX you need to use a template.

When i tried the same procedure with EXL2K for bursting, i got empty excel sheets with no data in the output.

Have you tried using SET COMPOUND=BYTOC?