report grouping

A

aheath15

My report will display a list of products. Some products have sub assemblies
within them, some do not. In fact, some of the sub assemblies have further
assemblies within them (so there are 4 leves total, with 3 levels of sub-data
sheets ultimately stemming from the master product table). In my report, I
need to have ALL products listed, whether they are a sub-assembly product or
on the master product table itself, AND I need the format to look as follows:

Product 1
Product 1A
Product 1a
Product 2
Product 3
Product 3A

etc- it needs to be clear which products belong to which assemblies.

My problem is that the report gets messed up since the 'levels' for each
product are not the same (see above that product 2 does not have a product 2A
or 2a level). What is the best way to accomplish this?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top