Tips and Tricks
 Crystal Reports Forum : Crystal Reports for Visual Studio 2005 and Newer : Tips and Tricks
Message Icon Topic: Background color formula Post Reply Post New Topic
Author Message
Kanesh
Newbie
Newbie


Joined: 17 Jun 2008
Online Status: Offline
Posts: 10
Quote Kanesh Replybullet Topic: Background color formula
    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.
IP IP Logged
Savan
Senior Member
Senior Member
Avatar

Joined: 14 Dec 2007
Location: India
Online Status: Offline
Posts: 162
Quote Savan Replybullet 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
IP IP Logged
Kanesh
Newbie
Newbie


Joined: 17 Jun 2008
Online Status: Offline
Posts: 10
Quote Kanesh Replybullet Posted: 17 Oct 2008 at 1:37am
Thanks a lot, this works fine.
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.049 seconds.