Error message: "The Report Designer Component is required by this report and isn’t installed on the workstation. Install it before running this report."

•  NOTE: Back up the Windows registry and data before making changes 
• Log in as Administrator and verify the report runs without error
• Open Excel and check the Excel Options for the BIGenerator COM Add-in and Report Designer Add-in
• If the BI Tools menu appears for Administrator but not other users, try these steps

Uninstall and Reinstall as Administrator

1. Log in as user and uninstall Sage 100 ERP Workstation Setup
2. Browse to ..\MAS90\Wksetup, right-click Autorun.exe, select Run as Administrator
3. Install Sage 100 ERP Workstation and complete the wizard

Edit the registry

1. Log in as Administrator, click Start menu, in the run field type regedit and press ENTER.
2. Go to HKEY_CURRENT_USER > Software > Microsoft > Office > Excel > Add-Ins > BIGenerator.
3. Right-click BIGenerator and select Export.
4. Log in to the same machine as a user experiencing the error. Click Start menu, in the run field type regedit and press ENTER.
5. Click File, Import.
6. Select the registry file you exported from other machine and click Open.
7. Verify BIGenerator displays under HKEY_CURRENT_USER > Software > Microsoft > Office > Excel > Add-Ins folder.

Missing BIGenerator Add In Remote Environment

Follow the article Missing BIGenerator and PLdrill on terminal server to add the missing BIGenerator Add in.

1. Verify you can generate a NON Report Designer Report without error (that is, GL Transactions Detail report).
2. Open Excel and check the Excel Options for the BIGenerator COM Add-in and Report Designer Add-in. See the BI Tools menu is missing when running a Report Designer report for further instructions.

If you aren’t able to add the BIGenerator COM Add-in

1. Export custom reports see Upgrade (Import/Export) Sage 100 Intelligence reports for further instructions.
2. Close Excel and Sage Intelligence.
3. Uninstall Sage Intelligence and related components.
4. Perform a clean reinstall of Sage Intelligence and Report Designer Add-in.
5. Install the appropriate version of Sage 100 Intelligence.
6. Register Sage Intelligence using License Manager.
7. Verify reports run successfully in Report Manager.

More Notes

• Launch Excel at least once per user if using Citrix
• Ensure users have full control permissions to the Microsoft Office folder
• Try running Sage 100 as Administrator. Right-click the Sage 100 shortcut and select Run as Administrator