Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: While Do Loop Query Post Reply Post New Topic
Author Message
SwindonYid
Newbie
Newbie
Avatar

Joined: 26 Jan 2010
Location: United Kingdom
Online Status: Offline
Posts: 7
Quote SwindonYid Replybullet Topic: While Do Loop Query
    Posted: 11 Apr 2011 at 12:41am
hi,
 
I'm struggling with what is probably a simple thing to do......
 
I have a call logging database when I need to create a report that shows calls opened and closed by user. A call can be opened by any member of a team but may be closed by someone else. All I am wanting to do is a count of calls opened and a count of calls closed by each team member.
 
I've tried the following...
 
Local NumberVar a:=0;
while {Incident.Status Description:}="Closed" do
(
a :=a+1
);
a
 
IP IP Logged
comatt1
Senior Member
Senior Member
Avatar

Joined: 19 May 2011
Online Status: Offline
Posts: 337
Quote comatt1 Replybullet Posted: 19 May 2011 at 10:18am
are you summarizing the count like
Col1        - Col2
User name - total closed incidents

If this is the case, grouping and running totals would probably work best, however, I may be missing the point
IP IP Logged
SwindonYid
Newbie
Newbie
Avatar

Joined: 26 Jan 2010
Location: United Kingdom
Online Status: Offline
Posts: 7
Quote SwindonYid Replybullet Posted: 19 May 2011 at 9:08pm
Exactly that........ Any pointers?
IP IP Logged
comatt1
Senior Member
Senior Member
Avatar

Joined: 19 May 2011
Online Status: Offline
Posts: 337
Quote comatt1 Replybullet Posted: 25 May 2011 at 5:50am
if this hasnt been answered,

group by - user name

create running total-
summarize (count a key field, really wont) matter.
evaluate (use a formula and the expression should be {Incident.Status Description:}="Closed")
reset (on change of group)
IP IP Logged
SwindonYid
Newbie
Newbie
Avatar

Joined: 26 Jan 2010
Location: United Kingdom
Online Status: Offline
Posts: 7
Quote SwindonYid Replybullet Posted: 25 May 2011 at 9:18pm
Many thanks all, much appreciated.
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.023 seconds.