Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics NAV (Archived)

Fixed Number of lines in Nav 2016 report

Posted on by Microsoft Employee

Hello, i'm new to Nav and i have to modify a report for a customer; The original report is structured with header, body and footer they asked me to print at the begin of the body, for every page, the sum of the field of the previous page, and at the end of the body the sum of the field  of the current page.
So the situation must be like this:

page 1
Header
-------------------
Body

blank ( cause this is the first page)
record 1
record 2
record 3

sum of (record1.field, record2.field, record3.field)

-------------------------------------------------
footer

_______________________________________________________

page 2
Header
-------------------
sum of (record1.field, record2.field, record3.field)

blank ( cause this is the first page)
record 4 
record 5
record 6

sum of (record4.field, record5.field, record6.field)

-------------------------------------------------
footer

.... etc etc..
How can i do this? even without using a fixed number of lines for page, but i need a solution and i can't find it...

*This post is locked for comments

  • Verified answer
    Alexander Ermakov Profile Picture
    Alexander Ermakov 28,094 on at
    RE: Fixed Number of lines in Nav 2016 report

    You might as well be interested in this thread:

    forum.mibuso.com/.../transheader-transfooter-in-word-layout-nav-2016-cu4

  • Verified answer
    Amol Salvi Profile Picture
    Amol Salvi 18,694 on at
    RE: Fixed Number of lines in Nav 2016 report

    Hi

    You can look at this video so understand how to create trans footer and trans header in RDLC Report

    www.youtube.com/watch

    Hope this help you

  • Suggested answer
    Binesh Profile Picture
    Binesh 7,885 on at
    RE: Fixed Number of lines in Nav 2016 report

    Hello,

    It means you need TransHeader and transFooter Like NAV 2009 Clasic.

    if it so then, create a sum of group total  in RDLC

  • Verified answer
    Mohana Yadav Profile Picture
    Mohana Yadav 59,139 Super User 2024 Season 2 on at

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,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans