Print Page - Value prompt in report studio

Title: Value prompt in report studio
Post by: ari_meta on 27 Apr 2010 09:00:44 PM

Hi

We have a value prompt, which has more than 500 values in that. Any other idea to display value except search prompt.

Thanks

Ari

Title: Re: Value prompt in report studio
Post by: SSNCOG on 27 Apr 2010 11:42:12 PM

Hi,

Whats an issue with the value prompt with 500 values?
Does your page takes time to load the values? write more details

SSNCOG

Title: Re: Value prompt in report studio
Post by: ari_meta on 28 Apr 2010 03:42:52 AM

Hi

Thanks for reply. Actually, This prompt is on report page and user does not want to see so many values at single time.

So, i was thinking of alternate ways.

Regards

Ari

Title: Re: Value prompt in report studio
Post by: MFGF on 28 Apr 2010 05:30:15 AM

Hi,

Is it feasible to add an initial prompt for the general area or type required, then cascade your existing prompt from this to reduce the number of entries?

MF.

Title: Re: Value prompt in report studio
Post by: ari_meta on 29 Apr 2010 03:23:37 AM

Hi

I do not have something to cascade on. can we create a value prompt which shows A , B , C , D etc ? Then if user clicks on A , then he will see names with A only.

something like that.

Thanks
Ari

Title: Re: Value prompt in report studio
Post by: MFGF on 29 Apr 2010 06:30:08 AM

Hi,

Yes, you can. The initial value prompt will be populated by static values. The second value prompt will be fed from a query which uses the results of the first prompt in a filter.

MF.

Title: Re: Value prompt in report studio
Post by: ari_meta on 29 Apr 2010 07:30:29 PM

Thanks, Can you please elaborate it , how we can achieve this .

Ari

Title: Re: Value prompt in report studio
Post by: MFGF on 30 Apr 2010 07:49:35 AM

Create a prompt page. Drag in a Value prompt, and name the parameter for it, then press Finish. In the properties of the prompt, go the Static Values property and manually enter your 26 static values eg 'A', 'B' etc. Set the Multi Select property to 'No' and the Auto Submit property to 'Yes'.

Drag in a second value prompt and configure it as you have done currently - setting up a filter and a query which retrieves the 500 values for the prompt. In the properties of the second prompt, set the Cascade Source property to be the variable from the first prompt.

Finally, in Query Explorer, select the Query for your second prompt. Drag a Filter from the Toolbox into the Detail Filters area, and code the expression as [Item being displayed in your prompt] starts with ?Param from First Prompt?

Regards,

MF.

Title: Re: Value prompt in report studio
Post by: Gnani on 30 Apr 2010 07:54:41 AM

Write filter condition like

[Dataitem Name] starts with '?Parameter1?'

...Gnani...

Title: Re: Value prompt in report studio
Post by: ari_meta on 01 May 2010 05:41:28 AM

Hi

Thanks you , It has been very helpful.

Ari

Title: Re: Value prompt in report studio
Post by: pooja on 04 May 2010 08:02:17 AM

is it compatible for Query Subject from Stored Procedure too??
because we are using QS from SP.

thank you

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: ari_meta on 27 Apr 2010 09:00:44 PM