Looking to create AGING report based on # of Transaction each month.

[thi123]

I’m looking to create an aging report calculating the number of transaction that was completed between dates based on the following field:

Field Description
end date
# of days compl
from Odr days to Frm comp
Frm comp to Instr
Instr comp to installe
Prod install to tested
frm comp 11/11/02 73 73
instr comp 3/28/03 137 137
installed 6/24/03 88 88
tested - 0

frm comp 11/12/03 12 12
instr comp 1/2/04 51 51
installed 1/12/04 10 10
tested 1/21/04 9 9

frm comp 10/28/02 143 143
instr comp 1/23/03 87 87
installed 2/10/03 18 18
tested 5/30/03 109 109
Note: Combination of the fields I used:
Frm comp = Frm rec’d + Frm comp
Instr comp = Instr comp + Instr sign-off
Installed = installed + tested

What I need to accomplish is to count the transaction each month that have less than 10 days, 10-20 days, 20-44 days..etc…

YR 2002 < 10 days 10-20 days 20-44 days 45-59 days >60 days >90 days >120 days
Jan 0 0 0
Feb 0
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec

Based on the result at the top, I should have 1 transaction in Oct 2002 # of days greater than 120 days & 1 on Nov 2002.

And do the same for year 2003, 2004.
Is there an easy way to do this? Below is the formula I used to test but this did not work.

if {table.T$DESC} = "Frm Comp" or
{table.T$DESC} = " Frm Rec’d"
and {@#of days compl} < "10"
then 1 else 0

Sorry, this is long. Hope you understand what I am trying to explain.

 

[synapsevampire]

The number of transactions for each date, or from the beginning to the end of some process, or?

The post didn't format out well, and the description isn't very clear, which might explain the limited responses.

The formula shows "{table.T$DESC} = " Frm Rec’d"" yet the data doesn't show it as a possibility, further confusing things.

Try posting basic inofrmation:

Crystal version
Database/connectivity used
Example data (clear examples of the field names and data in a row, skip fields not used)
Expected Output (based on the example data)

If you want the number of days between 2 successive rows, use:

datediff("d", previous({table.date}),{table.date})

To test for specific ranges, try:

if datediff("d", previous({table.date}),{table.date}) < 11 then...

Just guessing that they're in successive rows though, you need to define the tables, not show your current report values.

-k