Subreports with no values

[vCallNSPF]

I have a generic database that can be used for all of my clients electronics equipment.

None of this equipment is linked into other tables but i need to display it in one big report. ive done this by making a main report with several subreports from each equipment table. now this works fine if each client has at least 1 of every type of equipment because the rest of the report moves automatically if i add new equipment. However if they dont have a certain type of equipment and i leave that table blank, it leaves a big white space on my final report where the subreport for that equipment would usually be.



how do i make it so that it just ignores blank subreports, or how do i make it recognise that there isnt information there

[RuralGuy]

What happens when you put:
Me.Visible = Me.RecordSet.Recount > 0
...in the OpenEvent of the SubReport?

[vCallNSPF]

What happens when you put:
Me.Visible = Me.RecordSet.Recount > 0
...in the OpenEvent of the SubReport?

do you mean the On Open property?,

This comes up with an error message saying "The expression On Open you entered as the event property setting produced the following error: The object doesnt contain Automation object 'Me.'."

I think the problem is, (this is the webdesign part of me thinking here) i have them floating on the main report like floated sections on web pages, so each subreport doesnt recognise that another one is there. Problem is i dont know how to change that, haha.

[RuralGuy]

I'm out of suggestions, sorry.

[vCallNSPF]

I'm out of suggestions, sorry.

its alright, thanks anyway

[vCallNSPF]

Okay, I've solved this.

Basically it was shifting everything down when new information goes in, but it wasn't shifting up if there was no information in the tables. This was because id positioned each subreport down the main report in order without resizing them. If you put them in the order that you want them to appear and resize the height to 0, position them as close as possible WITHOUT overlapping, the height will be the space that is displaced when there is nothing in that paticular table. so if the height is 0, then 0 space is shown so the next subreport will show directly after.

[RuralGuy]

Thanks for posting back with your solution.