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?