If then Else.....How to 1

[btamulis]

Newbie to SRS.........

Need to basically create a field on my report. I want the field to contain a string 'Yes' or 'No' based upon the numeric value of a field.

I tried as follows: (Added this expression to a text box on report)

=iif(Fields!QtyReceivedSoFar.Value)> 0, "Yes",
iif(Fields!QtyReceivedSoFar.Value)<= 0, "No"

My dataset has field QtyReceivedSoFar - if value = '0' then I want "No" if > 0 then "Yes".

In Crystal I would use if then else........How do I do this in SRS....?

Other posting seem to suggest I could create a function - which kind of makes sense - but I couldn't find anywhere that I could create a custom function for my report.....

Thanks in advance for any assistance.....

Bron Tamulis, CPIM
Great Plains Mfg Consultant

 

[RiverGuy]

=iif(Fields!QtyReceivedSoFar.Value > 0, "Yes", "No")

 

[btamulis]

Worked like a champ.......

Thanks,
Bron

Bron Tamulis, CPIM
Great Plains Mfg Consultant