D
doyle60
I have a report with five sub reports in the key field's footer. I
have them arranged like this:
123
45X
That is with three going across and 1 and 4 on top of each other and 2
and 5 on top of each other. I want 1, 2 and 3 to always appear at the
top and I want 4 and 5 to print directly after 1 and 2. They all have
a very slim height with the grow and shrink properties set to yes.
The user is able to make any of these invisible and in fact, any one
of them could actually have no related records. Also, each sub can be
long, two pages or really short, one line. Who knows?
The trouble is when 1 is null, for example, 4 only prints after 2 has
ended. So what I get is this:
X23
X23
453
4X3
XX3
XX3
(I'm mimicking the length of the subs by repeating the same number as
above, with the X being white space.)
It's awkward. Want I really want to see is:
423
423
X53
XX3
XX3
XX3
(Yes, there will be a bit of space above 4 for the very thin and null
1 but that is okay. (I actually corrected this when I only had 4 subs
with some code---but I don't care to be that tedious right now.)
Does anyone have any experience with this? I want the subs to appear
upper most as possible and not be concerned with what is going on left
or right with the other subs.
The only way I see to correct this is to create code that knows which
subs are blank and to fill in the source object accordingly, that is,
not to designate the source object in anyone sub.
But I want to ask opinions before I go to that trouble.
Thanks,
Matt
have them arranged like this:
123
45X
That is with three going across and 1 and 4 on top of each other and 2
and 5 on top of each other. I want 1, 2 and 3 to always appear at the
top and I want 4 and 5 to print directly after 1 and 2. They all have
a very slim height with the grow and shrink properties set to yes.
The user is able to make any of these invisible and in fact, any one
of them could actually have no related records. Also, each sub can be
long, two pages or really short, one line. Who knows?
The trouble is when 1 is null, for example, 4 only prints after 2 has
ended. So what I get is this:
X23
X23
453
4X3
XX3
XX3
(I'm mimicking the length of the subs by repeating the same number as
above, with the X being white space.)
It's awkward. Want I really want to see is:
423
423
X53
XX3
XX3
XX3
(Yes, there will be a bit of space above 4 for the very thin and null
1 but that is okay. (I actually corrected this when I only had 4 subs
with some code---but I don't care to be that tedious right now.)
Does anyone have any experience with this? I want the subs to appear
upper most as possible and not be concerned with what is going on left
or right with the other subs.
The only way I see to correct this is to create code that knows which
subs are blank and to fill in the source object accordingly, that is,
not to designate the source object in anyone sub.
But I want to ask opinions before I go to that trouble.
Thanks,
Matt