$VAR1 = {
          'columnsettings' => 'tran,DB Id

stamp,Date

document,Document Ref

description,Details

debit,Amount,number:yes;align:right;total:sum;

credit,Receipt,number:yes;align:right;total:sum;

bal,Balance,number:yes;align:right;

',
          'selector' => '2',
          'data' => 'SELECT

    `accounts`.`id` AS tran

    , `tillclients`.`name`

    , `tillclients`.`code`

    , `accounts`.`document`

    , `accounts`.`description`

    , `accounts`.`debit`

    , `accounts`.`credit`

    , `accounts`.`date`

    , `accounts`.`stamp`

    , `accounts`.`runningdebit`

    , `accounts`.`runningcredit`

    , (`accounts`.`runningdebit` - `accounts`.`runningcredit`) AS bal

FROM

    `oakdale_1`.`accounts`

    INNER JOIN `oakdale_1`.`tillclients` 

        ON (`accounts`.`entityid` = `tillclients`.`id`)

        

        WHERE clientgroup = \'FUNCTION/EVENTS\'



AND accounts.date >= \'[sdate]\' AND accounts.date <= \'[edate]\';

',
          'description' => 'PAYMENTS RECEIVED IN ADVANCE',
          'settings' => 'sdate,date,Start Date

edate,date,End Date',
          'rollup' => 'name',
          'id' => '79',
          'title' => 'FUNCTION CONTROLE',
          'category' => 'OAKDALE - REPORTS',
          'code' => '79'
        };