Sum duplicates rows

(0) Share

Report

Posted on by Community Member Microsoft Employee

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

All responses (9)

Answers (0)

Suggested answer

Rajasekhar@MS 5,567 on at

Like (0)

Report

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 Microsoft Employee on at

Like (0)

Report

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_ 1,762 on at

Like (0)

Report

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 18,694 on at

Like (0)

Report

RE: Sum duplicates rows

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

Indikauk 1,759 on at

Like (0)

Report

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 43,745 on at

Like (0)

Report

RE: Sum duplicates rows

What is the table you are using for data source? are you grouping on anything.
Community Member Microsoft Employee on at

Like (0)

Report

RE: Sum duplicates rows

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.
Suresh Kulla 43,745 on at

Like (0)

Report

RE: Sum duplicates rows

Is it a custom report or standard report. What values you are displaying and how are you grouping ?
Community Member Microsoft Employee on at

Like (0)

Report

RE: Sum duplicates rows

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