How to Get Count by using DistinctCount

[mischief911]

I am trying to create a report that lists the Top 20 Users with the most Help Desk Tickets, then break that number into # of Open and # of Closed Tickets. I am unable to get distinctcount or count to give me a simple aggregate number
(i.e. Count of Help desk Tickets by Userid, count of Help Desk Tickets by Userid where Closedate is Null etc) using a formula. I realize this is pretty basic stuff but I am stumped can anyone shed any light on this?

Thanks in Advance for your Assistance

 

[Roadkill150]

Have you tried grouping based on userid? then placing subtotals in the group footers. This could then be used through the topN expert to give you the top 20 users. Seagate Certified RCAD Specialist.
-Bruce Thuel-Chassaigne
roadkill150@hotmail.com

 

[kenhamady]

How do you distinguish open from closed? Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com

 

[mischief911]

I was able to get a Count of Total Help Desk tickets by userid using this formula:

DistinctCount({Change_Order.chg_ref_num},{Change_Order.requestor})

where requestor = userid and chg_ref_num = TicketNo

But I have not been able to get the count of the Closed tickets to work. I am checking to see if the ticket closed date is not null as to whether the ticketNo should be included in the count.

If(Not IsNUll({Change_Order.close_date})) Then DistinctCount({Change_Order.chg_ref_num},{Change_Order.requestor})

 

[kenhamady]

Use a running total field that does a distinct count of requestor, and for the evaluate condition formula use:

Not IsNull( {Change_Order.close_date}) ) Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com