How to use a data in the subreport

[ariansman]

I have made a report, to list the employee data as the main report. In one field the employee salary is mentioned. At the end of the field the sum of all employee salaries is shown in a box.


I put a subreport to list the Managers and in one column their salary is shown, with the related sum at the end.
There is a second subreport listing the company costs for different items. Again, the sum of all costs is shown in a box at the end of the field of the itemcosts.

My question: how can we add “sum of employee salaries” and “sum of managers salaries” and “sum of the item costs” ? In other words I need a data from one subreport to be added to another data from sunreport and also to a data in the main from.

All the above reports and subreports come from different unrelated tables.

Thank you

[June7]

Each subreport has a Sum in the Report footer section?

A textbox on main report can reference each subreport footer textbox in an expression.

[ariansman]

Each subreport has a Sum in the Report footer section?

A textbox on main report can reference each subreport footer textbox in an expression.

yes, each subreport has a sum in their respective footer section. lest say : sum([employeesalary]) in the main report and sum([managersalary]) and sum([companycosts]) in subreprots.
can you help me how can i write an expression to reference each sum from the subreports and main report?
thank you

[June7]

Try:

= subreportname1!textboxname + subreportname2!textboxname + subreportname3!textboxname