when I run this report using the select case code below it tells me that every employee is of asian descent. Am I doing something wrong here?

Thank you in advance for your help!


//A    Asian
//B    African American
//F    Foreign National
//H    Hispanic
//I    Native American/Alaskan Native
//M    Middle Eastern
//O    Other
//P    Native Hawaiian or Pacific Islander
//T    Two or More Races
//Undefined    Undefined
//W    Caucasian

Select {CEthnicity.ethnicity}
    case "A"
    :"Asian"
    case "B"
    :"African American"
    case "F"
    :"Foreign National"
    case "H"
    :"Hispanic"
    case "I"
    :"Native American/Alaskan Native"
    case "M"
    :"Middle Eastern"
    case "O"
    :"Other"
    case "P"
    :"Native Hawaiian or Pacific Islander"
    case "T"
    :"Two or More Races"
    case "Undefined"
    :"Undefined"
    case "W"
    :"Caucasian"
    Default
    :"Undefined";

thank you for your quick reply. i tried removing the semi colon from the end of the code and still got the same result. i changed out the code completely and tried the "switch" statement and that is still giving me the same result.

it is returning data however it is telling me that every employee is Asian instead of going through the whole statement and showing their true ethnicity.

any thoughts? this is the current code from the report.

Switch(
  IsNull({CEthnicity.ethnicity}), 'Undefined',
    {CEthnicity.ethnicity} = 'A', 'Asian',
    {CEthnicity.ethnicity} = 'B', 'African American',
    {CEthnicity.ethnicity} = 'F', 'Foreign National',
    {CEthnicity.ethnicity} = 'H', 'Hispanic',
    {CEthnicity.ethnicity} = 'I', 'Native American/Alaskan Native',
    {CEthnicity.ethnicity} = 'M', 'Middle Eastern',
    {CEthnicity.ethnicity} = 'O', 'Other',
    {CEthnicity.ethnicity} = 'P', 'Native Hawaiian or Pacific Islander',
    {CEthnicity.ethnicity} = 'T', 'Two or More Races',
    {CEthnicity.ethnicity} = 'U', 'Undefined',
    {CEthnicity.ethnicity} = 'W', 'Caucasian',
  true, 'Undefined')

thank again dell, here is what i am getting returned when i just use {CEthnicity.ethnicity}

LastName	FirstName	Annual Salary	FT/PT
	Heflin Catherine A F
LastName	FirstName	Annual Salary	FT/PT
	Hill Justin A M
LastName	FirstName	Annual Salary	FT/PT
	Hill Natasha A F
LastName	FirstName	Annual Salary	FT/PT

The 'A' (Asian) is returning for every employee. so i'm assuming it's the actual database that is incorrect?  when i run this as a sql query it returns the correct data ie employees lastname, firstname and ethnicity.