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??
Hi,
"in" doesn't work with parameters. :o
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
i'm sorry, "like" doesn't work with multiselect-parameters, "in" does good!
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.
If your prompt values comes from a query, check the performance of that query. this is nothing to do with IN operator.