|
=iif(Parameters!exce.Value=1,iif((Fields!LIMIT_AMOUNT.Value-Fields!BILL_AMOUNT.Value)>0,0,(Fields!BILL_AMOUNT.Value-Fields!LIMIT_AMOUNT.Value))>0,iif((Fields!LIMIT_AMOUNT.Value-Fields!BILL_AMOUNT.Value)>0,0,(Fields!BILL_AMOUNT.Value-Fields!LIMIT_AMOUNT.Value))) this expression is giving an result as boolean like True or False, actually it should return suppose if the parameter exec value=1 then it should return all >0 values other wise it should return all the values.
(comments are locked)
|
Be the first one to answer this question
Can you please explain what you are trying to achieve? What does mean by "it should return all >0 values other wise it should return all the values"? You have to let us know whether it is a field expression, property expression etc?