Symptoms

When reporting on the incident_task table, the user may want to show the Parent Incident related to the Task record. When the Column Parent.Number is used the user will see (empty) in the field.

Cause

The report will need to pull from the Incident Number field and not the Parent Number field

Resolution

Add the Column Incident.Number and remove the Parent.Number