Just remember no matter what the datatype of the field you are retrieving, when you retrieve it with GetProperty it comes as type TEXT.
----- Original Message ----- From: "Wills, Steve" <[EMAIL PROTECTED]> To: "RBASE-L Mailing List" <[email protected]> Sent: Friday, June 20, 2008 2:52 PM Subject: [RBASE-L] - Re: How to GETPROPERTY Value of CURRENCY Field in Report Break Footer? Yep', Dawn, that's how I'd done it previously, but, when I got that twinkle in my eye about 'GETPROPERTY ...', well, I had to walk that path. F/now, I've changed it as you advised. However, I'd still like to know about the possibilities available with GETPROPERTY as they relate to controls located on the report itself, as in forms. Thanks, Steve -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Dawn Hast Sent: Friday, June 20, 2008 1:36pm 13:36 To: RBASE-L Mailing List Subject: [RBASE-L] - Re: How to GETPROPERTY Value of CURRENCY Field in Report Break Footer? Steve, Rather than using the TEXTVALUE, try defining a report variable = the db field, then use that variable in your before generate eep: IF varname <= 0 THEN PROPERTY componentid FONT_COLOR 'RED' PROPERTY componentid FONT_BOLD 'TRUE' ENDIF Dawn ----- Original Message ----- From: Wills, Steve To: RBASE-L Mailing List Sent: Friday, June 20, 2008 2:19 PM Subject: [RBASE-L] - How to GETPROPERTY Value of CURRENCY Field in Report Break Footer? I have checked the RB website for help on this and came up half-empty (it's Friday and I'm tired, so it's not half-full). I have a report with a Break Footer, on which is a DB TEXT control for a CURRENCY-type field. In the Before Generate EEP, I want to test its value, namely to see if it's 0 or negative, in order to do conditional formatting/presentation of the field, a kind of "Hey, look at me, I'm the exception in this exception report!" attention-getter. I have been able to do this w/o problem for some TEXT-type fields on the report, but I'm not sure which other control to look at as a guide to getting the correct "value" property for this CURRENCY-type field. Could it be the TEXTVALUE property, as in a DB EDIT control or is it something else? Thanks, Steve in Memphis J. Stephen Wills Program Manager, Research Informatics Office of the Vice Chancellor for Research University of Tennessee Health Science Center 62 S. Dunlap, Suite 400 Memphis, TN 38163 Office: 901-448-2389 FAX : 901-448-7133
