Home » Categories » Solutions by Business Process » Profiler |
User-Defined Reports - *RECCOUNT Test Condition on $Record Control Block |
Article Number: 156 | Rating: Unrated | Last Updated: Tue, Jun 20, 2023 at 5:46 PM
|
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. |
Attachments
![]() There are no attachments for this article.
|
Application Menu Structure - EDI Order Processing
Viewed 1507 times since Thu, Jul 5, 2012
A3 Datafile Application Extra Data Items - EDI Order Processing
Viewed 1543 times since Thu, Jul 5, 2012
User Defined Report – Output to Excel
Viewed 911 times since Wed, Jun 13, 2012
Tradacoms ORDERS Messages - EDI Order Processing
Viewed 3115 times since Thu, Jul 5, 2012
Index, Pick Items and File Linking
Viewed 1839 times since Thu, Jun 28, 2012
Sales Ledger Extra Items - EDI Order Processing
Viewed 1498 times since Thu, Jul 5, 2012
Stock/Product File Extra Items - EDI Order Processing
Viewed 1529 times since Thu, Jul 5, 2012
User-Defined Reports - Report Last X Records
Viewed 1461 times since Mon, Jun 11, 2012
Set Application Password, Clear Application Password
Viewed 1538 times since Fri, Jun 29, 2012
Screen Actions - Additional F4-Select Options
Viewed 1570 times since Fri, Jun 8, 2012
|