cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
tommy_g
Helper V
Helper V

Paginated Reports - Running Heads don't seem to "run"

Attempting to create my first multi-page report. 

The structure is simple: grouping on Fleet Name, followed by a column header row and multiple line items.

I want the top-level group (Fleet Name and column headers to repeat on following pages.

I get nothing.

Tablix settings do not seem to have any effect:

Paginated running heads - Tablix settings.PNG

The first page:

Paginated running heads - page 1.PNG

The second page, note there is no running head for the group (Loblaw Ajax), nor the column header row. That is the problem.

Paginated running heads - page 2.PNG

 

Looking for pointers on how to make this work as intended, the report without group/column headers is very difficult to read.

 

1 ACCEPTED SOLUTION

Hi @tommy_g ,

 

Is your data region a table? If so, please refer to this post.  

 

 

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

Best Regards,
Winniz

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

5 REPLIES 5
v-kkf-msft
Community Support
Community Support

Hi @tommy_g ,

 

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

 

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

 

image.png

 

For more information, please refer to: Display Row and Column Headers on Multiple Pages (Report Builder and SSRS) 

 

 

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

Best Regards,
Winniz

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

I tried both options and see no change. I have "groups", the top-level which I want to be the "header" and the second level as the detail row. Perhaps I'm wrong in assuming "group = header". How does one declare a header?

Paginated Groups.PNG

 

Note this from the official documentation. This must be part of my problem, when I click I do not see dotted lines or other indicators. Therefore "depends on whether.... group headers..." I'm guessing I don't have any. 

tommy_g_0-1628561926451.png

 

Hi @tommy_g ,

 

Is your data region a table? If so, please refer to this post.  

 

 

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

Best Regards,
Winniz

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

This is very helpful, yes it is a table. I now know that "data region" is something more expansive than that. The article you cited is my next goal. At present, I'm only thinking "horizontal", probably from decades of banded report writers. I need to add a column group first, as that is where the "repeat" option is accessible.

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!