Lowercase

[fancyface]

Hi, I am currently using Crystal Reports 7 with a SQL ODBC connection. I have a field titled CITY within our ADDRESS tbl and I am trying to locate any cities that start with a lowercase letter for example "calgary" as opposed to "Calgary" within the CITY field. Thanks in advance for any help.

 

[lbass]

First go to file->report options and uncheck "database server is case-insensitive". Then use a record selection formula like this:

{address.city}[1] = lcase({address.city}[1])

-LB

 

[synapsevampire]

In the Report->Selection Formula->Record use:

left({table.city},1) = lowercase(left({table.city},1))

This will limit the rows to only those.

Or you can just use a formula within the details of:

if left({table.city},1) = lowercase(left({table.city},1)) then
"Lowercase"
else
"Uppcase"

Saying you are trying to locate it isn't enough, state that you are trying to limit the rows, or highlight those, or take some action...

-k

 

[fancyface]

Thanks for all your help. The formulas worked great.