Crystal Reports How to convert parameter entry into UPPERCASE

Report Design
Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design

Topic: How to convert parameter entry into UPPERCASE
	Page of 2 Next >>

Author	Message
Seabass Newbie 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 ? Thanks in advance,
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 28 Dec 2009 at 7:26am
	ucase({?param})
	IP Logged

Seabass Newbie Joined: 06 Jun 2009 Location: United States Online Status: Offline Posts: 32	Posted: 28 Dec 2009 at 7:36am
	sorry for the silly question here, but where do i put this formula ???? Thanks
	IP Logged

DBlank Moderator 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. Why do you need it to be uppercase?
	IP Logged

Seabass Newbie Joined: 06 Jun 2009 Location: United States Online Status: Offline Posts: 32	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....
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 28 Dec 2009 at 7:53am
	What is the search formula you are using and what is data type?
	IP Logged

Seabass Newbie Joined: 06 Jun 2009 Location: United States Online Status: Offline Posts: 32	Posted: 28 Dec 2009 at 7:53am
	I just tried the convert deal in the select statement and it work awesome !!! Thanks !
	IP Logged

Seabass Newbie 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} Thanks
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	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
	IP Logged

Seabass Newbie Joined: 06 Jun 2009 Location: United States Online Status: Offline Posts: 32	Posted: 29 Dec 2009 at 3:31am
	Thank you so much, this is great.... it is now working just as desired !!!!!
	IP Logged

Page of 2 Next >>

Post Reply

Post New Topic

Printable version

Printable version

Forum Jump

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

This page was generated in 0.048 seconds.