Download

KoolReport (v.6.6.1) has two forms of download based on your need. You can download the version of core library only or the one with examples included.

Install with Composer

If you are using Composer, you can install KoolReport by the command below:

 composer require koolreport/core

Tutorials

Watch our sceencasts

Get started with KoolReport

Learn how to install KoolReport with composer and to create a simple data report

Serious with building data report?

Keep updated

Interested in KoolReport and want to keep updated with our work?

We can keep you updated with what is going on with KoolReport: new features, bug fixed, new releases, new packages, tips and more.

What's included

Once downloaded, unzip the compressed folder to see the structure of KoolReport. You will see something like this:

koolreport/
└── core/
    ├── src/
    ├── tests/
    └── autoload.php
  				

Create your first report

Exciting! Let make a first simple working example.

Code Preview

The structure of our first example looks like this:

/
├── koolreport/
├── SalesByCustomer.php
├── SalesByCustomer.view.php
└── index.php
				

The SalesByCustomer.php contains report setup, SalesByCustomer.view.php contains view of report, and as you guessed index.php is the run file. Below are the detail code of each file.

<?php
require_once "SalesByCustomer.php";

$salesByCustomer = new SalesByCustomer;
$salesByCustomer->run()->render();					
				

<?php
require_once "koolreport/core/autoload.php";
use \koolreport\processes\Group;
use \koolreport\processes\Sort;
use \koolreport\processes\Limit;

class SalesByCustomer extends \koolreport\KoolReport
{
    public function settings()
    {
        return array(
            "dataSources"=>array(
                "sales"=>array(
                    "connectionString"=>"mysql:host=localhost;dbname=db_sales",
                    "username"=>"root",
                    "password"=>"",
                    "charset"=>"utf8"
                )
            )
        );
    }

    public function setup()
    {
        $this->src('sales')
        ->query("SELECT customerName,dollar_sales FROM customer_product_dollarsales")
        ->pipe(new Group(array(
            "by"=>"customerName",
            "sum"=>"dollar_sales"
        )))
        ->pipe(new Sort(array(
            "dollar_sales"=>"desc"
        )))
        ->pipe(new Limit(array(10)))
        ->pipe($this->dataStore('sales_by_customer'));
    }
}

				

<?php 
    use \koolreport\widgets\koolphp\Table;
    use \koolreport\widgets\google\BarChart;
?>

<div class="text-center">
    <h1>Sales Report</h1>
    <h4>This report shows top 10 sales by customer</h4>
</div>
<hr/>

<?php
    BarChart::create(array(
        "dataStore"=>$this->dataStore('sales_by_customer'),
        "width"=>"100%",
        "height"=>"500px",
        "columns"=>array(
            "customerName"=>array(
                "label"=>"Customer"
            ),
            "dollar_sales"=>array(
                "type"=>"number",
                "label"=>"Amount",
                "prefix"=>"$",
            )
        ),
        "options"=>array(
            "title"=>"Sales By Customer"
        )
    ));
?>
<?php
Table::create(array(
    "dataStore"=>$this->dataStore('sales_by_customer'),
        "columns"=>array(
            "customerName"=>array(
                "label"=>"Customer"
            ),
            "dollar_sales"=>array(
                "type"=>"number",
                "label"=>"Amount",
                "prefix"=>"$",
            )
        ),
    "cssClass"=>array(
        "table"=>"table table-hover table-bordered"
    )
));
?>
				

Result

Sales By Customer

Get the top ten customers who pay the most.

Some Q/A?

1. Your report looks so simple!

   Ah, yes! It is good to start with simplicity, isn't it? We will add more and more complicated examples along the way

2. Why you need to use the Group and Limit process when I can use SQL directly?

   Nice question! Yes, you can do so. However if you have CSV or Excel datasources which does not have power of database then you need Group and Limit process. Secondly, many data need to be clean up before they can be grouped, so you may want to pull out data, clean them first before grouping them.

Advanced examples

Below are some advanced examples to show how KoolReport can build an awesome report for you.

Sales By Country

Which countries generate the most sales?

Sales by Quarters

Summarize sales by the quarters.

Boat tickets

A catalog of available boat tickets for rent.

License

KoolReport is released under the MIT license and is copyright 2024 KoolPHP.Inc . Boiled down to smaller chunks, it can be described with the following conditions.

It requires you to:

• Keep the license and copyright notice included in KoolReport's PHP, CSS and JavaScript files when you use them in your works

It permits you to:

• Freely download and use KoolReport, in whole or in part, for personal, private, company internal, or commercial purposes
• Use KoolReport in packages or distributions that you create
• Modify the source code
• Grant a sub license to modify and distribute KoolReport to third parties not included in the license

It forbids you to:

• Hold the authors and license owners liable for damages as KoolReport is provided without warranty
• Hold the creators or copyright holders of KoolReport liable
• Redistribute any piece of KoolReport without proper attribution
• Use any marks owned by KoolPHP in any way that might state or imply that KoolPHP endorses your distribution
• Use any marks owned by KoolPHP in any way that might state or imply that you created the KoolPHP software in question

It does not require you to:

• Include the source of KoolReport itself, or of any modifications you may have made to it, in any redistribution you may assemble that includes it
• Submit changes that you make to KoolReport back to the KoolReport project (though such feedback is encouraged)

Contact Us

If you have any question, suggestion or anything you want to tell us, please use the Send Feedback button below. We will get back to you in no time.

* Please help us to improve the product.