By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,477 Members | 1,641 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,477 IT Pros & Developers. It's quick & easy.

building a multi level report

P: n/a
We are trying to build a multi level BOM report. The problem we are
having is in designing the report so that the spacing for each level
does not show up on the report when there is no information. Can this
be handled with vb code or some kind of special query or table
structure? The report right now is based on a recursive query, but in
report design each level has line space. So when it prints and there
are no parts there are spaces. We are printing this on 11 x 17 paper
and it has huge spaces with no parts data. Any ideas?

Aug 21 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Depends on your layout but Sections on a report can be set to shrink when
there is no data.

Check out the Can Shrink property of some sections.

This may help.

Jeff Pritchard
________________
Asken Research Pty. Ltd.
Access Database Developers
http://www.asken.com.au

"barb" <ba********@gmail.comwrote in message
news:11*********************@m79g2000cwm.googlegro ups.com...
We are trying to build a multi level BOM report. The problem we are
having is in designing the report so that the spacing for each level
does not show up on the report when there is no information. Can this
be handled with vb code or some kind of special query or table
structure? The report right now is based on a recursive query, but in
report design each level has line space. So when it prints and there
are no parts there are spaces. We are printing this on 11 x 17 paper
and it has huge spaces with no parts data. Any ideas?

Aug 22 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.