Print Page | Close Window

Background color formula

Printed From: Crystal Reports Book
Category: Crystal Reports for Visual Studio 2005 and Newer
Forum Name: Tips and Tricks
Forum Discription: Have you learned some great tricks to share with the group? Post them here!
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=4559
Printed Date: 26 Apr 2024 at 7:53am


Topic: Background color formula
Posted By: Kanesh
Subject: Background color formula
Date Posted: 16 Oct 2008 at 2:49pm
Hi,
 
In my datatable i have i column 'color' . This column can have two values:
'yes' or 'no' .
In the section expert i made a formula for the background:
if {dtImpPlan.color} = 'yes' then Color (238,130,238)  
 
This works, bud the problem is that all other lines(where color='no') get automatically a black color. Even if i make the background color white.
What is going on here???
 
Thanks.


Replies:
Posted By: Savan
Date Posted: 16 Oct 2008 at 11:05pm

you can do this way

if {dtImpPlan.color} = 'yes' then
   Color (238,130,238)  
else
   white


-------------
Thanks
Savan

Posted By: Kanesh
Date Posted: 17 Oct 2008 at 1:37am
Thanks a lot, this works fine.


Print Page | Close Window