KoolReport's Forum

Official Support Area, Q&As, Discussions, Suggestions and Bug reports.
Forum's Guidelines

Export PDF Is Blank with Pivot Table #922

Closed Hana opened this topic on on Jun 13, 2019 - 5 comments

Hana commented on Jun 13, 2019

Hi, i have a problem to export PDF is blank with PivotTable, Version Koolreport 4.0

Code:

//ReporteGastosController.php $report = new ReporteGastos;

    $report->run()
            ->export('ReporteGastosPdf')
            ->pdf(array(
                "width" => '31cm',
                "height" => '21cm',
                "margin" => '0.8cm'
            ))
            ->toBrowser("reporte_gastos.pdf");

//ReporteGastosPDF.view.php use \koolreport\widgets\koolphp\Table;

        use \koolreport\pivot\widgets\PivotTable;

        $dataStore = $this->dataStore('co_polizas_detalle');

        PivotTable::create(array(
            "dataStore"=>$dataStore,
            "measures"=>array(
                "copd_cargo - sum"
            ),
            'width' => '95%',
            "columnCollapseLevels" => array(2),
            "rowCollapseLevels" => array(4),  
            'totalName' => 'TOTAL',
            "headerMap" => array(
                "copd_cargo - sum" => 'CUENTA'
            ),
        ));
David Winterburn commented on Jun 14, 2019

Hi Hana,

What happens if you use your pdf view file as your report view file? Does it show the pivottable as normal? Thanks!

Hana commented on Jun 14, 2019

Hi David

In the web view the pivot table is shown correctly, when I download the Excel file the pivot table is generated correctly too. But when I download the PDF file the file generate all the pages but all of them are blank pages.

I took the Koolreports pivot table example to export to PDF and also in their example the PDF file generated has all the pages in blank.

Example : https://www.koolreport.com/examples/reports/pivot/pivot_extract/

Hana commented on Jun 18, 2019

Hi David

In the web view the pivot table is shown correctly, when I download the Excel file the pivot table is generated correctly too. But when I download the PDF file the file generate all the pages but all of them are blank pages.

I took the Koolreports pivot table example to export to PDF and also in their example the PDF file generated has all the pages in blank.

Example : https://www.koolreport.com/examples/reports/pivot/pivot_extract/

David Winterburn commented on Jun 19, 2019

Hi Hana,

We are aware of this issue and will release a fixed version of Pivot soon.

Oya Kaynar commented on Dec 18, 2020

is the problem solved

Build Your Excellent Data Report

Let KoolReport help you to make great reports. It's free & open-source released under MIT license.

Download KoolReport View demo
None yet

Export