IIF and other functions not working
I have an .FR3 file which from the preview-mode in the designer works perfectly.
When I preview the report from code, it hangs on the first Expression that uses IIF and says there is a syntax error.
the Report prepares and shows perfectly in the designer-preview-function but not via code.
myReport = new TfrxReport(Application);
myReport->LoadFromFile("reports\\fac.fr3",true);
myReport->ShowReport(true);
the above code seems correct to me, even tried with PrepareReport before showing it.
The error is as follows:
The following error(s) occured:
Memo14: error in Expression
[IIF(<ADOQuery1."erekost">=1,IIF(<ADOQuery1."TAAL">='N','Kost',IIF(<ADOQuery1."TAAL">='F','Co?»t','Cost')),IIF(<ADOQuery1."TAAL">='N','Ereloon',IIF(<ADOQuery1."TAAL">='F','Honoraire','Fee')))]
')' expected
please help
I'm using FastReport 3.21
When I preview the report from code, it hangs on the first Expression that uses IIF and says there is a syntax error.
the Report prepares and shows perfectly in the designer-preview-function but not via code.
myReport = new TfrxReport(Application);
myReport->LoadFromFile("reports\\fac.fr3",true);
myReport->ShowReport(true);
the above code seems correct to me, even tried with PrepareReport before showing it.
The error is as follows:
The following error(s) occured:
Memo14: error in Expression
[IIF(<ADOQuery1."erekost">=1,IIF(<ADOQuery1."TAAL">='N','Kost',IIF(<ADOQuery1."TAAL">='F','Co?»t','Cost')),IIF(<ADOQuery1."TAAL">='N','Ereloon',IIF(<ADOQuery1."TAAL">='F','Honoraire','Fee')))]
')' expected
please help
I'm using FastReport 3.21
Comments
I'm using 3.21 in BDS2006 now (cppbuilder in fact)