In the prompt IN function is not working for report studio report.

[jd]

Hello Friends,

I have a report studio report with 10 columns and 2 prompts.
when I am testing the report with prompts report is running forever it is not prompting to enter the values.

example prompt is [Cog] in(?Cog?)

one more importent thing, if I give the prompt like [Cog]  = '3C'  report is showing data

why it is happening like that, looks like in the prompt IN is not working. please any body can help me??

[IceTea]

Hi,

"in" doesn't work with parameters.   :o

[elsolo21]

Don't you just need to make sure your prompt is set up for 'multi-select'?  I use 'IN' with my prompts/parameters all the time.

-Eric

[IceTea]

i'm sorry, "like" doesn't work with multiselect-parameters, "in" does good!

[MFGF]

Hi,

A couple of questions:

Have you physically defined a prompt in your report, or are you relying on your parameter resulting in an auto-generated prompt?

How many distinct values are there for the prompted item?  How long does it take your database to return a list of these distinct items?

MF.

[Gopinath]

If your prompt values comes from a query, check the performance of that query. this is nothing to do with IN operator.