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

[Guest]

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!

 

[Douglas J. Steele]

Reports are passive, not interactive.

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

 

[BruceM]

A button on a custom toolbar?

Reports are passive, not interactive.

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

 

[Douglas J. Steele]

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

 

[BruceM]

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