Home » Categories » Solutions by Business Process » Profiler |
User-Defined Reports - Report Last X Records |
Article Number: 157 | Rating: Unrated | Last Updated: Tue, Jun 20, 2023 at 5:45 PM
|
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. |
Attachments
![]() There are no attachments for this article.
|
Index, Pick Items and File Linking
Viewed 1872 times since Thu, Jun 28, 2012
Extract Between Databases
Viewed 1486 times since Fri, Jun 29, 2012
D - Data Interchange
Viewed 1646 times since Thu, Jun 28, 2012
Copy Items Back to Lookup File (9902)
Viewed 1568 times since Fri, Jun 29, 2012
Constraints and Exceptions - EDI Order Processing
Viewed 2713 times since Thu, Jul 5, 2012
User Defined Report – Output to Excel
Viewed 926 times since Wed, Jun 13, 2012
ProFiler Applications List / Create New
Viewed 1592 times since Thu, Jun 28, 2012
Create D03 Menu for this Application
Viewed 1552 times since Thu, Jun 28, 2012
Report ‘List Records’ Options
Viewed 1353 times since Wed, Jun 13, 2012
Reports on EDI Orders - EDI Order Processing
Viewed 1508 times since Thu, Jul 5, 2012
|