CODEWITHSUNDEEP
sqlreporting-servicesreportbuilder3.0
whatwhatwhat
whatwhatwhat

Reputation: 2276

Report Builder returning "Expression expected" on a textbox

I'm confused, how is this not an expression? I get the error in the title using the expression below as a placeholder for a textbox.

=IF(COUNT(Fields!item.Value, "FGInputTest")=0,"Item and lot combination do not exist", First(Fields!item.Value, "FGInputTest"))

Upvotes: 0

Views: 97

Answers (1)

Paul Bambury
Paul Bambury

Reputation: 1312

The SSRS if statement is spelt 'Iif' not 'If'

Upvotes: 1

Related Questions