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

Frx Error 9 Subscript Out Of Range

OR Run - time error '9' - Subscript out of lunch Brett Johnson access error We are getting "Runtime Error 9: Subscript out of Range" error message when we export one particular report to Excel. Thanks! Please let me know if you are not able to access above link. have a peek here

Any ideas? What can I do to fix the error? Any ideas what could be causing this? Reply Reply With Quote April 6th, 2011,03:46 PM #4 Steve R Jones View Profile View Forum Posts View Blog Entries Ride 'em Cowboy Join Date Oct 2001 Location Dallas, TX

Check any MOVETO=definations at system.cfg Cheers Sanjay Reply Sheila Ochoa My Badges Sheila Ochoa responded on 10 Nov 2013 5:56 PM Sanjay, we didn't try all of these just because I am running consolidated bs. This error commonly shows up if you attempt to copy pages into an Excel file.

By Wombat in forum Networking and Internet Replies: 7 Last Post: April 4th, 2002, 01:11 PM Posting Permissions You may post new threads You may post replies You may not post Have you checked the user permission in GP for all companies if the report contains tree? All other reports export with formulas fine. Restart your computer when the program is finished fixing or restoring any corrupted files.References & ResourcesPersonal Computer Fixes: Runtime Error 9Download: Registry Cleaner ProgramsRelatedGrandpa Needs a New Cell PhoneProductivityWaterproof Your Tech:

Thanks for the feedback. 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 you receive a message that says "Run-time error 9: Subscript out of range," that means Visual Basic is unable to read commands. or check the user permission for appropriate company in GP?

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 I also have reports that export with formulas with same footer values. Hope this helps!!! Mark Reply Anne Bronchetti Anne Bronchetti responded on 9 Feb 2010 7:07 AM Hi - Thanks for your quick reply.

Life is good again. Get news about the products and tech you really care about. Check theysys datafolder definition at C:\Users\username\AppData\Local\FRx Software\FRx 6.7\FRxConfig.xml. 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 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 navigate here John 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 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 The reports can be run using Report Designer with no errors but when the same reports are run using Report Launcher the error occurs.

We ran the same report last month with no errors. Posting Quick Reply - Please Wait « Previous Thread | Next Thread » Thread Information Users Browsing this Thread There are currently 6 users browsing this thread. (0 members and 6 Both computers local installs and Citrix are pointed to the same file locations for sysdata and iodata. http://kshelper.com/frx-error/frx-error-0.html Hope this helps!!!

The time now is 09:49 PM. We have now print screened the solution for reference next January! For one of the units in the tree, I get an error 9: subscript is out of range.

Does anyone have any ideas why Report Launcher would give us this error only on the Citrix computer?

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 login as a SA it works fine, but not as a user. 8900- FRX is unable to open a connection to GL database because the login or pwd is So, a lot of the remedies that I'm seeing in my research do not speak to such a situation. What is the subscript referring to?

First, the director of this department has tried most everything called for in KB articles, to no effect. There are several solutions to fix this Runtime Error 9 problem, so try them all in order.Add a Default PrinterStep 1Plug a printer into your computer, plug in the power cord Since I am not familiar with this error. this contact form 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

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 We only get this error if we mark to export to Excel with formulas. Is the company in the catalg in the tree? I had tried the compacting databases, altering trees and column and row formats.

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 When we moved the data from the footer to the header on the problem report, the report was able to be generated to Excel successfully. If you Google-> error 9: subscript is out of range You'll probably get the idea its a software issue. All assistance is appreciated.

The same reports can be run using Report Launcher on a local workstation, it is just a Citrix install where this error is occurring. {{offlineMessage}} Store Store home Devices Microsoft Surface PCs & tablets Xbox Virtual reality Accessories Windows phone Software Office Windows Additional software Apps All apps Windows apps Windows phone apps Games Xbox or check the user permission for appropriate company in GP? John Tags: Microsoft Dynamics GP 2010: Other Reply All Responses (3) Only Answers Heather Roggeveen Works For Olympic Software (NZ) Ltd in New Zealand @hroggeveen LinkedIn YouTube Blog Website My Badges

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.