Failed to launch Report Designer in Great Plains

Posted on 2008-10-03
Last Modified: 2013-12-11
When i try to run FRx within Great Plains I get the drilldown viewer appear rather than the report designer. How do setup frx within Great plains as i cant seem to associate the report designer to great plains.

Question by:nrafiq1
  • 6
  • 2

Expert Comment

by:James Glaubiger
ID: 22641466
FRx is an external reporting application that just looks at the SQL data for GP, similar to Crystal Reports.   They both use ODBC or some other connector to pull the data they need from the database.   There is no integration between FRx and GP to launch reports, treat them as seperate applications.

Expert Comment

by:James Glaubiger
ID: 22641784
The Navigation Bar does let you setup external shortcuts, you might be able to create a shortcut in GP that launches the Report Designer.

Expert Comment

by:James Glaubiger
ID: 22641792
I am also going to have to retract my previous statement about no integration at all.   There is one setup window for FRx in GP.

Reports>>Financial>>FRx and enter the location of the exe file in the setup window.

hope this helps

Author Comment

ID: 22647681
That is the problem I done get the setup window when I launch

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails


Expert Comment

by:James Glaubiger
ID: 22651575
Please attach a screenshot of your FRx setup screen in GP.

Expert Comment

ID: 22664976
In the installation directory of GP look for FRXDYN.INI (this is where Dex.INI is as well) and the path should be pointing to FRx32.exe. For example:

[Frx Launch]
:C:Program Files/FRx Software/FRx 6.7/FRx32.exe

Expert Comment

by:James Glaubiger
ID: 22665228
I think it is more likly that he needs to look at the shortcut created by FRx installer on the desktop which launches Report Designer, right click it and select properties.  Look at the target and commands typed in there.   Compare this with what is in the FRx setup screen or create a Shortcut in the Navigation bar

Expert Comment

by:James Glaubiger
ID: 22670629
Should be the path in your FRx Setup Screen in GP
"C:\Program Files\FRx Software\FRx 6.7\FRx32.exe"
Or it needs to be adjusted for the location you have FRx installed to.

Accepted Solution

c0sm1cp1nball earned 250 total points
ID: 22673910
When GP is installed, FRX is already added in the GP menus (Reports > Financial > FRX) but it does not work yet. The first time you click on it in GP, GP will prompt you for the executable file for FRX and the FRXDYN.ini will be created. And yes, the path is correct as this is how the path is written for the GP  report dictionary files in the dynamics.set file for GP. FRX is a GP add-in but it is not installed like the common ones where you just add a CNK file in the GP code folder so in effect, it has it's own INI file

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

Suggested Solutions

Title # Comments Views Activity
Hiring a Canadian to work in Canada for my U.S. business 3 85
crm 2016 on cloud 5 73
CRM 2011 SSRS Question 12 85
SSRS Problems 9 27
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…
Read about achieving the basic levels of HRIS security in the workplace.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor ( If you're interested in additional methods for monitoring bandwidt…

746 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

10 Experts available now in Live!

Get 1:1 Help Now