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.
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/
>
>