Crystal Reports

Save Time Designing and Distributing Presentation-Quality Reports

Create and customize presentation-quality reports from your Sage 100 ERP (formerly Sage ERP MAS 90 and 200) systems data with SAP Crystal Decisions software. SAP Crystal Reports for Sage 100 ERP is a powerful report writer that allows you to create meaningful reports quickly and easily. You can use sample reports straight out of the box (see some of the reports included with your Sage 100 ERP software in the sidebar). Or modify reports to suit your needs, then save and run them anytime.

Take control over the look of your documents by selecting font type, size, and color. Enhance the layout by applying lines, borders, and shading. Further enrich your reports with embedded pictures, diagrams, and logos. Use tables, cross-tabulations, or one of 12 graph styles to communicate your financial information. You can even create reports with drill-down capabilities simply by selecting that option for the detail section of a report.

SAP Crystal Reports for Sage 100 ERP “Experts” are wizards that guide you through the report process from start to finish, and Private Tutor is a built-in training and online help system. You can run your reports at predetermined times, even unattended. See the features list on the reverse side for exciting new capabilities.

The open database connectivity driver (ODBC), included with the application, gives SAP Crystal Reports for Sage 100 ERP direct access to Sage 100 ERP data. The ODBC driver also provides read-only access to Sage 100 ERP data for other applications, including Microsoft® Word, Excel®, and Access software—for automatic transfer of your accounting information into other applications and report writers. SAP Crystal Reports for Sage 100 ERP is included with your Sage 100 ERP software.


Compatible with Sage 100 Standard, Advanced, and Premium ERP



These may be embedded in a main report so that you can insert information from different tables with different formats into any section of a report. For example, you can embed your income statement into the balance sheet and pull the net income figure into the balance sheet.

Conditional and Multiple Section Reports
This feature lets you specify special conditions for each section of a report, allowing one report to produce several different outcomes.

Enhanced Cross-Tabulation Objects
You can present summary information in a single cell, replacing columnar report formats.

Form-Style Reports
This feature allows for printing with greater precision on preprinted forms using new guidelines and text objects.

Mail-Merge Capabilities
You can combine database information with letters or other text objects and specify selection criteria to target specific groups of customers.

Report Design Control
Improved user interface gives more power and control over report design by letting you customize your design environment. You can also use a drawing model instead of a predefined grid for more accurate placement of data fields.

Control Formatting with Formulas
Data can be displayed in a different color or underlined to put emphasis on a particular cell and its value.

Enhanced Graphing Capabilities
You can graph on details, formulas, and subtotals, and you can choose from several graphical formats.

Report Distribution Capabilities
With SAP Crystal Reports for Sage 100 ERP, you can publish reports to the web with automatic HTML output, presenting embedded graphs and other features of the original report. When exporting to Word and Excel, images, lines, boxes, and color are included. You can send email reports in any of the output formats supported within the SAP Crystal for Sage 100 ERP runtime viewer.


  • Access wizards to easily guide the reporting process from start to finish
  • Specify special conditions allowing one report to produce several outcomes
  • Present summary information in a single cell
  • Use subreporting capabilities to incorporate multiformat tables

Customizable Report Templates Include

Accounts Payable

  • Aged Invoice
  • Check History
  • Trial Balance
  • Vendor Listing

Accounts Receivable

  • All Bundled Reports
  • Aged Invoice
  • Customer Listing
  • Sales Analysis
  • Salesperson Commission
  • Trial Balance

Bank Reconciliation

  • All Bundled Reports

General Ledger

  • All Bundled Operational and Financial Reports

Inventory Management

  • Item Listing
  • Item Reorder
  • Stock Status
  • Item Valuation

Job Cost

  • Masterfile Listing
  • Code Detail
  • Analysis by Cost Type
  • Billing History
  • Work In Process

Purchase Order

  • Purchase History
  • Open PO by Item
  • Open Purchase Order

Sales Order

  • All Bundled Operational Reports Including Invoicing and Shipment Processing

Crystal Reports