KoolReport's Forum

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

Total and Grand total #49

php datagrid php pivot table
Open zenon opened this topic on on Aug 2, 2017 - 1 comments
zenon commented on Aug 2, 2017

Hi KoolPHP Inc,

Is it possible to have total and grand total in a table like Table 1 below? I managed to do like Table 2. I tried using the Group process (by date, sum quantity), however, the item column will only show 1 row like Table 3 as shown below.

Thanks.

KoolReport commented on Aug 2, 2017

There are two solutions:

  1. Use the Pivot package
  2. Build your own table using data resulted in dataStore:

To get data and meta data from a datastore you do;

$data = $this->dataStore("name_of_store")->data();
$meta = $this->dataStore("name_of_store")->meta();

There you can loop and build you own table.

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

Designed and built with by KoolPHP Inc.

Code licensed MIT.