Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations dencom on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Help with summarizing or totaling

Status
Not open for further replies.

The8thWonderJS

IS-IT--Management
Oct 28, 2005
9
US
Hi,
I am using crystal V9. I have a report that shows how many help desk tickets are closed in a day, the priority of the ticket, and the resolution. There are two groups the first group is by the tech then inside that group it is grouped by day. It looks Like this.

Joe Johnson
12/12/2005
556540 Low Reset Proxy settings for user
542365 Medium Reloaded Right fax application
532511 Low Reset Password

12/13/2005
368541 High Removed virus from users system
514788 Low Reset Password

I am trying to total the number of low, the toatl number of medium, and the toal high priority tickets, in the header of the report, but the total is showing up for all of the technitions when I just want one technicians total. If I put the total in the group header then it gives me what I want but I can't have it there.

the field data for ticket number is:{HPD_HelpDesk.Case_ID_}
Ticket Priority: {HPD_HelpDesk.Priority}
Technician: {HPD_HelpDesk.Assigned_To_Individual_}

any help would be great. I will try and help others out on this forum although I am no expert with Crystal.
 
Are you talking about a summary in the report header? You have to be specific, as "header" could mean report, page, or group header. If you mean the report header, and you want a summary by technician by priority regardless of days, then insert a crosstab where you use technician and priority as row fields, and count of caseID as the summary.

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top