This is a migrated thread and some comments may be shown as answers.

ColumnHeadersPrintOnEveryPage not working as required

3 Answers 63 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Kalli Kaldi
Top achievements
Rank 1
Kalli Kaldi asked on 08 Nov 2019, 10:54 AM

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

3 Answers, 1 is accepted

Sort by
0
Eric R | Senior Technical Support Engineer
Telerik team
answered on 12 Nov 2019, 08:49 PM

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

Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
0
Kalli Kaldi
Top achievements
Rank 1
answered on 13 Nov 2019, 02:43 PM

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

0
Eric R | Senior Technical Support Engineer
Telerik team
answered on 13 Nov 2019, 03:59 PM

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

Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
Tags
General Discussions
Asked by
Kalli Kaldi
Top achievements
Rank 1
Answers by
Eric R | Senior Technical Support Engineer
Telerik team
Kalli Kaldi
Top achievements
Rank 1
Share this question
or