>>The problem is definitely with the IIF() and probably the way SFReports views it. I changed my IIF() expression to
>>IIF( DATE_FLD1 > DATE_FLD2, 1, 0 ) and I still see bunch of asterisks.
>
>Did you try a UDF, which might be named MyMax()? I understand UDFs are not an acceptable in your case, but I mean, just to aid in the detective work, by comparing results.
Yes, I did try UDF and it works. I actually went ahead with the UDF as the solution to this problem.
Thank you for your help.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham