Reports with Sub Reports

[Guest]

I have a report with 2 sub-reports that are causing me some troubles. The main report has no records in fact the only unique (except for Labels) field is a Grand Total.

The first problem I am having is the formatting for the Page Header & Page Footer are gone (the Report Header and Footer do appear). Also, I am having trouble aligning the data of the two subforms with the Grand Total field. Can I programatically control the sub-form placement

The second problem occurs when there is no data in either of the two sub-reports the Sub-totals and the Grand Totals shows #Error. Is there a simple IIF I can use to properly calculate the Grand Total by checking the sub-totals first

Thank you for your help

Davi

 

[Duane Hookom]

There are no page sections or events in subreports. You can replace page
headers by creating a primary grouping level on an expression like:
=1
Then show the group header and set its Repeat Section = Yes

I have no idea how to align your subreports' data.

You can use:
=IIf(srptA.Report.HasData, srptA.Report.txtTotal, 0)

--
Duane Hookom
MS Access MVP

I have a report with 2 sub-reports that are causing me some troubles. The

main report has no records in fact the only unique (except for Labels) field
is a Grand Total.

The first problem I am having is the formatting for the Page Header & Page

Footer are gone (the Report Header and Footer do appear). Also, I am having
trouble aligning the data of the two subforms with the Grand Total field.
Can I programatically control the sub-form placement?

The second problem occurs when there is no data in either of the two

sub-reports the Sub-totals and the Grand Totals shows #Error. Is there a
simple IIF I can use to properly calculate the Grand Total by checking the
sub-totals first?