Hello,

I have what seems like a simple issue. Yet, I cannot get my formula to show in the report. The header for this particular column is Gender. By default the report shows numbers representing the following - Male, Female, other or unknown.
I want the report to reflect the names that the numbers represent.
Here is my formula:
if {DDB_PAT_BASE.Gender}=1 then "Male"
else if {DDB_PAT_BASE.Gender}=2 then "Female"
else if {DDB_PAT_BASE.Gender}=3 then "Other"
else if {DDB_PAT_BASE.Gender}=4 then "Unknown"

I don't get any errors, but  the values don't change, they still show only the numbers in the report.

What am I doing wrong?

Is the table field numeric or string?

If it's numeric, add this to the top:

stringvar gender_string;

In the formula add:

gender_string = "male" instead of just "male". Same for "female", "other", "unknown"

Then at the bottom:

gender_string

Edited by hello - 27 Feb 2014 at 11:08am

The formula is not assigning a value, thus the := is not necessary.  I am still guessing that freekingeek just did not drop the formula on the sheet, still looking at the field.

You said you just renamed an existing report? So you haven't changed any of the report fields?

I think kevlray may be correct about the wrong field being in the report. Can you try just removing the field from the report and placing the formula field in its place?

stringvar gender_string;

if {DDB_PAT_BASE.Gender}=1 then gender_string := "Male"
else if {DDB_PAT_BASE.Gender}=2 then gender_string := "Female"
else if {DDB_PAT_BASE.Gender}=3 then gender_string := "Other"
else if {DDB_PAT_BASE.Gender}=4 then gender_string := "Unknown";

gender_string







PS:
I've never really been sure when to use the = or the :=
so I try it both ways.

Edited by hello - 28 Feb 2014 at 6:00am