How to make Parameter field Case sensitive

[teegireddy]

Hi All,
i have an issue with the user that they need the parameter field should be case sensitive which is not a case sensitive in the DB.

Here is my Question, i Have Contract ID (D260752,Etc..)which is the parameter and the user needs this D as d260752
is this possible any way either in crystal or business objects(Universe level)..to change the case of the parameter which is selected...

can any one help me out.

Thanks verymuch in advance.

 

[Turkbear]

Hi,
Can you explain why the parameter needs to be case-sensitive when the database is not?

Are there cases where 2 IDs differ only in the case of the initial letter? ( Not likely, though, if the database is not case sensitive).

I realize that the user may want the parameter choice list to look a certain way and, if you really need to do that, you can probably create a view that has the parameter values in lower-case using a function to convert any that need it ( database dependent, in Oracle it would be

lower({ContractID})

To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[chelseatech]

The record selection is based on a formula, often in the form:
{table.databasefield} = {?parameter]

This is then passed via SQL to the database. It is the database that can be set to case sensitive or insensitive. Changing the database from one to another can be a complex operation.

Case sensitive is faster, but less flexible. Users usually expect the selection to be insensitive so they can select a city of "New York", "NEW YORK" or "new york" and get all the matching entries.

In the end, improve the quality of data always helps.

Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm

 

[Turkbear]

Hi,
To avoid case issues you could use:

Upper(table.databasefield}) = Upper({?parameter])

This may cause some performance hit depending on your database.






To Paraphrase:"The Help you get is proportional to the Help you give.."