Link to home
Start Free TrialLog in
Avatar of jvonhendy
jvonhendy

asked on

Crystal Reports 2008 blank space in output

I have two table employees and salary history. All employees are in the employees table that includes Salary, hourly and contractors. The only employees that have a record in the salary history table are salary and hourly.

My problem is this, I am trying to write a report that shows if the employee is hourly, salary or contractor. The following formula code works fine for all employees except the contractors. I get a blank space in the crystal report formula for the contractors. I have a default for contractors and I still get a blank space. Can somebody tell me how to overcome this problem.  I am SQL server 2008.
Select {XHR_SalaryHist.SalaryUnit}  
Case "BIWKLY": "SALARY"
Case "SALARY": "SALARY"
Case "ANNUAL": "SALARY"
Case "HR": "Hourly"
Default: "CONTRACTOR" ;


 (second version I tried)
stringvar salary := 'Contract';
if {XHR_SalaryHist.SalaryUnit} in ['BIWKLY', 'ANNUAL']
     THEN salary :='SALARY'
ELSE
    if  {XHR_SalaryHist.SalaryUnit} = 'HR'
        THEN salary :='Hourly'
ELSE
     salary :='CONTRACTOR';
ASKER CERTIFIED SOLUTION
Avatar of Mike McCracken
Mike McCracken

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of jvonhendy
jvonhendy

ASKER

there is no value for the contractors because the contractors are NOT in the salary history table.
Did you try the formula?

mlmcc