Parameter Field

[wildrancher]

I have a Parameter field called PeriodID.

This is a concatenation of MONYYYY. This is stored in the database as uppercase as JAN2003.

If my users enter jan2003 in lower case how can I make sure that it gets converted to Uppercase before it runs the query at the database???

Please Help.

Thanks

 

[lbass]

Did you try this?

{table.month} = uppercase({?periodID})

-LB

 

[IdoMillet]

Create an SQL Expression that uses the DBMS function for UpperCase (different DBMS have different names for that function and some may not have it).

Then use the SQL expression in your record selection criterion.

That would allow the record selection to be done by the DBMS instead of by Crystal.

Cheers,
- Ido

CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[rhinok]

...or depending on your database you can simply select the Report Option 'Case-Insensitive SQL Data' (SQL Server supports it, Oracle does not).

 

[wildrancher]

It still doesnot work.

I created a Parameter field called ?PERIOD.
It works for UpperCase values only.

How can I make it work for anycase. Iam on Crystal 8.5 and Oracle 9i.

Please Advice.

Thanks

 

[sameer11]

Check if your ?PERIOD is a date type or string type
it should be a string type

and try Lbass advice. that should do.



Sameer