Hi,

I do have a problems on this formula,

I have a formula field call "confirm", in side I put this

if ({?stdconfirm}) = 'Null'
then ToText ("SI - Non Confirm")
else If ({?stdconfirm}) = 'ALL'
then ToText ("SI - Confirm & Not Confirm")
else ToText ("SI - Confirm")

In the Selection Formula I put this

(
if {?stdconfirm} ='NULL'
then (isnull ({SI.DateConfirm}))
else
    if {?stdconfirm} ='ALL'
     then (isnull ({SI.DateConfirm})) and (not isnull ({SI.DateConfirm}))
    else
        if{?stdconfirm} <>'NULL'
        then (not isnull ({SI.DateConfirm}))
          else
          false
)

My result only shown "Null" and <>"Null" output. For "All" is did not appear.

Can anyone help me to solve this issue?
My dateconfirm field is datetime and allow null in the database table

Thanks a lot for the help

Regards,
shiloh

Hi Dblank,

Thanks for your help

The report work prefect now.

Thanks a lot