KoolReport's Forum

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

Drilldown in DataTables #1025

Open Rajesh opened this topic on on Aug 1 - 2 comments

Rajesh commented on Aug 1

Hi Koolreport,

I have already implemented your table drilldown package which works pretty good. I was wondering if it is possible to implement the same on DataTables. I tried to use your DataTables package and changing the "Table" class to "DataTables" in the report.view.php file. After the change, I am able to see the first level Datatable which works fine but drilldown does not work on it. Could you please let me know if I need to make any other changes to make drilldown work on DataTables?

Thanks,

Rajesh.

Rajesh commented on Aug 7

Hi Koolreport,

Could you please respond to my question?

Thanks,

Rajesh.

David Winterburn commented on Aug 9

Hi Rajesh,

For drilldown to work we need to use a widget's client events. I think DataTables' event names are a bit different from Table. If you use row select for drilldown, please try the following code for DataTables' select event:

DataTables::create(array(
    ...
    "options" => array(
        ...
        "select" => true,
    ),
    "clientEvents"=>array(
        "select"=>"function(e,dt,type,indexes){
            //your drilldown code
        }"
    )
    ...

Let us know if this works for you. Thanks!

Give tips to supporter for his good work

If you feel that supporter has done a good work, consider giving him some credit. Any amount put into the tips box below is appreciated. By doing so, you have contribtuted to the existence of KoolReport and the quality of support.

Tips box
help needed

DataGrid