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