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?
[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
#1
André Arnaud de Cal...
291,622
Super User 2024 Season 2
#2
Martin Dráb
230,354
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
