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
Benefits of EDI
Viewed 1394 times since Thu, Jul 5, 2012
A2 Error Messages - EDI Order Processing
Viewed 1440 times since Thu, Jul 5, 2012
Extend Number of Menu Entries
Viewed 1529 times since Thu, Jun 28, 2012
Global Updates - Update Numeric Values to Y-Type Items
Viewed 1411 times since Tue, Jun 12, 2012
Revalidate Incoming Orders (incl prior) - EDI Order Processing
Viewed 1423 times since Thu, Jul 5, 2012
User-Defined Report - Multiple Email Output
Viewed 1504 times since Mon, Jun 11, 2012
G2 – Extract Records between Database Files
Viewed 837 times since Thu, Jun 28, 2012
T – Table Updating
Viewed 726 times since Fri, Jun 29, 2012
ProFiler Options Definition
Viewed 1309 times since Thu, Jun 28, 2012
Disk Utilities
Viewed 1334 times since Thu, Jun 28, 2012