Value prompt limit

[muraliappikonda]

Im trying to retreive a report with more than 3000 values in the the value prompt and its thrown with an err: ORA 01795 "maximum number of experssion in a list is 1000" and i could see a limit of 1000 for IN operator in oracle.Please let me know any ideas of overcoming this

Thanks,
Murali

[dlafrance]

The only idea that come to my mind is to do union with different queries that have a max on 1000 elements.

Don't know if it could work inside report studio..