How to tally up occurrences of date ranges

[lsantos]

Hi,

I am using CR v7 accessing an AIX/Informix database. My query is that follows:

I have 2 files: event (parent) and tasks (child). Each event is indexed by department and category. Each task as a "completion by date". I need to produce a (cross tab) summary report of outstanding tasks by date range. Therefore I need to compare each task "completion by date" with the (current or parameter) date and summarize totals as follows:

0-30days 31-60days 61-90days 91-120days
======== ========= ========= ==========
Dept1 / Cat1 10 5 2 1
Dept1 / Cat2 8 6 4 2
Dept5 / Cat1 2 1 2

Totals 20 12 8 3

Any suggestions??

Tx a lot

 

[dgillz]

Have a look at the functions Aged0to30Days, Aged31to60Days, Aged61to90Days, Over90days, Next30Days, Next31to60Days, Next61to90Days, and Next91to365Days.

There is ample documentation in the help files on these functions.

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

 

[lsantos]

dgillz,

Thanks for your message. I have come across those functions but I cannot figure out how to use them in this instance as the 0-30, 31-60, ... columns will be calculated on the fly for every event / task. so (as per my example above) every task will add 1 to the corresponding column (i.e. date range).

I thought I could define variables for every period range and increment when the condition is met. I was also looking into arrays and if I could define two-dimension arrays and load them while crystal reads through the files ....

I just don't know if I am on the right track and if crystal is able to format the information in such fashion. Maybe I have to write a program of some sort to achieve this…

Any crystal suggestion or examples I could use to bring some light into my dim thoughts??

Thank you very much.