Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Header and footer data...
Microsoft Dynamics NAV (Archived)

Header and footer data of a report are not matching the body's data.

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

I customized Report 10074 Sales Invoice. It works correctly when printing one Posted Sales Invoice at a time. When I attempt to print more than one, it does not (if one of the PSI's requires multiple pages). So, I print a batch of 4 invoices. The 1st requires 3 pages, the rest require only 1. The first two pages print as expected, but the third does not. It has the line information from the 1st invoice (which it should) but the header and footer information is for the 2nd invoice. Any ideas of what could be causing this?

*This post is locked for comments

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Header and footer data of a report are not matching the body's data.

    There is an inherent issue in the design of R10074. It does not seem to affect much unless the report is modified. The issue had to do with the tablix properties (keeptogether was false, needed to be true). One set to true, the issue ceased.

  • Rajasekhar@MS Profile Picture
    Rajasekhar@MS 5,567 on at
    RE: Header and footer data of a report are not matching the body's data.

    Hi

    For Document Type Reports, when you print multiple pages, header data is depends on whether there are lines(body of report), so the header will link only to the lines of the first page only, so for document type reports if you use Page Header and Page Footer need to use code.getdata and setdata.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Header and footer data of a report are not matching the body's data.

    Ramesh, are you telling me to make sure those are the settings for the group properties, or are you telling me to check for those and to change them?

    Everyone else, what could cause a report's getdata and setdata to not align? It works in most situations.

    If I print one invoice at a time it works.

    If I print multiple invoices that don't overflow to multiple pages, it works.

    But If I print multiple invoices and one of them is multiple pages long, it will print every page but the final page of that invoice correctly. On that last page, it will have the proper lines in the body, but it will have the next invoice's header and footer details.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Header and footer data of a report are not matching the body's data.

    I know, and I am using them. They work as expected for most of the pages, except one.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Header and footer data of a report are not matching the body's data.

    Hi Zachary,

    you can follow as Amol said and also check this each row group properties like

      KeepTogether=false

      KeepWithGroup=before(child Group's)

      RepeatOnNewPage=True

    Thank You,

    Ramesh.

  • Amol Salvi Profile Picture
    Amol Salvi 18,694 on at
    RE: Header and footer data of a report are not matching the body's data.

    Hi,

    You need to check report layout and you have use one more table with grouping of invoice no outside the table where the data displays

    You can check report no 205 and check for list1_details_group .Check for this.

  • Rajasekhar@MS Profile Picture
    Rajasekhar@MS 5,567 on at
    RE: Header and footer data of a report are not matching the body's data.

    Hi

    For Document Reports to print Dynamic Header and footer information need to add Hidden fields in the body, for this need to use Code.GetData and Code.SetData, refer the below how to use code.setdata and Code.getdata, you can also refer the base document reports in Navision how it is used

    https://msdn.microsoft.com/en-us/library/dd301162.aspx

    https://clauslblog.wordpress.com/2012/10/03/simplifying-document-reports-in-nav-2013/

    https://www.youtube.com/watch?v=dievcKyhoWU

    http://www.dynamicsnavconsultant.com/2010/07/how-to-define-setdata-and-getdata-in-rtc-reports-in-dynamics-nav-navision/

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans