Change Log

Version 2.5.0 #

  1. Add void aggregate function (--) in Groups tab
  2. Add table's self join
  3. Add escape comma in filter IN values

Version 2.1.0 #

  1. Add escape character for comma in In/Not In filter/having
  2. Fix Group by when there are multiple other fields in select
  3. Fix dynamic properties in PHP 8.2

Version 2.0.0 #

  1. BREAKING CHANGE: move schema definition from visualquery widget to method "defineSchemas()" in report for security reasons
  2. Add Select Distinct option
  3. Add Having condition to Groups
  4. Add brackets, delete, toggle and draggable abilities to Filters and Group's Having
  5. Add delete, toggle and draggable abilities to Groups and Sorts
  6. Move inputs' resource files to visualquery

Version 1.0.0 #

  1. Build sql query with graphical user interface.

Get started with KoolReport

KoolReport will help you to construct good php data report by gathering your data from multiple sources, transforming them into valuable insights, and finally visualizing them in stunning charts and graphs.