Notifications
Announcements
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
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?
You need to select the dataset for the table, or reference that in that field.
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.
When do you get this error ,when you add something to the footer of the report ? Check report 119 for easy version.
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.
Yes you can do it by referencing the report item
msdn.microsoft.com/.../dd220421.aspx
Try to check how the standard reports are doing.
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?
Check this
msdn.microsoft.com/.../ms170712.aspx
[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.
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
HoangNam 7
