Print Page | Close Window

High light 1 cell with blank or empty value

Printed From: Crystal Reports Book
Category: Crystal Reports for Visual Studio 2005 and Newer
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=4826
Printed Date: 18 May 2024 at 1:48pm


Topic: High light 1 cell with blank or empty value
Posted By: huynhng
Subject: High light 1 cell with blank or empty value
Date Posted: 18 Nov 2008 at 2:05am
Hi all,
 
    I have 2 colums in report (CR 10): ColumnA and ColumnB.
    I set background color formula for ColumnB:
         if(strcmp({ColumnA}, {ColumnB}) = 0) then
               crred
         else
               nocolor
    (it mean: if 2 columns are different value --> column B is set to red "Background" color
    case 1: columnA with value 'aaa' and columnB with value 'bbb' --> columnB is set to red in background
 
    case 2: columnA with value 'aaa' and columnB with value ' ' (one space, i get this value from DB) --> columnB is not set red in background althought 2 column is different. (I think Crystal Report can not apply formula for blank, null, event one space character)
 
     Any body have solution please tell me asap! Dose CR support formular for case 2
 
Thanks and regards,
Huynh


-------------
No comment


Replies:
Posted By: BrianBischof
Date Posted: 18 Nov 2008 at 9:03am
In the report options, set the option 'use default values for null'. This way, if a value is null, then CR treats it as an empty string. See if that helps.

-------------
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>


Print Page | Close Window