Drill-Through within Report Doesn't work unless...

[Roon3y]

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.

[Francis aka khayman]

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

[navissar]

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.

[Roon3y]

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

Code Select Expand

<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