lkudsk
asked on
How to make a report showing the number of open incident at any given time
Hallo everybody,
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.
Example:
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)
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.
Example:
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)
Try this idea
Selection formula
IsNull({ClosedDateField}) OR {ClosedDateField} >= Date(2012,1,1)
Create formulas for each month
If {DateOpened} < Date(2012,1,1) AND {ClosedDateField} > Date(2012,1,1) then
1
Else
0
Similarly for each month.
You can then summarize the formulas to get the totals you want.
mlmcc
Selection formula
IsNull({ClosedDateField}) OR {ClosedDateField} >= Date(2012,1,1)
Create formulas for each month
If {DateOpened} < Date(2012,1,1) AND {ClosedDateField} > Date(2012,1,1) then
1
Else
0
Similarly for each month.
You can then summarize the formulas to get the totals you want.
mlmcc
ASKER
That is correct. I wil try your solution and get back to you as quick as possible
/Kudsk
/Kudsk
ASKER
Should the formula for Febryar be like this
If {probsummarym1.open.time} < Date(2012,1,2) AND {probsummarym1.close.time} > Date(2012,1,2) then
1
Else
0
I am not safe with how I make the dates
If {probsummarym1.open.time} < Date(2012,1,2) AND {probsummarym1.close.time}
1
Else
0
I am not safe with how I make the dates
ASKER
Do you want me to summarize Januar and Febraury to get how many incident open at Febraury 31st.?
ASKER
I have my repot here. I don't understand how to make it. Sorry
Would it be possible for you to make a soloution I can see?
thanks in advance
Antal--bne-sager-NU.rpt
Would it be possible for you to make a soloution I can see?
thanks in advance
Antal--bne-sager-NU.rpt
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Example on Jan 1st you have 200 incidents open
During January, you close 50 and open 20 new ones
Feb 1st shows 170 open incidents.
You want to run a report today to show the same results for Jan 1st and Feb 1st.
Is that correct?
mlmcc