question

scarney avatar image
scarney asked

SSRS Expression

I am getting the following error when I change the expression to include additional value. I have added parenthesis in many places but can't figure it out. Any help is appreciated. [rsCompilerErrorInExpression] The Value expression for the textbox ‘textbox260’ contains an error: [BC30455] Argument not specified for parameter 'FalsePart' of 'Public Function IIf(Expression As Boolean, TruePart As Object, FalsePart As Object) As Object'. This expression works: =sum(cdec(iif(Fields!Call_Report_Code.Value = "1D " and Fields!Collateral_Code.Value = 918 and Fields!Payment_Code.Value > "1" , Fields!Query_Balance.Value, 0))) I get the error when I change to the following: =sum(cdec(iif(Fields!Call_Report_Code.Value = "1D " and Fields!Collateral_Code.Value = 918 or Fields!Collateral_Code.Value = 973 or Fields!Collateral_Code.Value = 974 and Fields!Payment_Code.Value > "1", Fields!Query_Balance.Value, 0)))
ssrsexpression
10 |1200

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

1 Answer

·
Usman Butt avatar image
Usman Butt answered
Have you tried this? sum(cdec(iif((Fields!Call_Report_Code.Value = "1D ") and ((Fields!Collateral_Code.Value = 918) or (Fields!Collateral_Code.Value = 973) or (Fields!Collateral_Code.Value = 974) ) and (Fields!Payment_Code.Value > "1"), Fields!Query_Balance.Value, 0)))
2 comments
10 |1200

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

scarney avatar image scarney commented ·
Thank you, that worked!
0 Likes 0 ·
Usman Butt avatar image Usman Butt commented ·
@scarney Can you please accept the answer if it helped. This will help the future users. Thanks.
0 Likes 0 ·

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.