Hi, I have a report that is generating dynamically 29-31 columns as days of month depending on the month type. each day has a different number value. I want to add another column that will sum all the numbers in the generated days column.

here is the report code:

function setup()
    {
        $this->month = date('m', strtotime($this->params["date"]));
        $this->year = date('Y', strtotime($this->params["date"]));
        $this->monthDays = cal_days_in_month(CAL_GREGORIAN, $this->month, $this->year);
        $this->src('db')
        ->query('CALL getTeacherAttendancePerMonth(:year, :date)')
        ->params(array(
            ":year"=>$this->params["year"],
            ":date"=>$this->params["date"]
        ))
        ->pipe(new \koolreport\processes\Map(array(
            "{value}" => function($row, $metaData, $index, $mapState) {
                $days = array('א','ב','ג','ד','ה','ו','ש');
                //$month = date('m', strtotime($this->params["date"]));
                //$year = date('Y', strtotime($this->params["date"]));
                $newRow = [];
                foreach ($row as $k => $v) {
                    if (is_numeric($k))
                        $k = 1*$k;
                        if ($k >= 1 && $k <= 31) { //i.e $k is month day
                            $weekday = date('w', strtotime($this->year.'-'.$this->month.'-'.$k));
            		        $newRow[$k. " - " . $days[$weekday]] = $row[$k];
                        } else {
                            //echo $k."<br>";
                            $originalK = $k;
                            if ( in_array($k, array('teacher_id','id_number','hour_group_id', 'total_hours', 'reason_id') ) ) {
                                $k = lang('tts.'.$k);
                            }
                            $newRow[$k] = $row[$originalK];
                            //$row[$originalK] = number_format($substituteDays * $row['cost'], 2);
                        }
                    }
                    return $newRow;
                }
        )))
        ->pipe($this->dataStore("st"));
    }

<?php
        DataTables::create(array(
            "dataSource"=>$this->dataStore("st"),
            "removeDuplicate"=>array("id_number","teacher_id","total_hours"),
            "options"=>array(
                "searching"=>true,
                "paging"=>true,
                'columnDefs' => array(
        			array(
        				'visible' => false,
        				//'targets' => [$this->monthDays+6], //hide the first column
        			)
        		),
            ),
            'complexHeaders' => true,
            'headerSeparator' => ' - ',
            'cssClass'=>array(
                'table'=>'table table-bordered',
                'tr'=>'cssItem',
                'td'=>function($row,$colName)
                {
                    return in_array($colName, array('teacher_id','id_number', 'reason')) ? 'text-right' : 'text-center';
                },
                'th'=>function($colName)
                {
                    return in_array($colName, array('teacher_id','id_number','reason')) ? 'table-dark text-right' : 'table-dark text-center';
                },
            ),
        ));
        echo '<div class="footer print-only">Footer</div>';
        ?>

Please see attached a screen capture of the report.

I want to group the first, second and tenth column to be one in case its have the same value. how do I do that?

Hi David, Thanks, i used the first solution to calculate the Sum in the same MAP process I already have in the code and it works. 1. I did not understand the second solution for the group. what actually I am trying to achieve is the following: I have a row with teacher name for example David Winterburn id number 123456789. this teacher have two rows or maybe three or more depending on the grouped data in the database. I want that the column teacher name and id number will join to be one.
2. columns that have NULL are displayed in the report with a dash. can I remove it. I want it to be empty. I tried to use DropNull() but does not help!

Lets ask it like this. assuming I want to group a single column, teacher_id what do I need to do?

clientRowGroup can not help me. it is a formula column. I have a column that dome of its rows are identical and I just want to rowspan them to be single. do you have a code sample for that?

But "removeDuplicate" is also not something that can help in my case. because in case I have a teacher name David and he has two rows in table. implementing removeDuplicate to the teacher name will work fine because the name is unique but lets assume I want to removeDuplicate on a column which is not unique in the table, for example working_hours. in this case if two different teachers will have the same working_hours it will group them also despite the fact the it is a different teacher name