Use of IFF
I am using Fastreport in Delphi XE6/XE7 for a short time. Therefore I am not yet very expierienced with Fastreport.
Unfortunately not all the possibilities of Fastreport, like scripting, can be used in Fastreport in Delphi.
I am now trying to use all the possibilities that I have. I am having an problem with the use of IFF.
I have a databasefield 'Prod_Actief' of the dataset 'Prod' which is a boolean field.
In stead of displaying True of False in the report, I like to display 'Ja' and 'Nee', dutch for 'Yes' and ' No'.
I have put the following statement in the memo-field: => [IIF( vartostr(<Prod."Prod_Actief">) == "TRUE",'Ja','Nee')] <=
When I run the preview I get an error. An ')' is expected. (See included picture in file)
=> The following error(s) have occured:
Memo7: Error in Expression 'IIF( vartostr(<Prod."Prod_Actief">) ==
"TRUE",'Ja','Nee'): ')' expected <=
By the way: Does anyone a place where I can find a manual which describes short and clear all the functions Fastreport.
Unfortunately not all the possibilities of Fastreport, like scripting, can be used in Fastreport in Delphi.
I am now trying to use all the possibilities that I have. I am having an problem with the use of IFF.
I have a databasefield 'Prod_Actief' of the dataset 'Prod' which is a boolean field.
In stead of displaying True of False in the report, I like to display 'Ja' and 'Nee', dutch for 'Yes' and ' No'.
I have put the following statement in the memo-field: => [IIF( vartostr(<Prod."Prod_Actief">) == "TRUE",'Ja','Nee')] <=
When I run the preview I get an error. An ')' is expected. (See included picture in file)
=> The following error(s) have occured:
Memo7: Error in Expression 'IIF( vartostr(<Prod."Prod_Actief">) ==
"TRUE",'Ja','Nee'): ')' expected <=
By the way: Does anyone a place where I can find a manual which describes short and clear all the functions Fastreport.
Comments
[IIF( (vartostr(<Prod."Prod_Actief">) == "TRUE"),'Ja','Nee')]
when having problems with syntax try using fr's buily in exptession builder to help.
in designer window select the functions tab all the functions and their requirements are listed.
[IIF( <Prod."Prod_Actief">,'Ja','Nee')]
I have tried both:
[IIF( (2>5) == "TRUE"),'Ja','Nee')]
[iff ((1> 2) and (6<5)), 'TEXT1', 'Text4']
in Memo as well as system variable text.
I keep on getting the same error in expression
)' identifier expected
I have added extra parens as well as taken them away
Using XE3 and FR 4
What am I not seeing?
I believe that "==" is correct if you are using C++ script. If you are using PascalScript use "=" instead.
Have you tried it without the "and"? Im not sure if IIF supports "and" (logical or bitwise).