>>
>>Dmitry,
>>
>>Suggestions - may be wrong, since I do not know SDT
>>
>>
>>(1)
>>select eval('max(d2-d1, 0)')
>>
>>(2) To get rid of the asterisks, force the field length
>>select ntom(eval('max(d2-d1, 0)')) from test
>>
>>works as well
>>select mton(eval('max(d2-d1, 0)')) from test
>>
>>and this also
>>select mton(eval('max(ntom(d2-d1), $0)')) from test
>>
>
>Gregory,
>
>In SDT I can only specify the calculated field expression. For example, DATE_FLD1 - DATE_FLD2, or IIF(something,choice1,choice2), etc. And I can't enter "select" in this expression. Because this expression will be used in the auto report generator with a SELECT statement. And as I found out, somehow the SELECT used by SFReports does not like the IIF() expression as even if I hard-code number 1 as a return choice from IIF(), the report shows a bunch of asterisks.
>
>Thank you for your suggestions.
Then, can you specify
mton(eval('max(ntom(d2-d1), $0)')) as the calculated field expression ?
Seems to me that the expression is fed into an sql statement (original error)
Gregory