Hi Ralf,

Please put your pivot matrix inside a form together with your Export button and this hidden input:

<input type='hidden' name='koolPivotUpdate' value=1 />

Let me know if it solves your export problem. Thanks!

Hi Ralf,

The form should have method="post" and the Excel export button should be like this:

<form id='form1' class="form-inline" method="post">
                <button formaction='exportExcel.php'>Export Excel</button>
                <input type='hidden' name='koolPivotUpdate' value=1 />
                <?php
                PivotMatrix::create(array(
                    "id" => "pivotMatrix1",
                    'dataSource' => $this->dataStore('sales'),
                ...
</form>

and exportExcel.php should be:

require_once "MyReport.php";
$report = new MyReport();

$report->run()->exportToExcel('MyReportExcel')->toBrowser("MyReport.xlsx");

Thanks!