Transheader / Transfooter in Word Layout (NAV 2016 CU4)

Sebastien_Konsbruck · 2016-04-01

Hello everyone

I'm in the middle of a project that includes converting RDLC to Word reports.
So far, everything worked like a charm.

However, we've now encountered an issue: there seems to be no native way of doing transfooters and transheaders except for counting the number of lines that word will probably insert on the page before breaking...

Now, we thought: why not create a visual basic code that sums before each page break a specified range in a table (like a conditional {SUM(ABOVE)} ) and inserts the value in a field control?

Does anyone have an idea how to realize such a task?

Thanks in advance and have a great weekend!

Best regards,
Sébastien

gerdhuebner · 2016-09-22

Finally, I found a way to implement Transheader and Transfooter lines into arbitrary Word layout:
https://massivedynamicsblog.wordpress.com/2016/09/22/how-to-implement-carryover-in-wordlayout-reports/

RockWithNAV · 2016-04-01

Hey Seb,

Check out this link, this is the only way we handle Trans-header and Trans-Footer in NAV RDLC Reports.

Code.SetRunningTotal is he key for doing this which you will find in the below link. Do pass valid parameters it will work for sure.

https://blogs.msdn.microsoft.com/nav/2011/06/06/transfooter-and-transheader-functionality-in-rdlcssrs-reports-revisited/

Sebastien_Konsbruck · 2016-04-14

Hi,

Thanks a lot for your answer. This works well in RDLC.

We were hoping to complete all customer requirements in the new Microsoft Office Word Layout (XML) but this seems to be not feasible at this stage.

If someone happens to find a solution for this, please let me know.

Thanks again.

Best regards,
Sébastien

gerdhuebner · 2016-08-22

Unfortunately, SUM(ABOVE) is only working for the entire table colum, which may spread over multiple pages... - There seems to be no way to sum the values printed on a single page, if the number of printed rows per page is unknown. Furthermore, bookmarks within a repeating section content control are deleted, when new rows are added, so this idea is also foredoomed.
It is definitely impossible to implement Transheader/-footer within the docx file directly, since it (normaly) does not contain informations about automatic pagebreaks. This information is only available, after the docx has been opened in Word or rendered for printing. So it might be possible with a Word macro, which has to be automatically executed upon opening/printing or by using Word Automation (or Microsoft.Office.Interop.Word, respectively). At any rate, the lines for the Transheader/-footer have to be put into the Word header/footer, not into the body (same is true for RDLC layout).
So, the first question to answer is: Has anyone implemented Transheader/-footer into Word independently from NAV?

gerdhuebner · 2016-09-22

Finally, I found a way to implement Transheader and Transfooter lines into arbitrary Word layout:
https://massivedynamicsblog.wordpress.com/2016/09/22/how-to-implement-carryover-in-wordlayout-reports/

Sebastien_Konsbruck · 2016-11-23

Hi,
Thanks a lot!
Great! Will try it out.
Best regards
Sebastien

Transheader / Transfooter in Word Layout (NAV 2016 CU4)

Best Answer

Answers

Categories