"Error 5: Invalid Procedure call or argument" error message when you generate a report in FRx 6.7.2013 and then send it to an Excel PivotTable or to an Excel PivotChart

Article ID: 895045 - View products that this article applies to.
Microsoft Business Solutions-Axapta 3.0 is now part of Microsoft Dynamics AX 3.0. All references to Microsoft Business Solutions-Axapta and Microsoft Axapta pertain to Microsoft Dynamics AX.
Notice
Expand all | Collapse all

SYMPTOMS

When you use Microsoft FRx 6.7.2013, you may receive the following error message:
Error 5: Invalid Procedure call or argument
You receive this message when you generate a report in FRx Reporter and then export the report to an Excel PivotTable or to an Excel PivotChart.

CAUSE

This issue occurs because the Excel PivotTable/PivotChart hotfix was not applied when FRx Reporter was originally installed.

RESOLUTION

To resolve this issue, you must apply the Excel PivotTable/PivotChart hotfix. To do this, follow these steps:
  1. Insert the FRx 6.7 CD into the computer, and then start the FRx installation.
  2. Click Installation Prerequisites.
  3. Click Update for PivotTable/PivotChart Users.
  4. Click Hotfix Readme/Installation instructions, and then follow the instructions in the wizard.

Properties

Article ID: 895045 - Last Review: July 25, 2011 - Revision: 4.0
APPLIES TO
  • Microsoft Business Solutions for Analytics–FRx 6.7 Desktop
  • Microsoft Dynamics GP 10.0
  • Microsoft Dynamics GP 9.0
  • Microsoft Business Solutions–Great Plains 8.0
  • Microsoft Business Solutions–Great Plains 7.5
  • Microsoft Dynamics SL 6.5
  • Microsoft Business Solutions–Solomon 6.0
  • Microsoft Dynamics AX 4.0
  • Microsoft Dynamics AX 3.0
  • Microsoft Dynamics NAV 4.0
  • Microsoft Business Solutions–Navision 3.70
  • Microsoft Small Business Financials 9.0
  • Microsoft Business Solutions Small Business Financials North America Edition 8.0
  • Microsoft Business Solutions Small Business Manager 7.5, when used with:
    • Microsoft Business Solutions for Analytics–FRx 6.7 Desktop
Keywords: 
kbnavisionfrx kbsolomonfrx kbsmallbusinessfinancialsfrx kbgreatplainsfrx kbaxaptafrx kbinfo kbmbsmigrate KB895045

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com