Report Layout (RDL) - Repeat Table Header on new Page

Aluan · 2015-10-19

Hello,
we are using Microsoft Dynamics NAV 2015.
I searched and tried a lot, but nothing did work, maybe it's not possible.

We have a table with one header row an a few lines.
I changed the "RepeatOnNewPage" property to true, like here:
-> http://vbcity.com/blogs/xtab/archive/2010/06/14/what-to-do-when-the-repeatcolumnheaders-property-in-a-tablix-isn-t-working.aspx
In the "Tablix Properties" i checked the "repeat header rows on each page".

I am not sure, but maybe the problem is the "CanGrow" Property in a table row. Sometimes we have a huge text, over a site. Whenever the text goes over 1 site the table header row will not be printed.

Is there a way to print the table header row on every page until the table ends?

postsaurav · 2015-10-19

HI Aluan,
Try this and let me know if any issues -
Blog

Aluan · 2015-10-20

Hey,
i tried the steps, but it didn't work. It's pretty much the same as in the posted site.
Anyway thanks for your answer.

lakshanvindana · 2015-10-20

Hi Aluan,

You are almost done it. These are the steps I followed, and so far it works for me.
1. Select "Advanced Mode" in the Group Pane.
2. Select the correct Static row from the Row Group
3. Change the properties of;
KeepTogether = True
KeepWithGroup = After
RepeatOnNewPage = True

that is all, no need to change tablix properties, repeating in pages works even without "KeepTogether" property change, but I think it is what you have missed, so try it out.

Aluan · 2015-10-20

Hi,
still the same problem. Whenever the text goes above a site the table header does not appear.

lakshanvindana · 2015-10-20

if you don't mind, send me the object, I will try.

Aluan · 2015-10-20

I created a testfile (it's a ".txt" exported file), and uploaded it at Pastebin.
-> http://pastebin.com/uvqzq0AL

lakshanvindana · 2015-10-21

Hi Aluan,

The issue is because in your report first row is going up to second page, because of the text you have insert 60 times. If you reduced it to like 20 and the other row (another blank line or a sales line) comes to next page, table header is repeating for sure.
Is that long text a major requirement? May I know the requirement.

Aluan · 2015-10-21

Hi lakshanvindana,
thank you for helping me.
Yes the long text is a major requirement. Sometimes the text goes over 2 sites, or more.

The long text is everytime in the same table cell and the property "MarkupType" is set to "HTML".

Belias · 2015-10-21

Can you use the "header" section of the report (not of the table) to show your data? That section can be printed on every single page, no matter what.

Aluan · 2015-10-21

No i can't use the header, because there are much more information (a list, an other table) before the table will be printed.

lakshanvindana · 2015-10-21

what you actually take for that text?

Aluan · 2015-10-21

It's like a description for the item. For every item you can create such a description. That's not a standard field, so the text can be really long.

lakshanvindana · 2015-10-21

Hi Aluan,

check the text file here;
http://pastebin.com/c4wRG6HN

some sort of a solution for your requirement.

Aluan · 2015-10-21

Hi thank you,
i'll try this in the other reports where that is needed.
When i am done i will post here again.

Aluan · 2015-10-21

So, it works now. I added a DataItem and a Column like you, and modified the Code a bit. I was able to split every line into another column cell and now the TableHeader appears on every site.
Thank you for your time & solution!

Howdy, Stranger!

Quick Links

Categories

Report Layout (RDL) - Repeat Table Header on new Page

Comments