RB Select

Yahoo Archive
1
Along the way set a new field to be something like:
Top10Vendor = IIF(top10 = true,VendorTotal,0) so that it is zero if not a top 10 vendor.
Then aggregate on Top10Vendor into something maybe called TotalTop10Vendors - aggregated at Vendor and reset never. The zeros for non-top 10 vendors will not show in the total. Do a similar sum for all vendors if you want top 10 weight.

I'll send a PRL with a couple examples off-list.
-Todd C.

-----Original Message-----
From: Todd Hofert [mailto:thofert@...]
Sent: Friday, March 28, 2003 8:40 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] RB Select


That is perfect. Thanks for your help. I like what you are saying about the
grand total for top ten but I am not sure I understand how to pull that off.

Thanks again
Todd

-----Original Message-----
From: Todd Caughey [mailto:caugheyt@...]
Sent: Friday, March 28, 2003 9:15 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] RB Select


I usually do a count at the same level I am aggregating to (such as Vendor)
and then create a calculated field as a flag to test on and inhibit
printing the band. Such as Top10 = IIF(VendorCnt > 10,False,True) and only
print the band line if Top10 = True. You would need to also prepass
aggregate the sum by vendor and sort descending to rank them from top down.
Once in awhile RB gets really picky about sorting on aggregates but if the
rest of the report and sorting are simple it should be able to be done.

If you want a grand total for only the top 10 then you would need to set a
conditional field and sum on that. Usually I do both a conditional sum and
a total sum (such as all vendors) and at the end express the top n as a
percentage of the whole. Might be useful to know the top 10 vendors are X%
of payables.
-Todd C.

-----Original Message-----
From: Todd Hofert [mailto:thofert@...]
Sent: Friday, March 28, 2003 7:38 AM
To: Vantage List (E-mail)
Subject: [Vantage] RB Select


I have a report that calculates the SUM of APInvHed.InvoiceAmt by Vendor. I
would like to show only the top ten vendors. Can someone assist me with the
statement to select only the top ten vendor records?

Thanks
Todd Hofert



Yahoo! Groups Sponsor

ADVERTISEMENT

< http://rd.yahoo.com/M=245454.2994396.4323964.2848452/D=egroupweb/S=17050071
83:HM/A=1457554/R=0/* http://ipunda.com/clk/beibunmaisuiyuiwabei>

< http://us.adserver.yahoo.com/l?M=245454.2994396.4323964.2848452/D=egroupmai
l/S=:HM/A=1457554/rand=922002770>

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


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



Yahoo! Groups Sponsor
<http://rd.yahoo.com/M=245314.3072841.4397732.2848452/D=egroupweb/S=1705007183:HM/A=1495890/R=0/*http://www.netbizideas.com/yheb42>
<http://us.adserver.yahoo.com/l?M=245314.3072841.4397732.2848452/D=egroupmail/S=:HM/A=1495890/rand=911634891>

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 the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]
2
I have a report that calculates the SUM of APInvHed.InvoiceAmt by Vendor. I
would like to show only the top ten vendors. Can someone assist me with the
statement to select only the top ten vendor records?

Thanks
Todd Hofert
3
I usually do a count at the same level I am aggregating to (such as Vendor) and then create a calculated field as a flag to test on and inhibit printing the band. Such as Top10 = IIF(VendorCnt > 10,False,True) and only print the band line if Top10 = True. You would need to also prepass aggregate the sum by vendor and sort descending to rank them from top down. Once in awhile RB gets really picky about sorting on aggregates but if the rest of the report and sorting are simple it should be able to be done.

If you want a grand total for only the top 10 then you would need to set a conditional field and sum on that. Usually I do both a conditional sum and a total sum (such as all vendors) and at the end express the top n as a percentage of the whole. Might be useful to know the top 10 vendors are X% of payables.
-Todd C.

-----Original Message-----
From: Todd Hofert [mailto:thofert@...]
Sent: Friday, March 28, 2003 7:38 AM
To: Vantage List (E-mail)
Subject: [Vantage] RB Select


I have a report that calculates the SUM of APInvHed.InvoiceAmt by Vendor. I
would like to show only the top ten vendors. Can someone assist me with the
statement to select only the top ten vendor records?

Thanks
Todd Hofert



Yahoo! Groups Sponsor

ADVERTISEMENT
<http://rd.yahoo.com/M=245454.2994396.4323964.2848452/D=egroupweb/S=1705007183:HM/A=1457554/R=0/*http://ipunda.com/clk/beibunmaisuiyuiwabei>
<http://us.adserver.yahoo.com/l?M=245454.2994396.4323964.2848452/D=egroupmail/S=:HM/A=1457554/rand=922002770>

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 the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]
4
That is perfect. Thanks for your help. I like what you are saying about the
grand total for top ten but I am not sure I understand how to pull that off.

Thanks again
Todd

-----Original Message-----
From: Todd Caughey [mailto:caugheyt@...]
Sent: Friday, March 28, 2003 9:15 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] RB Select


I usually do a count at the same level I am aggregating to (such as Vendor)
and then create a calculated field as a flag to test on and inhibit
printing the band. Such as Top10 = IIF(VendorCnt > 10,False,True) and only
print the band line if Top10 = True. You would need to also prepass
aggregate the sum by vendor and sort descending to rank them from top down.
Once in awhile RB gets really picky about sorting on aggregates but if the
rest of the report and sorting are simple it should be able to be done.

If you want a grand total for only the top 10 then you would need to set a
conditional field and sum on that. Usually I do both a conditional sum and
a total sum (such as all vendors) and at the end express the top n as a
percentage of the whole. Might be useful to know the top 10 vendors are X%
of payables.
-Todd C.

-----Original Message-----
From: Todd Hofert [mailto:thofert@...]
Sent: Friday, March 28, 2003 7:38 AM
To: Vantage List (E-mail)
Subject: [Vantage] RB Select


I have a report that calculates the SUM of APInvHed.InvoiceAmt by Vendor. I
would like to show only the top ten vendors. Can someone assist me with the
statement to select only the top ten vendor records?

Thanks
Todd Hofert



Yahoo! Groups Sponsor

ADVERTISEMENT

<http://rd.yahoo.com/M=245454.2994396.4323964.2848452/D=egroupweb/S=17050071
83:HM/A=1457554/R=0/*http://ipunda.com/clk/beibunmaisuiyuiwabei>

<http://us.adserver.yahoo.com/l?M=245454.2994396.4323964.2848452/D=egroupmai
l/S=:HM/A=1457554/rand=922002770>

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


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