?
Solved

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

Posted on 2014-02-25
5
Medium Priority
?
1,081 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
  • 3
  • 2
5 Comments
 
LVL 11

Accepted Solution

by:
Mihai Stancescu earned 2000 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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…
Are you ready to place your question in front of subject-matter experts for more timely responses? With the release of Priority Question, Premium Members, Team Accounts and Qualified Experts can now identify the emergent level of their issue, signal…
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
Suggested Courses
Course of the Month14 days, 3 hours left to enroll

809 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