• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1121
  • Last Modified:

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

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
mrong
Asked:
mrong
  • 3
  • 2
1 Solution
 
Mihai StancescuSoftware Engineer Commented:
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
 
mrongAuthor Commented:
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
 
mrongAuthor Commented:
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
 
Mihai StancescuSoftware Engineer Commented:
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
 
mrongAuthor Commented:
Mishu,

I had KeepWithGroup set to 'After' before.
I'm repeating group headers not table headers.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Office 2010

This course will introduce you to the interfaces and features of Microsoft Office 2010 Word, Excel, PowerPoint, Outlook, and Access. You will learn about the features that are shared between all products in the Office suite, as well as the new features that are product specific.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now