Home > Frx Error > Frx Error 9 Subscript Out Of Range

Frx Error 9 Subscript Out Of Range

If you Google-> error 9: subscript is out of range You'll probably get the idea its a software issue. I suggest applying the latest service pack to resolve the issue.Service pack 9 is available for all general ledgers, and service pack 10 isbeing tested and released for all general ledgers I have seen other posts that said this issue was corrected in V9, but following posts said that upgrading to V9 did not solve the issue. I am trying to understand if its a report writing or technical issue. Check This Out

The time now is 10:39 PM. I tried this on two different FRx service packs (sp11 and sp12) and different computers with the same results.  The work-around is to do one of the following:   1. I am still gettingthe error message. Any ideas?Terry 3 Replies 119 Views Switch to linear view Disable enhanced parsing Permalink to this page Thread Navigation TerryF 2008-03-05 23:08:01 UTC Rick Tenorio [MSFT] 2008-03-07 18:24:02 UTC TerryF 2008-03-10

Since I am not familiar with this error. I am still gettingthe error message. Reply Birdwell Birdwell responded on 14 Aug 2014 4:50 PM I had the same issue with Sage MAS 500 version of FRx and found that either removing the export to Excel

We only get this error if we mark to export to Excel with formulas. To use Google Groups Discussions, please enable JavaScript in your browser settings, and then refresh this page. . The reports can be run using Report Designer with no errors but when the same reports are run using Report Launcher the error occurs. Hope this helps!!!

Forum New Posts FAQ Calendar Community Groups Albums Forum Actions Mark Forums Read Quick Links Today's Posts View Site Leaders Who's Online Blogs Latest Activity Forum PC Hardware and Tech Technical Mark Reply Anne Bronchetti Anne Bronchetti responded on 9 Feb 2010 7:07 AM Hi - Thanks for your quick reply. Mark Reply Industries Education Government Health Discrete Manufacturing Hospitality and travel Retail and consumer goods For customers Small and midsize businesses Enterprise Envision Microsoft Ignite Microsoft AppSource For partners Microsoft partner Here's a couple: Subscript out of range (Error 9) Fix Subscript Out of Range error "Common Sense is a flower that doesn't grow in everyone's garden." Reply Reply With Quote

Notify me of new posts by email. How to fix it? I am still gettingthe error message. Verify and try again. 91 - object variable or with block variable not set 3704 - operation is not allowed when the object is closed.

By Sweeper in forum Applications and Operating Systems Replies: 20 Last Post: September 11th, 2005, 02:47 PM Spybot DSO error fix By John Prophet in forum Applications and Operating Systems Replies: https://community.dynamics.com/gp/f/32/t/137822 Reply Natarajan SankaraNarayanan Works For Business Experts Gulf in Dubai, U.A.E @natraj88 LinkedIn Google+ Blog Website My Badges Suggested Answer Natarajan SankaraNarayanan responded on 18 Aug 2014 1:19 AM Hi, Please in Kuwait LinkedIn My Badges Hossam Fathy responded on 25 Mar 2010 1:28 PM Try Compact FRx Database. Posting Quick Reply - Please Wait « Previous Thread | Next Thread » Thread Information Users Browsing this Thread There are currently 1 users browsing this thread. (0 members and 1

We did find that there was a row with a link which was referencing GL Year 2008 instead of 2009 and needed to be updated. I also have reports that export with formulas with same footer values. Tags: error 9 Subscript Report Launcher FRx Reply All Responses (2) Sanjay Kumar Rajarao Works For FMTConsultants in Los Angeles, CA @sanjayrajarao LinkedIn Blog Website My Badges Sanjay Kumar Rajarao responded Create another catalog ID with no rounding. 3.

Have you checked the user permission in GP for all companies if the report contains tree? in United States LinkedIn Website Dave Winters responded on 21 Jun 2010 12:31 PM Searching again for remedies I saw this thread today. Check withyour FRx support provider for download information."Error 9 Subscript out of range" This error occurs when exporting a reportto Excel when the Subtotal on Segment option is selected on the this contact form Clearing and re-typing headers and footers even with the same or different values did not help As Debbie suggested, I removedFooters from the offendingreports.

If I do not export formulas, it worksfine, but if I try to export flrumla's I get the error message. Thanks again :) Reply Mark Roux My Badges Mark Roux responded on 9 Feb 2010 7:13 AM Ah, excellent. By Athlonanime in forum Applications and Operating Systems Replies: 3 Last Post: March 26th, 2004, 08:09 PM Great Plains and FRX By iamsmiling in forum General Tech Discussion Replies: 0 Last

Any ideas?Terry Rick Tenorio [MSFT] 2008-03-07 18:24:02 UTC PermalinkRaw Message This was a reported issue with Microsoft FRx 6.7 and was fixed in a servicepack.

Any ideas?Terry RWanalyst 2008-04-30 13:50:00 UTC PermalinkRaw Message Terry,I'm getting the same message... We ran the same report last month with no errors. I am able to export one unit in the tree succesfully, butif I try to export two units the Subscript out of range error occurs.--TerryPost by Rick Tenorio [MSFT]This was a Fix?

Check withyour FRx support provider for download information."Error 9 Subscript out of range" This error occurs when exporting a reportto Excel when the Subtotal on Segment option is selected on the I had tried the compacting databases, altering trees and column and row formats. What can I do to fix the error? navigate here Ignore the warning - the report viewer will launch after the report is done.   Here are some more in-depth articles on error 9, mainly related to FRx Report Designer: http://support.microsoft.com/kb/865978

Thanks Sandip 210.440.9855 Reply Debbie O'Conner Debbie O'Conner responded on 26 Mar 2010 9:57 AM The headers and footers should both be reviewed. Reply Industries Education Government Health Discrete Manufacturing Hospitality and travel Retail and consumer goods For customers Small and midsize businesses Enterprise Envision Microsoft Ignite Microsoft AppSource For partners Microsoft partner resources If I do not export formulas, it worksfine, but if I try to export flrumla's I get the error message. Do you get this message with one report or all of your reports?thanks,Post by TerryFAfter applying service pack 9 I still receive Error 9 when I try to exportformulas to excel.

OR Run - time error '9' - Subscript out of lunch Brett Johnson access error We are using release 6.7. Check withyour FRx support provider for download information.This bug fix address the following:"Error 9 Subscript out of range" This error occurs when exporting a reportto Excel when the Subtotal on Segment Any ideas what could be causing this?

If I do not export formulas, it worksfine, but if I try to export flrumla's I get the error message. If I do not export formulas, it worksfine, but if I try to export flrumla's I get the error message. I have triedcompacting the System database and I tried creating a simple consolidatedtree with only two units that rollup to a summary unit. My AccountSearchMapsYouTubePlayNewsGmailDriveCalendarGoogle+TranslatePhotosMoreShoppingFinanceDocsBooksBloggerContactsHangoutsEven more from GoogleSign inHidden fieldsSearch for groups or messages

I have triedcompacting the System database and I tried creating a simple consolidatedtree with only two units that rollup to a summary unit. Hope this helps!!! Reply Reply With Quote April 6th, 2011,10:13 AM #2 Steve R Jones View Profile View Forum Posts View Blog Entries Ride 'em Cowboy Join Date Oct 2001 Location Dallas, TX For one of the units in the tree, I get an error 9: subscript is out of range.

I have triedcompacting the System database and I tried creating a simple consolidatedtree with only two units that rollup to a summary unit. Please let me know if you are not able to access above link. If the report is not using a tree, the user only needs access to the company selected in the catalog. Any ideas?Terry TerryF 2008-03-10 17:25:02 UTC PermalinkRaw Message After applying service pack 9 I still receive Error 9 when I try to exportformulas to excel.

or check the user permission for appropriate company in GP?