To answer an earlier question, I am not using an existing report. I created this report and I used a formula from another report that is using the same
"DDB_PAT_BASE" table.  

just as a note:
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

is missing the assignment operator...all the = should be :=

and as DBlank said, the gender field will always be the value from the database...only the formula will be different, because, again as stated, the data is not being changed, you are just changing how it is displayed with the formula

you need to place the formula on the report.

we realize that all you want to do is to display male instead of 1.

the logic that has been posted would seem to this, so if the formula has been placed on the report where you want to display it (which we assume you have done) and it is not displaying the correct results...then we have been giving suggestions on how to correct the logic or how to debug your logic.

it also sounded from one of the posts that you thought the formula would update the data in the field so that it would display as desired (male instead of 1), which is not the case.

just trying to help

Edited by lockwelle - 28 Feb 2014 at 8:35am