I need to filter out all the Part ID's with lowercase descriptions

[tthai826]

I need to extract all the part master id descriptions that are in lower case so they can be edited to be in all uppercase. So My question is how can i go on doing that, or is it at all possible to enter in a formula where it'll automaticly render all the descriptions that are in lower case and convert them to upper case?

 

[synapsevampire]

You can do either.

Crystal won't let you modify existing data, but it will convert to uppercase using:

UpperCase({MyTable.MyField})

You can check for lowercase or uppercase by using:

{MyTable.MyField} = LowerCase({MyTable.MyField})

You could also use a SQL Expression:

UPPER(MyField)

But if the database has it stored in lowercase, and you want it stored in uppercase, you should issue an update statement against the database using a query tool, as in the following SQL Server example:

update MyTable
set MyField = UPPER(MyField)

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[tthai826]

That lowercase search kind of worked. I just want it to be restricted to only searching for lowercase.

 

[synapsevampire]

Is that to say you only want rows back that have lowercase data?

You can limit the rows in the database to only lowercase by using the following in the record selection criteria:

{MyTable.MyField} = LowerCase({MyTable.MyField})

If you want them all to be returned as UPPERCASE, create a formula with:

UpperCase({MyTable.MyField})

And display that formula instead of the field.

I don't think that I fully understand what you want, hopefully this handles it.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[tthai826]

alright, this is what i'm trying to do exactly. I'm trying to pull up stored data as follows. only the part id's with lower case descriptions.


Rec No. Part Master ID. Description
xxxx xxxxxxxxxxxxxxx xxxlowercasexxx

having the part id number in there with the descriptions is very important. Thanks for any help you can provide

 

[rosemaryl]

Dear tthai826,

So what you want to do is pull descriptions that contain lowercase letters. So do this:

{MyTable.MyField} <> Uppercase({MyTable.MyField})

this should return those records that contain lowercase in the description.

ro
Rosemary Lieberman
rosemary@microflo.com,

http://www.microflo.com

Microflo provides expert consulting on MagicTSD and Crystal Reports.

 

[synapsevampire]

What Ro is saying is what I posted before your post:

(Ro: Your example will also show Proper Cased, it should be as below)

You can limit the rows in the database to only lowercase by using the following in the record selection criteria:

{MyTable.MyField} = LowerCase({MyTable.MyField})

The record selection criteria is located by:

Report->Edit record selection->Record

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[tthai826]

thanks all it worked. i'm really new at this. all your info helps out greatly