>>>
>>>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)
I will try your suggestion. But why do you use ntom() and mton()? Couldn't you just have
eval('max(d2-d1),0))?
"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