COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: chinnucognos on 09 Mar 2016 10:37:47 AM

Title: Reports drillthru with drop down functionality
Post by: chinnucognos on 09 Mar 2016 10:37:47 AM

I have a report named  say "Director" report , the report  should have the option to see "Manager" & "Supervisor" reports in Newtab with drop down functionality.So I have a value prompt with two static choices as 'Manager ' & 'Supervisor'  and here I struck to drillthru from value prompt values?

Is there any alternative to achieve drill thru report having dropdown functionality.

Note:Using Cognos 10.2.2 with IE9 as Interface browser

Thanks in advance.
Title: Re: Reports drillthru with drop down functionality
Post by: BigChris on 10 Mar 2016 02:25:47 AM
Just put two text fields on your report for 'Manager' and 'Supervisor" and put the drill throughs from them instead.
Title: Re: Reports drillthru with drop down functionality
Post by: chinnucognos on 10 Mar 2016 04:43:02 AM
Hi Bigchris,

Thanks for reply
I need dropdown functionality along with dril thrus asigned to those values
How can i achieve dropdown(just like valueprompt dropdown)?
Title: Re: Reports drillthru with drop down functionality
Post by: BigChris on 10 Mar 2016 05:58:50 AM
No idea - I'd give the user a solution that works and not get hung on the method...you're the report designer after all.
Title: Re: Reports drillthru with drop down functionality
Post by: Lynn on 10 Mar 2016 06:08:01 AM
There is no out-of-the-box way to do what you are describing as far as I know. I agree with Chris.
Title: Re: Reports drillthru with drop down functionality
Post by: chinnucognos on 10 Mar 2016 08:50:56 AM
After all, i have changed it to act as "Hyperlink" buttons and user accepted.
Thanks BigChris and Lynn
Cheers ;)