Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

How to repeat columns in each page which generated through list

Hi All,

 

I have generated following structure using List in report builder. while everything is working fine what I want is that like column headings in table , this columns of the list should also get repeated in every page of the report but unable to figure out how to achieve it.

 

Kindly suggest.

 

 

 

3 Replies

  • v-janeyg-msft's avatar
    v-janeyg-msft
    Icon for Community Support rankCommunity Support

    Hi, Anonymous 

     

    Yes, You can do it by changing the setting.

    To display column headers on multiple pages:

    1. Right-click the row, column, or corner handle of a tablix data region, and then click Tablix Properties.

    2. In Column Headers, select Repeat header columns on each page.

    3. Click OK.

    To display row headers on multiple pages

    1. Right-click the row, column, or corner handle of a tablix data region, and then click Tablix Properties.

    2. In Row Headers, select Repeat header rows on each page.

    3. Click OK.

    Reference:

    Show Row & Column Headers on Multiple Pages (Report Builder) - Microsoft Report Builder & Power BI Report Builder | Microsoft Docs 

     

    Did I answer your question ? Please mark my reply as solution. Thank you very much.
    If not, please feel free to ask me.


    Best Regards,

    Community Support Team _ Janey

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi v-janeyg-msft 

     

    I have already tried that but while it working for the Table, not working for the List.  In this design I have created List Inside another List. The first list contains all the headers and the second contains the data which is going to be repeated but the solution is not working for me in this case.

     

     

    While here I can see various options to add Media/Images I haven't seen any option to add RDL file so that I can share the file with you.

     

    • v-janeyg-msft's avatar
      v-janeyg-msft
      Icon for Community Support rankCommunity Support

      Anonymous 

       

      Sorry, AFAIK, this is the only way to make each page contain column headers, if you really mind, you can change all to table format. Otherwise, you need to set up a separate page for each page.

       

      Did I answer your question ? Please mark my reply as solution. Thank you very much.
      If not, please feel free to ask me.


      Best Regards,

      Community Support Team _ Janey