Drill through to multiple reports

[TT14]

How can I drill through to a report depending on the value of a field. i.e. If the Value is A then open report A
If the Value is B then open report B

 

[TT14]

PS this is in ReportNet 1.1

 

[MissReportNet]

Hi,

Create the value as a paramater in you target report and create a drillthrough from your drillthrough report to your target repport.

Cheers,

 

[TT14]

MissReportNet

Thank you for your response however,

The problem is that I have multiple target reports!

I can create a drill through to all the target reports which will then prompt the user as to which report they want but, I wanted the report to automatically drill through to the correct report based on the value of a given field.

As per my example above if the value of the field is A then drill through to report A, if the value of the field is B then drill through to report B

 

[jyash]

Were you able to achieve this. I want to do the same thing but in Impromptu 7.1 MR2. Any ideas by anyone.

TIA
Yash

 

[griffindm]

jyash,

Not possible in Impromptu. You can have multiple drill-thru reports, but selecting them is always manual.

Dave Griffin


The Decision Support Group
Reporting Consulting with Cognos BI Tools
Magic with Data
Want good answers? Read FAQ401-2487 first!

http://www.decisionsupportgroup.com

 

[jyash]

Thanks Dave.

But if I have multiple drill thru on a column, is there a way to manually select which one to run from upfront. The problem is when i publish it on upfront, i can get that option. Any ideas.

TIA
Yash