Finding the Right Report Writer

Most ERP systems come with standard reports which have been developed over the years from previous customer requirements.  While these standard reports may provide some level of useful information, since it wasn’t specifically designed to meet your requirements you won’t be able to access the wealth of relevant critical-decision making information your ERP system holds.

More than just customized reporting, SYSPRO Report Writer enables you to produce simple ad hoc reports in a format that the user requires. The easy menu-driven design provides instant access to all system data with no programming skills required.

The Report Writer system allows you to send reports to the printer, a screen preview or an ASCII file. Data can be read and written back to the database to facilitate mass updates. Data from third party sources can be used in reports. Data can also be exported to third party software such as spreadsheets, word processors, databases, etc.

The Benefits of Report Writer:

• Quickly and easily produce custom reports
• Intuitive interface enables design by non-programmers
• Built-in data dictionary
• Easy integration to third-party sources
• Export data in multiple formats for third party use
• Daisy-chain reports for management packs
• Multi-level security for sensitive reports and data
• Secured update function
• Zero programming skills required

Report Writer Features:

• Click-and-go reporting via the report wizard
• Custom report formatting to suit your company standards
• Bitmap backgrounds provide watermarks and company logos
• Report in default sequence or define up to 10 levels of custom sorting
• Flexible selection criteria based on run-time prompts
• Run-time selection of Summary or Detail reporting
• XML Output:
  • XML Output wizard guides you through publishing options
  • Customizable stylesheets for company themes or plain XML
  • Sophisticated layout control
  • Summary reports can drill down to detail
  • Automatic publishing to intranet and internet available

Security:

• Define Password and Operator/Group level security per report
• Protect report creation and execution
• Password protect specific tables
• Globally restrict access to Tables and Columns
• Standard linkages for easy reporting across multiple tables
• Export report definitions between locations
• Provide instruction with report narrations

Processing:

• Top X reporting allows reports such as top 20 selling items
• Grand totals and up to 5 levels of subtotals per report
• Up to 100 user-defined variables per report
• Run-time prompts and check boxes provide great flexibility
• Sophisticated conditional printing and positioning
• Simple to use click and edit interface with preview
• Arithmetic calculations including power and square roots
• Powerful include and exclude logic with multiple level and/or logic

Integration with SYSPRO:

• Integrates with all SYSPRO modules
• Reports across SYSPRO companies
• Non-SYSPRO data can be included in the overall framework for a complete view of your business

Because of its wealth of features and, most of all, its ability to be customized, I recommend SYSPRO’s Report Writer to my clients.

If you are looking for a report writer, or would like more information, please email me.