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
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
Integration
The Report Writer module accesses all files and fields within the SYSPRO database
