Home > Frx Error > Frx Error Subscript Out Of Range

Frx Error Subscript Out Of Range

Remove rounding on the row. 2. Close Box Join Tek-Tips Today! If we uncheck that box, we do not get the error. We are getting "Runtime Error 9: Subscript out of Range" error message when we export one particular report to Excel. navigate here

By joining you are opting in to receive e-mail. Click Here to join Tek-Tips and talk with other members! What can I do to fix the error? Fix?

If the report is using a tree, the user will need access to all of the companies in the tree. Resources Join | Indeed Jobs | Advertise Copyright © 1998-2016 ENGINEERING.com, Inc. All other reports export with formulas fine. 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. Red Flag This Post Please let us know here why this post is inappropriate. I had tried the compacting databases, altering trees and column and row formats. or check the user permission for appropriate company in GP?

or check the user permission for appropriate company in GP? Does anyone have any ideas why Report Launcher would give us this error only on the Citrix computer? Register now while it's still free! Copyright 2014 All Enthusiast, Inc Powered by: vBulletinCopyright ©2000 - 2016, Jelsoft Enterprises Ltd.

Reply Sandip Jadhav Works For BatchMaster in Laguna Hills, California LinkedIn YouTube Blog My Badges Sandip Jadhav responded on 25 Mar 2010 1:45 PM Jaymi, Try this KB Link : https://mbs.microsoft.com/knowledgebase/KBDisplay.aspx?WTNTZSMNWUKNTMMYUTMZWVZSQTWWUNTTQMZRNXKPSSOVRNVROLMVMWQOOTUKWYYVLXPOYSMONXLWWTXOZLSLPXMMRKKYQWZL 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 The reports can be run using Report Designer with no errors but when the same reports are run using Report Launcher the error occurs. but, i'm only getting it on onereport.

Have you checked the user permission in GP for all companies if the report contains tree? see it here Life is good again. 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.

I have triedcompacting the System database and I tried creating a simple consolidatedtree with only two units that rollup to a summary unit. Any ideas?Terry RWanalyst 2008-04-30 13:50:00 UTC PermalinkRaw Message Terry,I'm getting the same message... Create another catalog ID with no rounding. 3. Hope this helps!!!

Since I am not familiar with this error. Posting Guidelines Promoting, selling, recruiting, coursework and thesis posting is forbidden.Tek-Tips Posting Policies Jobs Jobs from Indeed What: Where: jobs by Link To This Forum! The regional settings of the computers have been checked and everything else seems to be the same. his comment is here Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Check theysys datafolder definition at C:\Users\username\AppData\Local\FRx Software\FRx 6.7\FRxConfig.xml. How to fix it? Hope this helps!!!

Required fields are marked *Comment Name * Email * Website Notify me of follow-up comments by email.

OR Run - time error '9' - Subscript out of lunch Brett Johnson access error The time now is 10:45 PM. I also have reports that export with formulas with same footer values. I have triedcompacting the System database and I tried creating a simple consolidatedtree with only two units that rollup to a summary unit.

All rights reserved.Unauthorized reproduction or linking forbidden without expressed written permission. 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 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 http://bloggingsystemsblog.com/frx-error/frx-error-message-subscript-out-of-range.html Talk With Other Members Be Notified Of ResponsesTo Your Posts Keyword Search One-Click Access To YourFavorite Forums Automated SignaturesOn Your Posts Best Of All, It's Free!

Here's Why Members Love Tek-Tips Forums: Talk To Other Members Notification Of Responses To Questions Favorite Forums One Click Access Keyword Search Of All Posts, And More... Join UsClose Fareness: When & Where for Low Airfare Register Help Remember Me? Already a member? If I do not export formulas, it worksfine, but if I try to export flrumla's I get the error message.

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 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 Close Reply To This Thread Posting in the Tek-Tips forums is a member-only feature. Close this window and log in.

They are also running the same versions. Join Us! *Tek-Tips's functionality depends on members receiving e-mail. 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 If I do not export formulas, it worksfine, but if I try to export flrumla's I get the error message.

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 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 I am trying to understand if its a report writing or technical issue. If I do not export formulas, it worksfine, but if I try to export flrumla's I get the error message.

If you Google-> error 9: subscript is out of range You'll probably get the idea its a software issue. I am still gettingthe error message. 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 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. in Kuwait LinkedIn My Badges Hossam Fathy responded on 25 Mar 2010 1:28 PM Try Compact FRx Database. Thread Tools Show Printable Version Subscribe to this Thread… April 6th, 2011,09:01 AM #1 bj108 View Profile View Forum Posts View Blog Entries Junior Member Join Date Apr 2011 Posts