Report Builder 2.0 "Repeat header rows on each page" doesn't work by Barak Bester1

Closed

as By Design Help for as By Design

Type:	Bug
ID:	442791
Opened:	5/6/2009 6:05:32 AM
Access Restriction:	Public

Workaround(s)

view

User(s) can reproduce this bug

I created a report with report builder with a tablix in it.
On the tablix properties, I marked the chck boxes
"Repeat header rows on each page" and "Repeat header columns on each page"

When running the report, the table spans on more than one page but the header row appears only on the first page

Details (expand)

English

SQL Server 2005 SP2 - Developer Edition

Reporting Services

Windows XP SP2 Professional

US English

1. Create a new report
2. Create a database based on a query that one of it fields (aka Field A) has at least 50 unique values
3. Insert a table to the report
4. Drag Field A to the table, a header is created in the cell above
5. Right click on the table
6. Right click on the corner handle to get the tablix properties and select "Tablix Properties"
7. Mark "Repeat header rows on each page" check box
8. Mark "Repeat header columns on each page" check box
9. Run the report
10. Click on the "Next Page" button

The topmost row in the 2nd page is a regular (details) row

The topmost row in the 2nd page should be the header row

File Name	Submitted By	Submitted On	File Size
Header is not repeated in page 2.JPG (restricted)	Barak Bester1	5/6/2009	-
Header appers in page 1.JPG (restricted)	Barak Bester1	5/6/2009	-
Checkboxes are marked.JPG (restricted)	Barak Bester1	5/6/2009	-

Posted by Microsoft on 5/14/2009 at 11:42 AM

Thank you for using SQL Server Reporting Services.
We are generally reviewing this feature set for a future release.
The following content was recently published to help but again, we are reviewing for a future release how to make the expereince better.
Thank you

Controlling Row and Column Headings
http://msdn.microsoft.com/en-us/library/cc281227.aspx

Posted by AltonD on 9/8/2009 at 2:11 PM

On StackOverflow.com do a search for "Reporting Services: Tablix RepeatColumnHeaders doesn’t work on some reports"

At the bottom of the center screen, where it says row and groups, click on the arrow to the right of "Groups" and select advanced mode. Select the outermost [static] and in it's properties select "RepeatOnNewPage" and set it to true.

Microsoft