Transheader / Transfooter in Word Layout (NAV 2016 CU4)

Sebastien_Konsbruck

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

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

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

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

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

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

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