Solved

FRx Report Designer Error

Posted on 2010-09-23
4
1,132 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
  • 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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

Suggested Solutions

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. …
Automatically creating a Trello card using data from a Microsoft Dynamics CRM record turned out to be an easy project that yielded great results.  Here's how I did this for an internal team at General Code.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

803 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