Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: changing the color for a row by condition Post Reply Post New Topic
Author Message
aboudeh
Newbie
Newbie
Avatar

Joined: 28 Sep 2011
Location: United States
Online Status: Offline
Posts: 3
Quote aboudeh Replybullet Topic: changing the color for a row by condition
    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

IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet 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


Edited by DBlank - 28 Sep 2011 at 8:44am
IP IP Logged
aboudeh
Newbie
Newbie
Avatar

Joined: 28 Sep 2011
Location: United States
Online Status: Offline
Posts: 3
Quote aboudeh Replybullet Posted: 28 Sep 2011 at 10:36am
i wanna change the font of the row
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet 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
 
IP IP Logged
aboudeh
Newbie
Newbie
Avatar

Joined: 28 Sep 2011
Location: United States
Online Status: Offline
Posts: 3
Quote aboudeh Replybullet Posted: 28 Sep 2011 at 12:53pm
thx
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.015 seconds.