2 Replies Latest reply on Sep 28, 2015 9:13 AM by Dr4ke

    Report on Incident Assignments/Resolutions and Change Assignments/Completions

    Apprentice

      Hi all,

       

      I am trying to create a report to show all Incident Assignments/Resolutions and Change Assignments/Completions. For now I'm focusing on the Incident Assignments and I will progress as I get each bit working - so with that in mind, I have the following structure set-up.

       

      pm_process.pm_guid --> tps_audit_trail.tps_object_guid

      pm_process.pm_latest_assignment_gp_guid --> tps_group.tps_guid

      tps_audit_trail.tps_function_id --> md_business_function.md_guid

      md_business_function.md_class_type --> md_class_type.md_guid

       

      This gives me the following:

       

      Incident Reference, Business Function (e.g. 'Add Assignment'), Class Type (e.g. 'Incident') and the Latest Assignment Group.

       

      BUT I obviously want to see all of the assignments, so I change the links to be the following (adding in the top two links):

       

      pm_process_assignment.pm_process_guid --> pm_process.pm_guid

      pm_process_assignment.pm_group_guid --> tps_group.tps_guid

      pm_process.pm_guid --> tps_audit_trail.tps_object_guid

      tps_audit_trail.tps_function_id --> md_business_function.md_guid

      md_business_function.md_class_type --> md_class_type.md_guid

       

      Which gives me:

       

      Incident Reference, Business Function (e.g. 'Add Assignment'), Class Type (e.g. 'Incident') and the Assignment Group of that particular assignment

       

      Which is exactly what I want - so for Incident example 1234 I can see there were three assignments (Group1, Group2 and Group3) . However, because there have been three assignments it is tripling every entry in the report three times (and if there had been 4 assignments, it will quadruple them all). Does anybody have any setups that achieves my overall goal?

       

      If this isn't possible I'm going to need to resort to subreports....

       

      Thanks in advance,

      Si