Can this be done? (A report that can generate a second report)

R

Ration

Hi,

I have 2 reports. The first is a summary that displays totals laid out in
the following column format:

ID#, Date, Rep Name, Score

The second report gives detailed information about what makes up the score.
Both reports use "ID#" as the primary key. I need the summary report to
display each ID# as a clickable link. When the link is clicked, I need it to
pull the detail report for the ID# chosen.

Is this possible? How?

Thanks!
 
D

Douglas J. Steele

Reports are passive, not interactive.

You cannot click on anything in a report and have an action occur.
 
B

BruceM

A button on a custom toolbar?

Douglas J. Steele said:
Reports are passive, not interactive.

You cannot click on anything in a report and have an action occur.
Click to expand...
 
D

Douglas J. Steele

How would you know which detail row from the first report is supposed to
provide the ID# for the second report?
 
B

BruceM

Ah. I read it too quickly. Of course there is no way of selecting the
record from the summary report.
 
Top