subreport problem

J

JohnLute

I have a report with multiple subreports in an unusual design. I'll simplify
my subreport names for better clarity:

rptSpec contains srpt1 (Child - txtProfileID / Master - txtProfileID)
srpt1contains srptA (Child - txtProfileID / Master - txtProfilesAssociations)
srptA contains srptB (Child - txtProfileID / Master - txtProfileID)
srptB contains srptA (Child - txtProfileID / Master - txtProfilesAssociations)

You may ask, "Why do srptA and srptB contain one another?" That's a long and
difficult explanation but let's suffice it to say that it's necessary.

The problem: srptA generates a blank space in srptB <IF> a record exists in
srptA of srptA.srptB.

I guess the problem is that I'm using srptA as a subreport of a subreport ot
itself. Be that as it may - any ideas how to keep the blank space from
appearing? One solution I have is to eliminate the nesting of srptA by
creating a duplicate of it. The problem with this is that "sptA"actually
reflects over 15 subreports. Therefore, I'd have to create over 15 duplicate
subreports. This will make the database larger and also create design
revision inconsitencies. For example, if I revise srptA then I will also need
to revise its duplicate. That's no fun.

Thanks in advance for any help you might have!
 
Top