How to use IIF function
We are trying to use the IIF function in a report, to set string contents as follows:
IIF([DatasetName."FieldName"]=1,'true','false')
this produces the error "Identifier expected" - what are we doing wrong?
Thanks
IIF([DatasetName."FieldName"]=1,'true','false')
this produces the error "Identifier expected" - what are we doing wrong?
Thanks
Comments
IIF([DatasetName."FieldName"]=1,'true','false') bad syntax
[IIF(<DatasetName."FieldName"> =1,'true','false')]