Home » Categories » Solutions by Business Process » Profiler

User-Defined Reports - *RECCOUNT Test Condition on $Record Control Block

Datafile Software

User-Defined Reports - *RECCOUNT Test Condition on $Record Control Block

One of the report types available on the ‘Databases on Desktop’ tools is a Top-10 report allowing you to list the Top 10 (or 50 / 100 etc.) customers based on turnover, the Top 10 selling stock lines and so on but this type of report has been difficult to achieve in ProFiler when you also want overall totals.

This new feature allows you to use the variable ‘*RECCOUNT’ on a test condition against a $RECORD control block to test the number of records reported.


On the above example the report lists on the Top 5 customers by yearly turnover (using the test condition of *RECCOUNT Less/Equal 5) but goes on to show the total turnover for all customers, a total turnover of the top five customers and what percentage of the total turnover that represents.

Custom Fields
  • Release ID: 6.3
Attachments Attachments
There are no attachments for this article.
Related Articles RSS Feed
Link to Company Constants Extra Payroll Data Items
Viewed 1863 times since Fri, May 27, 2016
Maintain Constants
Viewed 1429 times since Fri, Jun 29, 2012
F - Forms Maintenance
Viewed 1363 times since Thu, Jun 28, 2012
User Defined Report – Output to Excel
Viewed 893 times since Wed, Jun 13, 2012
G1 – Global Update to a Database
Viewed 786 times since Thu, Jun 28, 2012
Pre-Define Forms
Viewed 1418 times since Thu, Jun 28, 2012
Print Database Definition
Viewed 1716 times since Fri, Jun 29, 2012
Create D03 Menu for this Application
Viewed 1473 times since Thu, Jun 28, 2012
P – Program
Viewed 783 times since Fri, Jun 29, 2012
User-Defined Reports - Report Last X Records
Viewed 1430 times since Mon, Jun 11, 2012