Is this a subreport?

[wvanpup]

Responses to my previous request for help were so useful I am seeking your advice again.

I have a report which shows the total number of contracts and the total value of contracts for the different divisions of where I work. It looks something like this:

(this should look like a table, but I can't get the hang of doing that. Sorry.)

Div #ofContracts $of Contracts
A 10 150,000
B 12 225,000

What I would like is to put somewhere in the report a place where you can click and get this information for all employees in the division, so it would take you to something that looks something like this:

Div A Employees
Emp #ofContracts $of Contracts
A 2 50,000
B 6 75,000
C 2 25,000

From this I would like a place to click that would give the contract information related to an individual employee, so it would prompt you for the name of the employee and take you to something that looks something like this:

Div A Employees
Employee A
Contract# Customer Contract Value
123 Co. XYZ 40,000
456 Co. ABC 10,000


In looking at my guidebook it seems like what I want are subreports, but the guidebook does not give good instructions on how to generate this kind of sequence.

Does anyone have any suggestions on how to do this and, perhaps more importantly, any recommendations for on-line help I could refer to?

As always, TIA for any assistance.

WVANPUP

 

[CBrighton]

Sounds like a form / subform combo would be better.

Reports aren't really designed to be interacted with.

With a continuous form a command button added to the detail section would be displayed on each record, so you could have that button open a form / report with details for the person who that record relates to, or have it unhide a subform and edit the /filter property to make sure it only shows the data for that person.

Alternatively you could have a single combobox with all employee names in the header / footer alongside a command button which would work in a similar way (use the contents of the combobox to open a report / form / edit the .filter property on a subform).