COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: benhuebner on 11 Jan 2011 11:37:02 AM

Title: Drillthrough always in the same "new" window
Post by: benhuebner on 11 Jan 2011 11:37:02 AM
Hi Cognoise community, I need your help!

I'm using drillthrough definitions in my reports (8.41 FP 2) to open details of a list in a new window.
The problem is when I click another list entry without closing the detail window I get a second one and so on...
What my users demand is that the details always open in the same "new window"

Any ideas?

Kind Regards

Ben.
Title: Re: Drillthrough always in the same "new" window
Post by: Arsenal on 11 Jan 2011 01:15:08 PM
If your users don't mind the source being replaced by the target report every time they click a drill through, then this is as simple as taking off the check mark from "Open in New Window" option in the drill through definition (located just below the Format option, I believe)
Title: Re: Drillthrough always in the same "new" window
Post by: benhuebner on 12 Jan 2011 05:15:24 AM
Oh, I'm afraid they do mind. I know that I can perform a drillthrough in the same window if I want, but what I need is a new window for the first drill click in the master window and then an update on the already open window if possible... thanks so far any more ideas?

Kind Regards

Ben.
Title: Re: Drillthrough always in the same "new" window
Post by: Arsenal on 12 Jan 2011 10:49:10 AM
Hmmm, so what you have is say 2 or 3 different drill links in the same parent report and you're fine with the first drill opening a new window but when you click the 2nd or 3rd drill in the parent report, it should utilize the same window that was opened when the 1st drill link was clicked.

I do not think there's an out of box functionality for doing that. I am not even sure there would be some sort of a JS based solution for that but I'm no JS expert so perhaps some of the more JS inclined folks here can chime in?
Title: Re: Drillthrough always in the same "new" window
Post by: benhuebner on 13 Jan 2011 03:15:29 AM
Not exactly the first drillthrough link should open the new windows. The second and third should overwrite the content in the now already open child window. If the user has closed the child window in the meantime it should open a new one with the next drillthrough click.
But nevertheless, I think your answer is correct and the solutions comes with the SDK... or are there any more ideas?

Kind Regards

Ben.
Title: Re: Drillthrough always in the same "new" window
Post by: ggarg22 on 25 Mar 2011 12:44:38 PM
Hi benhuebner,

Did you find an answer to the questions? I have the similar request from users and banging my head over it.

Please share the solution you have implemented.

Thanks,
Gary
Title: Re: Drillthrough always in the same "new" window
Post by: benhuebner on 15 Jul 2011 10:21:00 AM
 :-\ no, I'm afraid there is no solution in 8.41.
Title: Re: Drillthrough always in the same "new" window
Post by: CognosPaul on 16 Jul 2011 12:34:41 PM
Is your source a graph or something else?

If it's a graph then I can't help you. If it's something else, like a crosstab, you can use an HTML item to create a link to the target report.

First, go to the target report in Connection and click on the properties. Look at and copy the default URL.
Then wrap the label with the HTML Items:
1. Report Expression:
'<a href="defaultURL&p_ParameterName='+[Query1].[Data Item]+'" target="DetailData">'
Where ParameterName is the parameter you're passing and Data Item is the value you're passing.
2. Text Item:
</a>