KoolReport v1.47.3 has been rolled out

Party time! We are glad to let you know that we have released KoolReport version 1.47.3. This version contains some new data processing classes, enhancements for Table widgets as well as several bug fixes.

AggregatedColumn

This is a new process added to the family of KoolReport's data processes. This special process will create a new column which contains aggregated result of a column in the table.

->pipe(new AggregatedColumn(array(
    "total"=>array("sum","quantity")
)))
->pipe(new CalculatedColumn(array(
    "percent"=>"{quantity}/{total}"
)))

As you can see in above code, a new column called total, the sum of quantity, is added to table . From here, you can calculate the weight of quantity over total with CalculatedColumn. The AggregatedColumn support all basic operation sum, count, min, max

Tranpose process

Transpose process allows us to transpose a table, turning column into row and row into column. This process is helpful when you need to manipulate data to draw charts.

Table widget

Table widget is one of the most used in report. Some of enhanced features are:

1. The Table now has ability to show footer. We can add settings to make Table calculate sum, avg for a particular column and put result at the footer of table.
2. The Table now can apply css style to each column.

You may view example of Table here.

PdoDataSource

The issue of PdoDataSource is not working with SQL Server has been removed completely. If you are using PdoDataSource and not able to retrieve data from SQL Server, please upgrade KoolReport to this version.

Overall

Through time, KoolReport library has become better and better. Sometime we could not image we can reach this stage. Still, there are long way to go, our vision is still far and we are taking step by step toward it everyday.

<3 koolreport team