KoolReport's Forum

Official Support Area, Q&As, Discussions, Suggestions and Bug reports.

Pivot with Mysql #1193

Closed entahsiapa opened this topic on on Dec 2, 2019 - 2 comments

entahsiapa commented on Dec 2, 2019

How to use Pivot with Mysql

pargibay commented on Dec 2, 2019

Hi Entahsiapa,

the database is indifferent.

You can take an example like this and try with your mysql ddbb

 $node = $this->src('dollarsales'); //here your data conection
[......]
        ->pipe(new Pivot(array( //here define your pivot structure -> row/column
            'dimensions'=>array(
                'row'=>'customerName, productLine, productName'
            ),
[......]
        ->pipe($this->dataStore('sales'));
entahsiapa commented on Dec 3, 2019

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
None yet

None