I have an FDTable with an integer column which to the user must appear as a set of different strings in a grid. Example: 0 as 'Null', 1 as 'Open', 2 as 'Closed'. Etc.
For a simple column with only two possibilities I already set the CustomFormat property of the column to IfThen(%s = "0", 'No', 'Yes'). This works well, but when I tried to do the same for the said column before and set CustomFormat to IfThen(%s = "0", 'Null', IfThen(%s = "1", 'Open', 'Closed')) it doesn't work at all (FDTable throws an unnamed exception on activating). How do I accomplish what I've explained?