I have a report which I wrote to display information from a SQL database.
The report displays the date that employees have accepted certain policies.
I need to extend the report so that no 'NULL' values are shown in the report.
instead, the report should show either 'NOT REQUIRED' or 'NOT ACCEPTED'
The logic is as follows:
IF the policy was applicable to this employee THEN return the date it was accepted
IF the date is NULL THEN return 'NOT ACCEPTED'
IF the policy is not applicable to this employee THEN return 'NOT APPLICABLE'
The way to define if a policy is applicable to a user is through another series of tables which list the policies applicable for a combination of;
the tables for this information are:
For each user, their properties (location, busArea, type) are stored in the 'Employee' table.
I have included:
-a copy of the database.
-a pdf of the report that is currently working
-the sql used for the current report
-the sql that I have put together so far in building the new report - however this is not working fully
Please let me know if further details are needed.