Print Page | Close Window

If/Then Relating to Two Columns Printed From: Crystal Reports Book Category: Crystal Reports 9 through 2020 Forum Name: Technical Questions Forum Discription: Formulas, charting data, Crystal syntax, etc. URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22342 Printed Date: 28 Apr 2024 at 7:34am Topic: If/Then Relating to Two Columns Posted By: jgarner Subject: If/Then Relating to Two Columns Date 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 Replies: Posted By: jgarner Date 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.

Print Page | Close Window