question

gajendra avatar image
gajendra asked

Multiple IIF candition in ssrs report


Now I am working on a project where I have to show the dynamic value of after decimal place if user selection contain
"C"(Like 333) then report record show in round else show in one decimal place(like 333.7) and if the value of the report having the value "-1700" then report value show "open" and report value if have the value"32000" then report value show "Close"

I have tried

=iif(
InStr(Parameters!Tag1.Value, "RTD") > 0,

FormatNumber(CDbl(Fields!TagName1.Value= -7000 ),1,iif((Fields!TagName1.Value= 32000 "open","close"),

,FormatNumber(Round(Fields!TagName1.Value),0)))

but it is showing error

ssrsiif
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

· Write an Answer

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.