GroupHeaderBand and export to Excel

[Jennypi]

Hi,

Please find attached an upgraded version.
Hope you can work with it.

Thanks.

[HighAley]

Hello.

We have made some changes in your report template.
It works as expected.

report.mrt

(22.48 KiB) Downloaded 311 times

Thank you.

[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.

[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.

[Jennypi]

Working like a charm!
Thank you for your help!

[HighAley]

Hello.

We are always glad to help you.
Let us know if you need any additional help.

Thank you.