RB - Top 25 Sales Results

Todd,

I tried the way Mike Low and Ed advised, it didn't work for me.
Do you have a sample report that you could e-mail to me?
miket@...
I'd appreciate it.

Mike Tonoyan / All American Products Co.

----- Original Message -----
From: "Todd Caughey" <caugheyt@...>
To: <vantage@yahoogroups.com>
Sent: Friday, January 11, 2002 2:11 PM
Subject: RE: [Vantage] RB - Top 25 Sales Results


> I do exactly this both for "Top n" as well as selecting for over/under a
> dollar or margin threshold. Works well. I don't count but rather Total a
> field set to 1 at a given group level. Then set a field to true or false
> dependingon if the count (or rank) is above the cuttoff. This used for
the
> conditional on the band line.
> -Todd C.
>
> -----Original Message-----
> From: Mike Lowe [mailto:MLowe@...]
> Sent: Friday, January 11, 2002 3:35 PM
> To: vantage@yahoogroups.com; vantage@yahoogroups.com
> Subject: Re:[Vantage] RB - Top 25 Sales Results
>
>
> Ok, off the top of my head and not looking at Report Builder I think you
can
> create an aggregate field that will "count" group records. Place this in
> the
> group line and use a conditional print to suppress printing for everything
> greater than 25. Or only print for everything 25 and less. Can't
remember
> which way the logic works.
>
> Hope this helps...
>
> Mike Lowe
> Connor
>
> ____________________Reply Separator____________________
> Subject: [Vantage] RB - Top 25 Sales Results
> Author: <vantage@yahoogroups.com>
> Date: 1/11/2002 9:26 PM
>
> Hello everyone,
>
> I have a RB report that calculates and sorts the sales totals for the
> distributors in descending order. It's for determining the top 25
> distributors. Is there any way to print only top 25 customer totals
> instead of the entire list?
>
> Mike Tonoayn / MIS Manager
> All American Products Co.
> e-mail: miket@...
>
>
>
> 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/.
> <http://groups.yahoo.com/group/vantage/files/.>
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> <http://groups.yahoo.com/group/vantage/messages>
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/links
> <http://groups.yahoo.com/group/vantage/links>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
> <http://docs.yahoo.com/info/terms/>
>
>
>
>
>
>
> Yahoo! Groups Sponsor
>
> ADVERTISEMENT
>
>
<http://rd.yahoo.com/M=216105.1806326.3318126.1261774/D=egroupweb/S=17050071
>
83:HM/A=915130/R=0/O=1/I=brandr-lrec/postholidaygroup/*http://shopping.yahoo
> .com/domain?d=holiday&cf=posthol01>
>
>
<http://us.adserver.yahoo.com/l?M=216105.1806326.3318126.1261774/D=egroupmai
> l/S=1705007183:HM/A=915130/rand=793693474>
>
> 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/.
> <http://groups.yahoo.com/group/vantage/files/.>
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> <http://groups.yahoo.com/group/vantage/messages>
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/links
> <http://groups.yahoo.com/group/vantage/links>
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
> <http://docs.yahoo.com/info/terms/> .
>
>
>
>
> [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/links
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
Hello everyone,

I have a RB report that calculates and sorts the sales totals for the
distributors in descending order. It's for determining the top 25
distributors. Is there any way to print only top 25 customer totals
instead of the entire list?

Mike Tonoayn / MIS Manager
All American Products Co.
e-mail: miket@...
Hello everyone,

I have a RB report that produces top sales results for our
distributors. The report is sorted in descending order on total sales
figures. Is there any way to have RB to print up to 25 records
instead of the entire list?

Mike Tonoyan / MIS Manager
All American Products Co.
1135 Aviation Place
San Fernando, CA 91340-1460
Tel.: 818-361-0059 Ext.: 246
Fax: 818-898-2236
e-mail: miket@...
You could try creating an aggregate count that never resets and accumulates
every distributor, probably would have to be pre-pass. Then create a filter
for aggregate < 26. I've never tried it before but it seems like it could
work.


- Ed

-----Original Message-----
From: miket91326 [mailto:miket@...]
Sent: Friday, January 11, 2002 2:31 PM
To: vantage@yahoogroups.com
Subject: [Vantage] RB - Top 25 Sales Results


Hello everyone,

I have a RB report that produces top sales results for our
distributors. The report is sorted in descending order on total sales
figures. Is there any way to have RB to print up to 25 records
instead of the entire list?

Mike Tonoyan / MIS Manager
All American Products Co.
1135 Aviation Place
San Fernando, CA 91340-1460
Tel.: 818-361-0059 Ext.: 246
Fax: 818-898-2236
e-mail: miket@...



Yahoo! Groups Sponsor

ADVERTISEMENT

<http://rd.yahoo.com/M=215002.1818248.3328688.1261774/D=egroupweb/S=17050071
83:HM/A=847665/R=0/*http://ads.x10.com/?bHlhaG9vbW9uc3RlcjcuZGF0=1010784676%
3eM=215002.1818248.3328688.1261774/D=egroupweb/S=1705007183:HM/A=847665/R=1>


<http://us.adserver.yahoo.com/l?M=215002.1818248.3328688.1261774/D=egroupmai
l/S=1705007183:HM/A=847665/rand=950389965>

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/.
<http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages>
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links>

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]
I do exactly this both for "Top n" as well as selecting for over/under a
dollar or margin threshold. Works well. I don't count but rather Total a
field set to 1 at a given group level. Then set a field to true or false
dependingon if the count (or rank) is above the cuttoff. This used for the
conditional on the band line.
-Todd C.

-----Original Message-----
From: Mike Lowe [mailto:MLowe@...]
Sent: Friday, January 11, 2002 3:35 PM
To: vantage@yahoogroups.com; vantage@yahoogroups.com
Subject: Re:[Vantage] RB - Top 25 Sales Results


Ok, off the top of my head and not looking at Report Builder I think you can
create an aggregate field that will "count" group records. Place this in
the
group line and use a conditional print to suppress printing for everything
greater than 25. Or only print for everything 25 and less. Can't remember
which way the logic works.

Hope this helps...

Mike Lowe
Connor

____________________Reply Separator____________________
Subject: [Vantage] RB - Top 25 Sales Results
Author: <vantage@yahoogroups.com>
Date: 1/11/2002 9:26 PM

Hello everyone,

I have a RB report that calculates and sorts the sales totals for the
distributors in descending order. It's for determining the top 25
distributors. Is there any way to print only top 25 customer totals
instead of the entire list?

Mike Tonoayn / MIS Manager
All American Products Co.
e-mail: miket@...



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/.
<http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages>
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links>

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
<http://docs.yahoo.com/info/terms/>






Yahoo! Groups Sponsor

ADVERTISEMENT

<http://rd.yahoo.com/M=216105.1806326.3318126.1261774/D=egroupweb/S=17050071
83:HM/A=915130/R=0/O=1/I=brandr-lrec/postholidaygroup/*http://shopping.yahoo
.com/domain?d=holiday&cf=posthol01>

<http://us.adserver.yahoo.com/l?M=216105.1806326.3318126.1261774/D=egroupmai
l/S=1705007183:HM/A=915130/rand=793693474>

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/.
<http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages>
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links>

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]
Thank you all.

Mike Tonoyan


----- Original Message -----
From: "Todd Caughey" <caugheyt@...>
To: <vantage@yahoogroups.com>
Sent: Friday, January 11, 2002 2:11 PM
Subject: RE: [Vantage] RB - Top 25 Sales Results


> I do exactly this both for "Top n" as well as selecting for over/under a
> dollar or margin threshold. Works well. I don't count but rather Total a
> field set to 1 at a given group level. Then set a field to true or false
> dependingon if the count (or rank) is above the cuttoff. This used for
the
> conditional on the band line.
> -Todd C.
>
> -----Original Message-----
> From: Mike Lowe [mailto:MLowe@...]
> Sent: Friday, January 11, 2002 3:35 PM
> To: vantage@yahoogroups.com; vantage@yahoogroups.com
> Subject: Re:[Vantage] RB - Top 25 Sales Results
>
>
> Ok, off the top of my head and not looking at Report Builder I think you
can
> create an aggregate field that will "count" group records. Place this in
> the
> group line and use a conditional print to suppress printing for everything
> greater than 25. Or only print for everything 25 and less. Can't
remember
> which way the logic works.
>
> Hope this helps...
>
> Mike Lowe
> Connor
>
> ____________________Reply Separator____________________
> Subject: [Vantage] RB - Top 25 Sales Results
> Author: <vantage@yahoogroups.com>
> Date: 1/11/2002 9:26 PM
>
> Hello everyone,
>
> I have a RB report that calculates and sorts the sales totals for the
> distributors in descending order. It's for determining the top 25
> distributors. Is there any way to print only top 25 customer totals
> instead of the entire list?
>
> Mike Tonoayn / MIS Manager
> All American Products Co.
> e-mail: miket@...
>
>
>
> 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/.
> <http://groups.yahoo.com/group/vantage/files/.>
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> <http://groups.yahoo.com/group/vantage/messages>
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/links
> <http://groups.yahoo.com/group/vantage/links>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
> <http://docs.yahoo.com/info/terms/>
>
>
>
>
>
>
> Yahoo! Groups Sponsor
>
> ADVERTISEMENT
>
>
<http://rd.yahoo.com/M=216105.1806326.3318126.1261774/D=egroupweb/S=17050071
>
83:HM/A=915130/R=0/O=1/I=brandr-lrec/postholidaygroup/*http://shopping.yahoo
> .com/domain?d=holiday&cf=posthol01>
>
>
<http://us.adserver.yahoo.com/l?M=216105.1806326.3318126.1261774/D=egroupmai
> l/S=1705007183:HM/A=915130/rand=793693474>
>
> 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/.
> <http://groups.yahoo.com/group/vantage/files/.>
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> <http://groups.yahoo.com/group/vantage/messages>
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/links
> <http://groups.yahoo.com/group/vantage/links>
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
> <http://docs.yahoo.com/info/terms/> .
>
>
>
>
> [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/links
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>