Re[2]: RB - Top 25 Sales Results

Mike,

I believe Ed, Todd and Mike L. were initially correct in that either
conditional printing or filtering on a pre-pass aggregate can show
the top 25.

If you don't mind uploading the report to the Report Builder "files"
section, I'm 99% positive I can get it to work in a few minutes.

Lonnie


> Subject: [Vantage] RB - Top 25 Sales Results
> Author: <vantage@y...>
> 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@a...
Mike,

Thank you.

Mike Tonoyan


----- Original Message -----
From: "Mike Lowe" <MLowe@...>
To: <vantage@yahoogroups.com>
Sent: Monday, January 14, 2002 11:00 AM
Subject: Re[2]: Re[2]: [Vantage] RB - Top 25 Sales Results


> Hi Mike,
>
> Sometimes yes I do use ODBC. However, more often I use Crystal against an
> Access database. I use the Vantage Export function to create some "table
dumps"
> in dbf format from each of my divisions running Vantage. I then
consolidate
> these into a single Access database so that I can run Connor consolidated
sales
> reports.
>
> We used to use ProVision to do something similar running RB against this
> Progress Consolidated Sales Database. However, I wanted to simplify the
process
> (make it not reliant on ProVision programming skills) so that I could
teach
> non-programmers how to update / maintain this process...and I also wanted
to
> utilize Crystal with its enhanced feature set instead of RB.
>
> A side benefit to using this Access database is that I have the
flexibility to
> add fields to these tables to make writing reports easier. This
sometimes
> negates the need to do certain joins or even utilize sub-reports.
>
> But, the short answer to your original question is - sometimes.
>
> Mike Lowe
> Corporate I.S. Manager
> Connor Manufacturing Services
> MLowe@...
> (909) 273-1282
>
> ____________________Reply Separator____________________
> Subject: Re: Re[2]: [Vantage] RB - Top 25 Sales Results
> Author: <vantage@yahoogroups.com>
> Date: 1/14/2002 10:13 AM
>
> Mike,
>
> Do you use ODBC driver with Crystal Reports to access the information?
>
> Mike Tonoyan / All American Products Co.
>
> ----- Original Message -----
> From: "Mike Lowe" <MLowe@...>
> To: <vantage@yahoogroups.com>
> Sent: Friday, January 11, 2002 4:50 PM
> Subject: Re[2]: [Vantage] RB - Top 25 Sales Results
>
>
> > Mike,
> >
> > Guess I should have actually opened RB. I became curious and tried to
get
> this
> > to work. Apparently the conditional printing doesn't work on an
> aggregated
> > grouped field. Sorry to lead you astray.
> >
> > This is one more reason to use Crystal. The TopN function is a built in
> > function. A couple clicks and you would have exactly what you want.
> >
> > Crystal has a MUCH more robust function set. Well worth the investment
in
> money
> > and time in training.
> >
> > My final 3 cents for the day...
> >
> > Mike Lowe
> > Connor
> >
> > ____________________Reply Separator____________________
> > Subject: Re: [Vantage] RB - Top 25 Sales Results
> > Author: <vantage@yahoogroups.com>
> > Date: 1/11/2002 3:35 PM
> >
> > 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/
> > >
> > >
> >
> >
> >
> > 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/
> >
> >
> >
> >
> >
> >
> > 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/
> >
> >
>
>
>
> 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/
>
>
>
>
>
>
> 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/
>
>