You’re offline. This is a read only version of the page.
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
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)
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.
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.
Check how grouping done in classic report. It surely some grouping done to get this done.
What is the table you are using for data source? are you grouping on anything.
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.
Is it a custom report or standard report. What values you are displaying and how are you grouping ?
Sorry forgot to mention I work on reports with Visual studio 2015.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,151
Super User 2024 Season 2
#2
Martin Dráb
229,993
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (