thehollis
asked on
Combining group results in Reporting Services Part 2
I am creating a report that displays multiple demographics of employees who do or do not utilize direct deposit. One of the groups (UNION_CODE) returns 6 items: (NULL), Union1, Union2, Union3-Service, Union3-Skilled, Union3-Tech and then reports how many in each group has direct deposit, does not have direct deposit, or partially uses direct deposit.
I've been asked to combine the results to show only 3 groups:
1. Union1
2. Union3 (Service, Skilled, & Tech)
3. "Everyone else" ((NULL) and Union2)
Any ideas on how to do this either in the SQL query dataset or in the report layout (or anywhere else)?
I've been asked to combine the results to show only 3 groups:
1. Union1
2. Union3 (Service, Skilled, & Tech)
3. "Everyone else" ((NULL) and Union2)
Any ideas on how to do this either in the SQL query dataset or in the report layout (or anywhere else)?
SELECT EMPLOYEE, LAST_NAME, FIRST_NAME, DEPARTMENT,
PROCESS_LEVEL, TERM_DATE, SCHEDULE, EMP_STATUS,
UNION_CODE, "COALESCE"(AUTO_DEPOSIT, 'N')
AS AUTO_DEPOSIT
FROM LAWSON.EMPLOYEE
WHERE (TERM_DATE = '01-JAN-1700')
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER