3 Replies Latest reply on Jul 26, 2012 12:20 PM by dmshimself

    Historical Report

    Darren.Bradshaw Expert

      My Senior Manager is wanting a report that will show summarize which support team had an incident assigned to them at the end of that week at a given point in time.


      I am thinking of have a parameter field to input the end date then asking how many weeks I want to go back.


      So the report could show how many incidents each support team had open at the end of that week then I can the use this to plot it on a graph.


      So it could look something like this.



      Any help / advice would be great.

        • 1. Re: Historical Report

          You probably want to look at the optional MI module as it does exactly what you are after, graphs and all.  You give it some KPIS to calucalte and it stashed them away daily and allows you to rport on them.  The problem you might face otherwise is that crystal reports and queries give values at the point in time you run them.  Re-run the report later and the values will be different.  In general it's hard to look at an historical point in time with those tools.  It's not impossible, but sometimes hard work and you have to change the design to dump the values you want.  Or you run the query, export to excel, save and do the report from there

          • 2. Re: Historical Report
            Darren.Bradshaw Expert

            We are not licensed for the MI Module, so it would have to be a crystal report.


            I do have a stored procedure that was created when the system was installed thats does something like what I am after but not quite.

            • 3. Re: Historical Report

              I hope you can get it modified.  You could alwways mail yourself the results of running the query/report every day and build up a picture that way.