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 - 2 comments

entahsiapa commented on Dec 2

How to use Pivot with Mysql

pargibay commented on Dec 2

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

thanks

KoolReport Is Free and Open-Source!

KoolReport is a professional php reporting framework which saves you tons of time to construct dynamic data report & dashboard.

  • Connect to various datasources such as MySQL, SQL Server, MongoDB or even from CSV or Excel file.
  • Contain series of powerful built-in data processes for your data manipulation.
  • Generate stunning charts and graphs to help you communicate data insights to your audiences effectively.
  • Integrate seamlessly with any php frameworks such as Laravel, CodeIgniter, Symfony.
Download Now and register our tutorials to get started!

Download KoolReport
None yet

None