[Report Builder] Limiting Records count

Yahoo Archive
1
One way would be to create an agragate count of customers (count at customer
group, reset never) and then create a function field to be true or false
depending on whether the count is <= your limit (20). Then supress printing
of all lines not qualifying (true in the function). You still read all the
data but don't see what you don't want. Be careful of any whole report
summary which will include non-suppressed data. You need to summ on a
conditionaly set value. You will also need to pre-pass agregate. I have a
ranked sales report (based on invoices) that shows the top x customers
ranked from highest to lowest and then shows totals for everyone else and
the grand total.

-Todd Caughey
Harvey Vogel Mfg. Co.

-----Original Message-----
From: Darren Mann [mailto:dmann@...]
Sent: Wednesday, September 12, 2001 3:08 PM
To: Vantage User Group (E-mail)
Subject: [Vantage] [Report Builder] Limiting Records count


I am wanting to limit the number of records included on my report. The
report is a listing of customers sales totals and I would like only the top
20 customers included in the report. Can someone explain how I can
accomplish this?


Thanks,

Darren Mann
Miller Products Co.


Yahoo! Groups Sponsor

<http://rd.yahoo.com/M=207641.1594108.3142424.1269402/D=egroupweb/S=17050071
83:HM/A=765263/R=0/*http://www.verisign.com/cgi-bin/go.cgi?a=b15334027000300
0>

<http://us.adserver.yahoo.com/l?M=207641.1594108.3142424.1269402/D=egroupmai
l/S=1705007183:HM/A=765263/rand=357303235>

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]
2
I am wanting to limit the number of records included on my report. The
report is a listing of customers sales totals and I would like only the top
20 customers included in the report. Can someone explain how I can
accomplish this?


Thanks,

Darren Mann
Miller Products Co.
3
At 04:07 PM 9/12/2001 , you wrote:
>I am wanting to limit the number of records included on my report. The
>report is a listing of customers sales totals and I would like only the top
>20 customers included in the report. Can someone explain how I can

I think you can do it with RecordNumber() in a calculated field. I think
it's calculated after the sorting, so if you had a pre-pass aggregate for
the customer sort, you could probably filter directly on it. It not, you
could try a conditional print / suppress on the record lines using it.

-Wayne