make empty subreports show up

[Jason]

I have a main report with multiple subreports, whenever a
subreport has no data it eats up a small amount of blank
space, which messes up the look of my report. I want to
make my sub report show up with the headings and at least
1 row of empty fields so I don't have that weird blank
area in between subreports since they are set with
justified layout, any help is appreciated, thanks.

 

[Marshall Barton]

I have a main report with multiple subreports, whenever a
subreport has no data it eats up a small amount of blank
space, which messes up the look of my report. I want to
make my sub report show up with the headings and at least
1 row of empty fields so I don't have that weird blank
area in between subreports since they are set with
justified layout, any help is appreciated, thanks.

A subreport without any data will never appear. There's a
couple of other things you might want to try.

One is to make sure the subreport control and its section
both have their CanShrink property set to Yes. Under most
circumstances, this should eliminate the the bank space
altogether.

If you really want to see something in that space, then add
a label control with whatever content you want and place it
on top of the subreport. Then add a line of code to the
section's Format event:

Me.thelabel.Visible = Not Me.subreport.Report.HasData

 

[Jason]

Great, thanks a lot!

-----Original Message-----



A subreport without any data will never appear. There's a
couple of other things you might want to try.

One is to make sure the subreport control and its section
both have their CanShrink property set to Yes. Under most
circumstances, this should eliminate the the bank space
altogether.

If you really want to see something in that space, then add
a label control with whatever content you want and place it
on top of the subreport. Then add a line of code to the
section's Format event:

Me.thelabel.Visible = Not Me.subreport.Report.HasData