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