Solved

FRx Report Designer Error

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

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

If you need to import sales transactions from another system into Microsoft Dynamics GP as Sales Order Invoices, you may need to store some additional data related to the customer, the transaction, or the line items.  Even if your company is manuall…
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.
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

743 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

11 Experts available now in Live!

Get 1:1 Help Now