Group rows by value of a column

Stimulsoft Reports.WEB discussion
Post Reply
progalion
Posts: 10
Joined: Mon Nov 13, 2023 9:39 am

Group rows by value of a column

Post by progalion »

Greetings

I have a question about grouping the rows and I couldn't find my answer in the docs

Consider I have a datasource with these columns : Name - Count

for example I have 10 rows of this data source and 4 of them have same Name and I want to merge their Count column and sum the count
like :

Test 1 | 20
---------------
Test 1 | 23
--------------
Test 2 | 12

and the result I want :

----------------
Test 1 |
          | 42
Test 1 |
----------------
Test 2 | 12

*only the Count column is merged

Is it possible to do this?

Thank you.
Lech Kulikowski
Posts: 7333
Joined: Tue Mar 20, 2018 5:34 am

Re: Group rows by value of a column

Post by Lech Kulikowski »

Hello,

You can use the ProcessingDuplicates property.
https://www.stimulsoft.com/en/documenta ... icates.htm

Thank you.
progalion
Posts: 10
Joined: Mon Nov 13, 2023 9:39 am

Re: Group rows by value of a column

Post by progalion »

Hi

The solution you provided merge the duplicate column and its different from what I want
Is it possible to merge and sum the value of other columns?
Like if column A is duplicate , I want to group them and merge column b and sum the value of it

Thank you.
Lech Kulikowski
Posts: 7333
Joined: Tue Mar 20, 2018 5:34 am

Re: Group rows by value of a column

Post by Lech Kulikowski »

Hello,

You can add grouping and Sum by groups.

Thank you.
Attachments
Screenshot 2024-06-03 134108.png
Screenshot 2024-06-03 134108.png (39.59 KiB) Viewed 3652 times
Post Reply