The KoolReport Blog

Announcements, discussions, and more for KoolReport and its extended packages.

Drill Down and Drill Through Report in Advanced Data Reporting

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 and Drill Through Report

Drill Down

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.

  1. Example 1: Sale By Time
  2. 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.

  1. 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

KoolReport 2.0.0 + 30% OFF For Pro Version On Special Christmas

Merry Christmas! On this special occasion we are glad to let you know that we have released KoolReport 2.0.0 and having special promotion with 30% OFF for KoolReport Pro.

Introduce SubReport

SubReport is the most highlighted feature in this release. SubReport allows a report to be rendered inside a main one. This allows us to handle bigger reports by dividing into smaller, separated reports. Also this will help to improve the reusable code among reports, leading to shorter code and limit redundant codes. Furthermore, some application of SubReport can interest you:

  1. Create real-time report in which charts and graphs are automatically updated.
  2. Make data-driven group of input controls.
  3. Build drill down report type.

We made a small example to demonstrate usage of SubReport. View example.

Google Charts

There are big improvements for Google Charts in which charts loading method are rewritten completely to enhance the stability of rendering as well as to add the ability of loading Google Charts via ajax and subreport.

Google Charts are also equipped with client-side events now. For example, we can catch the selection action of user on charts to take further actions.


Table also has much improvement with localization/language and client event handling features. We now can change language for Table as well as catch the row selection to take further action.

Other enhancements

  1. Update the parameter binding for PDODataSource, MySQLDataSource and SQLSRVDataSource.
  2. Ability to further process data in the report's view. For example, data in DataStore can be further filtered for specific charts or table.
  3. Fix the template() function and add language loading capability for Widget

To get new version of KoolReport, click here.

Christmas and New Year promotion

In this special occasion, we would like to give 30% OFF for KoolReport Pro.

Check it out!

Merry Chirstmas and Happy New Year!

<3 koolreport team

KoolReport helps to analyze your data and ultimately turn them into visual reports or dynamic dashboards.

"KoolReport helps me very much in creating data report for my corporate! Keep up your good work!"

Alain Melsens

"The first use of your product. I was impressed by its easiness and powerfulness. This product is a great product and amazing."

Dr. Lew Choy Onn

"Fantastic framework for reporting!"

Greg Schneider
Get KoolReport Now, It's FREE!