KoolReport's Forum

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

Latest Version of PivotExtract Appears Broken #1002

Open Michael Menefee opened this topic on on Jul 20, 2019 - 2 comments

Michael Menefee commented on Jul 20, 2019

Hi, it appears PivotExtract is returning zeros for all values, including on your example page: https://www.koolreport.com/examples/reports/pivot/pivot_extract/

I'm seeing equivalent results, no matter what parameters I pass to PivotExtract.

Further, I can't seem to extract the whole table - errors out unless I specify a parent for both row and column.

Any ideas...?

Thanks!

KoolReport commented on Jul 21, 2019

Sorry for our late reply, please allow us sometime to consult the dev.team.

David Winterburn commented on Jul 22, 2019

Hi Michael,

We will fix this issue the next release of Pivot package. In the meantime, you could apply a patch by opening the file pivot/PivotUtil.php and replace these lines:

                $dataRow = isset($fni['indexToDataRaw'][$r][$c]) ? 
                $fni['indexToDataRaw'][$r][$c] : array();

with these:

                $dataRow = isset($fni['indexToData'][$r][$c]) ? 
                $fni['indexToData'][$r][$c] : array();

Let us know if it works for you. Thanks!

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
bug
help needed

Pivot