Sage Partners
Connect on Twitter
  • Home
  • Find a Reseller
    • By Location >
      • U.S. Partners
      • Canada Partners
    • By Sage Product >
      • Sage ERP Partners >
        • Sage 50 Partners
        • Sage 100 Partners
        • Sage 300 Partners
        • Sage Intacct Partners
        • Sage X3 Partners
        • Sage 500 Partners
      • Sage Construction Partners >
        • Sage 100 Contractor (Partners)
        • Sage 300 Construction (Partners)
      • Other Sage Partners
  • Sage Product Info
    • Sage 50
    • Sage 100 >
      • Sage 100 Tips & Tricks
      • Sage 100 System Requirements
    • Sage 300 >
      • Sage 300 Installation Guides
    • Sage Intacct
    • Sage 500
    • Sage X3
    • Sage Construction >
      • Sage 100 Contractor
      • Sage 300 Construction
      • Sage Estimating
    • Other Sage Products >
      • Sage Fixed Assets >
        • Sage Fixed Assets User Guides
      • Sage CRM
      • Sage HRMS >
        • Sage HRMS System Requirements
  • Sage Add Ons
  • Resources
    • Blog
    • Popular Articles
    • Buying Guides >
      • Inventory Management Tips
      • ERP Implementation Failure
  • Contact Us

How to Add Custom Crystal Reports to Your Sage 100 Menu

3/31/2022

0 Comments

 
Sage 100 Custom Report Menu
Sage 100 comes with lots of standard, built-in reports right out of the box. But sometimes, a standard report doesn’t deliver the custom fit you need for your particular business or situation. That’s where the Crystal Reports Designer comes in, allowing you to build tailor-fit reports using Sage 100 data tables. Then once it’s built, here’s how to add that custom Crystal Report to the Sage 100 menu for quick and easy access.

Adding a Custom Crystal Report to Sage 100 Menu

1. Open Library Master, Setup menu, Report Manager
 
2. Click Add Report to Menu to launch the Menu Wizard
 
(Note: To be able to access the Add Report to Menu option, your user login will need the "Allow User to Access Menu Wizard" check box option enabled in Role Maintenance).
 
3. On the Menu Wizard, click Next
 
4. For Module, select the module application to which the custom report will be added
 
5. For Path and File Name, browse to the custom Crystal Report file
 
IMPORTANT: The report file name must end with CUSTOM.RPT and be 30 characters or less (Example: MyAwesomeReport_custom.rpt)
 
6. For Report Name, enter the name you want displayed on the menu for this report
 
7. Click Next
 
8. Select the applicable user Role(s) that will be allowed to access this report
 
9. Click Finish
 
10. Take notice in the Custom Reports Menu of the applicable module (that you selected in Step 4), a new option with your Report Name (entered in Step 6) now displays and can be selected.

IMPORTANT: The added custom Crystal Report should get copied to the "..\MAS90\Reports" folder on the server where Sage 100 is installed. If it does not exist there, copy it there.
 
Note: Sage Customer Support does not provide assistance in creating or troubleshooting custom Crystal Reports or third-party products. If you need help, contact your Sage Reseller.

FAQ: What Versions of Crystal Reports are Supported with Sage 100?

NEED SAGE 100 CRYSTAL REPORTS TRAINING?

Click below to find a Sage Authorized Partner in your area who can help.
Sage 100 Partners

What is Crystal Reports for Sage?

SAP Crystal Reports is a third-party reporting tool that’s bundled with Sage 100 (and as the name suggests, is owned by SAP which acquired the product in 2007). In addition to the loads of standard, pre-built Crystal Reports provided “out of the box” with Sage 100, this powerful reporting platform also allows you to create presentation-quality reports with tons of features and flexibility.
 
But just like anything that’s powerful and feature-packed, designing your own custom reports does require some degree of skill, training, and familiarity with the underlying Sage 100 database structure. However, using the pre-built Crystal Reports is as easy as just choosing an available report from the Sage 100 menu.
Picture
See Also:
How to Install Sage 100 Crystal Reports Designer
How to Delete a Custom Crystal Report from the Sage 100 Menu
What Versions of Crystal Reports are Compatible with Sage 100


0 Comments

Your comment will be posted after it is approved.


Leave a Reply.

    ARE YOU A SAGE PARTNER?

    Get Your Business Listed Here!

    Click below if you're interested in having your business listed in this online directory of Sage Partners.
    Get Started
    Sage Cloud Hosting by gotomyerp

    Popular Articles

    Big Bang Implementation vs Phased Approach
    (Pros, Cons)

    ---
    Sneak Peek!
    Sage 100 2025
    ---
    What's New in
    Sage 300 2025

    ---
    New Release:
    Sage Intacct 2025 R1
    ---
    What Does ERP Stand For?
    ---
    Sage 100 System Requirements and installation Guide
    ---
    Sage 300 Installation Guide
    ---
    Sage 100 Tips & Tricks

©2025 Top-Sage-Resellers.com. All rights reserved. This material and content on this website may not be reproduced, displayed, modified or distributed without the express prior written permission of the copyright holder. This website is not owned, operated, affiliated with, or endorsed by Sage Software, Inc. or Sage Intacct, Inc. Sage, Sage logos, and Sage product names mentioned herein are registered trademarks or trademarks of Sage Software, Inc. and/or its affiliates. Other product names mentioned are trademarks of their respective owners.
Privacy Policy