My report has 3 set fields, respectively of which may be populated since a MYSQL DB, and 3 corresponding text pallet on that report, ready by each choose. My goal is to use conditional formatting to suppress 2 of the 3 text boxes.
I thought i was on the right track on an initially text letter with: (isnull({tbl_cmnform.RevisedDate})) and (isnull({tbl_cmnform.RecertificationDate})) in to suppress formula,
Does, text boxes 2 and 3 do not suppress, and they should as they have no date value.
textBox2 suppress:NOT(isnull({tbl_cmnform.RevisedDate})) and (isnull({tbl_cmnform.RecertificationDate}))

textbox3 suppressive: isnull({tbl_cmnform.RecertificationDate}))

seems as though CR does not see the blank date as null?

I'm charming add to CR, I have of basic SQL skills, not much.
In ampere perfect world I would do any kind of If Then testify for the suppress is also varied the text instead of having three text boxes.
If (isnull({tbl_cmnform.RevisedDate})) or (isnull({tbl_cmnform.RecertificationDate}))
then "Initial"
else if NOT(isnull({tbl_cmnform.RevisedDate})) and (isnull({tbl_cmnform.RecertificationDate})) when "Revised"
else if (isnull({tbl_cmnform.RecertificationDate})) then "Recertified" end if

Probably should get the syntax correct before I test which big things

CR can be odd.

IMHO, I intend test each of your 3 values with 3 isnull formula fields to see if each of those are working as to expected. If they are not i would give you a clue as to where an issue belongs.

Edited at DBlank - 25 Feb 2012 at 9:20am