I have two sub-reports.
sub-report1 with 4 colums AmountDue, Discount, Interest and Total. On these colums I'm getting group totals and over all totals.
I have the same colums on sub-report2.
I need to grab the over all totals from both sub-reports and add them together. They look like this is the source control, however "AmountDue" source control =
=Sum([Amount]+[Amount2]-[Amount3])
Thank for the help
PJ
They are not just grand total the are grand calculated totals.
I have try referencing a unbound text box back to the sub-reports and adding the totals. With no luck.
=ns([Reports]![Sub_rpt1]![Text47])+nz([Reports]![Sub_rpt2]![Text47])
It just shows #name on the report.
sub-report1 with 4 colums AmountDue, Discount, Interest and Total. On these colums I'm getting group totals and over all totals.
I have the same colums on sub-report2.
I need to grab the over all totals from both sub-reports and add them together. They look like this is the source control, however "AmountDue" source control =
=Sum([Amount]+[Amount2]-[Amount3])
Thank for the help
PJ
They are not just grand total the are grand calculated totals.
I have try referencing a unbound text box back to the sub-reports and adding the totals. With no luck.
=ns([Reports]![Sub_rpt1]![Text47])+nz([Reports]![Sub_rpt2]![Text47])
It just shows #name on the report.