Skip to Content
0
Former Member
Jan 16, 2008 at 06:14 PM

Group Records by Ranges...

14 Views

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.