Announcements
No record found.
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:
*This post is locked for comments
You can do that in your report using SUM of the LinePrice field or create a variable TotalAmount and caculate the total of the values
Check Standard Reports Order Confirmation or Invoice, there is a field in that called TotalAmountInclVAT and check the logic for that.
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/.../
[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.
Check this
msdn.microsoft.com/.../ms170712.aspx
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?
Yes you can do it by referencing the report item
msdn.microsoft.com/.../dd220421.aspx
Try to check how the standard reports are doing.
Yeah I've tried doing that but I just get this when I try to save the report
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.
When do you get this error ,when you add something to the footer of the report ? Check report 119 for easy version.
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.
You need to select the dataset for the table, or reference that in that field.
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.
Congratulations to our 2026 Super Stars!
Thanks to all of our 2025 Community Spotlight stars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.