June 7, 2019
LET PARTY! We are very happy to let you know that KoolReport 4.0.0 has been released. There are many enhancements in this version that worth your upgrade.
Now all our packages both free and paid can be installed through
Composer. The free packages are hosted with famous Packagist and the commercial packages are hosted with our self-built private repository.
Since we moved our GitHub repository from
koolreport/core, we have adjusted our folder structure a little bit for unity between manual installation and composer installation.
The core itself has been improved so much from datasources to data processes and the visualization. Those existed bugs from version 3.x has been solved completely in this version.
We added a new widget added called
Card to the core. The
Card allows us to show the important KPI value in our report. If you aim at constructing a dashboard, Card widget is very useful.
KoolReport 4.0.0 is extended capability to work with other template engines rather than just default and boring
.view file. To support this feature, we have released 3 new template engine packages:
- Blade: You are in love with Blade in Laravel? Now you can use blade for your report view
- PlatesPHP: You just want to use native PHP template? PlatesPHP is your best choice.
- Twig: Another famous and proven template engine. Fast and secure.
All of them are free. You can download those packages via our website or install them with composer.
Planning to release in previous version but we are only able to perfect and release our
Amazing theme package now. The
Amazing theme allows us to make our report look new and modern. Built on top of Bootstrap 4, the amazing theme inherits all cool features of Bootstrap 4 together with new look and feel. We also added some cool widgets for this theme package as well. Say no more, you can have a look at this new package here
Amazing Theme Introduction - Amazing's ChartCard
Other Packages' Enhancements
- Pivot: New
Pivot2D has been added. Algorithm change for better and faster data summarization.
- Excel: Able to create Excel charts using template, more widgets are added.
- Cube: Improve efficiency.
- CloudExport: Update ChromeHeadlessio service
- DataGrid: Improve security for server processing feature.
- ..and many others.
If you have owned KoolReport Pro license, you can upgrade via
composer with package name
koolreport/pro. You may login to our website, heading to My Licenses page and generate token key to upgrade. If you have not, please consider getting KoolReport Pro as it is the most valuable package that we offered.
KoolReport 4.0.0 is a must-upgraded version as it contains many important improvements and bug fixes. We are working hard to make KoolReport better and better day by day.
<3 koolreport team
July 16, 2018
LET PARTY to celebrate the new version of KoolReport 2.78.0. We are very proud because we thought everything was just perfect in the previous version but still this new one comes with a lot of improvements. We have been working hard to find every enhancement point even tiny. So here come the new version, all are backward compatible so you need not to worry. Please upgrade!
In this version, we have reviewed all datasource classes once more time to assure they are totally safe from any security threats. Furthermore, we have improved datasources for MySQL, Postgre, SQLSRV and Oracle to reduce their response time and memory usage by enabling the connection sharing. It means that, if you have multiple queries to the same database, connection will be shared between them thus reducing the unneccessary of re-connecting time. This technique has been implemented for PdoDataSource but have not done for others.
We have improved the
src($name) function as well. Previously, this method requires us to specify the name of datasource. However we found that 80% of the cases, we have only ONE datasource. So we thought that it would be nicer to just write
src() without any parameter, KoolReport will automatically get the first datasource to use. A tiny improvement but it can free our mind and reduce the typo of datasource name which resulted in error.
We have also enhanced the SubReport feature. In the previous version, we use HTML comment tags to mark subreport section but we found that some web servers remove the HTML comment tags for the purpose of optimization which will cause big issue for SubReport so we change to use HTML element. As a result, SubReport now works perfectly.
In previous version of KoolReport, we may need to remove the resources folder when upgrade to new version. It is quite troublesome and easy to forget. In this version, we use KoolReport's version and widget's version as a factor to generate widget's url. It helps us to reduce the unneccessary work when upgrade library, KoolReport will make sure all generated resources files stay updated.
Last, we have improved the event of
Google Chart and
Table. Now in those events like rowClick or itemSelect, we will receive selectedRow with associate data beside the array one. For example, you can access the row id by
selectedRow or by
selectedRow['id']. This will add convenience to get data cell value for further processing.
Above are highlights, you may view the full release note.
Together with the new core, we have release below new package version:
- DataGrid 1.5.0: Adding formatValue for footer and enable data-search and and data-order feature.
- Pivot 4.1.0: Add count percentage and sum percentage to pivot process
- Cube 2.1.0: New
- Excel 3.0.0: Change to advanced
PHPOffice/PHPSpeadsheet library and discard the deprecated
- ChartJS 1.2.0: Return associative array on event
- SparkLines 1.20: Add ability to write js in widget creation.
- Inputs 3.5.0: Add ability to write js in widget creation.
- Morris Chart 2.0.0: Use advanced jsonEncode() function.
- DrillDown 2.0.0: Ability to work with
Beside the new version of above packages, we have add two brand new packages
- Codeigniter 1.0.0
- Laravel 1.0.0
Those two packages are free and born to make KoolReport work seamlessly in CodeIgniter and Laravel environment. In the future, we will add more packages like those two to support KoolReport working in other PHP Frameworks like Symfony, Yii2 and etc.
And not to forget, we released KoolReport Pro 2.78.0 containing all above released packages. If you own KoolReport Pro, you may upgrade now.
Have thought that the previous version was perfect, we are proved to be wrong by this new releases with a lot of enhancements. Listening to users is the key point and we will continue to do so. We thank you so much for all of your suggestions, bug reports, your case of usages that you shared with us. That's priceless! Thank you!
If you have any questions or comments, please post on this forum topic.
<3 koolreport team
February 15, 2018
Today is the first day of year 2018 in Lunar Calendar. This is the time when we enjoy family atmosphere, visiting relatives and giving each others the best wishes. In this special occasion, we would like to give you 20% OFF for KoolReport Pro.
Let us help you to create the best report!
<3 koolreport team
January 16, 2018
Drill down and drill through are two extremely powerful features in business intelligence. They both give the user the ability to see data and information in more detail–although they do so in different fashions.
Drill down is a capability that takes the user from a more general view of the data to a more specific one at the click of a mouse. For example, a report that shows sales revenue by state can allow the user to select a state, click on it and see sales revenue by county or city within that state. It is called “drill down” because it is a feature that allows the user to go deeper into more specific layers of the data or information being analyzed.
Further levels of drill down can be set up within the report–practically as many as supported by the data. In our example, the drill-down can go from country to state to city to zip code to specific location of stores or individual sales reps. Typically, the look and feel of each level of the report is similar–what changes is the granularity of the data.
- Example 1: Sale By Time
- Example 2: Sale By Location
Drill Through (MultiView)
Instead of taking the user to a more granular level of the data, drill through takes him to a report that is relevant to the data being analyzed, also at the click of a mouse. For example, a tabular report that shows sales revenue by state can allow the user to click on it and reveal an analysis grid of the same data, or a heat map representing the data in visual form. It is called “drill through” because it is a feature that allows the user to pass from one report to another while still analyzing the same set of data.
- Example: Sale By Month With Different Views
Benefits of Drill Down and Drill Through
Gain instant knowledge of different depths of the data – Drill down gives the user a deeper insight of the data by letting him see what makes up the figures he’s analyzing. For example, in mere seconds, drill-down answers questions such as: of my National sales figure, which states are performing better? Which states are underperforming? And within each state, which territories are driving revenue?
See data from different points of view – Drill through allows users to analyze the same data through different reports, analyze it with different features and even display it through different visualization methods. This greatly enhances the users’ understanding of the data and of the reasons behind the figures.
Keep reporting load light and enhance reporting performance – By only presenting one layer of data at a time, features like drill down lighten the load on the server at query time and greatly enhance reporting performance–while offering great value to the end-user.
<3 koolreport team
January 4, 2018
We wish you have a great start on this 2018. On this special occasion we would like to give 30% OFF for both KoolReport Pro and KoolPHP UI.
Here are some great pictures of our traditional dress called "Ao Dai" or Long Dress. We normally wear this on the events like New Year.
Hope that you like those pictures and again, Happy 2018 and Don't Forget Our 30% OFF For KoolReport Pro and KoolPHP UI on this special occasion.
<3 KoolPHP Inc