ToUpper - sorry, another newbie question

[IvySkye]

How do I set the method of ToUpper on a field before it is analyzed by the WHERE clause?

For example, in Maximo we have the CrewID field. Although it is a select value field, people can simply type in the shift and save the record. I may have a shift written in a dozen different ways (SHIFT 1, Shift 1, shift 1, etc.) In Crystal I set the field uppercase and solved the problem, I can't figure out how to do it in ERDPro.

Thanks in advance.

 

[wesw]

Do you want a parameter to be converted to uppercase?
Is this coming from a request page? (Maximo version 5.x)

Or are they typing in the value in the application? and then running the report for selected records etc.

Wes

 

[ASG0856]

My suggestion would be

Create a computed field called (say) MyCrewId in the column name block (Type in MyCrewId).
Then in the formula block, type UPPER(Server.dbname.table.field)
How much of that you type in depends on the way your actuate is set up.

Verify the Sql (click the SQL button in the menu bar, select Verify SQL). If it verifies, that should work