Grouping but not changing the sequences
Data:
1:123:50
2:098:10
3:234:20
4:098:20
5:234:30
6:345:10
What I need in the report is:
1:123:50
2:098:30
3:234:50
4:345:10
but now will show with ascending:
1:098:30
2:123:50
3:234:50
4:345:10
If I put the group without sorting it will show the original data.
This discussion has been closed.
Comments
Hello!
To merge all rows with the same code whilst preserving the order of their first occurrence (123 → 50, 098 → 30, 234 → 50, 345 → 10), use the following solution:
Add a calculated column called FirstSeenSeq to the source (the sequence number of the first occurrence of the code: 123->0, 098->1, 234->2, 345->3), and in GroupHeaderBand.Condition specify [Data.FirstSeenSeq] (with SortOrder.Ascending), outputting [Data.Code] and [TotalSum].