none
How to display Column Headers on every page? RRS feed

  • Question

  • Hi,

    I'm using Visual Studio 2013 to create reports for SSRS in SQL 2014. The report I made is simple & looks working fine, except one thing: All column headers that I want them to appear on every page only appear only on page 1. It seems simple at first, but I haven't find a solution to make these columns header appear on every page.

    Please help!

    Thanks

    All coumn Headers appear only on page 1

    I tried to search to see if any threads in forum that have similar issue like mine, but I couldn't find it.


    • Edited by EdwardJde Friday, October 2, 2015 7:56 PM
    Friday, October 2, 2015 7:53 PM

Answers

  • Hi All,

    Finally I solved my issue luckily.

    First, I found a post showing that the following attributes for Column group should be adjusted:

    FixedData : set to True

    KeepWithGroup : set to After

    RepeatOnNewGroup : set to True

    then I got error message when trying to preview my report: "All tablixmember elements in a tablix column hierarchy must have the keepwithgroup property set to none".

    After a few minutes of being confused, then I switched the way I did: instead of adjusting the attributes of Colum group, I did adjust with attributes of Row group & this time, my report ran smoothly: the column header shows every page in the way I want.

    Edward

    • Marked as answer by EdwardJde Saturday, October 3, 2015 2:31 AM
    Saturday, October 3, 2015 2:31 AM