Report Design
 Crystal Reports Forum : Crystal Reports for Visual Studio 2005 and Newer : Report Design
Message Icon Topic: High light 1 cell with blank or empty value Post Reply Post New Topic
Author Message
huynhng
Newbie
Newbie


Joined: 18 Nov 2008
Location: Singapore
Online Status: Offline
Posts: 5
Quote huynhng Replybullet Topic: High light 1 cell with blank or empty value
    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


Edited by huynhng - 18 Nov 2008 at 2:06am
No comment
IP IP Logged
BrianBischof
Admin Group
Admin Group
Avatar

Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Quote BrianBischof Replybullet 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>
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.016 seconds.