Print Page | Close Window

Case sensitive?

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=3932
Printed Date: 04 May 2024 at 6:25am


Topic: Case sensitive?
Posted By: dtamondong
Subject: Case sensitive?
Date Posted: 07 Aug 2008 at 2:17pm

I created an exceptions report to pull addresses from our database to ensure address standards are being followed.  One of our standards is that addresses should be in all uppercase.  How do I exclude addresses that are in all uppercase and show only those that were entered in mixed or all lowercase?


Replies:
Posted By: rahulwalawalkar
Date Posted: 08 Aug 2008 at 3:06am
Hi
 
In record selection formula check
 
 
uppercase({table.addressfield}) <> {table.addressfield}
 
cheers
Rahul


Print Page | Close Window