Crystal Report with Count of Help Desk Issues 1

[dataman86]

I have created a Call Issue Program in VB that keeps track of call issues handled by each computer technician. The MainCallIssue table has these fields: ID. Issue, Resolution, ResolutionTime, Time, WorkOrder#, DateTimeAdded, UserAdded, DateTimeModified, User Modified, Status, and Comments.

I am trying to create a Crystal report showing the count of reports by each technician for a defined period of time. Where do I place a count to do this in the cr?

Do I count the Issues? Also, need a count of workorder#'s assigned to techncian

Anyhelp is appreciated.

Dataman86

 

[Turkbear]

Hi,
Several approaches but the simplest would be to Group on ID ( I assume that is the tech) and do a count of records in the details of the group. If there can be multiple work orders per issue then counting distinct issues may be what you want.







To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[dataman86]

Thank You.