If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Issue in autosubmit for a cascading prompt

Started by Manu0521, 04 Mar 2014 09:40:11 AM

Previous topic - Next topic

Manu0521

Hi ALL,
I am using two reports in my cognos workspace, created using report studio. I have added a global filter for field say country and my first report shows the revenue genearated by employees for country wise. In the second report I am using a cascading prompt with the first one being a value prompt for the country and second will show the value prompt for  employess belonging to that country and Both the reports uses the same data item name for country and I have created a select value filter for country in the global area.

so when I select any of the country in my report 1 , the report 1 displays the data and when I move to tab 2 , my value prompt in the tab2 for country doesnt auto selects, but the selected value in the global filter is present inside the dropdownlist.

So I tried using java script in my report 2 to auto select the prompt value.
I used the below code and it works well in report studio.
<script type="text/javascript">
var fW = (typeof getFormWarpRequest == "function" ? getFormWarpRequest() : document.forms["formWarpRequest"]);
if ( !fW || fW == undefined) { fW = ( formWarpRequest_THIS_ ? formWarpRequest_THIS_ : formWarpRequest_NS_ );}
var prompt = fW._oLstChoicesmyPrompt;
if (prompt.value.length==0)
{
prompt.options[2].selected = true;
promptAction('finish');
}
</script>

But in cognos workspace it selects the value in the country prompt , but my cascaded prompt doesnt changes on this selection. I have set the auto submit property to yes .

Please let me know your suggestions on how to get this work around.

Thanks,
Mani