dbr.sum on filtered report not updating

(8 posts) (2 voices)
  1. jasmondluk, Member

    We noticed when using dbr.sum on filtered report, the total is not being updated. May I know if this is a problem or a feature that will be supported later? Thanks.

  2. myDBR Team, Key Master

    What is the version and build that you are using?

    See the demo for filters and dbr.sum.

    --
    myDBR Team

  3. jasmondluk, Member

    myDBR 6.1.1 (build 4513)

  4. myDBR Team, Key Master

    Can you get the export as SQL (export menu at top right) from the report and attach it to a support ticket in the support email. This way we can rerun your report and see what might cause this for you.

    --
    myDBR Team

  5. jasmondluk, Member

    select 'dbr.tab', 'Detail payment';
    select 'dbr.tab', 'Daily summary by Fee type';
    select 'dbr.tab', 'Daily summary by Pay type';
    select 'dbr.tab', 'Daily summary by Teacher';
    select 'dbr.tab', 'Daily summary by Classroom';

    select 'dbr.text', 'Eye Level Interactive Education Centre (Discovery Park)';

    select 'DBR.crosstab' as 'DBR.crosstab', 'Pay type' as 'Pay type';

    select 'DBR.hsum' as 'DBR.hsum', 'value' as 'value';

    select 'DBR.sum' as 'DBR.sum', 'value' as 'value';

    select 'dbr.search', 1;

    select 'dbr.summary.text', 'Received by', 'Total';

    select 'dbr.subtitle', 'Payment Received History - Detail payment';

    select 'DBR.text' as 'DBR.text', 'Payment record inputted from Oct-23, 2021 to Oct-23, 2021 (According to entry date 根據輸入日期)' as 'concat(\'Payment record inputted from \',date_format(From_date,\'%b-%d, %Y\') ,\' to \', date_format(To_date,\'%b-%d, %Y\') ,\' (According to \', if(as_datetype=\'E\',\'entry date 根據輸入日期)\',\'pay date 根據付款日期)\' ))';

    select 'dbr.css', '.content {zoom: 0.7;}';

    select 'dbr.column.filter', 'Pay date', 'select';
    select 'dbr.column.filter', 'Center', 'select';
    select 'dbr.column.filter', 'Student', 'text';
    select 'dbr.column.filter', 'Name', 'select';
    select 'dbr.column.filter', 'Enrollment/Sales remarks', 'text';
    select 'dbr.column.filter', 'Account code', 'select';
    select 'dbr.column.filter', 'Received by', 'select';
    select 'dbr.column.filter', 'Course/Product', 'select';
    select 'dbr.column.filter', 'From', 'select';
    select 'dbr.column.filter', 'To', 'select';
    select 'dbr.column.filter', 'Payment remarks', 'text';
    select 'dbr.column.filter', 'Receipt remarks', 'text';

    select 'dbr.footerstyle', ' border: 1px solid gray;';
    select 'dbr.colstyle', 'Pay Ref', '[white-space:pre; border: 1px solid gray;]';
    select 'dbr.colstyle', 'Entry time', '[white-space:pre; border: 1px solid gray;]';
    select 'dbr.colstyle', 'Student', '[white-space:pre; border: 1px solid gray;]';
    select 'dbr.colstyle', 'ID', '[white-space:pre; border: 1px solid gray;]';
    select 'dbr.colstyle', 'Course/Product', '[white-space:pre; border: 1px solid gray;]';
    select 'dbr.colstyle', 'Name', '[white-space:pre; border: 1px solid gray;]';
    select 'dbr.colstyle', 'Class no.', '[white-space:pre; border: 1px solid gray;]';
    select 'dbr.colstyle', 'Payment remarks', '[white-space:pre-wrap; border: 1px solid gray; max-width:500]';
    select 'dbr.colstyle', 'Receipt remarks', '[white-space:pre-wrap; border: 1px solid gray; max-width:500]';
    select 'dbr.colstyle', 'Enrollment/Sales remarks', '[white-space:pre; border: 1px solid gray;]';
    select 'dbr.colstyle', 'Account code', '[white-space:pre; border: 1px solid gray;]';
    select 'dbr.colstyle', 'Pay date', '[white-space:pre; border: 1px solid gray;]';
    select 'dbr.colstyle', 'From', '[white-space:pre; border: 1px solid gray;]';
    select 'dbr.colstyle', 'To', '[white-space:pre; border: 1px solid gray;]';
    select 'dbr.colstyle', 'Received by', '[white-space:pre; border: 1px solid gray;]';
    select 'dbr.hidecolumn', 'Date';
    select 'dbr.colstyle', '[value]', '[border: 1px solid gray;white-space:pre;color: black;]%.2f;[border: 1px solid gray;color: black;]%.2f;[border: 1px solid gray;color: red;]%.2f';

    select 'dbr.export.options', 'orientation', 'landscape';
    select 'dbr.export.options', 'paper_size', 'A4';
    select 'dbr.export.options', 'zoom_scale', 80;
    select 'dbr.wkhtmltopdf', '--margin-left 5 --margin-right 5 --margin-bottom 5 ';

    select 'dbr.crosstab.col', 'Cash', 'Cheque', 'Transfer';

    select '4495571' as 'Pay Ref', cast('2021-10-23' as date) as 'Pay date', cast('2021-10-23 13:25:13' as datetime) as 'Entry time', 'Kaylie Yu' as 'Student', 'DP000971' as 'ID', 'R SPK' as 'Course/Product', 'Sparks 拼音班' as 'Name', '4' as 'Class no.', '2021-10-30' as 'From', '2021-11-20' as 'To', '' as 'Payment remarks', '' as 'Receipt remarks', '' as 'Enrollment/Sales remarks', null as 'Account code', 'Online' as 'Received by', 'PayMe Online' as 'Pay type', 1000.0 as '[value]', cast('2021-10-23' as date) as 'Date'
    union all
    select '4495479', cast('2021-10-23' as date), cast('2021-10-23 11:33:36' as datetime), 'Hillary Pui Yin Chen', 'DP000441', 'R Math', 'Mathematics 數學', '4', '2021-10-23', '2021-11-13', '', '', '', null, 'Online', 'FPS Online', 880.0, cast('2021-10-23' as date)
    union all
    select '4495413', cast('2021-10-23' as date), cast('2021-10-23 10:11:50' as datetime), 'Lok Hui', 'DP000866', 'R Eng', 'English 英文', '8', '2021-11-06', '2022-01-08', '', '', '', null, 'Lilian Shum', 'Cash', 2000.0, cast('2021-10-23' as date)
    union all
    select '4495382', cast('2021-10-23' as date), cast('2021-10-23 09:07:02' as datetime), 'Hazel Ho', 'DP000887', 'R AW', 'Active Writers 英文寫作', '4', '2021-10-30', '2021-11-20', '', '', '', null, 'Lilian Shum', 'Cash', 1080.0, cast('2021-10-23' as date);

  6. myDBR Team, Key Master

    Hi,
    looks like a problem comes from the hidden column (Date) at the end of the crosstab data columns. If you change the order between the 'Date' and the '[value]' columns, the report will be the same, and the Total is updated correctly.

    We'll fix it to work in either way.

    --
    myDBR Team

  7. myDBR Team, Key Master

    The issue is now fixed in the latest build. Thank you for reprorting this.

    --
    myDBR Team

  8. jasmondluk, Member

    Thank you for your help


Reply

You must log in to post.