Re: Distinct Counts

2007-04-03 Thread Kemes, Lisa
PROTECTED] On Behalf Of Axton Sent: Monday, April 02, 2007 6:56 PM To: arslist@ARSLIST.ORG Subject: Re: Distinct Counts Kind of off topic, but I had an rfe for this that was not considered (RFE0007086): http://arswiki.org/bugs/show_bug.cgi?id=16 Summary: Ability to perform grouping and aggregates - table

Re: Distinct Counts

2007-04-03 Thread Kemes, Lisa
IST.ORG Subject: Re: Distinct Counts ** Lisa, You can get counts ( distinct and totals) by sorting, grouping and using the statistics on the ARSystem report section of the user tool. To get a distinct list as a report do not select any fields. Go straight to the Sort tab and sort on your fiel

Re: Distinct Counts

2007-04-02 Thread Axton
liance. - paraphrased by me From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kemes, Lisa Sent: Monday, April 02, 2007 12:45 PM To: arslist@ARSLIST.ORG Subject: Distinct Counts ** A customer would like to run rep

Re: Distinct Counts

2007-04-02 Thread Reiser, John J
EMAIL PROTECTED] On Behalf Of Kemes, Lisa Sent: Monday, April 02, 2007 12:45 PM To: arslist@ARSLIST.ORG Subject: Distinct Counts ** A customer would like to run reports on his form that includes distinct counts. In SQL this is easy (Select Building, count(Area_Code) from PBX_COST_MASTER group by bui

Re: Distinct Counts

2007-04-02 Thread Joe D'Souza
Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Kemes, Lisa Sent: Monday, April 02, 2007 12:45 PM To: arslist@ARSLIST.ORG Subject: Distinct Counts ** A customer would like to run reports on his form that includes distinct counts. In SQL this is easy (Select

Re: Distinct Counts

2007-04-02 Thread Frank Caruso
Create a SQL View of the data and then create a Remedy View for the user On 4/2/07, Kemes, Lisa <[EMAIL PROTECTED]> wrote: ** A customer would like to run reports on his form that includes distinct counts. In SQL this is easy (Select Building, count(Area_Code) from PBX_COST_MASTER gr

Distinct Counts

2007-04-02 Thread Kemes, Lisa
A customer would like to run reports on his form that includes distinct counts. In SQL this is easy (Select Building, count(Area_Code) from PBX_COST_MASTER group by building). How can I get this data extracted from a Form in Remedy? We do not have Crystal Reports yet (would that help?) We are