How to use IIF function in FastReports?

delphi delphi-xe8 fastreport
Wennie picture Wennie · Dec 31, 2015 · Viewed 12.1k times · Source

I have a field that contains an integer value (1 or 0 only), if the field contains 0 I want to print 'Male' in my report; if it's 1, then print 'Female'.

This is what I have done so far and it doesn't work:

[IIF(<ReportPersonal."civilStatus"> = 0, 'Male', 'Female')]

That code always prints 'Male' though the value of the civilStatus field is '1'.

Here is the Link to the report file

Advanced thanks to our experts.

Answer

Val Marinov picture Val Marinov · Jan 3, 2016

In MemoView "ReportPersonalcivilStatus" has : 

DisplayFormat.FormatStr="False,True" DisplayFormat.Kind="fkBoolean".

Try to set Memo - > Format to Text(no formating).

Related questions

Return the root directory of Delphi executable

I have a Delphi application executing and when I call GetCurrentDir the following returns: C:\dev\w32\2015\BCSLBDemo\Win32\Debug When I call ExtractFileDir(GetCurrentDir()) I receive the following: C:\dev\w32\2015\BCSLBDemo\Win32 What I desire is C:\dev\…

Read More
Incompatible types: 'PAnsiChar' and 'PWideChar'

I am very new in delphi XE8. I have this following code which is from my delphi version 6 and I want to run it in delphi XE8. 1. function UTF8ToStringLen(const src: PChar; const Len: Cardinal): widestring; 2. var 3. l: Integer; 4. …

Read More
Delphi Rest.JSON JsonToObject only works with f variables

I'm using Delphi XE8. I was just looking at the REST.Json ObjectToJsonString() and JsonToObject() calls. Mainly attempting to do something like this: How to convert an object to JSON and back with a single line of code I noticed …

Read More