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';
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
THEN salary :='SALARY'
ELSE
if {XHR_SalaryHist.SalaryUnit
THEN salary :='Hourly'
ELSE
salary :='CONTRACTOR';
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Did you try the formula?
mlmcc
mlmcc
ASKER