KoolReport v.1.27.6

Yeahhh! Party again in just 20 days! We just want to let you know that we have released new version 1.27.6. This version contains very important updates such as: ability to theme report, supporting old database connections, sorting columns by name or label.

Theme your report

One of the most requested features that we received from our users is the ability to theme or style a report. A theme sets a report a consistent font, colors of chart, spacing and etc. As a result, we will have different look and feel for our report just by changing the one themes to another. In this new version, we can use a theme simple as below code:

<?php
class MyReport extends \koolreport\KoolReport
{
    use \koolreport\bluesea\BlueSeaTheme;
}

Although in this version, KoolReport is able to theme a report but we are still working on a theme to release. There is no theme demo right now but it will be soon. We will keep you update.

Support old database connection

Since the first version of KoolReport, we support the use of PDODataSource to connect to most common databases such as MySQL,SQL Server, Oracle and others. PDO has become standard of database connection. However, some of our users still request the old database connection. So we have added first two classes MySQLDataSource and SQLSRVDataSource to help to connect the most used databases.

Sort columns by name or labels

We have provided a new process called ColumnsSort which help to sort your list of columns in correct order. This process can be used after Cube or Pivot process to re-order the columns generated by them.

Some other minor updates

1. Fix the initiation of Google Chart widgets, this fix is due to the change in google chart library.
2. Move ExcelDataSource and MongoDataSource to separated packages. This will help to reduce the size of core packages. The packages for excel and mongodb will be distributed free under MIT License.
3. Add debug() function to KoolReport so that we can see the all data available before creating view.
4. Sort process now can sort data by custom comparison function.

The full updates list can be found here.

If you have any questions or comments on this new version, please go to this forum thread. All comments, good or bad, are welcome.

Thank you very much.

<3 koolreport team