GROUPING AND CALCULATIONS 1

[elansienna]

Hello,

I need to design a report to capture, count and group by month the following:
backlog = incidents opened prior to the target month and still open.
new incidents = incidents opened during the target month.
closed incidents = incidents open before or during the target month and closed during the target month.
remaining open = incidents opened in the target month still open on the last day of the target month. Here is a report design:

Date Backlog New Closed Remaining
6/07 20 100 90 30
7/07 30 80 100 10

My dilemma, I use a open_time database field to group the records where it's grouping the records by the open date of the incident which looks okay initially until you find that this grouping leaves out the backlog count and those incidents that may have opened in one month, but closed two months down the road. There is also a close time of the incident which I couldn't use solely as it will not accurately capture new incidents and closed incidents. Does anyone have any thoughts or has developed a report such as this?

elansienna

 

[Madawc]

You can do a set of running totals, that count for when something opens in a month or closes in a month. SHow then as a 'mock-crosstab' in the report footer.

You can save a little time by doing a paste to a dummy report, changing the name and then pasting back.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[elansienna]

Thanks Madawc, I was leaning towards the running totals which I think is going to be my best bet.