Joined: 06 Jun 2009
Location: United States
Online Status: Offline
Posts: 32
Topic: How to convert parameter entry into UPPERCASE 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 ?
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
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.
Joined: 06 Jun 2009
Location: United States
Online Status: Offline
Posts: 32
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}
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum