Repeat Headers in reports

davmac1

In the NAV training material, it says the way to repeat headers is:
Task 5: Repeat the Column Captions on Each Page
High Level Steps
1. Repeat the Column Captions on each page.
Detailed Steps
1. Repeat the Column Captions on each page.
a. Select Tablix Properties. The Tablix Properties window will
appear.
b. On the General tab, check the Repeat header rows on each
page option.
c. Click OK to close the Tablix Properties window.
(Chapter 3 of 80433_NAV2013_ENUS_REP)

This has never worked for me.
Instead I found this tip using google:
Steps:

1. In the grouping pane, make sure to turn on advanced mode (click on the small black down arrow on the far right of the grouping pane)
2. Select the corresponding (Static) item in the row group hierarchy
3. In the properties grid, set RepeatOnNewPage to true
http://msdn.microsoft.com/en-us/library/cc281227.aspx
So, I wondering, is our NAV reports training wrong, or am I missing a step somewhere?

I am hoping Claus will answer this since he knows all the report answers - or someone like him.

clausl

The reporting training could be wrong, but has been a while since I read it. To my knowledge, the reporting training material has been updated from NAV 2009 to NAV 2013.
Therefore, this is probably a copy paste error from NAV 2009 to NAV 2013 material. On the other hand, I also think this is a bug in VS 2010 or a nice feature to make us spend more time in VS 2010.
In VS 2008 when setting the property, “Repeat header rows on each page” the property, “RepeatHeaderOnNewPage” is set to “True” for all header rows. This is great and saves time.
Doing the same in VS 2010 has no effect on the “RepeatOnNewPage” property, which now no longer exist in the propery list for each row. We now have to go to Advanced Mode and then manually count and guess which row we have to set the “RepeatOnNewPage“. So the “Repeat header rows on each page” in Tablix Properties page does absolutely nothing, or at least I cannot see what it does. Maybe others can tell me what it does. If not this is a bug in VS 2010.
For the sake of somebody else facing this problem and finding this post, I am attaching a screen dump of what you need to change to get your table headers to repeat on new pages:

In addition, I have create a small demo report, which prints table headers on new page. Feel free to explore this report here, with many other examples.
I have included FOB, TXT, PDF, JPG, and offline files. Link: http://sdrv.ms/TIrMRM

/Claus Lundstrøm

davmac1

Claus, thanks once again for your detailed response.
http://social.msdn.microsoft.com/Forums ... 1ac4c8Once I figured it out, it is not too hard to fix, but definitely takes more work.
I went to post this question on a Microsoft Visual Studio forum and it gave me answers from my topic title (you don't even have to post the details - quite impressive!):

http://blogs.msdn.com/b/robertbruckner/archive/2008/10/13/repeat-header-and-visible-fixed-header-table.aspx
http://social.msdn.microsoft.com/Forums/en/sqlreportingservices/thread/948e9caa-5402-47cb-a995-12c20b1ac4c8
It looks like the enhancements changed the way the table (tablix) works.
http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/ee29da49-5c8c-47f3-a905-c730dcbe9780
http://msdn.microsoft.com/en-us/library/cc281227.aspx

Guess no one in SSRS/VS development at Microsoft is channeling the spirit of Steve Jobs - make it as streamlined and simple as possible.