thatgirl100
Technical User
Hi there,
I posted a couple weeks ago, but I don't think I provided enough detail. After looking for previous posts on the issue of drill-through and passing prompt parameters from the parent report to the child report, this is the only advice I could find: "You can specify passing multiple fields from your parent report to your drill report. Just select them as 'Columns to be included in the drill through filter' when you set your drill down options."
However, I don't think this helps me because I want to be able to pass through fields that are NOT columns in the parent report, they are just parameters that the user would have selected.
For example:
User selected - Time period - Jan 1/05 - Feb 1/05
Province in ('NS', 'NB', 'NL')
Drug Category in ('Narcotics')
Province # of patients # of prescriptions
NS 100 150
NB 50 75
NL 60 80
Now, I want to be able to drill-through on the province field, and bring up a detailed child report that will show me who those 100 patients are in NS, and what drugs they were prescribed.
I need to be able to pass through the criteria:
Time period - Jan 1/05 - Feb 1/05
Province in ('NS', 'NB', 'NL')
Drug Category in ('Narcotics')
Otherwise, if I just drill through on 'NS', it will bring me back records for ALL drug categories, and for ANY date.
I'm just stumped how to pass through the items I put in my prompt manager so that the user won't have to select them all again when running the child report.
Thanks so much! P.S. I'm using Impromptu 7.3, and am not very experienced, so I don't know a huge amount of the jargon yet.
Kirstin
I posted a couple weeks ago, but I don't think I provided enough detail. After looking for previous posts on the issue of drill-through and passing prompt parameters from the parent report to the child report, this is the only advice I could find: "You can specify passing multiple fields from your parent report to your drill report. Just select them as 'Columns to be included in the drill through filter' when you set your drill down options."
However, I don't think this helps me because I want to be able to pass through fields that are NOT columns in the parent report, they are just parameters that the user would have selected.
For example:
User selected - Time period - Jan 1/05 - Feb 1/05
Province in ('NS', 'NB', 'NL')
Drug Category in ('Narcotics')
Province # of patients # of prescriptions
NS 100 150
NB 50 75
NL 60 80
Now, I want to be able to drill-through on the province field, and bring up a detailed child report that will show me who those 100 patients are in NS, and what drugs they were prescribed.
I need to be able to pass through the criteria:
Time period - Jan 1/05 - Feb 1/05
Province in ('NS', 'NB', 'NL')
Drug Category in ('Narcotics')
Otherwise, if I just drill through on 'NS', it will bring me back records for ALL drug categories, and for ANY date.
I'm just stumped how to pass through the items I put in my prompt manager so that the user won't have to select them all again when running the child report.
Thanks so much! P.S. I'm using Impromptu 7.3, and am not very experienced, so I don't know a huge amount of the jargon yet.
Kirstin