Great,Plains,Consultant,FRx,te computer Great Plains Consultant: FRx technical notes for Programmer
----------------------------------------------------------Permission is granted for the below article to forward,reprint, distribute, use for ezine, newsletter, website,offer as free bonus or part of a product for sale as longas no changes a Gone are those times when the companies and the organisations didn't need a hi-tech system to handle them. Owing to the considerable increase in the business sector and thus, an enormous increase in the complexity of the organisational struc
Surprisingly, but we saw some interest in FRx metadata extraction. This is when you are trying to replicatereports, originally designed in FRx, in other tools: Crystal Reports, MicrosoftSQL Server Reporting Services or SSRS. Thereare numerous pitfalls in that direction, for example, you will need to understandhow to switch GL20000 table for open year reports to GL30000 for historicalyear reports, but assuming that you really need full control in your customreports, this small publication gives you highlights on how to extract FRxmetadata: 1. SpecificationSet file. Please launch FRx ReportsDesigner, login and in menu Company->Information, and read Specification Setname in FRx System Information. Thenagain in Company->Specification Sets in Location field read file name,something like FRxRpts.f32. This filestores FRx metadata for all the companies, located in the Specification Set 2. Well,what is next, how do I open this file? Surprisingly enough FRx for Great Plains metadata is stored in MicrosoftAccess format. Please, do not open thisfile in MS Access directly in you SysData directory. Instead copy the file, in order not todestroy your production FRx system, and open the copy. This file is password protected, we do nottrain you on MS Access password retrieving, assuming that you are experiencedin that 3. ReadingFRx metadata. Likely that your concernis Row Formats, because such things as Column Layout is easy topic in SQL Viewor Stored Procedure. Such tables as RowMaster, Row Link Detail should give you perfect ideas on how to build SQL Queryon FRx report replication. One comment,as this may be a puzzle to resolve. In FRxyou may use Account Sets. Look forrecords, prefixed with SET word in Link column of Row Link Detail table. You should link those records withAccSetMaster table, where Account Sets are described 4. Ifyou need help with FRx reports design, upgrade, modification and general GreatPlains support, feel free to call us: 1-866-528-0577, [email protected]
Great,Plains,Consultant,FRx,te