Manage-2000 Reporting - Brightlight Solutions
Download
Report
Transcript Manage-2000 Reporting - Brightlight Solutions
Manage-2000 Reporting
The different methods compared.
The Reporting Methods
REPORT.BUILD
IEP
Source Code
ODBC
Intro - REPORT.BUILD
Advantages
Simple, easy to use.
GUI Interface (IF EOT is enabled)
Uses EOT Viewer for output.
Allows user to copy data to external sources
Allows user to change sort on the fly.
Allows user to format report (In EOT Viewer)
Intro - REPORT.BUILD
Disadvantages
Can only select data from one source
UniData file.
Can not do calculations on the fly (Without an I
DESC defined in the dictionary)
No real control over the printer when
sending the output directly to a printer
device.
Can not do advanced subtotal header or
footer lines in report output.
Intro - IEP
Advantages
Can select from multiple files (As defined in
DICT.BUILD)
Can do ‘on the fly’ I-DESC or Calculations
Complete control over printed output.
Headers / Footers
Decimal Precision (Data has 4 decimals, you
only want to see 2 decimals)
Formatting (“$” “,” “-”)
Can export to PC text files.
Intro - IEP
Disadvantages
More difficult to use than REPORT.BUILD
Does not use EOT Viewer for output.
Intro - Source Code Programs
Advantages
Complete, total control over all aspects.
Disadvantages (Depending on if you can write or modify
code)
Cost to make changes to output.
Intro - ODBC
Advantages
Integration with ODBC compliant systems.
Microsoft Excel
Microsoft Access
Disadvantages
I-DESC rendering can at times be slow.
Difficult to setup
VSG Views must be setup
SQL must be initialized
IEP – REPORT.WRITER
Similar to REPORT.BUILD (Non EOT)
Automatically creates
DATA.SELECTION
TEMPLATE.BUILD
Compiles Code
IEP – TABLE.WRITER
Similar to REPORT.WRITER
Creates report output similar to a
Microsoft Excel Pivot Table.
Automatically creates
DATA.SELECTION
TEMPLATE.BUILD
Compiles Code
IEP – ROI.CONNECTION
Creates text files and downloads them to your
PC
Comma Delimited
Tab Delimited
User Defined Output Formats (IEP.FORMAT.BUILD)
For complex text file output consider using
DBU.
Supports Header / Footer Layout
Subroutines can be attached to attributes.
IEP – DATA.SELECTION
Defines what data you want.
Creates calculations
Links data among multiple files.
IEP – TEMPLATE.BUILD
Defines the layout of the data gathered
using the DATA.SELECTION
Formats data (Such as currency)
Defines Headers / Footers
Page
Line Level
Summary Page
IEP – IEP.FUNCTION.BUILD
Combines a DATA.SELECTION with one
or more TEMPLATE.BUILDs.
A DATA.SELECTION can be used by
multiple TEMPLATES at the same time.
Multiple Functions can be created using the
same DATA.SELECTION with different
TEMPLATES.
IEP – SBA
Used to take detail transactions (such as
IT or SA records) and create summary
records for use in DATA.SELECTION
Summary data is Period sensitive.
Users can define different calendars for
definition of periods. (CALENDAR.BUILD)
Finding your Data…
SHOW.NAMES
SHOW.FILES
Allows you to navigate the module tree looking for
the file you are looking for
Allows you to search files based on criteria such as
Module or File Use
DICT.INQ
Allows you to search the Dictionary of a file.
Also enables you to look at “Set” information.
IEP Documents to review…
IEP.USER.SUMMARY
DATA.SELECTION Function Document
COPY.REPORTS
IEP Demo
Create Sales Report Showing
Customer Number
Invoice / Sales Order Number
Part Number
Quantity
Sales
Invoice / Sales Order Date