Skip to main content

Crystal Reports

SAP Crystal Reports for Sage 100 ERP


SAP Crystal Reports integrates with Sage 100 ERP to allow you to create and customize presentation-quality reports quickly and easily. Choose from a number of standard reports or modify reports to fit your business’ specific needs. Select everything from the font type, size, and color to graphs and tables. See more detail in your reports with drill-down capabilities so that you can format the information the way you need it to be.

Crystal Reports is simplified by wizards to guide you through the creation process from start to finish, making it easier than ever to create custom reports. SAP Crystal Reports is integrated with Sage 100 ERP with the open database connectivity driver (ODBC) so that it can always access your company data, enabling you to eliminate time-consuming double entry. It can also integrate with Microsoft Word and Access so that you can use the reports however you feel comfortable.


Crystal Reports Features


  • Subreports: 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.


Accounting Business Solutions by JCS is a certified Sage partner offering a variety of Sage software support, training, and discounted Sage software sales. Whether you are in the manufacturing industry or are a service provider such as an attorney, Sage is guaranteed to have an accounting software solution for you!