I whould very much like to make a report (in Crystal reports) showing the number of open incident at any given time. For example per month
Open incident january 1th = XXX
Open incident february 1th = XXX
The report should show the history of open incident per month
I have tried to make a report myself my the problem is that, as I can see it, Crystal report is only showing an instant image - an image of how the status of the incident is right now.
I run a report in january and it showed that I have 270 open incident.
If I run the same report february 1th Some (50 incident) of the incident is closed in the meantime (the period between January 1th and February 1th)
Therefore the report will show 220 if I run the report February 1th. The problem is that the report that I ran Januar 1th also shows 220 open incident (because the status of the incident have changede)