hdr - Sum usage

(3 posts) (2 voices)

Tags:

No tags yet.

  1. Dev, Member

    Hi,

    I am using dbr.hdr and dbr.sum in a report. Is it possible to disable the row-by-row count and only show the grand total at the end of the report? Currently, it shows the total for each row and also displays a grand total at the end. How can I disable the row-by-row count and just show the grand total?

    Any help would be appreciated, Thank you.

  2. Dev, Member

    https://docs.google.com/presentation/d/14OeXbvdx2DOxw_eR-njRt_5kfRNo9ObeUpZ9GxQ5T0s/edit?usp=sharing

    In the above link, I have updated the image. Is it possible to show just 4 (at the end of the result set not the hdr format)and not show the row by row 16?

  3. myDBR Team, Key Master

    You can use the limit_summary_level-option to determine at which summary levels you wish to show the summaries. If you want only the total summary you can use:

    select 'dbr.summary.options', 'limit_summary_level', 0;

    --
    myDBR Team


Reply

You must log in to post.