Error Report Designer license is required or This workbook does not contain valid data to use the Report Designer Add-In, occurs in Sage 100 Intelligence
Description
“#Error Report Designer license is required” or “This workbook does not contain valid data to use the Report Designer Add-In”, message occurs and the Task Pane does not display in Excel when generating a Report Designer Add-in type of report in Sage 100 Intelligence.
Cause
This issue is possibly caused by Report Designer Add-in (RDA) reports being created in a different version than the report is being generated from. Example: Custom RDA report created in Sage Intelligence 5.0, imported into Sage Intelligence version 4.50.
Resolution
Note: You must have purchased the Designer module for Sage 100 Intelligence in order to run any Designer type of report
The above messages will appear if the Report Designer module is not enabled, do the following to verify:
- Open Sage Intelligence License Manager
- Highlight your Sage Account Number (left side)
- In the Report Designer Enabled field verify that a 1 appears.
- If “1” does not appear AND you have purchased the Sage Intelligence Report Designer module, please contact Sage Sales Advisor at 800-390-3643 to generate new activation keys.
- If you have not purchased the Report Designer module, please contact your Business Partner or Sage Sales Advisor to purchase the Designer module
If the Report Designer is enabled, please the possible resolutions below:
Resolution 1:
- Run the canned Report Designer Add-in report under the Report Designer Add-In folder in Report Manager
- Access Excel Options, click Add- Ins tab
- In the Manage section, select Excel Add-Ins and click Go
- At the Add-Ins Window, uncheck the Report Designer Add-In 1.0.0 and click OK.
- Then go back to the Add-Ins Window and select the Report Designer Add-In 1.0.0 and click OK
- The Task Pane will now appear.
If error still persists:
- Run the canned Report Designer report under the Report Designer Add-In folder in Report Manager
- Access Excel Options, click Add- Ins tab
- In the Manage section, select Excel Add-Ins and click Go
- At the Add-Ins Window, uncheck the Solver Add-in and click OK
Resolution 2:
- Keep the Report Designer Add-In 1.0.0 report open.
- Run any Designer Report (Under Designer folder in )
- Go back to the Report Designer Add-In report and the Task Pane can now be displayed.
NOTE: If the data does not display in a report that was saved and the cells display an error message, refresh the data (click F9 on the keyboard)
If Task pane still does not appear, see Related Article below Task Pane is missing in Excel when generating a Report Designer Add-In report in Sage 100 Intelligence
Resolution 3:
- Download and replace the BICORE.EXE file found on the below link.
- https://www.dropbox.com/s/6sjnxy9j7v3jzsm/BICore%282%29.exe?dl=0
- Once Downloaded, navigate to the existing BICORE.EXE file and then replace with the new downloaded one.
If using Excel 2013, please see Additional Information section below