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.

Thanks it worked.