COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: DikEE on 10 Oct 2008 03:50:31 AM

Title: Value Prompt Default Problem
Post by: DikEE on 10 Oct 2008 03:50:31 AM
All

This is my first post so apologies if this is in the wrong forum or has been raised before

I have a large data set that I want to filter using value prompts.  In order to reduce the initial data extraction and speed up the query, I used a default value on a value prompt (I then have other prompts to further filter the data).  I then need to be able to select all values from the value prompt that I assigned the default to.  However, when I select the very top value (i.e. the field name) it simply reverts back to the default value.  I know this should be easy but its driving me mad!

Any advice would be very welcome

Cheers

Richard
Title: Re: Value Prompt Default Problem
Post by: Suraj on 10 Oct 2008 01:17:59 PM
do u have javascript or just default value typed in?
Title: Re: Value Prompt Default Problem
Post by: DikEE on 14 Oct 2008 11:03:51 PM
I just have the default value specified in the value prompt properties.  I have tried to use java script for this, and I can get it to return a default value but the query takes as long to run as if I hadn't specified a default in the first place

Cheers

Richard