Skip to Content

How to display subtotals a line with the last record in every group

Hi Experts,

I have my report created. My report consist of 2 groups namely: Classification(1st Group) and Category(2nd Group) and Qty column for the summation of the Category Group. Now I want to display the summation of the Classification Group a line with the last record in the Category Group.

See the Image Below.

Regards,

Eric

rptlayout.png (94.8 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Jan 14, 2017 at 08:41 AM

    Hi Abhilash,

    Thanks for your reply.

    I already solved my problem by creating two formula.

    1. @RunningTotal -> This will increment in every record within the group.
    2. @SummationOfEveryGroup -> This is the subtotals of every group.

    Method:

    Right click the @RunningTotal formula field then in the formula button suppress and i use this code:

    IF @RunningTotal <> @SummationOfEveryGroup THEN True ELSE False

    Regards,

    Eric.

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 12, 2017 at 07:58 AM

    Hi Eric,

    Right-click the summary for the Classification Group > Select Format Field > Common tab > Click the formula button Suppress and use this code:

    Next({Classification Group}) = {Classification Group}

    -Abhilash

    Add comment
    10|10000 characters needed characters exceeded