Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: Grouping Post Reply Post New Topic
Author Message
Willis
Newbie
Newbie


Joined: 11 Dec 2014
Location: United States
Online Status: Offline
Posts: 2
Quote Willis Replybullet Topic: Grouping
    Posted: 15 Dec 2014 at 7:45am
Hello everyone,

I am running a report on one of our ticket systems and I am grouping by technicians. When I run the report it comes back with a list sorted by the Tech's listing each of the tickets they worked.

Tech1 15978
Tech1 15999
Tech1 16069

Tech2 15987
Tech2 16033

Above is just an example. What I want is at the end of each of those for it to total up how many tickets each technician worked. Example:

Tech1 15978
Tech1 15999
Tech1 16069
Total 3

Tech2 15987
Tech2 16033
Total 2

Is this possible and if so can someone point me to where I can see how to do it by chance? I am using Crystal Reports 11.

Thank you!
Willis
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 15 Dec 2014 at 7:55am
use the insert summary function (blue E- sigma sign) and change it to a distinct count of the ticket_number field at the trechnician group.
basically creates a summary field the same as:
DistinctCOunt(table.ticketNo,table.technicianid)
IP IP Logged
Willis
Newbie
Newbie


Joined: 11 Dec 2014
Location: United States
Online Status: Offline
Posts: 2
Quote Willis Replybullet Posted: 15 Dec 2014 at 8:41am
Way cool! Just what I needed. Thank you DBlank!

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.031 seconds.