Print Page | Close Window

changing the color for a row by condition

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
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=14517
Printed Date: 28 Apr 2024 at 9:16pm


Topic: changing the color for a row by condition
Posted By: aboudeh
Subject: changing the color for a row by condition
Date Posted: 28 Sep 2011 at 7:09am
hello,i have a question
i have crystal report that get it data from database
 i wanna change the color of row by condition
like:
studID      Fname     Lname     mark
  1                mike       brwon     60
   2                tid           any        70
   3               sara      nithing       90


how can i change the row to red when the mark is 90
thanks alot


Replies:
Posted By: DBlank
Date Posted: 28 Sep 2011 at 7:23am
background color of the row, background color of the field or ink color of the field(s)?
row background would be:
open the section expert
select detail section
select color tab
select formula
if table.mark=90 then crRed else Crnocolor

Posted By: aboudeh
Date Posted: 28 Sep 2011 at 10:36am
i wanna change the font of the row

Posted By: DBlank
Date Posted: 28 Sep 2011 at 10:39am

select all the fields you want to change

right click and select format objects
select font tab
select color formula button
if table.mark=90 then crRed else CrBlack
 

Posted By: aboudeh
Date Posted: 28 Sep 2011 at 12:53pm
thx


Print Page | Close Window