I'm using koolreport 3.1.0 to extract excel data with a pivot and I have the error: A PHP Error was encountered Severity: Notice Message: Undefined index: rowNodesMark

But when i use koolreport 4.0.0 or 4.0.1 i have this error: ErrorException (E_ERROR) Illegal offset type in isset or empty (View:

I use the koolreport_pro_3.1.0 i have this error: ErrorException (E_NOTICE) Undefined index: rowNodesMark

D:\xampp\htdocs\paeij\vendor\koolreport\packages\pivot\PivotExcelExport.php namespace koolreport\pivot;

use \koolreport\core\Utility; use \PhpOffice\PhpSpreadsheet as ps;

class PivotExcelExport {

public function saveDataStoreToSheet($dataStore, $sheet, $option)
{
    $totalName = Utility::get($option, 'totalName', 'Total');
    $emptyValue = Utility::get($option, 'emptyValue', '-');
    $headerMap = Utility::get($option, 'headerMap', array());
    $dataMap = Utility::get($option, 'dataMap', array());
    $meta = $dataStore->meta()['columns'];

    $pivotUtil = new PivotUtil($dataStore, $option);
    $fni = $pivotUtil->getFieldsNodesIndexes();
    $rowNodes = $fni['mappedRowNodes'];
    $rowNodesMark = $fni['rowNodesMark'];
    $rowIndexes = $fni['rowIndexes'];
    $rowFields = array_values($fni['rowFields']);
    $colNodes = $fni['mappedColNodes'];
    $colNodesMark = $fni['colNodesMark'];
    $colIndexes = $fni['colIndexes'];
    $colFields = array_values($fni['colFields']);
    $dataNodes = $fni['dataNodes'];
    $dataFields = array_values($fni['dataFields']);
    $indexToData = $fni['indexToData'];

    $cell = ps\Cell\Coordinate::stringFromColumnIndex(1) . 1;
    $endCell = ps\Cell\Coordinate::stringFromColumnIndex(
        count($rowFields)) . count($colFields);
    $sheet->setCellValue($cell, implode(' | ', $dataNodes));
    $sheet->mergeCells($cell . ":" . $endCell);
    $sheet->getStyle($cell)->getAlignment()->setHorizontal(
        ps\Style\Alignment::HORIZONTAL_CENTER);
    $sheet->getStyle($cell)->getAlignment()->setVertical(
        ps\Style\Alignment::VERTICAL_TOP);

Arguments "Undefined index: rowNodesMark"

This is my code:

pivotindicateur.php

<?php //MyReport.php namespace App\Reports;

require_once dirname(FILE)."/../../vendor/koolreport/autoload.php"; // No need, if you install KoolReport through composer use \koolreport\processes\Group; use \koolreport\cube\processes\Cube; use \koolreport\processes\ColumnMeta; use \koolreport\processes\CopyColumn; use \koolreport\processes\DateTimeFormat; use \koolreport\widgets\google\ColumnChart; use \koolreport\processes\Filter; use \koolreport\pivot\processes\Pivot; use \koolreport\pivot\processes\PivotExtract; use \koolreport\pivot\PivotExcelExport; require_once "BaseRapport.php";

class PivotIndicateur extends BaseRapport {

  use \koolreport\excel\ExcelExportable;

use \koolreport\export\Exportable;

public function setup()
{
    $node=$this->src('test')
    ->query("select LIBEFFT,LIBOUTPUT,LIBELLEIND,count(*) as TOTAL FROM indicateur i
    join effet e on e.IDEFFET=i.IDEFFET
    join output o on o.IDOUTPUT=i.IDOUTPUT group by LIBEFFT,LIBOUTPUT,LIBELLEIND;")
    ->pipe(new ColumnMeta(array(
      'TOTAL'=>array(
        'type'=>'number',
      ),
    )))
    ->pipe(new Pivot(array(
      'dimensions'=>array(
        'row'=>'LIBEFFT,LIBOUTPUT,LIBELLEIND'
      ),
      'aggregates'=>array(
        'sum'=>'TOTAL',
      )
    )))

    ->pipe($this->dataStore('pivotindicateur'));

}  

} //////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////::::

pivotindicateur.view.php

<?php

use \koolreport\widgets\koolphp\Table;
use \koolreport\widgets\google\ColumnChart;
use \koolreport\widgets\google\BarChart;
use \koolreport\widgets\google\DonutChart;
use \koolreport\widgets\google\PieChart;
use \koolreport\widgets\google\GeoChart;
use \koolreport\drilldown\DrillDown;
use \koolreport\processes\CopyColumn;
use \koolreport\pivot\widgets\PivotTable;

?>

/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////

pivotindicateur.excel.php:

<?php

use \koolreport\excel\Table;
use \koolreport\excel\PivotTable;
use \koolreport\excel\BarChart;
use \koolreport\excel\LineChart;

$sheet1 = "Indicateur";

?>