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.
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.
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.