subreport problem

rbuser

I have a subreport with another subreport in it, currently the second
subreport is in the buildingid header band ( I have a group based on
buildingid). The second subreport is a continuation page of some
information that prints on the first subreport. The second
continuation page prints fine, but then it prints another page of the
first subreport after it. I have tried moving the subreport down to
the buildingid footer band thinking this would fix it, but then it
prints endless pages and never stops. Any ideas how to fix this? The
second subreport property is set to child currently, changing it to
the other types did not seem to work.

digitalmetaphors

You should probably place the two subreports by each other in the same band
of the parent report. Set the second subreport to shift relative to the
first subreport. This way they will each print once and the first one will
print before the second one.

If that doesn't help, then how is your data structured? Setting it to child
type is probably correct in this configuration.

Cheers,

Jim Bennett
Digital Metaphors

rbuser

If I have to, I can do this, however I would prefer not to for the following
reason:
The data is setup like this: Parcels table is the main report (ParcelID
primary key)
- The first sub report is parcelbuildings ParcelID, BuildingID, ...
the second sub report is BuildingID, .

So, if I move the second sub report to the parcel report, and the parcel has two
buildings, the report will print like the following:
Page 1 Page2 Page3 Page4 Page5 .

I would prefer it to print like this
Page 1 Page2 Page3
Page4 Page5 .

digitalmetaphors

If you data is configured in a master-detail relationship, then for every
building record, you should have one floor record- correct? Try placing the
floor subreport at the bottom of the detailband of the building subreport.
Do you need the group on BuildingID, since the parcel is only going to one
floor? If not, then delete the group and use the Titleband.NewPage property
of the subreport to have it print on a new page.


Cheers,

Jim Bennett
Digital Metaphors