Post Author: dkotenoglou
CA Forum: Formula
I use Crystal Reports XI to report on Customer Service Request
sent to the HelpDesk system.
One report I have developed is:
Amount of currently Open Requests followed by Average amount
of Days Open.
I did this by identifying all u201COpenu201D Requests and then do a
count of them.
I then calculate the amount of Days Open for that request
(Current Date u2013 Date Request was Open)
Finally I hide the Details.
So in effect the report looks like
Amount of Open Requests u2013 200
Average amount of Days Open u2013 9
Now I want to further develop this report. I still want counts and by Days Open, but I
want to group they by static Ranges.
Using the example above I would like it to look like
Amount of Open Request over 30 Days u2013 15
Amount of Open Requests between 5 u2013 30 Days u2013 90
Amount of Open Requests between 1 u2013 5 Days u2013 95
One thought I had wsa to use a Group and a formula for the
group, but I could not access my Date
Range formula in the
Group Window.
I thought about being cheap and running three subreports all
near each other so that it looks like it is one report, but I think that is
silly. There has to be a better way.