Solved

FRx Report Designer Error

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

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…
As an accountant it is essential that I am able to provide accurate and timely information to management and staff.  One of the challenges that I have faced is the need to report on a time period, whether it be a month, quarter, or year, and wanting…
Delivering innovative fully-managed cloud services for mission-critical applications requires expertise in multiple areas plus vision and commitment. Meet a few of the people behind the quality services of Concerto.
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…

932 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now