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
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
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
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
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
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
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
7 matches
Mail list logo