KoolReport's Forum

Official Support Area, Q&As, Discussions, Suggestions and Bug reports.
Forum's Guidelines

Remove from Rowgroup Collapse type report #3005

Open AhmedHaroon opened this topic on on Mar 1, 2023 - 2 comments

AhmedHaroon commented on Mar 1, 2023

created a report on Rowgroup Collapse example, its working fine yet. now I want to remove duplicates like KoolReport Table removeDuplicate feature, how i can do this as the above mentioned example is using DataTables? OR can i create same report using KoolReport Table? please help, these repeating data is looks very unprofessional report.

below are code and screenshot for reference.

may be due to this report's nature removeDuplicate is not feasible but hoping to have one...


use \koolreport\datagrid\DataTables;
use \koolreport\inputs\Select2;


    .select2 {
        width: 100% !important;
    .sidebar {
        background: #ffffff !important;
    tr[role="row"] td:first-child {
            padding-left: 50px;
    .select2-selection {
        width: 400px !important;
<div class='report-content'>
<br />
    <div class="text-center">
        <h2>Members Dues</h2>
    <br />

    <form method="post">
        <div class="row">
                <div class="col-md-8 offset-md-2">
                <div class="form-group" style="display: flex; flex-direction: row; flex-wrap: nowrap; align-content: center; justify-content: center; align-items: center; margin-bottom: 1rem;">
                <div style="display: flex; width: 100%; flex-direction: row; flex-wrap: nowrap; justify-content: center; align-items: center;">
                    <strong style="margin-right: 15px;">Select Mamber</strong>
                <div class="form-group text-center" style="margin-bottom: 0rem;">
                    <button class="btn btn-success"><i class="glyphicon glyphicon-refresh"></i> Load</button>

        "name" => "MyTable1",
        "themeBase"=>"bs4", // Optional option to work with Bootsrap 4
            "table"=>"table table-striped table-bordered",
                if (in_array($colName, array("due_amount","recived_amount","balance_amount")))
                    return "text-right";
                if (in_array($colName, array("membership_no","description","due_amount","recived_amount")))
                    return "text-center";
        "plugins" => [ "Buttons" ],
        "columns" => [
            "due_amount"=>array("label"=>"Due Amt."),
            "recived_amount"=>array("label"=>"Received Amt."),
        "clientRowGroup" => [
            "members_full" => [
                'direction' => 'asc',
                "top" => "<td colspan='999'>{expandCollapseIcon} {members_full}</td>",
        "options" => [
            "paging" => true,
            "searching" => true,
            "pageLength" => 25,
            "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" => 'Toggle Member',
                    "action" => "function() { KRMyTable1.toggleAllGroups(0); }",
        "onReady" => "function() {
            MyTable1.on( 'draw.dt', function () {
                console.log( 'event draw' );
            } );



Sebastian Morales commented on Mar 3, 2023

So far the row group and remove duplicate features have been conflicted. Thus, you can only use one at a time. We will investigate to see if we can improve to make them work together. Tks,

AhmedHaroon commented on Mar 3, 2023

@Sebastian Morales thanks for reply.

hope this will be resolved in future release / updates.


Build Your Excellent Data Report

Let KoolReport help you to make great reports. It's free & open-source released under MIT license.

Download KoolReport View demo
help needed