Report Writer

Objective

To fulfill the unique reporting requirements of each business by allowing for the creation of custom reports while allowing complete access to the SYSPRO database.

The Value of SYSPRO Report Writer

• Reporting is completely user-definable enabling the retrieval of wanted data in a preferred format
• Easy, menu-driven design – no programming skills required
• Provides instant access to all system data
• Offers the ability to read and write back to the database facilitating mass updates, if desired
• Reports on data from third party sources
• Exports data to third party software (spreadsheets, word processors, databases, etc)
• Run-time prompts allow for real-time reporting
• Provides excellent security control for sensitive reports
• Has the ability to “daisy-chain” reports
• A Report Wizard is available
• Sends reports to the printer, screen, ASCII file, or XML documents
• Supplements standard SYSPRO reports
• Preview of reports to screen and e-mail capabilities
• Sequence selected at run-time

Matching SYSPRO to Your Business

• Formats any number of reports in order to suit unique information needs and control the content as well as the layout of each report
• Prints detailed or summarized reports
• Data files within SYSPRO can be updated with new data, constants or calculated results
• Creates user-defined files
• Designs customized security controls to insure that only authorized users can access data and/or reports
• Data files can be linked for reporting from multiple files to one report
• Creates special sorting indexes for use with many of the standard SYSPRO reports
• Run-time check boxes allow greater flexibility
• Works with both SQL and C-ISAM database
• Up to 10 run-time prompts with browse facility on key fields
• Powerful include logic with pattern matching and nested logic
• Conditional printing and positioning
• Output XML documents for display in HTML format

Integration

• The Report Writer module accesses all files and fields within the SYSPRO database
• E-mail reports with the Office Automation module

Processing

• Offers user-defined report, column and detail line headings
• Has powerful include and exclude logic with pattern matching and nested logic
• Provides five user-defined subtotal levels plus grand total
• Allows 10 predefined, multilevel sequences on any field
• Provides the facility to create user-specified numbered records, i.e. top 20 highest selling items
• Gives user-defined variables for calculations and strings
• Provides user-defined run-time prompts that allow design dynamic reports that can run repeatedly
• Gives vertical and horizontal print definitions
• Has arithmetic calculation facilities
• Report layouts are “painted” on the screen as they are designed
• Conditional printing and positioning provides unconditional flexibility