Hi Sebastian,
I don't see there is a koolreport_assets directory. This is the link for the report.
https://dev03.resilion.net/analytics/subidrev/
Here is the code, basically from the example given:
<div class="report-content">
<div class="text-center">
<h1>Sub ID Revenue</h1>
<p class="lead">
Yesterday Sub ID Revenue Report
</p>
</div>
<style>
tr[role="row"] td:first-child {
padding-left: 50px;
}
</style>
<?php
DataTables::create(array(
"name" => "MyTable1",
"dataSource"=>$this->dataStore("subidRev"),
"themeBase"=>"bs4", // Optional option to work with Bootsrap 4
"cssClass"=>array(
"table"=>"table table-striped table-bordered"
),
//RecordDate, RecordHour, Segment, DeviceType, Country, subidgid, utm_source, subidaid, subidcid, Sessions, Pageviews, Impressions, PaidClicks, Revenue
"plugins" => [ "Buttons" ],
"columns" => ["Segment", "subidgid", "DeviceType","Revenue"],
"clientRowGroup" => [
"Segment" => [
'direction' => 'asc',
"top" => "<td colspan='999'>{expandCollapseIcon} Segment: {Segment}</td>",
],
"subidgid" => [
'direction' => 'asc',
"top" => "<td colspan='999'>{expandCollapseIcon} SubID: {subidgid}</td>",
],
],
"options" => [
"fastRender" => true,
"paging" => true,
"searching" => true,
"pageLength" => 50,
// "dom" => 'Blftip',
"dom" => "<'row mb-2'<'col-12 text-right'B>>" . "<'row'<'col-sm-6'l><'col-sm-6'f>>"
. "<'row'<'col-sm-12'tr>>" . "<'row'<'col-sm-5'i><'col-sm-7'p>>",
"buttons" => [
[
"text" => 'Collapse group 1',
"action" => "function() { KRMyTable1.collapseAllGroups(0); }",
],
[
"text" => 'Collapse sub id',
"action" => "function() { KRMyTable1.collapseAllGroups(1); }",
],
[
"text" => 'Expand Customers',
"action" => "function() { KRMyTable1.expandAllGroups(0); }",
],
[
"text" => 'Expand Categories',
"action" => "function() { KRMyTable1.expandAllGroups(1); }",
],
[
"text" => 'Toggle Customers',
"action" => "function() { KRMyTable1.toggleAllGroups(0); }",
],
[
"text" => 'Toggle Categories',
"action" => "function() { KRMyTable1.toggleAllGroups(1); }",
],
],
],
"onReady" => "function() {
MyTable1.on( 'draw.dt', function () {
console.log( 'event draw' );
KRMyTable1.collapseAllGroups(0);
KRMyTable1.collapseAllGroups(1);
} );
KRMyTable1.collapseAllGroups(0);
KRMyTable1.collapseAllGroups(1);
}",
));
?>
</div>