Solved

FRx Report Designer Error

Posted on 2010-09-23
4
1,137 Views
Last Modified: 2013-12-11
Environment:
Microsoft FRx Release 6.7.9111
Microsoft Windows Server 2003 R2
Logged in as Domain Admin
System DSN created.

Process:
Open FRx Report Designer
Login
Click Row Formats
Click New
Click EDIT -> Add Rows from Chart of Accounts...
Click OK on Window (Error occurs here)

Conditions:
When I log into FRx as sa the above works without an error.
When I log in as another user, I receive the error: "Error opening connection to"

The user (non SA login) can run reports through FRX without a problem.

Any input would be appreciated. Error when NOT sa.
0
Comment
Question by:mirey
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
4 Comments
 
LVL 10

Expert Comment

by:Jeff Wight
ID: 33798867
If you log into GP with the user account that gets this error, can you access Account data (Cards -> Financial -> Accounts)?



0
 

Author Comment

by:mirey
ID: 33799616
jd_wright,
I logged into GP with this user and was able to pull up CARDS->FINANCIAL->ACCOUNTS and when I click on the lookup for the account field in the account maintenance window, I get a window with all the GL accounts.
0
 

Accepted Solution

by:
mirey earned 0 total points
ID: 34394326
We solved this issue with a quick fix, applied the latest service pack for FRx and all was good.
0
 

Author Closing Comment

by:mirey
ID: 34424465
We solved this issue with a quick fix, applied the latest service pack for FRx and all was good.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Dynamics CRM Online: Add Button on Sub-Grid 8 487
Common Front Ends using Dynamics CRM 3 138
Dynamics crm 5 64
Duplicate Detection - CRM 2011 2 64
This is a walkthrough guide I wrote whilst upgrading my on-premise MS Dynamics CRM 3.0 deployment to 4.0. This covers the actual installation of the product to a working level for my system, I ran into a lot of issues that the steps below fixed so h…
Getting data out of MAS90 doesn’t have to be tedious or time consuming.  With any version of Excel using the included Microsoft Query function, you can access just about any data set or combination of data sets stored in your MAS90 MAS200 Software. …
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question