Dear Koolreport,

Why in Create Pivot in Codeigniter not support to set row more than 2 field ?

Below is 2 field in row and fine :

->pipe(new Pivot(array(
		    'dimensions'=>array(
		    'row'=>'NmLang,NmBar'
		  ),

If more than 2, error child row :

->pipe(new Pivot(array(
		    'dimensions'=>array(
		    'row'=>'NmLang,NmBar,No_OK'
		  ),

I'm already create pivot in koolreport example without codeigniter with row more than 2 field, output is no problem.

Regards,

Mazmur

Hi David,

This is screenshoots my error report with pivot in codeigniter :

Code my Report :

->pipe(new Pivot(array(
		    'dimensions'=>array(
		    'row'=>'NmLang,NmBar,No_OK'
		  ),
		  'aggregates'=>array(
			'sum'=>'SaldoAkhir',
			'count'=>'SaldoAkhir'
		  )
		)))
		->pipe($this->dataStore("StockFG"));

my view :

 <?php
			  $dataStore = $this->dataStore('StockFG');
			  PivotTable::create(array(
				'dataStore'=>$dataStore,
				'rowDimension'=>'row',			
				'measures'=>array(
				  'SaldoAkhir - sum', 
				  'SaldoAkhir - count'
				),
				'rowSort' => array(
				  'SaldoAkhir - sum' => 'desc',
				),
				'rowCollapseLevels' => array(1),
				'totalName' => 'Total Stock',
				 'width' => '100%',
				'nameMap' => array(
				  'SaldoAkhir - sum' => 'Sales (in USD)',
				  'SaldoAkhir - count' => 'Number of Sales',
				),
				
			  ));
			?>

Ok, Solved. Thank you