I am trying to write a report that will show if an Incident is either a Parent or Child of another Incidnet. I have identified that the relationship is stored under im_incident_incident.
However when using this data on a Crystal Report only the child Incidnets are displayed beacuse that is the only data returned from the (im_incident_incident) table. (I have linked pm_process.pm_id to im_incident_incident.im_child_id).
I need to show all Incidnets including those with a parent / child relationship.
How can I achive this with Crystal?