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

sum sub report values

Hello,

I have two sub reports in one main report. I want to calculate the balance from both two sub reports. I have no that how I can do it. The snapshot of report is given bellow. Please help me.

Thanks in advance.

12.PNG (13.9 kB)
Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    Posted on Jul 18, 2016 at 02:08 PM

    Hi Shakir,

    Use shared variables to bring back values to the Main Report.

    In Subreport 1, create a formula with this code:

    shared numbervar cred := Sum({Credit field});

    Place this formula on the Report Footer

    In Subreport 2, create a formula with this code and place this on its Report Footer:

    shared numbervar deb:= Sum({Debit field});


    In the Main report, create a formula with this code and place this on the Report Footer of the Main Report:


    shared numbervar cred;

    shared numbervar deb;

    cred - deb;


    Make sure that this formula is on a section below the section that holds the two subreports.


    -Abhilash

    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.