Active TopicsMemberlistSearchHelpRegisterLogin

Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: aging report Post Reply Post New Topic
Author Message
latinlover
Newbie
Newbie
Avatar

Joined: 21 Jul 2008
Location: Australia
Online Status: Offline
Posts: 6
Quote latinlover Replybullet Topic: aging report
    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)
IP IP Logged
latinlover
Newbie
Newbie
Avatar

Joined: 21 Jul 2008
Location: Australia
Online Status: Offline
Posts: 6
Quote latinlover Replybullet 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


Edited by latinlover - 21 Jul 2008 at 6:41pm
We are what we do day by day.
Therefore, excellence is not a fact, it is a habit. (aristoteles)
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3701
Quote hilfy Replybullet 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
www.protiviti.com/US-en/data-management-advanced-analytics
IP IP Logged
latinlover
Newbie
Newbie
Avatar

Joined: 21 Jul 2008
Location: Australia
Online Status: Offline
Posts: 6
Quote latinlover Replybullet 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)
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3701
Quote hilfy Replybullet 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
www.protiviti.com/US-en/data-management-advanced-analytics
IP IP Logged
latinlover
Newbie
Newbie
Avatar

Joined: 21 Jul 2008
Location: Australia
Online Status: Offline
Posts: 6
Quote latinlover Replybullet 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)
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump 		You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.030 seconds.
HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | CLICK PLAYS | COACH FORUMS | TROPICAL FISH

© 2004-2024 Brian Bischof. All Rights Reserved.