Formula that calculates from separate subreports? 1

[random621]

I have a report that contains 2 subreports. One subreport shows sales contracts filled for a particular commodity. The other subreport shows insurance reimbursement received for the same commodity.

Each subreport has a "total" value. On the main page of the report I would like to add a formula field that sums each of the total value fields in the subreports.

Is this possible? And if it is, how can it be accomplished?

Thanks.

 

[pgtek]

hi
Sorry cant be done
have you try making a summary

pgtek

 

[random621]

Pgtek -

I had not considered a summary. How do you think one might work in this case?

 

[pgtek]

Hi
since your making a total value base on the report
but you cant have a sub report in a sub report
you have your sub report link base on a commom field of the main report

cheers

pgtek

 

[lbass]

Yes, of course, you can total results from subreports in the main report. Within each subreport, you need to write a formula which defines the total as a shared number variable, as in:

In subreport 1:
shared numbervar sub1total := sum({table.amount}, {table.ID}) //where {table.ID} is a group field within the subreport, otherwise omit

Repeat for subreport 2 with a different name for the shared variable. Then in the main report, for simple addition of the two, create a formula:

shared numbervar sub1total + shared numbervar sub2total

The formula would need to be placed in a section below the section where the subreports appear, e.g., if the subreports are in group footer 1, then insert a section group footer 1b and place the formula in that.

-LB