upper case filter condition

[naveenshindhe]

Hi,
My prompt is in lower case. Using oracle database.
my filter condition is
Region in (upper(?prompt?))
but this region is in upper case.

If i give above condition i can select only 1 region i.e, it comes as combo box.iam unable to select multiple regions.

But, I want to select multiple regions, i.e, if i give

Region in (?prompt?)

i am able to select multiple regions, but i am not getting any records.

do you have any idea how to do this

please help.
regards

naveen.

 

[mennooo]

Have you tried lower(Region) in ?Prompt?

 

[sln007]

If Region is stored as upper-case in your DB, then "(Region in (upper(?prompt?))" should work fine...(I use exactly that style).

If Region is stored in either upper-or-lower case in your DB, then "upper(Region) in (upper(?prompt?))" should work.

Try dislpaying your ?prompt? values in the report header to
see what is being used. It might help.