Hello,
I just bought the PRO, I am new to KoolReports.
I am trying to alter the pivot example report provided,
I want to pass value to this pipe,
->pipe(new Pivot(array(
"dimensions"=>array(
"column"=>"orderYear, orderMonth",
"row"=>"customerName, productLine"
),
"aggregates"=>array(
"sum"=>"dollar_sales",
"count"=>"dollar_sales"
)
)))
In the above code using your customer_product_dollarsales2, orderYear, orderMonth already converted to 2015, 03. But in my case i take full date(2015-03-11) from Database.
My question here is,
How to pass orderYear from my DB result (2015-03-11) ?
Thanks.