Changing Boolean to "Yes" or "No"

[JohnOB]

I am trying to recreate a report I have in CR 10 in Reporting Services, I am in BIDS trying to work out how I can have a boolean field which holds 1 or 0 to show as Yes or No, on Crystal reports I could jsut right click the field and choose this option, but I can't find a similar thing in Reporting Services.

Also I have another field which contains numbers and I would like the report to show "Yes" if the number is greater than 0 and "no" if it equals Zero, and again can't work out how to do this, am trying to use the expression builder but to no avail.

Any help or advice greatly appreciated.

Thanks

"Stupid isn't not knowing the answer, it's not asking the question

 

[xlbo]

=IIF(Fields!FieldName.Value = 1,"Yes","No")

=IIF(Fields!FieldName.Value > 0,"Yes","No")



Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question