Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 1234»»»

Repeating TABLE Header on each page of the report when you print the exported to excel report. Expand / Collapse
Author
Message
Posted Tuesday, October 28, 2008 2:06 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, June 17, 2011 2:19 AM
Points: 52, Visits: 280
Hi,

I have generated the report and looks fine. But while printing the QA Smile wants the report headers(TABLE HEADERS) need to be print on each page. I can get this by doing some format in EXCEL, but that should be done using SSRS. Is this feature present in SSRS to make the table header showup on each page when printing.

Any help would be greatly appreciated.

Thanks,
Suman
Post #593245
Posted Monday, April 6, 2009 8:59 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, April 7, 2009 7:57 PM
Points: 2, Visits: 6
I too have a same requirement. any ssrs guru help out.
Post #691623
Posted Tuesday, April 7, 2009 7:26 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Thursday, September 18, 2014 9:01 AM
Points: 470, Visits: 1,450
Select your table so you can see the column/row selectors
Right click in the "ALL" selector (the top left corner), then click properties
This birngs up the Table Properties dialog
There you can check the box to repeat the header rows on each page along with other page/header/footer options
Post #691982
Posted Tuesday, April 7, 2009 8:41 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, June 4, 2010 10:17 AM
Points: 191, Visits: 386
for SSRS 2008,

If a report with a table is created using the wizard feature (In Solution Explorer, right click on Reports --> Add New Report) Table Headers will repeat on every page.

Instead if a report is created without using the wizard (In Solution Explorer, right click on Reports --> Add --> New Item) Table Headers will not repeat on every page. Setting Repeat Header (Rows/Columns) on each Page for the Tablix will not help either.

If you have already built the report and cannot rebuild using the steps above and if and only if you are comfortable altering the xml behind the rdl, do the following. (Save a Backup rdl first)

View Code.
Look for TablixRowHierarchy
Below that there will be a TablixMember that corresponds to the header row.
to that header and any other header rows ( Tablix Member) add the three element properties.

KeepWithGroup After /KeepWithGroup
RepeatOnNewPage true /RepeatOnNewPage
KeepTogether true /KeepTogether


You should see the header rows repeating.


View Siva Gurusamy's profile on LinkedIn

"Software changes. This is a rather obvious statement, but it is a fact that must be ever present in the minds of developers and architects. Although we tend to think of software development as chiefly an engineering exercise, the analogy breaks down very quickly. When was the last time someone asked the designers of the Empire State building to add ten new floors at the bottom, put a pool on the top, and have all of this done before Monday morning? " : Doug Purdy, Microsoft Corporation
Post #692093
Posted Tuesday, April 7, 2009 9:15 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, June 17, 2011 2:19 AM
Points: 52, Visits: 280
Thanks for the reply. Is this possible in ssrs 2005 ??
Post #692158
Posted Tuesday, April 7, 2009 9:21 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, June 4, 2010 10:17 AM
Points: 191, Visits: 386
In 2005, lrosini's suggestion to check Repeat header rows on each page, should help.

In the XML, look for /Header and between /Header and /TableRows, make sure you have this element property: RepeatOnNewPage true /RepeatOnNewPage. If not add this and try.


View Siva Gurusamy's profile on LinkedIn

"Software changes. This is a rather obvious statement, but it is a fact that must be ever present in the minds of developers and architects. Although we tend to think of software development as chiefly an engineering exercise, the analogy breaks down very quickly. When was the last time someone asked the designers of the Empire State building to add ten new floors at the bottom, put a pool on the top, and have all of this done before Monday morning? " : Doug Purdy, Microsoft Corporation
Post #692169
Posted Tuesday, April 7, 2009 10:41 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, June 17, 2011 2:19 AM
Points: 52, Visits: 280
Thanks for the reply.
Applying that property does not work. It only prints the header on the very first page but not all.

Thanks,
Suman
Post #692286
Posted Tuesday, April 7, 2009 10:46 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, June 4, 2010 10:17 AM
Points: 191, Visits: 386
what is the image/figure on your header rows when you select the table. You should see the header image. Or are you seeing the image with three black lines denoting Detail rows.




View Siva Gurusamy's profile on LinkedIn

"Software changes. This is a rather obvious statement, but it is a fact that must be ever present in the minds of developers and architects. Although we tend to think of software development as chiefly an engineering exercise, the analogy breaks down very quickly. When was the last time someone asked the designers of the Empire State building to add ten new floors at the bottom, put a pool on the top, and have all of this done before Monday morning? " : Doug Purdy, Microsoft Corporation
Post #692291
Posted Tuesday, April 7, 2009 11:07 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, June 17, 2011 2:19 AM
Points: 52, Visits: 280
It is header row. I just dragged the column and placed them into detail section and header shows up in report header which is header row image. It only prints header on first page but not all.
Post #692317
Posted Tuesday, April 7, 2009 11:14 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, June 4, 2010 10:17 AM
Points: 191, Visits: 386
Did you check the box for Repeat header rows on each page?
Do you know where to do this?


View Siva Gurusamy's profile on LinkedIn

"Software changes. This is a rather obvious statement, but it is a fact that must be ever present in the minds of developers and architects. Although we tend to think of software development as chiefly an engineering exercise, the analogy breaks down very quickly. When was the last time someone asked the designers of the Empire State building to add ten new floors at the bottom, put a pool on the top, and have all of this done before Monday morning? " : Doug Purdy, Microsoft Corporation
Post #692328
« Prev Topic | Next Topic »

Add to briefcase 1234»»»

Permissions Expand / Collapse