Creating reports and dashboards | Stimulsoft community forum

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.

Hello,

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

Thank you.

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.

Hello,

You can add grouping and Sum by groups.

Thank you.