I've been working with a database that handles sales checks, I need to be able to first group the data by branch, then by sales person and finally by client and show all the individual checks that have been registered to each client. I've used the groupCollapse parameter, but to my surprise it only affects the last column you add to the groupField array, so the rest of the fields, even though the collapse icon is a + sign, they appear uncollapsed.
Does anyone know of a workaround? I've tried to mess around with the groupingToggle feature but I don't really know how it works... I'm still trying to understand how javascript/jquery works so it's really hard for me to figure out a way to solve this problem.
If you need me to, I can upload my code somewhere so you can take a look at it.
Update
Here's the grouping part of my code:
grouping:true,
groupingView : {
groupField : ['Sucursal','SlpName','OCRDCardName'],
groupColumnShow : [false, false],
groupText : ['<b>{0}</b>'],
groupCollapse : true,
groupOrder: ['asc', 'asc'],
groupSummary : [true, true],
showSummaryOnHide: true
}
Here's my jsfiddle: http://jsfiddle.net/xnkUr/