Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

RE: drill through report

Status
Not open for further replies.

allyne

MIS
Feb 9, 2001
410
US
Hi Everyone,

I have created a drill through report that looks something like this.

TextBox = Person TextBox = Address TextBox = State
Report 1 Data:

Person1 Address1 WA
Person2 Address2 WA

I have a drill down report that is created on the Person TextBox. What I want to do is when I run Report1 and get the above data I then want to click on "Person1" and bring up another report that shows only data for Person1. What I'm currently getting is data for both Person1 and Person2. Is there a way to get data only for person1?

Thanks for your help!
 
You can create a report just for Person1 and then hyperlink to it from your drilldown report.
 
You might want to look at passing a parameter from your main report to your drill-through report that identifies the person (a person id?).
 
Hello,

I tried both suggestions and neither worked. Any more suggestions?

Thanks for your help!
 
If neither idea worked it would seem to me you will need to do some more studying on subreports. My suggestion should work, but you just need to have a good understanding of subreports.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top