I have a fcolum in my ssrs report that give me $ amounts. the problem is I only want to see the the fields that have $.01 dollars or greater it is now showing blanks and $0.00 in some of the fields I need tofilter this out in the expression statement can some on help me with this.
example
john doe | $102.00 | ( I need to keep this )
Jane doe | | ( I dont want this to show) This just shows a blank
Mark Doe | $0.00 | ( I dont want this to show)
Bill Doe | $200.00 | ( I want this)
my expression =FormatCurrency(Fields!MASRCAMOUNT.Value)
What do you want to show if the value is 0? Do the FormatCurrency only if the value is > 0. Something like this:
=IIF(convert.todecimal(Fields!MASRCAMOUNT.Value) > 0, FormatCurrency(Fields!MASRCAMOUNT.Value), '')
|||
I tried the expression but it is erroring sayin g it doesnt like the todecimal I get it underlined in red this is what I have.
IIF(convert.todecimal(FormatCurrency(Fields!MASRCVAMOUNT.Value) > 0, FormatCurrency(Fields!MASRCVAMOUNT.Value))
I t underlining the todecimal in red it there what do I do
|||IIF(convert.todecimal(FormatCurrency(Fields!MASRCVAMOUNT.Value) > 0, FormatCurrency(Fields!MASRCVAMOUNT.Value))
IIF(CDec(FormatCurrency(Fields!MASRCVAMOUNT.Value) > 0, FormatCurrency(Fields!MASRCVAMOUNT.Value)) I tried this also butr it doesnt work can some on help me.
|||Yeah Reporting Services is weird. Try this:
=IIF(CDec(Fields!MASRCAMOUNT.Value) > 0, FormatCurrency(Fields!MASRCAMOUNT.Value), '')
|||I tried the below but I keep getting error the , ") at the end highlight in red. I have tried removing the ," and just leaving )) this doesnt work either. any suggestions.
=IIF(CDec(Fields!MASRCAMOUNT.Value) > 0, FormatCurrency(Fields!MASRCAMOUNT.Value), '')
|||What do you want to show if the value is blank? It this good:
= IIF(CDec(Fields!MASRCAMOUNT.Value)>0, FormatCurrency(Fields!MASRCAMOUNT.Value), FormatCurrency(CDec(0)))
No comments:
Post a Comment