DataTables

<?php
require_once "MyReport.php";

$report = new MyReport;
$report->run()->render();

<?php
//Step 1: Load KoolReport
require_once "../../../load.koolreport.php";

//Step 2: Creating Report class
class MyReport extends \koolreport\KoolReport
{
    function settings()
    {
        return array(
            "dataSources"=>array(
                "automaker"=>array(
                    "connectionString"=>"mysql:host=localhost;dbname=automaker",
                    "username"=>"root",
                    "password"=>"",
                    "charset"=>"utf8"
                ),
            )
        ); 
    } 
    protected function setup()
    {
        $this->src('automaker')
        ->query('select * from customer_product_dollarsales2')
        ->pipe(new \koolreport\processes\Limit(array(200, 0)))
        ->pipe($this->dataStore("sales"));
    } 

}

<?php
    use \koolreport\datagrid\DataTables;
?>
<div class="report-content">
    <div class="text-center">
        <h1>DataTables</h1>
        <p class="lead">
        How to use row detail with DataTables
        </p>
    </div>
    <?php
    DataTables::create(array(
        "dataSource"=>$this->dataStore("sales"),
        "themeBase"=>"bs4", // Optional option to work with Bootsrap 4
        "columns" => [
            "customerName", "productLine", "productName", "dollar_sales",
            "orderDate" => [
                "visible" => false,
            ]
        ],
        "rowDetailData" => function($row) {
            return "Server-built row detail: " . $row['orderDate'];
        },
        // "rowDetailData" => "function(row) {
        //     return 'Client-built row detail: ' + row.orderDate;
        // }",
        // "rowDetailIcon" => false,
        // "rowDetailSelector" => 'td.col-customer-name',
        "options" => [
            "paging" => true,
            "searching" => true,
            "pageLength" => 10,
        ],
    ));
    ?>
</div>