I was wondering if there was a way in the data grids to have a footer in the Group By?

Meaning instead of doing the sum of all the columns for the whole report only do the sum for the columns in each group?

DataTables::create([
                'name' => 'rowGroupTable',
                'dataStore' => $this->dataStore('result'),
                'plugins' => [
                    'Buttons',
                    'FixedColumns',
                    'FixedHeader',
                    'KeyTable',
                    'Responsive',
                    'RowReorder',
                    'Scroller',
                    'SearchPanes'
                ],
                'options' => [
                    'dom' => 'Blfrtip',
                    'buttons' => [
                    ],
                    'searching' => true,
                    'paging' => true,
                    'pageLength' => 100,
                    'order' => $this->params['order'],
                    'fixedHeader' => true,
                    'autoWidth' => false,
                    'columnDefs' => [
                        $width
                    ],       
                ],
                'clientRowGroup' => [
                    'groupby' => [
                        'direction' => 'asc',
                        'top' => '<td colspan="999">{expandCollapseIcon} ' . $groupbyTitle . ': {groupby}</td>',
                    ],
                ],
                'cssClass' => [
                    'table' => 'table table-bordered table-striped table-hover'
                ],
                'columns' => $columns,
                'showFooter' => $this->params['sum'],
                'fastRender' => true,
                'onReady' => 'function() {
                    arr = getOrderBy();
                    rowGroupTable
                    .order(arr)
                    .draw();
                    checkRecordCount();
                }',
            ]);

Here is our code snippet for how we handle our group by data table.

This Picture shows the general Idea of what we want.

There are a couple of issues I am seeing.

First, I have spaces in my column names and that is causing this error.

This error is when I try to Use the column Permit # to do the calculation.

Second, When I do use a column that has no space it works, however not all my rows have data and when it does the sum it is returning a NaN rather than the actual Number.

My guess is that the Sum is not converting Nulls to 0 AND so it is failing. Is there anything I can do on my end (I still need to display nulls as they are) to fix this issue?

I did This to koolreport/datagrid/DataTables.php and it worked for the NaN issue.

Not sure that really helps or not.

Do you have an ETA on when that would be done?

I know that is has been forever since this thread and I am finally getting back to this. So it fixes the first issue of the JS error. but this file did not fix the second issue of NAN issue.

Also, not sure, but if a group by goes to another page does it only calculate for the group by on the one page or the full group by?

it would be helpful to have all the same grouped categories have the total at the end of the of their group by. we do 100 rows per page but have some groups that exceed that.

We will look into how we can get the summed values to not be NAN.