Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / NAV 2016. Reports. Kee...
Microsoft Dynamics NAV (Archived)

NAV 2016. Reports. Keep totals and tax details close to the footer

(0) ShareShare
ReportReport
Posted on by Ghetz 2,983

I'm having trouble getting the results we want in our Sales invoice Design.

The number of lines in the report can be any number between 1 and about 200 in some cases. After the Invoice Lines, we show the VAT details, where you get the VAT amount per VAT Type, so it's a table, and we can't actually put it in the footer without using variables which we really want to try and avoid, as we can have up to 4 types of VAT Types.

Is there any way we can keep the VAT details close to the footer?? We need some formula to dynamically add an empty space to the report depending on the number of lines.

Any ideas on how to achieve this? We created the design using the standard invoice as our base design, so we have "list1", "list1_contents" and all standard design objects.

inv_5F00_DESIGN.png

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: NAV 2016. Reports. Keep totals and tax details close to the footer

    Can you provide a sample of the report you suggest in NAV 2016. Also the link is no longer valid Binil. Thank you.

  • Suggested answer
    TharangaC Profile Picture
    TharangaC 23,116 on at
    RE: NAV 2016. Reports. Keep totals and tax details close to the footer

    Agreed with Binil. My view is also to use SetData and GetData functions and then add the content you want to print in a report footer. In that way you can guarantee that the content in the footer will print only in the page footer.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: NAV 2016. Reports. Keep totals and tax details close to the footer

    I think it would be better to use the Standard GetData ,SetData functionality used in standard Document reports to achieve this. So you can place the VAT details on footer and also able to hide it dynamically to print at last page.

    msdn.microsoft.com/.../dn833424.aspx

    If I'm not wrong a dynamic formula for adding blank space on report based on number of lines not going to be a consistent solution.

  • Suggested answer
    Amol Salvi Profile Picture
    Amol Salvi 18,694 on at
    RE: NAV 2016. Reports. Keep totals and tax details close to the footer

    Either you can print you footer details by adding one more table footer after you VAT details

    or  you can fix no of rows in body .Check the below link

    mohana-dynamicsnav.blogspot.in/.../fixed-no-of-lines-in-nav-2013-rtc.html

  • Suggested answer
    Roberto Stefanetti Profile Picture
    Roberto Stefanetti 12,998 on at
    RE: NAV 2016. Reports. Keep totals and tax details close to the footer

    my suggestion: use Word Layout report instead RDLC for document reports.

    ..but if you need to use RDLC report format, look at above links

    nice post\solution by Steven Renders here:

    thinkaboutit.be/.../placeinbottom-in-rdlc-layout

    or

    www.packtpub.com/.../Place%20at%20the%20bottom

    Others

    forum.mibuso.com/.../nav2013-how-to-print-total-invoice-amount-in-footer

    dynamicsuser.net/.../tables-in-footer-section-of-a-report

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,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans