Greetings,
My helpdesk has requested a real time report to see how many cases each
tech has closed. (Multiple names on one report) I have created the
fields necessary for this and am getting the data I need but where I run
into problems is with the Crystal report part of it. On the statistics
tab I could not find a distict count option, since all I really want to
do is a summary of the names and their ticket totals...

Any Ideas or workarounds are certainly appreciated...

Thanks,

Juan

_____________________________

Hi Juan,

I don't bother with Crystal for this. I run the search, export to a cvs
file, convert to Excel and then use the following formula
=COUNTIF(A2:A1400,"username")

At 03:19 PM 12/10/2001 -0600, you wrote:
>**
>
>Greetings,
>My helpdesk has requested a real time report to see how many cases each
>tech has closed. (Multiple names on one report) I have created the
>fields necessary for this and am getting the data I need but where I run
>into problems is with the Crystal report part of it. On the statistics
>tab I could not find a distict count option, since all I really want to
>do is a summary of the names and their ticket totals...
>
>Any Ideas or workarounds are certainly appreciated...
>
>Thanks,
>
>Juan
>
>_____________________________
>
>
>You may also control your subscription options, including UNSUBSCRIBE, at
>www.ARSLIST.org

>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
MARK BRITTAIN
Team Leader/Remedy Developer
Customer Support Center
AppliedTheory Corporation
800.727.0793

_____________________________

Hi Juan,

I would create a group on the name field and then put a count of the tickets
into the group as well. Then hiding the details section would ensure that
crystal only shows the name once with the count of tickets.

HTH

Sam

-----Original Message-----
From: Figueroa, Juan [mailto:Juan.Figueroa@ARCHONGROUP.COM]
Sent: Tuesday, 11 December 2001 10:20
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: Remedy Report/Distinct Count


**

Greetings,
My helpdesk has requested a real time report to see how many cases each
tech has closed. (Multiple names on one report) I have created the
fields necessary for this and am getting the data I need but where I run
into problems is with the Crystal report part of it. On the statistics
tab I could not find a distict count option, since all I really want to
do is a summary of the names and their ticket totals...

Any Ideas or workarounds are certainly appreciated...

Thanks,

Juan

________________
_____________


You may also control your subscription options, including UNSUBSCRIBE, at
www.ARSLIST.org

_____________________________

Hi, Juan,

If you still want to do it in Crystal, my colleague here did it by adding
another form and using direct sql to insert records to it mimicking what the
sql logs show for a Remedy CREATE. The direct SQL is a procedure that runs
a cursor: select field1, ... fieldn count(*) group by field1, ... fieldn.

In Crystal, create a subtotal on the count field and show it in the group
footer.

Jim.

-----Original Message-----
From: Mark Brittain [mailto:brittain@APPLIEDTHEORY.COM]
Sent: Monday, December 10, 2001 3:38 PM
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: Re: Remedy Report/Distinct Count


**

Hi Juan,

I don't bother with Crystal for this. I run the search, export to a cvs
file, convert to Excel and then use the following formula
=COUNTIF(A2:A1400,"username")

At 03:19 PM 12/10/2001 -0600, you wrote:
>**
>
>Greetings,
>My helpdesk has requested a real time report to see how many cases each
>tech has closed. (Multiple names on one report) I have created the
>fields necessary for this and am getting the data I need but where I run
>into problems is with the Crystal report part of it. On the statistics
>tab I could not find a distict count option, since all I really want to
>do is a summary of the names and their ticket totals...
>
>Any Ideas or workarounds are certainly appreciated...
>
>Thanks,
>
>Juan
>
>_______________
______________
>
>
>You may also control your subscription options, including UNSUBSCRIBE, at
>www.ARSLIST.org

>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
MARK BRITTAIN
Team Leader/Remedy Developer
Customer Support Center
AppliedTheory Corporation
800.727.0793

________________
_____________


You may also control your subscription options, including UNSUBSCRIBE, at
www.ARSLIST.org

_____________________________

On Mon, 10 Dec 2001 15:19:39 -0600, Figueroa, Juan
wrote:

>**
>
>Greetings,
>My helpdesk has requested a real time report to see how many cases each
>tech has closed. (Multiple names on one report) I have created the
>fields necessary for this and am getting the data I need but where I run
>into problems is with the Crystal report part of it. On the statistics
>tab I could not find a distict count option, since all I really want to
>do is a summary of the names and their ticket totals...
>
>Any Ideas or workarounds are certainly appreciated...
>
>Thanks,
>
>Juan
>
>_______________
______________
>

>You may also control your subscription options, including UNSUBSCRIBE, at
www.ARSLIST.org

Juan-

If you want to keep in in the Crystal-esque reporting tool:

On the Sort tab, select the name field (or whatever identifier you're using
for each person) and check the "Group on this field" box.

On the Statistics tab, you can leave the operation as "Count" but select
the field name you grouped on instead of "Report" in the "Compute On" field.

Angela Bourassa-Edwards
Specific Integration, Inc.

_____________________________