Solved

MS SQL Reporting (Repeat column headers on new pages in RDL)

Posted on 2014-02-25
5
1,000 Views
Last Modified: 2014-07-15
greetings,

I need to repeat column headers on all pages(PDF) in rdl report(VS 2008).
I already checked the feature of "Repeat header columns on each page" in Tablix properties
but no luck.

Please suggest.
0
Comment
Question by:mrong
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 11

Accepted Solution

by:
Mihai Stancescu earned 500 total points
ID: 39888160
Hi,

On right side of the Grouping pane, click the down arrow, and then click Advanced.
Now you should see the grouping list different.
Click the static tablix member for the row that you want to repeat.
Then in the properties window you have two properties "KeepWithGroup" and "RepeatOnNewPage".
Set KeepWithGroup Before or After depending on your selected member and RepeatOnNewPage to True.

Regards,
Mishu
0
 

Author Comment

by:mrong
ID: 39891627
Mishu,

I tried your suggestion but got the following error msg.

The tablix 'table1' has an invalid TablixMember. All TablixMember elements in TablixColumnHierarchy must have the KeepWithGroup property set to "None'.

Any idea? Thx
0
 

Author Comment

by:mrong
ID: 39891988
Mishu,

It is working now. The only issue is the headers won't show on the last page of the PDF output.

Any suggestions?

Thanks.
0
 
LVL 11

Expert Comment

by:Mihai Stancescu
ID: 39892557
Hi,

Try setting the KeepWithGroup to After.
Also if you have multiple rows in the table header you must do the steps in my previous post for every column.


Regards,
Mishu
0
 

Author Comment

by:mrong
ID: 39892570
Mishu,

I had KeepWithGroup set to 'After' before.
I'm repeating group headers not table headers.
0

Featured Post

Instantly Create Instructional Tutorials

Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.

Question has a verified solution.

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

A long time ago (May 2011), I have written an article showing you how to create a DLL using Visual Studio 2005 to be hosted in SQL Server 2005. That was valid at that time and it is still valid if you are still using these versions. You can still re…
This article shows how to deploy dynamic backgrounds to computers depending on the aspect ratio of display
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

733 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