Multiple subreports

S

SVE

Here's the situation. I have a company with address, phone, etc.
information. This company has multiple sites. The company and sites have
multiple contact names and multiple phone numbers per name. Each site has
multiple pieces of equipment. Here's basically the way I would like the
report to look:
Company Name
Company Address
Site Name
Site Address
Equipment
Equipment
Equipment
ETC...
Site Name
Site Address
Equipment
Equipment
Equipment
ETC...
Site Name
Site Address
Equipment
Equipment
Equipment
ETC...
ETC...
Contact name
Contact Name
Contact Name
ETC...

Is this even possible? If so, how do I set up my report to get this layout?

Another option would be to have the company name and address like above, but
list just one site with its multiple pieces of equipment and the relevant
contact information for that specific site. Like this:
Company Name
Company Address
Site Name
Site Address
Equipment
Equipment
Equipment
ETC...
Contact name
Contact Name
Contact Name
ETC...

Thanks in advance for all your help.
 
Top