Export to Excel with Mutiple Sheets

Hi,
I have encountered this problem of not being able to export my different sub
reports to individual work sheets within excel. I have tried to put Page
breaks after each table, as this is all the sub reports contain. Thus after
each table a page break is inserted. If I preview the Report, containing all
the sub reports, it shows the correct page breaks. However when I export this
to Excel it gives me the following:
Sheet 1 - Document Map
Sheet 2 - First Sub Report
Sheet 3 - All the remainder of the Sub Reports straight after each other all
in one sheet.
I need to have the Sub Reports all in seperate sheets. Can anyone help,
please'
Thanks,
NatNat, I am experiencing the exact same problem. Have you gotten any info/reply
from experts? I really need answers, too.
thanks
"Nat" wrote:
> Hi,
> I have encountered this problem of not being able to export my different sub
> reports to individual work sheets within excel. I have tried to put Page
> breaks after each table, as this is all the sub reports contain. Thus after
> each table a page break is inserted. If I preview the Report, containing all
> the sub reports, it shows the correct page breaks. However when I export this
> to Excel it gives me the following:
> Sheet 1 - Document Map
> Sheet 2 - First Sub Report
> Sheet 3 - All the remainder of the Sub Reports straight after each other all
> in one sheet.
> I need to have the Sub Reports all in seperate sheets. Can anyone help,
> please'
> Thanks,
> Nat