Print Page | Close Window

aging report

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=3765
Printed Date: 01 May 2024 at 9:19pm


Topic: aging report
Posted By: latinlover
Subject: aging report
Date Posted: 21 Jul 2008 at 5:32pm
Hi everyone, this is my first post. sorry if i make any mistake.
 
i work in a service desk and i am trying to make a report.
The report will open and asks for a start and an end date. As a result of this report i should obtain how many incidents remained open each day within the specific period of time.
 
ex for one day only.
 
in this day i already had 15 opened tickets + 3 new tickets - 4 closed tickets.
at the end of the day i still have 14 opened incidents.
 
any clue on how to do this?
 
by the way, i am using CR 7.
 
thx, max. 
 


-------------
We are what we do day by day.
Therefore, excellence is not a fact, it is a habit. (aristoteles)


Replies:
Posted By: latinlover
Date Posted: 21 Jul 2008 at 6:40pm
i thought about something like this:
 
k=1
do while k<= difftotal
     dcounter=0
     do while not eof
           if @date<= open date and @cdate>open date then
               dcounter=dcounter+1
           endif
     enddo
     array dperiodo [k]=dcounter
     k=k+1
enddo
 
is it possible?
if yes. can i create a graph with this array?
 
thx, max


-------------
We are what we do day by day.
Therefore, excellence is not a fact, it is a habit. (aristoteles)

Posted By: hilfy
Date Posted: 22 Jul 2008 at 3:07pm
No, this is not possible.
 
What does your data look like?  (Tables and columns)
 
-Dell


-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics

Posted By: latinlover
Date Posted: 22 Jul 2008 at 4:43pm
hi dell, thx for your answer.
the table is what you would expect about incidents opened in a service desk.
 
incident # / open date / resolved date / state (open or closed) / closed date / description / analyst name / client name....
 
ex.
 
1 / 12-05-2008 / null / O / null / cant turn off computer / maxd / Robert coff
2 / 12-05-2008 / 13-05-2008 / C / 13-05-2008 / how to install prt drvr / maxd / malena sharapova
 
i hope this hlps.
thx, max


-------------
We are what we do day by day.
Therefore, excellence is not a fact, it is a habit. (aristoteles)

Posted By: hilfy
Date Posted: 23 Jul 2008 at 8:18am
This is actually a fairly simple filter to set up in the report.  It will look something like this:
 
{incident.open_date} = CurrentDate or
IsNull({incident.resolved_date}) or
{incident.resolved_date} = CurrentDate
 
If you have other conditions in your Selection Criteria, you MUST put parentheses around these three lines in order for it to work correctly.
 
-Dell
 


-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics

Posted By: latinlover
Date Posted: 03 Aug 2008 at 10:40pm
dell,
thx for your time and help.
your suggestion works for a specific day only. the problem is that CR reads the table only once when i really need to read the table as many times as per the range of dates.
anyway, i found a work-around:
create a store procedure to populate a new table with the results. Then i open CR using the values in the new table.
 
thx very much. max


-------------
We are what we do day by day.
Therefore, excellence is not a fact, it is a habit. (aristoteles)


Print Page | Close Window