COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Topic started by: Suraj on 13 Apr 2007 03:19:11 PM

Title: [RS]-Refreshing behavior of parent report on drill through...
Post by: Suraj on 13 Apr 2007 03:19:11 PM
Hi all,
I have set of reports that drill down to numerous child report and they open in a NEW WINDOW.
Whenever we click on a link in the parent report, it opens a new window for the child report which is what it should do.
Another default feature is that after we click on the link, the parent report also refreshes.
Simple reports refresh in just few seconds.
Some of my reports use numerous variables, parameters etc. In that case, the parent report takes a long time to refresh back to the same page.
It looks like running the parent report again without prompts.
Is there a way to disable that refresh feature when clicking on drill through links?
thank you for any idea.
Title: Re: [RS]-Refreshing behavior of parent report on drill through...
Post by: larsonr on 26 Apr 2007 01:32:42 PM
We contacted Congos and they have labeled it a bug.  Seems like a big miss on their end of checking current functionality.

Title: Re: [RS]-Refreshing behavior of parent report on drill through...
Post by: larsonr on 08 May 2007 08:02:32 PM
So we called our rep to put some pressure on Cognos.

The official answer, its a bug -- we'll shoot for a fix in Cognos 8.2 MR1.

We asked for a workaround, they have nothing.

So what we're doing is using the URL methodology.  We have a text item as the label, or image, or chart.  Then right before it we place an HTML item with <a href=the report url target="_new">  Then after the text item (or image, chart, etc....), we place an HTML item with < /a>. (sorry about the space, it didn't render right the first time)

This works so far.  It allows us to run "drill throughs" from the the parent report without it re-running.  Right now there is no work around though for a Cognos Portlet to not refresh.  If you want to do that then design your own portal interface using HTML tabs to stop it but that can be more overhead for a bug they "promise" to fix.

The reason there is a problem is that they are using a window.open method in their javascript in the drillthrough.js files.  I've actually played with it before in 8.1 when trying to modify the helps and tools links in the upper right corner of Cognos Connection and this does fire a request to the parent window.  There is something in their XML that is causing it but I can't find it. 

Hope this helps.  We just finished our rollout to 8.2 today and its working just fine.
Title: Re: [RS]-Refreshing behavior of parent report on drill through...
Post by: Suraj on 07 Aug 2007 01:04:40 PM
thanks for info larsonr.
that is a nice workaround but I think it will complicate other things when it involves deploying reports to different environments and country with local servers.
we have the latest MR for cognos8 and still this happens.
:(