Sum duplicates rows

(0) Share

Report

Posted on by Community Member

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

I have the same question (0)

All responses (9)

Answers (0)

Community Member on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Suresh Kulla 50,251 Super User 2025 Season 2 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Its 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.

Was this reply helpful? Yes No
Suggested answer

Suresh Kulla 50,251 Super User 2025 Season 2 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Suggested answer

Indikauk 1,759 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Suggested answer

Amol Salvi 18,698 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Suggested answer

Yogesh Kulkarni_ 1,762 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Suggested answer

Rajasekhar@MS 5,569 on at

Like (0)

Report
Copy link

Link copied!

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)

Was this reply helpful? Yes No