COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: Roon3y on 11 Dec 2013 02:11:47 PM

Title: Drill-Through within Report Doesn't work unless...
Post by: Roon3y on 11 Dec 2013 02:11:47 PM
Okay, hope someone can help. This has been messing with me for past couple of days.

I have a map report, which shows me who many employees from which states etc... I have a drill-through setup within the report to give me list when i go into specific state. It works perfectly (except for list showing when i have all states view), i am able to go into any state that has employees it'll go in show me map of that state and list of employees right below the map (see attached screenshot).

But here the main fuss with the report. When i open the report without opening report studio, it'll open and everything but it won't drill-through like it does when i run the report while report studio is open. When i click on the state it'll just blink and came back to default layout.

Cognos version 10.1.1

Hope i made sense, if not let me know ill try to clear things up.

PS may be someone can help me hide the list until i go into specific state.
Title: Re: Drill-Through within Report Doesn't work unless...
Post by: Francis aka khayman on 11 Dec 2013 08:28:47 PM
how about you test if there is something wrong with the map drill through?

add text (Cali, NY, etc) somewhere in the report and set it up to drill through. now try if these are working when you run the report without opening report studio and take it from there...

to hide the list, you can use conditional blocks or render variables. you will need a prompt value and set its default in cognos connection.

hope that helps
Title: Re: Drill-Through within Report Doesn't work unless...
Post by: navissar on 12 Dec 2013 03:01:39 AM
The behaviour you're describing is typical when a custom JavaScript doesn't cater for Cognos's different formWarpRequest names.
Maybe you can attach the syntax of any HTML Items in the report, and I'll try to fix them for you.
Title: Re: Drill-Through within Report Doesn't work unless...
Post by: Roon3y on 12 Dec 2013 08:39:22 AM
Quote from: Nimrod Avissar on 12 Dec 2013 03:01:39 AM
The behaviour you're describing is typical when a custom JavaScript doesn't cater for Cognos's different formWarpRequest names.
Maybe you can attach the syntax of any HTML Items in the report, and I'll try to fix them for you.

Hmm... the only HTML Items im using is for Value prompt which is just renaming the prompt

<script> document.formWarpRequest._oLstChoicesMyList[0].text = 'Select Company Number'; </script>

here is the report code, if that helps

https://www.dropbox.com/s/0hu30muhpqjw9c8/MAP_REPORT.txt