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
