Ron, Well the simplest way to do this assuming you can live with it only displaying when it is past due. 1. In the report assign a Variable to your Column that you described as svc3. Make it RED and give it a componentID such as PastDueDisplay and uncheck Visible. 2. In the BeforeGenerate EEP of the Band you placed your variable place this code. IF vMyVariable = 'PastDue' THEN PROPERTY PastDueDisplay VISIBLE TRUE ELSE PROPERTY PastDueDisplay VISIBLE FALSE ENDIF Jan -----Original Message----- From: "GRIES RONALD OR META" <[email protected]> To: [email protected] (RBASE-L Mailing List) Date: Thu, 16 Apr 2009 16:45:00 GMT Subject: [RBASE-L] - Re: Color of text
I am running V8. I am not familiar with that command Ron Gries Certified Home Inspector Certified Infrared Thermographer, Level II - No. 7579 Certified Indoor Air Consultant New Mexico Licensed Adjuster Office 575-625-0662 Cell 575-626-0892 -----Original Message----- From: "jan johansen" <[email protected]> Sent 4/16/2009 10:07:29 AM To: "RBASE-L Mailing List" <[email protected]> Subject: [RBASE-L] - Re: Color of text Ron, OK. I should have asked this in the last email. What version are you running? How familiar are you with the PROPERTY command? Jan -----Original Message----- From: "GRIES RONALD OR META" <[email protected]> To: [email protected] (RBASE-L Mailing List) Date: Thu, 16 Apr 2009 15:55:11 GMT Subject: [RBASE-L] - Re: Color of text Thanks In a report Ron Gries Certified Home Inspector Certified Infrared Thermographer, Level II - No. 7579 Certified Indoor Air Consultant New Mexico Licensed Adjuster Office 575-625-0662 Cell 575-626-0892 -----Original Message----- From: "jan johansen" <[email protected]> Sent 4/16/2009 8:30:21 AM To: "RBASE-L Mailing List" <[email protected]> Subject: [RBASE-L] - Re: Color of text Ron, It is possible but need some more information. Where is this to be displayed? In a report or on a form? Jan -----Original Message----- From: "GRIES RONALD OR META" <[email protected]> To: [email protected] (RBASE-L Mailing List) Date: Thu, 16 Apr 2009 14:24:53 GMT Subject: [RBASE-L] - Color of text Using the command below, can I have the text color change to red if the value of curstatus is ‘PastDue’. If yes, would you state the syntax? “UPDATE svc3 SET curstatus = (IFGT((ADDDAY(finalappdate,305)),(.#DATE),'OK','PastDue'))” Thanks to you all! Sorry for the spelling errors in the last email. Ron Gries Certified Home Inspector Certified Infrared Thermographer, Level II - No. 7579 Certified Indoor Air Consultant New Mexico Licensed Adjuster Office 575-625-0662 Cell 575-626-0892
