Should I be using a subreport?

[Juice05]

My question is whether I should be trying to use a subreport or if there is a better solution.

My issue is this:

I have a list of Pagers in a table. Each pager is associated with an account, each account can have several pagers but no pager has two accounts. Along those lines, each pager has services (Airtime fees, 411 fees, etc.) assigned to it. Each pager can have many services. Each pager has a cost center(Who do we bill the pager services to?). Each pager can have many cost centers.

I have been asked to create a report that could be generated for each account. It would list each pager in that account along with the pager's Services. It would also display a list of Cost Centers associated with each pager. So it would look like this:

Pager1 PagerNumber

Service1 Units Cost
Service2 Units Cost
Service3 Units Cost

CostCenter1 PercentCost
CostCenter2 PercentCost

Pager2 PagerNumber

Service1 Units Cost
Service2 Units Cost

CostCenter1 PercentCost
CostCenter2 PercentCost
CostCenter3 PercentCost
CostCenter4 PercentCost

I can get All pagers and services in one query, but getting another many to one relationship (Cost Centers) creates an issue. Is a sub report right for me? And if so do you have a link to a good tutorial?

Thanks in advance for any assistance you can give me.

 

[Juice05]

Yes, A subreport was the answer to my question.