KoolReport's Forum

Official Support Area, Q&As, Discussions, Suggestions and Bug reports.

Drilldown on table does not work when clicked on the footer total row? #1016

Open Rajesh opened this topic on on Jul 29 - 3 comments

Rajesh commented on Jul 29

Hi Koolreport,

I have implemented drilldown on table based on your package. When clicked on individual rows, drilldown works fine and I am able to see the details related to that row. But, when I click on the auto populated "Total" row ("footer"=>"sum"), I get empty table saying "No data available in table". Could you please let me know if it is possible to get all the details based on below image when clicked on "Total" row?

To be more precise, in below image, the tables with arrows that have green text "Drilldown" is achievable with Koolreport package but I am unable to achieve the table with arrow having red text "How to achieve below drilldown?" Please let me know.



KoolReport commented on Jul 30

You can write custom condition in rowClick event of table that only call next() method of drilldown if there is data from table. Note the total rows does not have data.

Rajesh commented on Aug 12

Hi Koolreport,

Thanks for the response and sorry for late reply. Can you please post the code on how to not allow drilldown when there is no data. I did try couple of options but did not have any luck. Below is the code for clientEvents => rowClick event in my php page.




Rajesh commented on Aug 13

No worries. Found the solution. Thanks!

KoolReport Is Free and Open-Source!

KoolReport is a professional php reporting framework which saves you tons of time to construct dynamic data report & dashboard.

  • Connect to various datasources such as MySQL, SQL Server, MongoDB or even from CSV or Excel file.
  • Contain series of powerful built-in data processes for your data manipulation.
  • Generate stunning charts and graphs to help you communicate data insights to your audiences effectively.
  • Integrate seamlessly with any php frameworks such as Laravel, CodeIgniter, Symfony.
Download Now and register our tutorials to get started!

Download KoolReport
help needed