MadIce
asked on
Total columns at group level in WinGrid
Infragistics controls are new to me and I'm struggling on how to use Calcs in the Wingrid. My datasource for my grid is results from a stored procedure. I did my grouping and group totals in the results. Works fine. Problem is the user needs to be able to change numbers on the grid to get new calcs. It works great when summing across in a row but can't get it to work on column level to the group. Let me show an example.
RecLevel Building SN TM BoxQty PalletQty TotalQty
Serial Level 5 1211 ZZA 0 0 0
Serial Level 5 1222 ZZA 0 0 0
Item Level 5 ZZA 100 1000 1100
Serial Level 7 1344 ZZA 0 0 0
Serial Level 7 1345 ZZA 0 0 0
Item Level 7 ZZA 200 3000 3200
Total Level ZZA 4300
Serial Level 5 1211 AAA 0 0 0
Serial Level 5 1222 AAA 0 0 0
Item Level 5 AAA 100 1000 1100
Serial Level 7 1344 AAA 0 0 0
Serial Level 7 1345 AAA 0 0 0
Item Level 7 AAA 200 3000 3200
Total Level AAA 4300
What I want to do is take the totalQty and total to the TotalLevel. I start out with this but when the user changes BoxQty or PalletQty it totals across but not down.
I've tried to use the Formula feature at the column level but can't get that to work. Trying to read up on ICustomSummaryCalculator , grouping and other stuff just not sure how to go about it.
FYI there are around 30 columns.
Using VB.net 2008.
RecLevel Building SN TM BoxQty PalletQty TotalQty
Serial Level 5 1211 ZZA 0 0 0
Serial Level 5 1222 ZZA 0 0 0
Item Level 5 ZZA 100 1000 1100
Serial Level 7 1344 ZZA 0 0 0
Serial Level 7 1345 ZZA 0 0 0
Item Level 7 ZZA 200 3000 3200
Total Level ZZA 4300
Serial Level 5 1211 AAA 0 0 0
Serial Level 5 1222 AAA 0 0 0
Item Level 5 AAA 100 1000 1100
Serial Level 7 1344 AAA 0 0 0
Serial Level 7 1345 AAA 0 0 0
Item Level 7 AAA 200 3000 3200
Total Level AAA 4300
What I want to do is take the totalQty and total to the TotalLevel. I start out with this but when the user changes BoxQty or PalletQty it totals across but not down.
I've tried to use the Formula feature at the column level but can't get that to work. Trying to read up on ICustomSummaryCalculator , grouping and other stuff just not sure how to go about it.
FYI there are around 30 columns.
Using VB.net 2008.
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
ASKER
Found own answer. Not what I was looking for.
You can use the text ItemLevel to add up the values from one ItemLevel to another Itemlevel and put the sum in the required cell.