Export Each Page To a Sheet

[Fanus]

Hello , I have 20 records and I print each record on a page, so I will have 20 pages
Is it possible to print them on different excel sheets?

[Lech Kulikowski]

Hello,

You can set the NewPageBefore/After for the databand.

Thank you.

[Fanus]

Hi , Thank you for your response
I did that but the problem is the pages are in the same excel sheet
Is there any way to put each page in a different sheet?

[Lech Kulikowski]

Hello,

Please set the ExcelSheet property.

Thank you.

[Fanus]

Hi , Thank you
It worked!

[Lech Kulikowski]

Hello,

You are welcome.

[Fanus]

Hello again
I encountered a weird problem
I have 2 major column in my datasource : DetectorId and DetectorFullName
I'm grouping base on DetectorId and putting the DetectorFullName in the ExcelSheet Property

if I have 4 groups with Names : Max - Kyle - Sara - Rosy

The sheets are generating correctly for each one but the name of the sheets are like this : Max - Kyle - Max1 - Rosy
the name of Sara's Sheet is Max1 and I don't know why this is happening

[Lech Kulikowski]

Hello,

Please send us a sample report with test data that reproduces the issue for analysis.

Thank you.