Group item & Sum of the value

[XiaoJun]

Hi.. i come again :emb:


Is it posible to group same item and sum their value at stimulsoft?
ex: I have an table
No Code Color Quantity SubTotal
-----------------------------------------------
1 00001 Blue 100 10000
2 00002 Orange 50 5000
3 00001 Blue 30 3000
4 00003 White 50 5000


Then i need the row no 1 and 3 to be combine like :
No Code Color Quantity SubTotal
-----------------------------------------------
1 00001 Blue 130 13000
2 00002 Orange 50 5000
3 00003 White 50 5000


thanks before :amazed:

[HighAley]

Hello.

Yes, It is possible. Please check attached report template.

Thank you.

[XiaoJun]

Thanks for your reply,,:biggrin:

but why i can't open the report? is it because of my stimulsoft version? i am using stimulsoft report.net.2008.1.

[HighAley]

Hello.

Thanks for your reply,,:biggrin:

but why i can't open the report? is it because of my stimulsoft version? i am using stimulsoft report.net.2008.1.

Yes, there are maybe problems with backward compatibility on older versions of StimulSoft Reports.
Please try attached report created in 2008.1 version.

Thank you.

[XiaoJun]

it seem like the example is sort by the code,
but i need the sorting is by No, not by the code.

the illustration is like i have a table data and there's already sorting with the column No is the identity, and then in report, i want the same item is grouping without change the major sorting.


thanks

[HighAley]

Hello.

it seem like the example is sort by the code,
but i need the sorting is by No, not by the code.

the illustration is like i have a table data and there's already sorting with the column No is the identity, and then in report, i want the same item is grouping without change the major sorting.


thanks

The sorting if GroupBand is necessary for right grouping. If you need any other sorting you can add it in DataBand.

Thank you.