"Runtime error 91: Object variable or With block variable not set" when exporting a report to Microsoft Excel

Entry Type: Informational

Product: FRx

Application: FRx Desktop

Version Reported: 6.081

Subject:

The error "Runtime error 91: Object variable or With block variable not set" occurs when exporting a report to Microsoft Excel.       

Possible Resolution:

  1. Create a new catalog ID for the report. Select the same row, column, reporting tree (if applicable), and detail level, and save.
  2. Generate the report using the 'Enhanced XML' Drilldown Viewer.
  3. After the report launches in the Drilldown Viewer, select File / Export / Worksheet File / Excel (.XLS).