Print Page | Close Window

Background color formula

Printed From: Crystal Reports Book
Category: Crystal Reports for Visual Studio 2005-2015
Forum Name: Tips and Tricks
Forum Discription: Have you learned some great tricks to share with the group? Post them here!
Printed Date: 07 Aug 2020 at 7:47pm

Topic: Background color formula
Posted By: Kanesh
Subject: Background color formula
Date Posted: 16 Oct 2008 at 2:49pm
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???

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)  


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

Print Page | Close Window