SSRS Expression for IF, THEN ELSE

(0) Share

Report

Posted on by ALAhmed

916

I am adding this field(InventJournalTable.Posted) to query(InventJournalTransTransfer) in AOT .
and i am intergrating reports via SSRS and i need some assisstance with an expression.
Icreate new expression in ssrs report as bellow :

=IIF((First(Fields!Posted.Value, "InventJournalTransTransferDS")) = "Yes",
Labels!@SYS88326 + First(Fields!JournalPostedDate.Value, "InventJournalTransTransferEEDP"),
(Labels!@SYS88326 + Labels!@SYS137068))

What is the wrong ih this exression?

*This post is locked for comments

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

Luan Nguyen 689 on at

Like (0)

Report

=IIF(Fields!EmployeeID.Value>10,"Yes","No")

I think field InventJournalTable.Posted is enum,and value return will be integer.

Was this reply helpful? Yes No
Suggested answer

XB 1,875 on at

Like (0)

Report

Did you try something like =IIF((First(Fields!Posted.Value, "InventJournalTransTransferDS")) = 1,

Was this reply helpful? Yes No