web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / FRx Runtime Error 9 ex...
Microsoft Dynamics GP (Archived)

FRx Runtime Error 9 exporting to Excel with formulas

(0) ShareShare
ReportReport
Posted on by Jaymi Stephens 470

We are on FRx Service Pack 11. We are getting "Runtime Error 9: Subscript out of Range"  error message when we export one particular report to Excel. We only get this error if we mark to export to Excel with formulas. If we uncheck that box, we do not get the error. All other reports export with formulas fine. Any ideas what could be causing this?

*This post is locked for comments

I have the same question (0)
  • Hossam Fathy Profile Picture
    Hossam Fathy 2,611 on at

     Try Compact FRx Database.

  • sandipdjadhav Profile Picture
    sandipdjadhav 18,306 on at

    Jaymi,

    Try this KB Link : https://mbs.microsoft.com/knowledgebase/KBDisplay.aspx?WTNTZSMNWUKNTMMYUTMZWVZSQTWWUNTTQMZRNXKPSSOVRNVROLMVMWQOOTUKWYYVLXPOYSMONXLWWTXOZLSLPXMMRKKYQWZL

    KB NO : 112846

    Hope it help will help you. Please let me know if you are not able to access above link.

     Thanks

    Sandip

    210.440.9855

     

  • Debbie O'Conner Profile Picture
    Debbie O'Conner 5 on at
    The headers and footers should both be reviewed.  I had the same issues with several of my reports.I don't know that it was the “/” character as this KB describes or the blank rows at the top as another KB describes, but on some of my reports, I had to completely remove the footers to get them to export without errors. 

    Debbie

     

  • Community Member Profile Picture
    Community Member on at

    Searching again for remedies I saw this thread today.

    I had tried the compacting databases,  altering trees and column and row formats.  I also have reports that export with formulas with same footer values.  Clearing and re-typing headers and footers even with the same or different values did not help

    As Debbie suggested, I removed Footers from the offending reports.  Life is good again.

     

  • Birdwell Profile Picture
    Birdwell 5 on at

    I had the same issue with Sage MAS 500 version of FRx and found that either removing the export to Excel with Formulas checkbox or removing the report footers provided a workaround.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans