Solved

How do I maintain headers by page in a Multiple column & Multiple page report?

Posted on 2010-11-08
7
487 Views
Last Modified: 2012-05-10
I am using SSRS designer and created a report which  has no page headers but there are 6 columns which have headers.  When I render the report the first page has the column headers but as I page through the column headers do not exist on the remaining pages.  Also,  if I print them I experience the same thing, column headers are only on the first page.

How can I view or print so that column headers remain in at the top of the columns on every pager?
0
Comment
Question by:rhservan
  • 5
  • 2
7 Comments
 
LVL 21

Expert Comment

by:Alfred1
ID: 34089874
Are you using a Tablix control?  If you are, you can try setting the RepeatRowHeaders property to True.
0
 
LVL 21

Expert Comment

by:Alfred1
ID: 34089982
By the way, if the RepeatRowHeaders setting to true won't work, try the following:

1.  Expose the Static groupings in the Row Groups area by setting the Group Area into "Advance Mode".  The setting of it is found on the upper right corner of the Columns Groups (there is a dropdown there and select Advance Mode).

2.  Then, select at least the upper most "Static" line in the Row Groups area.  This "Static" line should be at least one of the column headers in that row.  Selecting the Static line will expose the property "RepeatOnNewPage".  By default this is set to True.

3.  Set "RepeatOnNewPage" property to True.

4.  Test it out.

0
 
LVL 21

Expert Comment

by:Alfred1
ID: 34089988
Oh correction on my previous post on no. 2.  The default setting for "RepeatOnNewPage" is False and Not True.  :-)
0
3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

 

Accepted Solution

by:
rhservan earned 0 total points
ID: 34090278
Alfred1,

Actually I am working with column headers not the row headers.  Your info has set me into the right direction though.   I set the "fixedcolumnheaders" to True and placed checkmarks in the Repeat column headers on each page in Tablix properties.   That seemed to work.
0
 
LVL 21

Expert Comment

by:Alfred1
ID: 34090369
OK.  If it works, that is good then. :-)

Have you tried viewing it in print mode if it displays with headers in the next pages?  Try to print out a sample as well to be sure.  If everything works then, good on you. :-)
0
 
LVL 21

Expert Comment

by:Alfred1
ID: 34120623
I don't have any problem with what you want to do.  However, reading your comment, there is a way to do multiple solution (i.e. one comment accepted as solution and other comments accepted as assisted).  I can still recall someone did that with one of the questions I tried to answer before.

I haven't really experience awarding points since 1999 so I don't know how to do it.  :-)

We can actually ask a moderator to help us here but anyway I don't mind what you are planning to do and I will not object.  :-)
0
 

Author Closing Comment

by:rhservan
ID: 34134608
The term in the question - Column Headers was the concern and required additional configuration.  Thanks Alfred 1 for your response.  I tried to make this a multiple solution but it would not let me.  Since it is going into the knowledge I wanted others to see the most correct solution
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SSRS reports 5 31
DTC in SQL Cluster 5 39
Locating SQL Data Tools 2012 11 40
SSRS 2012 URL 11 57
A recent question popped up and the discussion heated up regarding updating a COMMENTS (TXT) field in a table using SSRS. http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Q_27475269.html?cid=1572#a37227028 (htt…
Introduction Earlier I wrote an article about the new lookup functions (http://www.experts-exchange.com/A_3433.html) that ship with SQL Server 2008 R2.  In this article I’m going to show you another new feature of SSRS 2008 R2, this time in the vis…
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…
Video by: Mark
This lesson goes over how to construct ordered and unordered lists and how to create hyperlinks.

895 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now