DataTable RowGrouping Not Grouping Error

comicrage

Hi,

I am using DataTable 1.9 and the RowGrouping pluging. The IQueryable collection being binded to the datatable is not sorted or grouped before the databinding event. When I used the following code

var oResultGrid = $("[id$='gvReportData']");

if (fixEmptyDataRow(oResultGrid)) {
var oTable = oResultGrid.dataTable({
"bPaginate": false,
"bFilter": false,
"bInfo": false
}).rowGrouping({
bExpandableGrouping: true,
iGroupingColumnIndex: 2

});
}
else {
oResultGrid.dataTable({
"sPaginationType": "full_numbers",
"aaSorting": [[1, 'asc']]
}).rowGrouping({
bExpandableGrouping: true,
iGroupingColumnIndex: 2
});
}

I can see that the rowgrouping takes the 2nd column as the grouping field. I see the gray grouping header on top of each row/record, but the common row in term of the column are not grouped. I only see the grouping field in gray header on top of each row but they are not group under the grouping field, therefore, no + expandable or collapsible function.

Been spinning for hours on this. Any help is greatly appreciated.