Friday, March 9, 2012

Expression help needed with filtering

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