Skip to Content
author's profile photo Former Member
Former Member

Grand total (Report footer) issue in a Report with Group selection.

Hi,

The case is simple, i have to summrise the NetValue field of a report at the Group level and at the Report level(Grand Total).

I also use a Group selection filter (I have grouped my records by MaterialDesc) to keep the desired groups.

As you already guessed, my group totals are fine but the grand totals(report footer) contain both filtered and non filtered group records. Is there any way to avoid this problem and get a Grand Total from the filtered group records?

Thank you.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Dec 08, 2011 at 12:10 PM

    You can not use standard summaries with Group Suppression you must use either Running Totals or variables.

    In Running Total evaluate click theformual button and eneter reverse condition to your group suppression.

    If you can not do that then you must use a Var

    In group footer where total is currently correct place a formula like this and suppress it

    @eval

    whileprintingrecords;

    global numbervar RepTot;

    If ..whatever your suppression condition is not true... then reptot:= reptot + sum( valuefield, groupfield);

    In report footer

    @display

    whileprintingrecords;

    global numbervar RepTot;

    Ian

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 08, 2011 at 04:04 PM

    Hi,

    1) Create a Running Total Field

    2) In the Field to summarize area, move the NetValue field and select Sum as the type of Summary

    3) Make sure 'Evaluate' is set to 'For each record' and 'Reset' is set to 'Never'

    4) Place this field on the Report Footer

    Hope this helps!

    -Abhilash

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 09, 2011 at 07:24 PM

    Both answers were absolutly correct!!!

    Thank you both for your help.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.