I have some big data I need to run reports on. In a year span the table could be 400,000 rows and about 85 columns of data computed in a stored procedure that can generate tons of different views for financial reporting. I have no problem exporting the data. First sheet looks good but the second sheet is blank.

Here is what I am working with in dev at the moment. What am I missing?

 protected function setup()
    {
		$params = array();

		$params[':pdate1'] = $this->params["pdate1"];
		$params[':pdate2'] = $this->params["pdate2"];
		$params[':pdate3'] = $this->params["pdate3"];
			
		$this->src('report')
			->query( "exec sp_getFinancialData @pdate1 = :pdate1,@pdate2 = :pdate2,@pdate3 = :pdate3"	)
			->params($params)
			->saveTo($trip_list);
			
			$trip_list->pipe($this->dataStore("trip_list"));
			
			$trip_list->pipe(new Pivot(array(
					"dimensions" => array(
						"column" => "expected, allowed",
						"row" => "orgCode"
					),
					"aggregates"=>array(
						"sum" => "charge"
					)
				)))
			->saveTo($trip_list_pivot);
			
			$trip_list_pivot->pipe($this->dataStore("trip_list_pivot"));
			;
    }    

I just want to list the org name on the left with some agg data in the columns across row grouped by the organization.

scratch this reply. Still need help with empty pivot for other reasons.

Old excel formats only support 65536 rows and I suspect ExcelExportable is probably 97 format wheras the big file export is true xslx ( just a guess ). Instead of using pivot can I apply a template to the second sheet or something?

In retrospect I think the best solution will be to pivot the data right in a copy of the original procedure. This is very easy to do with the built-in group_concat function in mysql and probably a lot faster. Also as far as koolreport is concerned BigSpreadsheetExportable is much faster than the ExcelExportable. I dont mind splitting up the data into two separate spreadsheets and adjusting the names to identify them respectively as the transaction data or pivot data, so I guess I will consider this resolved.