I have a report the produces output in an excel sheet with summary, and detail sheets. I am trying to burst this report. My burst value is not first sorted field because MY table of content needs first sorted field should be sumary field. Is there a way to burst table of content reprot on second sort field?

Thanks in advance!

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

Arif,

Report Caster can not handle bursting a compund report that uses table of contents. I think Excel has trouble bursting compound reports in general. What I have done to get around this issue is to use the ETL to schedule each individual report. Its not the ideal situation, but it works.

Here is a link to my thread where I got it working

http://forums.informationbuild...=355105693#355105693