You can't use the column names themselves in the report band eep - not sure why exactly. I'm sure there's a really good technical reason, but I never took the time to find out.
The easiest thing to do for the color names is use the object inspector, if you're using the Enterprise Edition. At one point, the list of allowed colors was included in the help files, but I think all colors are allowed now. You can use RGB values for custom colors: PROPERTY <componentid> FONT_COLOR '[R128,G32,B5]' ----- Original Message ----- From: Wills, Steve To: RBASE-L Mailing List Sent: Tuesday, April 29, 2008 5:41 PM Subject: [RBASE-L] - Re: How To Do Conditional Formatting/Presentation in Reports Dawn, thanks; I already got it workin’ … well, that’s probably a “duh”, huh’? Anyway, that’s pretty cool and it’s got me kinda’ pumped about exploring it some more. Anyway, lemme’ please follow up with 2 related Q’s about it” (1) Why the var’s rather than the fields? (2) Where is the list of defined color names? Thanks, Steve in Memphis From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Tuesday, April 29, 2008 3:42pm 15:42 To: RBASE-L Mailing List Subject: [RBASE-L] - Re: How To Do Conditional Formatting/Presentation in Reports Steve, 1. Define variables for the two fields you want to compare. 2. Give the two objects on the report component ids. 3. In the On Before Generate EEP for the BAND the fields are located: IF var1 <> var2 THEN PROPERTY <componentid> FONT_COLOR 'White' PROPERTY <componentid> COLOR 'Black' ELSE PROPERTY <componentid> FONT_COLOR 'Black' PROPERTY <componentid> COLOR 'White' ENDIF Dawn Hast "Wills, Steve" <[EMAIL PROTECTED]> wrote on 04/29/2008 04:31:00 PM: > I’m sure this has been answered somewhere, but so far I can’t find > it in the PDF’s I’ve downloaded or the doc’s, so, how do I do > conditional formatting in reports in v8? > > I am working on an exception/”police” report. I want to > conditionally format 2 fields on the report when they are not equal, > say white on black rather than black on white. > > I’m sure it can be done - a property setting I’d guess - but I’m at > a loss right now as to where to do it. > > > 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 >
