Home » Categories » Solutions by Business Process » Profiler

User-Defined Reports - Report Last X Records

Datafile Software

User-Defined Reports - Report Last X Records

The amount of data held within the databases increases over time particularly on files such as your sales transaction or sales order files. As file sizes increase reports can take longer to run and give you the required information; depending on the reporting requirement reviewing the full history may not be necessary.

In a sales environment a common requirement is to show the last five/ten sales taken as a motivational and information tool and you would list this information from the sales transaction file. However, the sales transaction file can include transactions and analysis for several years and, in this example, you only need to review the last 200 or so transaction records to obtain this information. This new feature allows you to set a ‘Last Record’ counter so that only the last n records in the file are processed when running the report potentially increasing the speed of the report dramatically.


Within the General Parameters of the User-Defined Report configuration a new parameter has been added to the ‘Slots’ facility to report on the last n (1-999) records.

Custom Fields
  • Release ID: 6.3
Attachments Attachments
There are no attachments for this article.
Related Articles RSS Feed
Create New Database
Viewed 2525 times since Fri, Jun 29, 2012
X – Custom Point (if applicable)
Viewed 848 times since Fri, Jun 29, 2012
G8 - Organise Pointers
Viewed 1661 times since Thu, Jun 28, 2012
User-Defined Reports - Update Excel Spreadsheet from Accumulators
Viewed 15507 times since Mon, Jun 11, 2012
User-Defined Reports - Print Images
Viewed 1727 times since Mon, Jun 11, 2012
Configuration - Defining the Ledger Link
Viewed 1764 times since Fri, Jun 29, 2012
Location of Files / Expand Settings
Viewed 1679 times since Thu, Jun 28, 2012
S Screen Actions
Viewed 1699 times since Fri, Jun 29, 2012
Application Profiles
Viewed 1589 times since Thu, Jun 28, 2012
Copy Items from Lookup Databases (9901)
Viewed 1777 times since Fri, Jun 29, 2012