Print Page | Close Window

Parameter fields - forcing Caps?

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=4125
Printed Date: 02 May 2024 at 10:28pm


Topic: Parameter fields - forcing Caps?
Posted By: Dakota
Subject: Parameter fields - forcing Caps?
Date 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.


Replies:
Posted By: BrianBischof
Date 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>

Posted By: rahulwalawalkar
Date 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

Posted By: Dakota
Date Posted: 01 Sep 2008 at 11:45pm
Thanks very much, I will try these out and see how I get on.
 
Cheers


Print Page | Close Window