9 Replies Latest reply on May 6, 2009 1:01 PM by Ian.Price

    Report on Incidents Opened and Incidents Resolved at the same time

    Rookie

      Hi,

      I'm looking to report on Incidents opened and Incidents resolved in the same crystal report, ideally a cross tab view with a graph, I can report on each of them individually but not together in the same crosstab. I have a view that pulls all incident details and relates then to resolution information. If I total pm_process.pm_guid and im_incident_resolution.im_guid I get the same value and was expecting im_incident_resolution.im_guid to bring back a different value.

       

      Any Ideas?

      Thanks

      Giovanni Vitale

      ITBM Administrator

      Whitbread Plc