Hi everyone, I currently have an Aged HT report that puts counts in the standard Aged buckets that Crystal provides. Works great as you would expect. Now I have a request to create a report that covers only 30 days but has a series of 5 day buckets, i.e. 0-5 days, 6-10 days, 11-15 days, etc. Of course those buckets don't exist in Crystal.
I'm not the greatest on formulas and I've been trying to get my arms around what the formula would be but I guess I just don't get it. I don't want to have to put actual dates in. So basically a bucket represents the number of open tickets and counting how many of them have been open 0,1,2,3,4 and 5 days for the first bucket. So I guess on each row I need to calculate how many days the ticket has been open. So would that formula be Today - Date Submitted with the result in days. So you would end up with a number on each row representing how many days it's been open. Hopefully this is valid thinking so far. So how do I get it to count all the 0,1,2,3,4 and 5's at one time to get the bucket value? I think grouping would be involved but I don't know how to define that. The report in general represents the last 30 days and I think there is a date range parameter I can choose for that to define the selection of records. I've looked at the Crystal support site and find some info on Aged but if it's telling me how to do this I'm not grasping it. I really need help in simple, basic terms. I've been working on these off and on for days and have a little brain scarring occurring so please be gentle. Appreciate your help in advance .... could be worth a drink(s) at RUG ... I can bring cheese too! Thanks, Susan Crystal 9 ARS 5.1.2 soon to be 7.0.1P2 Oracle 9i soon to be 10g Yes my Crystal 9 reports are working on the new versions. No Crystal server Use CrystalDesk Scheduler PRO9 and love it _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
