Summing a sub report

[rberry]

Hi
I have a main report with a sub report embedded in it. Within the sub
report I have a currency field CURR1.

Question - I want to sum this CURR1 field in the report header of the main
report but keep on getting Error#, I think my naming convention in relation
to CURR1 in the sub report is incorrect. Expression below:

=Sum([Main Report].[Sub Report]![CURR1])

Any ideas?

 

[Ofer Cohen]

In the sub report ReportFooter create a text box to sum the field
=Sum([CURR1])

Change the SubReport Visible property to No

In the Main Report , Report Header create a text box, and refer it to the
text box created in the SubReport Footer

=[SubReportName].[Report].[SumFieldName]