web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Microsoft Dynamics NAV (Archived)

How do I create a total of lines?

(0) ShareShare
ReportReport
Posted on by

I am creating a report with sales lines. I need to add up the sales lines to get a total of the price extended field. How do I do this? Here is what I have so far:

2671.Nav.PNG

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    on at

    OK here are the steps I'm taking:

    1. Right click the Data set->Add Calculated Field

    2. Entering "=SUM(Fields!LinePriceExtended.Value)" as the expression

    3. Save the report

    4. I get that error from above.

    What else can I try?

  • Suggested answer
    Suresh Kulla Profile Picture
    50,251 Super User 2025 Season 2 on at

    You need to select the dataset for the table, or reference that in that field.

  • Community Member Profile Picture
    on at

    I add the calculated field to the report, then save and close it. Then when I save and close the report in the NAV dev environment it pops that error.

  • Suggested answer
    Suresh Kulla Profile Picture
    50,251 Super User 2025 Season 2 on at

    When do you get this error ,when you add something to the footer of the report ? Check report 119 for easy version.

  • Community Member Profile Picture
    on at

    Yeah I've tried doing that but I just get this when I try to save the report

    4403.Nav.PNG

    I've looked at the other reports to see how they're doing it but it's not obvious how they're getting to the totals.

  • Suggested answer
    Suresh Kulla Profile Picture
    50,251 Super User 2025 Season 2 on at

    Yes you can do it by referencing the report item

    msdn.microsoft.com/.../dd220421.aspx

    Try to check how the standard reports are doing.

  • Community Member Profile Picture
    on at

    That totals the line items within the table. I need to have a completely separate field with the total that I can place in the footer. Is that possible?

  • Suggested answer
    Suresh Kulla Profile Picture
    50,251 Super User 2025 Season 2 on at

    Check this

    msdn.microsoft.com/.../ms170712.aspx

  • Community Member Profile Picture
    on at

    [quote user="Suresh Kulla"]You can do that in your report using SUM of the LinePrice field[/quote]

    Thanks. Can you please explain how to do this? I've tried several different ways to do exactly this but always end up getting errors.

  • Suggested answer
    Alexander Ermakov Profile Picture
    28,096 on at

    This how-to might be helpful: Adding Grouping and Totaling to the RDLC Report Layout in Visual Studio Report Designer msdn.microsoft.com/.../dd339014.aspx

    blogs.msdn.microsoft.com/.../

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

News and Announcements

Season of Giving Solutions is Here!

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

#1
HoangNam Profile Picture

HoangNam 7

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans