Page 1 of 1
Export Each Page To a Sheet
Posted: Wed Jun 26, 2024 8:38 am
by 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?
Re: Export Each Page To a Sheet
Posted: Thu Jun 27, 2024 8:26 am
by Lech Kulikowski
Hello,
You can set the NewPageBefore/After for the databand.
Thank you.
Re: Export Each Page To a Sheet
Posted: Mon Jul 01, 2024 11:49 am
by 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?
Re: Export Each Page To a Sheet
Posted: Mon Jul 01, 2024 7:58 pm
by Lech Kulikowski
Hello,
Please set the ExcelSheet property.
Thank you.
Re: Export Each Page To a Sheet
Posted: Sun Jul 14, 2024 8:15 am
by Fanus
Hi , Thank you
It worked!
Re: Export Each Page To a Sheet
Posted: Mon Jul 15, 2024 8:01 pm
by Lech Kulikowski
Hello,
You are welcome.
Re: Export Each Page To a Sheet
Posted: Mon Jul 22, 2024 6:20 am
by 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
Re: Export Each Page To a Sheet
Posted: Mon Jul 22, 2024 5:48 pm
by Lech Kulikowski
Hello,
Please send us a sample report with test data that reproduces the issue for analysis.
Thank you.