How to sum return values from multiple subreport at various levels

Issue Description

Subreports can return values to a main report's variables but using a variable whose value is returned from a subreport (or a subdataset) to define another variable's value does not generally work because the calculation engine (which computes regular variable values) and the subreport execution are de-phased. Regular variable values are computed before the detail band is rendered, and at that moment the subreport has not yet been executed and the value has not been fed to the variable.

Resolution

An design approach needing to sum return values from various subreport levels is to use several return values with calculation=Sum and target variables with reset types. See an example attached in Sample1.zip which you can run with 10 empty records, for example set the query to

Ref. Case 01523249

sample1.zip