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

Aluan

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

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

Aluan

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

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

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

lakshanvindana

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

Aluan

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

lakshanvindana

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

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

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

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

what you actually take for that text?

Aluan

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

Hi Aluan,

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

some sort of a solution for your requirement.

Aluan

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

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!