Page 1 of 1

Group item & Sum of the value

Posted: Mon Aug 08, 2011 3:09 am
by 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:

Group item & Sum of the value

Posted: Mon Aug 08, 2011 7:10 am
by HighAley
Hello.

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

Thank you.

Group item & Sum of the value

Posted: Mon Aug 08, 2011 10:48 pm
by 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.



Group item & Sum of the value

Posted: Tue Aug 09, 2011 1:42 am
by HighAley
Hello.
XiaoJun wrote: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.

Group item & Sum of the value

Posted: Tue Aug 09, 2011 5:19 am
by XiaoJun
it seem like the example is sort by the code,
but i need the sorting is by No, not by the code.:blush:

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 :)

Group item & Sum of the value

Posted: Tue Aug 09, 2011 7:33 am
by HighAley
Hello.
XiaoJun wrote:it seem like the example is sort by the code,
but i need the sorting is by No, not by the code.:blush:

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.