Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

Error message when you export a Microsoft FRx report to Excel: “Error 450 Excel is unable to set font style”


Symptoms

When you generate a report in FRx with the output set to Excel or Formatted Excel, you receive the following error message.

Error 450 Excel is unable to set font style (Wrong number of arguments or invalid property assignment)

↑ Back to the top


Cause

One of the building blocks (row, column, or tree) in the report is corrupted.

↑ Back to the top


Resolution

  1. Apply the latest service pack for FRx.
  2. With everyone out of FRx except one computer, go to File | Compact FRx Databases | Current Spec Set
  3. Run the report again.
If this does not solve the issue then:
  1. Create a new blank row, column, and tree
  2. Copy the row, column, and tree information from the original report into the new row, column, and tree that you created.
  3. Create a new catalog.
  4. Run the report to a Formatted Excel (.XLS).

↑ Back to the top


References

↑ Back to the top


Keywords: kb

↑ Back to the top

Article Info
Article ID : 964427
Revision : 3
Created on : 3/30/2017
Published on : 3/30/2017
Exists online : False
Views : 70