ColumnHeadersPrintOnEveryPage not working as required

[Kalli Kaldi]

Hi.

I'm using the standaloneTelerik Report Designer to create a report with a table control.  I set the property ColumnHeadersPrintOnEveryPage=true for the table to display the header on each page.  It works as required when I export to PDF, but when I export to Excel (XLSX) the column header does not freeze and disapears when scrolling down.

It looks like a bug to me but can you advice if not ?

Best regards,
Kalli

[Eric R | Senior Technical Support Engineer]

Hi Kalli Kaldi,

This is by design. The ColumnHeadersPrintOnEveryPage property is for a Physical Page Layout which is why it works when exporting to PDF.  Unfortunately, it won't be possible to freeze the first row with a table on Excel Export as the Table Item can be placed in any data related section and a frozen row is expected to be the first section. To freeze rows on Excel Export use the Page header instead.

Please let me know if need any additional information. Thank you for using the Reporting Forums.

Regards,

Eric R | Technical Support Engineer
Progress Telerik

[Kalli Kaldi]

Hi Eric and thank you for your replay.

I understand the design.  But putting the headers in the Page header section does not help me in my situation because I have to be able to hide some columns based on the data in the datasource and hiding one column (and the relative header) makes the rest of the headers out of place and size relative to their respective column in the table (hope you understand what I mean).

Regards,
Kalli Kaldi

[Eric R | Senior Technical Support Engineer]

Hi Karl,

Thank you and I believe I do understand the scenario. Although, at this time using the Page Header is the only way to produce frozen rows when exporting to Excel. However, using an expression binding for the Visibility property to alter a Textboxes in the Page Header might also be used. See the Bindings documentation for more details. 

Additionally, we have an existing Feedback Item that is approved and tentatively scheduled for the R1 2020 release. This would involve using the Report Viewer to freeze the rows which might work in your scenario as well.

Lastly, as a token of gratitude for your feedback, I have increased the priority of the Feedback Item by casting a vote for you. I encourage following it to receive status updates. 

I hope this helps. Please let me know if you need any additional information. Thank you.

Regards,

Eric R | Technical Support Engineer
Progress Telerik