Value prompt in report studio

[ari_meta]

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

[SSNCOG]

Hi,

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

SSNCOG

[ari_meta]

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

[MFGF]

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.

[ari_meta]

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

[MFGF]

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.

[ari_meta]

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

Ari

[MFGF]

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.

[Gnani]

Write filter condition like

[Dataitem Name] starts with '?Parameter1?'

...Gnani...

[ari_meta]

Hi

  Thanks you , It has been very helpful.


Ari

[pooja]

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

thank you