Failed to launch Report Designer in Great Plains

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.

Thanks
nrafiq1Asked:
Who is Participating?
 
c0sm1cp1nballCommented:
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
0
 
James GlaubigerCo-FounderCommented:
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.
0
 
James GlaubigerCo-FounderCommented:
The Navigation Bar does let you setup external shortcuts, you might be able to create a shortcut in GP that launches the Report Designer.
0
Cloud Class® Course: Microsoft Windows 7 Basic

This introductory course to Windows 7 environment will teach you about working with the Windows operating system. You will learn about basic functions including start menu; the desktop; managing files, folders, and libraries.

 
James GlaubigerCo-FounderCommented:
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
0
 
nrafiq1Author Commented:
That is the problem I done get the setup window when I launch

Reports>>Financial>>FRx
0
 
James GlaubigerCo-FounderCommented:
Please attach a screenshot of your FRx setup screen in GP.
0
 
c0sm1cp1nballCommented:
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
0
 
James GlaubigerCo-FounderCommented:
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
0
 
James GlaubigerCo-FounderCommented:
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.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.