Page 2 of 2
Re: GroupHeaderBand and export to Excel
Posted: Tue Sep 08, 2015 9:15 am
by Jennypi
Hi,
Please find attached an upgraded version.
Hope you can work with it.
Thanks.
Re: GroupHeaderBand and export to Excel
Posted: Tue Sep 08, 2015 12:07 pm
by HighAley
Hello.
We have made some changes in your report template.
It works as expected.
Thank you.
Re: GroupHeaderBand and export to Excel
Posted: Tue Sep 08, 2015 2:05 pm
by Jennypi
Hello,
It works great when printing, thanks. But when exporting to Excel, the header is displayed every time, it cuts the list in several parts. Even if I choose the option "Print one header and footer" in the Excel export form. I would like to have only one row of headings, just below the group details. See
my example in previous post.
Have you tried to export your modified report to Excel? Is there another option I forgot?
thanks.
Re: GroupHeaderBand and export to Excel
Posted: Wed Sep 09, 2015 7:11 am
by HighAley
Hello.
Sorry, we forgot about the export.
Please, add next code to the
Exporting event.
Code: Select all
GroupHeaderBand2.PrintOnAllPages = false;
this.Render();
And to return headers use next code in
Exported event.
Code: Select all
GroupHeaderBand2.PrintOnAllPages = true;
this.Render();
It's no matter if the
Use One Page Header and Footer option set or not.
Thank you.
Re: GroupHeaderBand and export to Excel
Posted: Wed Sep 09, 2015 7:27 am
by Jennypi
Working like a charm!
Thank you for your help!
Re: GroupHeaderBand and export to Excel
Posted: Wed Sep 09, 2015 2:01 pm
by HighAley
Hello.
We are always glad to help you.
Let us know if you need any additional help.
Thank you.