The tool is similar to FASTR and WORLDWriter (on AS400) but it is more flexible and offers more option. The main purpose is to allow a user to create custom report that reads any data from any tables in JDE and presents it in a nice and usable form.

 FASTR for E1 documentation

The main features are described below:

• Unlimited number of user defined rows
• Possibility to define rows manually or on the fly by a SQL statement (for example show 1 row per each revenue account in Account Master), possibility to define a sequencing of the lines
• Unlimited number of user defined columns
• Cell override support (on a specific line and for a specific column a different calculation may be defined)
• reusable selections and sequencings (one definition of data selection can be reused by several reports)
• support for Periodbalance, YTDbalance and other special functions related to Account Balances
• each cell on the result PDF is calculated using a formula that uses setup of a row and a column with possible cell override, it may have type of string/number/date, it may have a special background color
• formulas support several functions such as IF (excel like), UDC (to read UDC description), NAME (to get current user's name), PN/FY/FROM/THRU (to get the period for which the report was run), TRANS (to translate a value) and more, it is also possible to refer values of any other rows / columns / cells
• possibility to export the calculated data from JDE to excel/word/Internet explorer including the proper formatting and colors of the fields
• performance optimization - the calculation is done in C function that was optimized for performance
• online or UBE calculation - user can calculate the report interactively or using a UBE (useful for more difficult and large reports)
• possibility to define user rights to read / update / execute the defined reports (by groups or by reports)
• reports/selections/sequencings may belong to groups (for example Finance / Assets / Invoices / Taxes etc.), the user rights may be also defined for the groups
• one report may be presented in several languages (all hardcoded texts can be translated)
• user defined constants (may be defined for each run of a report to influence the results)
• formatting of the calculated values has several advanced features such as rounding / presenting in thousands / padding with blanks or zeros / formatting of dates and more

A small example of just a few lines of demo data:

The red row and green column are calculated from other cells, the purple field has a cell override with a constant value.