Print Page | Close Window

How to convert parameter entry into UPPERCASE

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=8740
Printed Date: 05 May 2024 at 6:46am


Topic: How to convert parameter entry into UPPERCASE
Posted By: Seabass
Subject: How to convert parameter entry into UPPERCASE
Date Posted: 28 Dec 2009 at 7:08am
Not an expert so hopefully this make sense....
 
I have a report that has parameter field when i generate it. The problem i have is that i need to have the user input to be all UPPERCASE.  Can i put a formula so the data the user put in is all converted to uppercase automatically ?
 
Thanks in advance,


Replies:
Posted By: DBlank
Date Posted: 28 Dec 2009 at 7:26am
ucase({?param})

Posted By: Seabass
Date Posted: 28 Dec 2009 at 7:36am
sorry for the silly question here, but where do i put this formula ????
 
Thanks

Posted By: DBlank
Date Posted: 28 Dec 2009 at 7:47am

This does not force the user to enter uppercase but rather would convert what they entered to uppercase after the fact. It can be used in the select statement or a formula if you need to display the parameter in the report.

Why do you need it to be uppercase?

Posted By: Seabass
Date Posted: 28 Dec 2009 at 7:49am
the data i am looking to is all uppercase... if i search for "belt" it will not return any results, but if i enter "BELT" it work just fine....
 
I think the convert would work..... let me try it, any other suggestions would be appreciated too....
 
BTW, i do not have access to modify the data properties in the database we are querying....
 

Posted By: DBlank
Date Posted: 28 Dec 2009 at 7:53am

What is the search formula you are using and what is data type?

Posted By: Seabass
Date Posted: 28 Dec 2009 at 7:53am
I just tried the convert deal in the select statement and it work awesome !!! Thanks !

Posted By: Seabass
Date Posted: 28 Dec 2009 at 10:51am
the uppercase formulas work just great...
So if i want to add a wildcard "*" before and after the text that the user will type in the parameter input field, how will i add this to the formulas below.... This is for the ITEM.DTE_LONGDESC field...
 
{INVBALANCES.CURBAL} <> 0.00 and
{INVENTORY.SITEID} = {?SITEID} and
{ITEM.DTE_LONGDESC} like ucase({?LDSEARCH}) and
{INVENTORY.LOCATION} = {?LOCATION}
 
Thanks

Posted By: DBlank
Date Posted: 28 Dec 2009 at 11:23am
2 different ways you can do this:
 
{INVBALANCES.CURBAL} <> 0.00 and
{INVENTORY.SITEID} = {?SITEID} and
{INVENTORY.LOCATION} = {?LOCATION} and
ucase({ITEM.DTE_LONGDESC}) like ucase('*' + {?LDSEARCH} + '*')
 
or
 
{INVBALANCES.CURBAL} <> 0.00 and
{INVENTORY.SITEID} = {?SITEID} and
{INVENTORY.LOCATION} = {?LOCATION} and
instr({ITEM.DTE_LONGDESC},{?LDSEARCH},1) > 0

Posted By: Seabass
Date Posted: 29 Dec 2009 at 3:31am

Thank you so much, this is great.... it is now working just as desired !!!!!

 

Posted By: jeana
Date Posted: 04 Jan 2010 at 6:57am
I have this same question except for an array parameter. Any suggestions?


Print Page | Close Window