Not sure if anyone else has had this problem.

I have a sales report that I hold to an Excel workbook using ON TABLE 'BYTOC 1' (salesperson name). If I run it using Report Caster without bursting it generates to the Excel workbook just fine the worksheets have the proper tabs by salesperson and proper information for the salesperson in it.

If I run the exact same report using Report Caster and burst it by salesperson it generates an email for each salesperson and attaches a worksheet indicating it is for that salesperson. However for the first salesperson the attached worksheet is blank. For the second salesperson the attached worksheet indicates it is for the second salesperson but contains the information for the first salesperson and so on. The information for the last salesperson is missing.

I've check the Distribution list and it only contains the names for the salespeople who are in the report. I've checked the raw data and there is no blank or strange salespeople within it.

I'm very confused as to why this would happen. Any suggestions would be appreciated.

This message has been edited. Last edited by: Glenn C.,

I assume your first BY field is the salesperson. If there is only one sheet per salesperson hold it as a worksheet not a workbook. Then ON TABLE HOLD AS xyz BYTOC

What PCHOLD FORMAT are you using?

Just to update this a little further I changed the output for the BYTOC and burst to be PDF instead of EXL2K and the bursting report worked just fine attaching the right salesperson report to the right salesperson email.
This means it appears to have something to do with the bursting using EXL2K. Using EXL07 does not allow for bursting in our version.

Does your version have FORMAT XLSX? That works in 8105.

If XLSX isn't an option one workaround might be to set BYTOC only when you're running it live and turn it off when you're running it in Scheduler.

-SET &BYTOC=IF &FOCFOCEXEC='RCASTER' THEN '' ELSE 'BYTOC';

TABLE FILE car
SUM SALES
BY COUNTRY
BY CAR
ON TABLE PCHOLD FORMAT EXL2K  &BYTOC
END

This message has been edited. Last edited by: BabakNYC,

There are other ways around this:

http://forums.informationbuild...227096086#6227096086

Thanks for the input.
I decided to modify the report and create separate schedules passing in the Salesperson name as a parameter to generate the individual reports for each.
Will continue to see If I can figure out the reason EXL2K and PDF bursting are acting differently but needed to get the reports generating.

Just as some additional information, I remember seeing this as well when we were on 7.7.03 and the output was EXL2K.
When using the report Caster you don't need the BYTOC command to burst the report and it will simply burst on the first BY field.
Commenting out the BYTOC command fixed ours for us when we had the problem.