Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: Parameter fields - forcing Caps? Post Reply Post New Topic
Author Message
Dakota
Newbie
Newbie


Joined: 29 Aug 2008
Online Status: Offline
Posts: 2
Quote Dakota Replybullet Topic: Parameter fields - forcing Caps?
    Posted: 01 Sep 2008 at 3:59am
Hi folks,
 
First timer poster here.....be gentle.
 
I was wondering if there was a way to force the entry of caps in the parameter entry screen.
 
The reason I ask, we have a report that keeps returning back 0 records, because the end-ser keep inputting 'a' instead of 'A' at the paramter entry on run. If we could force it so it always comes through as 'A' that would be great.
 
I have looking into the masks that can be set against the field but could not see anything (I think) that suited my needs.
 
Any help would be greatly appreciated.
IP IP Logged
BrianBischof
Admin Group
Admin Group
Avatar

Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Quote BrianBischof Replybullet Posted: 01 Sep 2008 at 10:40am
Welcome to the forum! Have you tried using ">L"? This forces it uppercase.
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>
IP IP Logged
rahulwalawalkar
Senior Member
Senior Member
Avatar

Joined: 08 Jun 2007
Location: United Kingdom
Online Status: Offline
Posts: 731
Quote rahulwalawalkar Replybullet Posted: 01 Sep 2008 at 12:20pm
Hi,
 
You can try this in your record selection formula
 
{Customer.Region} LIKE uppercase({?My Parameter}) this will change the entered parameter to upper case.
 
cheers
Rahul
IP IP Logged
Dakota
Newbie
Newbie


Joined: 29 Aug 2008
Online Status: Offline
Posts: 2
Quote Dakota Replybullet Posted: 01 Sep 2008 at 11:45pm
Thanks very much, I will try these out and see how I get on.
 
Cheers
IP IP Logged
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.047 seconds.