Skip to main content

Business Intelligence and Integration Tools

Sage 100 Crystal Reports


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.

*This module is compatible with Sage 100 Standard and Advanced ERP.


Compatible with Sage 100 Standard and Advanced 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.

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.

Enhanced Graphing Capabilities

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


  • 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

Create User-Defined Fields with the Customizer

“SAP Crystal Reports for Sage 100 ERP can make our documents look however we like. It gives us lots of choices, like either landscape or portrait formatting, or positioning text with center or left justification. These options really enhance the appearance of our reports.”

Leigh Scott-
Systems Manager;
Ledford Medical Electronics

Want More Information on Business Intelligence and Integration Tools?

Increase productivity and enhance functionality. Create an all-encompassing information management system for your business. Quickly generate reports, view vital company information, automatically consolidate data from multiple companies, divisions, and data sources for in-depth analysis. Keep your company, customers, and vendors “in the know” with automated triggered emails.

120 Eagle Rock Ave, Suite 330 East Hanover, NJ 07936 • 877.979.5462 •

©2012 Sage Software, Inc. All rights reserved. Sage, the Sage logos, and the Sage product and service names mentioned herein are registered trademarks or trademarks of Sage Software, Inc., or its affiliated entities. All other trademarks are the property of their respective owners.                                                                                                                                 

Close Menu
SWK Technologies