Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Technical Questions
Message Icon Topic: If/Then Relating to Two Columns Post Reply Post New Topic
Author Message
jgarner
Senior Member
Senior Member


Joined: 23 Jan 2009
Location: United States
Online Status: Offline
Posts: 159
Quote jgarner Replybullet Topic: If/Then Relating to Two Columns
    Posted: 26 Jun 2017 at 10:12am
I have two columns in my report. Column one is 'CONTRACTNUM', column two is 'ACTIVE'. Column two is either 'yes' or 'no'. I'd like to highlight all references listed under 'CONTRACTNUM' in crGreen if 'ACTIVE' is 'Yes'.

Also, do I actually need the 'ACTIVE' (column two) in my report, or can it remain in a table in the Field Explorer?

Any suggestion? Thanks in advance for your time and expertise!

CR 11.5.3.417
IP IP Logged
jgarner
Senior Member
Senior Member


Joined: 23 Jan 2009
Location: United States
Online Status: Offline
Posts: 159
Quote jgarner Replybullet Posted: 26 Jun 2017 at 11:01am
This was easier than I expected, and I did figure this one out on my own.

I created a new formatting formula with the following:
If {Sheet1_.Active} = 'yes' then color(0,255,0) Else crNoColor

Thanks.
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.012 seconds.