ColumnHeadersPrintOnEveryPage not working as required

4 posts, 0 answers
  1. Kalli Kaldi
    Kalli Kaldi avatar
    30 posts
    Member since:
    Oct 2011

    Posted 08 Nov Link to this post

    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

  2. Eric R | Technical Support Engineer
    Admin
    Eric R | Technical Support Engineer avatar
    230 posts

    Posted 12 Nov Link to this post

    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
  3. Kalli Kaldi
    Kalli Kaldi avatar
    30 posts
    Member since:
    Oct 2011

    Posted 13 Nov in reply to Eric R | Technical Support Engineer Link to this post

    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

  4. Eric R | Technical Support Engineer
    Admin
    Eric R | Technical Support Engineer avatar
    230 posts

    Posted 13 Nov Link to this post

    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
Back to Top