I need to compare the category used for logging an incident against the category used in the resolution
I am using Crystal (yes I know LD don't support Crystal), however I need to check that I am linking the correct tables and attributes
I have pulled through the im_incident_category through twice and attached one to im_incident.im_category_guid --> im_incident_category.im_guid
and have attached the other im_incident_resolution.im_category_guid --> im_incident_category_1.im_guid
However this is not working, when I pull the attribute onto the report it removes all records - can you help?
I have also created a new location category - I have pulled the usr_newlocationcode table onto the report and linked it im_incident.usr_newlocationcode --> usr_newlocationcode.usr_guid however when I go to the report it doesn't pull any fields through
I have also noticed that the attributes created in the usr_newlocationcode table are ubr_fullname