I have to create an aging report which docuware does not produce out of the box. So i am looking into the database and i want to know how i can create a report which tell me at any time how many documents are assigned to each user in the workflow. Also tell me for each document type how many documents falls in categories like 0-5 days, 6-10 days, 11-15 days, 16-20 days, 21-25 days, 26-30 days and over 30 days.See below to see an example of how i need the data back.
Which tables should in database will have Assign To (System variable) information.
|
Assigned To (Workflow)
|
Document Type
|
0-5 Days
|
6-10 days
|
11-15 days
|
16-30 days
|
21-25 days
|
26-30 days
|
Over 30 days
|
|
A
|
abc
|
1
|
|
|
|
|
|
1
|
|
A
|
def
|
|
1
|
3
|
|
2
|
|
|
|
B
|
abc
|
|
|
|
|
|
|
|
|
C
|
abc
|
1
|
|
1
|
|
|
|
|
