----- Original Message ----- From: "James Bentley" <[EMAIL PROTECTED]> To: "RBASE-L Mailing List" <[email protected]> Sent: Tuesday, June 24, 2008 5:01 PM Subject: [RBASE-L] - Re: Custom Colors In Reports?
> Steve, > > Just an observation. Even though RBase tightens up does not give an error > for the following IF statement > "IF (.vBF4_OBLIGATED_CHANGE) <= 0 THEN" > Probably because of the paren's and the IF test probably works. If you remove > the superfluous parenthesis you get an error of dotted variable on left side > of condition. Just one of thos nagging items that someday could come back to > haunt if Rbase tightens up its syntax. I think because of the PARENS, the dotted var is interpreted as a literal, thence no error since it's technically not a variable. > Jim Bentley > American Celiac Society > [EMAIL PROTECTED] > tel: 1-504-737-3293 > > > --- On Tue, 6/24/08, Wills, Steve <[EMAIL PROTECTED]> wrote: > >> From: Wills, Steve <[EMAIL PROTECTED]> >> Subject: [RBASE-L] - Custom Colors In Reports? >> To: "RBASE-L Mailing List" <[email protected]> >> Date: Tuesday, June 24, 2008, 1:52 PM >> This is a follow-up to yesterday's "Which Approach >> to Conditionally & >> Dynamically"Create" Control on Report?" >> question. >> >> I have a variable in a report which is assigned a value >> from a field/DB >> Text, vBF4_OBLIGATED_CHANGE and OBLIGATED_CHANGE, >> respectively. If this >> value is 0 or less, I want to change the (background) color >> of the >> control. >> >> Here is a block in the BEFORE GENERATE EEP: >> >> IF (.vBF4_OBLIGATED_CHANGE) <= 0 THEN >> PROPERTY BF4_OBLIGATED_CHANGE FONT_COLOR 'BLACK' >> PROPERTY BF4_OBLIGATED_CHANGE COLOR 'YELLOW' >> ELSE >> PROPERTY BF4_OBLIGATED_CHANGE FONT_COLOR 'BLACK' >> PROPERTY BF4_OBLIGATED_CHANGE COLOR 'WHITE' >> ENDIF >> >> >> This works. >> >> However, this statement does not : >> >> PROPERTY BF4_OBLIGATED_CHANGE COLOR 'CYAN' >> >> >> Nor does : >> >> PROPERTY BF4_OBLIGATED_CHANGE COLOR 'LIGHT CYAN' >> >> >> (Interestingly, each and every failed attempt changed the >> background to >> green.) >> >> >> Also interesting, these statements do work : >> >> PROPERTY BF4_OBLIGATED_CHANGE COLOR >> 'ActiveCaption' >> >> PROPERTY BF4_OBLIGATED_CHANGE COLOR 'AQUA' >> >> >> So, my questions are: >> 1) Which colors are available for changing the background >> of a DB Text >> in Reports? >> 2) Where are their "names" found/stored? >> 3) Can I add new colors or redefine existing, in either >> case using R,G,B >> values? >> >> >> >> 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 > > > > > >
