calculate sub-reports ?

[piet123]

Please help, (a2k)

Can I do this ?....

1. I have Main Report (data from a Query) with Group Header/Footer. In the GrpFooter section i have "TOTAL_1" (sumofvalue from detail section)

2. I have 3 sub-reports (data from Tables). Sub-reports are in MainReport's GroupFooter section.

Sub-rpt1 have got "TOTAL_A" (sumofvalue) in it's ReportFooter section.
Sub-rpt2 have "TOTAL_B"...(as above)
Sub-rpt3 have "TOTAL_C"...

In the Main Report's ReportFooter section I want something like this:

=([TOTAL_1])+([sub-rpt1].[TOTAL_A])+([sub-rpt2].[TOTAL_B])...etc.

Am I on the right track ?

Thanks,
Piet.

 

[Rich]

Use the HasData method, search the archives here for examples

 

[piet123]

calculate subreports

Use the HasData method, search the archives here for examples

Thank you. Exactly what I wanted. Now I want more !

1. In MainReport's GROUP FOOTER section I have 3 sub-Reports.
2. In MainReport's GROUP FOOTER section I now also have a textbox
(name 'text123') with the =Iif/HasData function which calculates the "totals" of all 3 sub-reports. This is all OK.

4. In the MainReport's REPORT FOOTER section I tried this:
=sum([text123]) No such luck. When report runs, it prompts for text123.

Any advice please !

Thanks.
Piet.