Adding a total from a Main report to a total from a Sub report

[Former Member]

Post Author: Raschel

CA Forum: General

I have a Main report where I created a formula. Then I have a Sub report where I inserted a Summary field. I need to know if there is a way to Total the Formula from the Main report with the Summary field from the Sub report.

Thanks!!

[Former Member]

Post Author: SKodidine

CA Forum: General

Step 1: In the sub-report create a formula which contains:

shared numbervar srtotal := Sum ({your field}) - this is your summary field in your subreport.

Place this formula after the summary field in your subreport.

Step 2: In the main report, create a formula that contains:

shared numbervar srtotal;

numbervar frandsrtotal := yourformulatotal + srtotal; - yourformulatotal is the first formula

Place this new formula in your main report after the subreport and after the formula.

This should give you the total of your first formula and the summary from the subreport.

Check out this KBase article for more info.

http://technicalsupport.businessobjects.com/KanisaSupportSite/search.do?cmd=displayKC&docType=kc&ext...