Hello. I have an access report that I need to emulate in reporting services. Here is what I am working on
=IIf ((Fields!SEQUEN CE_NO.Value =10, "20"," (" & Fields!EQUENCE_ NO.Value & ")")+ 10), "")

I need the value in the sequence_id feild if it is equal to 10 to be displayed in my report as 20 or stay the same