Error: "Report Designer component is required by this report and is not installed on this workstation"

From Sage Intelligence Knowledgebase
Revision as of 10:44, 13 November 2014 by Support (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Products

Sage 100 ERP


Description

Error: "The Report Designer Component is required by this report and is not installed on the workstation. Please install it before running this report", occurs when running a Report Designer type of report in Sage 100 Intelligence


Disclaimer

Backup Warning

Use caution when working with the below product functionality. Always create a backup of your data before proceeding with advanced solutions. If necessary, seek the assistance of a qualified Sage Business Partner, network administrator, or Sage Customer Support Analyst.


Network Warning

This solution requires advanced knowledge of your network. Contact your system administrator for assistance. Modifying Windows security incorrectly can severely affect system operations. Sage is not responsible for operation issues caused by incorrectly modifying your Windows security. Always create a backup of your data before proceeding with advanced solutions.


Operating System Warning

This solution requires advanced knowledge of your computer's operating system. Contact your system administrator for assistance. Modifying your Windows Registry incorrectly can severely affect system operations. Sage is not responsible for operation issues caused by incorrectly modifying your Windows Registry. Always create a backup of your data before proceeding with advanced solutions.


Cause

BIGenerator Excel com add-in was not installed properly or user does not have efficient permissions


Resolution

Open Excel and verify if BIGenerator Com Add-in is listed in Excel Options, see related article below, BI Tools is missing when running a Report Designer report

If you are not able to add the BIGenerator Com Add-in, please do the following:

  1. Export any custom reports, see related article below, How to Import and Export Reports in Sage Intelligence.
  2. Close Excel and Sage Intelligence
  3. Using Add/Remove programs, uninstall Sage Intelligence and if applicable also uninstall Report Designer Add-in and any Sage Intelligence hot fixes/patches,
  4. Install appropriate version of Sage 100 Intelligence. If using Windows 7, right click on .exe file and select to Run as Administrator
  5. Note: The first time you open Report Manager, you will be prompted to select new repository folder and register Sage Intelligence using License Manager.
  6. After successfully registering Sage Intelligence, launch Report Manager
  7. Confirm you can successfully run any canned Financials report.
  8. Close out of Excel and Report Manager
  9. If applicable, Install Report Designer Add-in. If using Windows 7, right click on .exe file and select to Run as Administrator


Additional Information

Note: Please make a backup of registry before proceeding. Sage is not responsible for operation issues caused by incorrectly modifying your Windows Registry. Always create a backup of your data before proceeding with advanced solutions.


If error still exists;

  1. Log into machine with the local "Administrator" account
  2. Verify you can successfully run report without error.
  3. In Excel and verify the BIGenerator Com Add-in is listed in Excel Options
  4. If the "Administrator" account has the BI Tools menu available in Excel and other users on same machine do not, please try the following:


  • 1:
  1. Login as User
  2. Using Add/Remove Programs, uninstall Sage 100 ERP Workstation Setup
  3. Browse to the ...\MAS90\Wksetup folder and right click on Autorun.exe and select to Run as Administrator
  4. Select to Install Sage 100 ERP Workstation
  5. Proceed through installation wizard


  • 2:
  1. Log in as Administrator, click Start menu, in run field type regedit and press ENTER
  2. Go to HKEY_CURRENT_USER > Software > Microsoft > Office > Excel > Addins > BIGenerator
  3. Right click on BIGenerator and select Export
  4. Log into same machine as a user getting error, click Start menu, in 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 BI Generator is listed under HKEY_CURRENT_USER > Software > Microsoft > Office > Excel > Addins folder


Category

Installation

Integration

Reporting


Entitlement

Sage 100 ERP