Skip to Content
avatar image
Former Member

Sum up Share Value

Hi All,

I have a main report which have 3 grouping and a subreport.

My report is place in GF3a in the main report and the share value is in GF3b.

How can I have the total of the share value at GF1?

Thanks.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Aug 17, 2017 at 08:48 AM

    Hi Mavis,

    1. Create a formula called @itr with this code:

    shared numbervar stotal;
    shared numbervar sharedvarfromsubreport; //replace this variable name with the shared variable from the subreport
    stotal := stotal + sharedvarfromsubreport;

    2. Create a formula to display the subtotal and place this on Group Footer 1:

    shared numbervar stotal;

    3. Create a reset formula to reset the variable for each group and place this on Group Header 1:

    shared numbervar stotal := 0;
    '';

    -Abhilash

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Abhilash,

      Thanks!!!! I got the subtotal at the Grp 1 level. Will you be able to advise how can I get the grand total at the report footer?

      Thanks in advance.

  • Aug 16, 2017 at 09:24 AM

    Create another Variable which evaluates in GF3b and is incremented by the value of your shared variable from your subreport.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 17, 2017 at 01:30 AM

    Hi Ian,

    Sorry not very sure how to do it. can you explain more?

    I am not very good with this.

    Thanks.

    Add comment
    10|10000 characters needed characters exceeded