Count Unique Orders in Crystal report based on UserDefined table

Thank you very much to all of you who replied. You guys saved me a ton of time. It works great with my test data at the moment.
Regards,
Uzma.

--- In vantage@yahoogroups.com, "Adele" <arbjorklund@...> wrote:
>
> Hi -
> once you have the field on your Crystal Report, Right click on the field. Click on Insert, click on summary, change sum to distinct count and save.
>
> --- In vantage@yahoogroups.com, "unackvi" <unackvi@> wrote:
> >
> > Hi all,
> > I have a crystal report based on a user defined table that lists Repair Order data for Part Numbers e.g. Part Number, Repair Order Number, Line Number, Qty etc.
> >
> > In the summary section I need to list the number of unique Repair Order Numbers listed in the report but I am almost clueless how to approach this. Conventionally if I had a Data Type 'Set'/'Array' I would loop through the records and add Repair Order Number to the set/array if already didn't exist until I reach the end.
> >
> > I would welcome any ideas to achieve the task.
> > Thanks in advance,
> > Uzma.
> >
>
Hi all,
I have a crystal report based on a user defined table that lists Repair Order data for Part Numbers e.g. Part Number, Repair Order Number, Line Number, Qty etc.

In the summary section I need to list the number of unique Repair Order Numbers listed in the report but I am almost clueless how to approach this. Conventionally if I had a Data Type 'Set'/'Array' I would loop through the records and add Repair Order Number to the set/array if already didn't exist until I reach the end.

I would welcome any ideas to achieve the task.
Thanks in advance,
Uzma.
Create a new "Running Total Field". Set the type to 'count' and you should
be all set.

On Fri, Jan 21, 2011 at 12:20 AM, unackvi <unackvi@...> wrote:

>
>
> Hi all,
> I have a crystal report based on a user defined table that lists Repair
> Order data for Part Numbers e.g. Part Number, Repair Order Number, Line
> Number, Qty etc.
>
> In the summary section I need to list the number of unique Repair Order
> Numbers listed in the report but I am almost clueless how to approach this.
> Conventionally if I had a Data Type 'Set'/'Array' I would loop through the
> records and add Repair Order Number to the set/array if already didn't exist
> until I reach the end.
>
> I would welcome any ideas to achieve the task.
> Thanks in advance,
> Uzma.
>
>
>


[Non-text portions of this message have been removed]
Make that "Distinct Count" if you want the number of unique order
numbers.

Chris

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Waffqle
Sent: Friday, January 21, 2011 6:56 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Count Unique Orders in Crystal report based on
UserDefined table

Create a new "Running Total Field". Set the type to 'count' and you
should
be all set.

On Fri, Jan 21, 2011 at 12:20 AM, unackvi <unackvi@...> wrote:

>
>
> Hi all,
> I have a crystal report based on a user defined table that lists
Repair
> Order data for Part Numbers e.g. Part Number, Repair Order Number,
Line
> Number, Qty etc.
>
> In the summary section I need to list the number of unique Repair
Order
> Numbers listed in the report but I am almost clueless how to approach
this.
> Conventionally if I had a Data Type 'Set'/'Array' I would loop through
the
> records and add Repair Order Number to the set/array if already didn't
exist
> until I reach the end.
>
> I would welcome any ideas to achieve the task.
> Thanks in advance,
> Uzma.
>
>
>


[Non-text portions of this message have been removed]



------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
You don't need a running total. Just insert a summary field, distinct
count, on the 'repair order number' field in your report, and add it to
the report footer section.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Chris Crosta
Sent: Friday, January 21, 2011 10:28 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Count Unique Orders in Crystal report based on
UserDefined table

Make that "Distinct Count" if you want the number of unique order
numbers.

Chris

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Waffqle
Sent: Friday, January 21, 2011 6:56 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Count Unique Orders in Crystal report based on
UserDefined table

Create a new "Running Total Field". Set the type to 'count' and you
should
be all set.

On Fri, Jan 21, 2011 at 12:20 AM, unackvi <unackvi@...> wrote:

>
>
> Hi all,
> I have a crystal report based on a user defined table that lists
Repair
> Order data for Part Numbers e.g. Part Number, Repair Order Number,
Line
> Number, Qty etc.
>
> In the summary section I need to list the number of unique Repair
Order
> Numbers listed in the report but I am almost clueless how to approach
this.
> Conventionally if I had a Data Type 'Set'/'Array' I would loop through
the
> records and add Repair Order Number to the set/array if already didn't
exist
> until I reach the end.
>
> I would welcome any ideas to achieve the task.
> Thanks in advance,
> Uzma.
>
>
>


[Non-text portions of this message have been removed]



------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links






------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
Hi -
once you have the field on your Crystal Report, Right click on the field. Click on Insert, click on summary, change sum to distinct count and save.

--- In vantage@yahoogroups.com, "unackvi" <unackvi@...> wrote:
>
> Hi all,
> I have a crystal report based on a user defined table that lists Repair Order data for Part Numbers e.g. Part Number, Repair Order Number, Line Number, Qty etc.
>
> In the summary section I need to list the number of unique Repair Order Numbers listed in the report but I am almost clueless how to approach this. Conventionally if I had a Data Type 'Set'/'Array' I would loop through the records and add Repair Order Number to the set/array if already didn't exist until I reach the end.
>
> I would welcome any ideas to achieve the task.
> Thanks in advance,
> Uzma.
>