Basic

Sales By Customer

Get the top ten customers who pay the most.

Sakila Rental Report

Get the sale report by month.

Sakila Rental Report With Database

Connect to Sakila database using PdoDataSource.

Format value in column

Show how to format value in table's column.

Sale By Country with GeoChart

Use Geochart in report.

Table Demo

This example demonstrates the capability and usage of table.

Advanced examples

Order List

View order of a customer, export report.

Export package

Export package helps to export your report to PDF and other formats. Get the Export package in here.

Export Sakila Rental Report

Export report to PDF.

Cube package

Cube package helps to turn your data into two dimension cross-tab table. Get the Cube package in here.

Sales by Quarters

Get sales by the quarters.

Sales by Months and Years

Get sales by months and years.

Sales by Customers And Products

Get sales by customers and products.

Pivot package

Pivot package helps you to explore multi-dimension aggregated data in a hierarchical way. Get the Pivot package in here.

Customers - Categories - Products Pivot

Get pivot table for customers, categories and products.

Years - Months Pivot

Get pivot table for years and months.

Years -Months - Customers - Categories Pivot

Get pivot table for years, months, customers and categories.

Inputs package

Inputs package helps you to build dynamic reports with user's inputs Get the Inputs package in here.

Introduce controls

List of all current controls in inputs.

List of orders

Get list of orders within date ranges and of selected customers.

Barcode package

Barcode package helps you to generate multiple types of barcode and qrcode Get the Barcode package in here.

Products' barcode

Catalogs of products' barcode and infomation.

Instruction

Setup databases

Most of our examples use .csv data file so that they can be run immediately without any installation. However, in some examples we would like to demonstrate the real usage of KoolReport with databases. So these examples require you to install samples databases.

You may find in the folder ./examples/databases three(3) sample databases which are automaker, sakila and world. They has been zipped for smaller size.

To install, you use phpMyAdmin to import directly those zipped file. There is no need to unzip.

To set the databases authentication, please open the ./examples/config.php file, there you can set your username and password so that example can work. The config file look like this:


<?php
return array(
    "automaker"=>array(
        "connectionString"=>"mysql:host=localhost;dbname=automaker",
        "username"=>"root",
        "password"=>"",
        "charset"=>"utf8"
    ),
    "sakila"=>array(
        "connectionString"=>"mysql:host=localhost;dbname=sakila",
        "username"=>"root",
        "password"=>"",
        "charset"=>"utf8"
    ),
    "world"=>array(
        "connectionString"=>"mysql:host=localhost;dbname=world",
        "username"=>"root",
        "password"=>"",
        "charset"=>"utf8"
    ),    
);

Extended packages

The demo may contains examples for specific packages which are not available standard KoolReport delivery. To install a package, you need to:

Download the package from KoolReport packages
Unzip package and put it inside folder "koolreport/packages"
All done! The packages is ready to use.

KoolReport Pro

KoolReport Pro is a special version including the latest KoolReport and all commercial packages. It is back with life-time license and professional support from us. The KoolReport pro comes with Developer License and Enterprise License.

Click here for more details.

Examples