Skip to main content

Notifications

Microsoft Dynamics NAV (Archived)

Sum duplicates rows

Posted on by Microsoft Employee

problem.jpg Hello. The problem I have doesn't look to hard, but I tried everything and I cant fix this. In my report I'm getting duplicate lines, yet they should be combined into one value, as you can see in the picture the red numbers are the ones that I should get, but for some strange it is split into 5 different lines. Please help me.

*This post is locked for comments

  • Suggested answer
    Rajasekhar@MS Profile Picture
    Rajasekhar@MS 5,567 on at
    RE: Sum duplicates rows

    Hi

    If you want to show sum of those 5 lines into one line, you need to create parent group based on the relation like Document No. , No. , on what basis or how are you identifying those lines needs to show sum, with that field or fields you need to create group and in textbox Use expression like sum(Fields!Decimal.Value)

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Sum duplicates rows

    Checked all grouping and its really ok, as for visibility i have it set to hide blank lines, but in my case visibility wouldn't help anyway, since i need to "SUM" some rows into one, because what i get is 5 lines with small values which should be only 1 line with all those value combined, for some strange reason it separates some values into 5.

  • Suggested answer
    Yogesh Kulkarni_ Profile Picture
    Yogesh Kulkarni_ 1,762 on at
    RE: Sum duplicates rows

    Rocius,

    Please check how grouping is been done in Classic Report.

    Probably, this has something to do with grouping.

    Also check whether some visibility (SHOWOUTPUT function) is been applied in classic report or not or for some calculations.

    -Yogesh Kulkarni
    Please verify, if you find answer helpful.

  • Suggested answer
    Amol Salvi Profile Picture
    Amol Salvi 18,694 on at
    RE: Sum duplicates rows

    Check how grouping done in classic report. It surely some grouping done to get this done.

  • Suggested answer
    Indikauk Profile Picture
    Indikauk 1,759 on at
    RE: Sum duplicates rows

    Hi Rocius

    Its Look Like you are printing details & to get the total you need to group the data so that you can get summary based on your group.

    Thanks

    Indika.

  • Suggested answer
    Suresh Kulla Profile Picture
    Suresh Kulla 43,745 on at
    RE: Sum duplicates rows

    What is the table you are using for data source? are you grouping on anything.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Sum duplicates rows

    problem-2.jpgIts a custom report. Values that are displayed are coming from record, my job is basicly to convert a report from 2009 to 2016 and i just cant seem to find a solution on how to fix this, in 2009 dynamic nav i also couldnt find that function to sum duplicates, but the person that created it managed to do it, sadly i dont know who made it and how he made it.

  • Suresh Kulla Profile Picture
    Suresh Kulla 43,745 on at
    RE: Sum duplicates rows

    Is it a custom report or standard report. What values you are displaying and how are you grouping ? 

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Sum duplicates rows

    Sorry forgot to mention I work on reports with Visual studio 2015.

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!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,151 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,993 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans