Reporting for Microsoft Great Plains/Dynamics/eEnterprise: RW ReportWriter tips for developer

Microsoft Business Solutions Great Plains is written in Great Plains Software programming tool: Great Plains Dexterity.  Dexterity in turn was built with conception of graphical cross-platform transferability (in time 1992 mostly Mac and MS Windows).  Plus Dexterity had database abstraction level (through C programming language).  The result of such a shrewd future-looking architecture Great Plains ReportWriter has multiple restrictions and drawbacks.

Lets first look at the advantages of using ReportWriter:

  • Seamless integration with Great Plains forms the most typical scenario you modify SOP_Long_Invoice_Form or SOP_Blank_Invoice_From and then print your invoices with modified form usually with your logo and changed formats and positions of the fields
  • Parameters Entry Forms.  Each existing report (Reports section) has associated parameters entry form. 

Restrictions:

  • No Cross-Modules links.  You can not associate report with the tables from non-related modules.  For example you can not have Sales Order Processing (SOP) and Purchase Order Processing data on the same report (you actually can but you need Dexterity programmer help)
  • Custom Reports.  You do not have parameters entry interface for your custom reports, but you could use restrictions to restrict the selection.  Custom reports could be used to export data from Great Plains in text (and then Excel format)

Advanced ReportWriter programming

  • Rw_ functions in Great Plains Dexterity.  When you need cross-modules data on the same report (Bill of Lading, which you could produce on the base of Picking List) you need to move the report you want to customize into your custom DYNAMICS.DIC and fill the gaps with RW_ functions these are allowed to be placed on the report with parameters

If ReportWriter doesnt do the job:

  • Crystal Reports.  Current version 8.0 and 8.5 (July 2005) are MS SQL Server based, where Crystal Report could work at will and produce all the desired links we recommend you to base Crystal Report on SQL Stored Procedure or SQL View.  You call Crystal Report engine via Modifier/VBA you need Customization Site Enabler license.  If you are on Great Plains Standard version: 7.5, or Great Plains Dynamics/eEnterprise 7.0, 6.0, 5.5 or 5.0 Btrieve/Pervasive SQL/Ctree you need to install Pervasive SQL driver (or Faircomm driver for Ctree)

Good luck with implementation, customization and integration and if you have issues or concerns we are here to help!  If you want us to do the job - give us a call 866-528-0577 or 630-961-5918! help@albaspectrum.com


Reporting for Microsoft Great Plains/Dynamics/eEnterprise: RW ReportWriter tips for developer

Comments

Post a Comment

Popular posts from this blog

Advantages and Advice About Online Degrees

Image
Many people today, are engaging in some form of ... ... The ... and ... are full of books and articles on how to be a better human being. If you want to be ... y Many people today, are engaging in some form of self-improvement activity. The bookstores and magazines are full of books and articles on how to be a better human being. If you want to be healthier, you diet. If you want to feel younger, you exercise. To expand our horizons, we travel or learn a foreign language. While these are all worthwhile activities, perhaps none are as important as continuing your education. Online education is no longer the wave on the future. It is here now! Around the country and, indeed, around the world, most colleges and universities provide some or all of their classes on the Internet. Some schools provide an entire degree program online. Many people today, from all walks of life, are getting an online college degree by taking these classes at home. Not long ago, distance learning was perceived a...
Read more

Quantum Speed Reading

Image
Quantum speed readingis just the latest way of reading books without opening the pages. It had created in Japan, and it has trained to both adults and kids for many years. Unlike the many more successful types of speed reading which are around QSR doesn't need the guide opened whatever. The book is only organised before the audience's experience. As well as the pages are turned quickly utilising the flash like when getting ready to mix credit cards. It's so really an innovative development in education. Quantum speed readingis just the latest way of reading books without opening the pages. It had created in Japan, and it has trained to both adults and kids for many years. Unlike the many more successful types of speed reading which are around QSR doesn't need the guide opened whatever. The book is only organised before the audience's experience. As well as the pages are turned quickly utilising the flash like when getting ready to mix credit cards. It's so real...
Read more

Indiareads Helping people avail books on rent to afford a better education

Indiareads is an online store that provides books on rent. The company is one its own kind of online store and provides almost 1.8 lakh titles of books across academics, literature and competitive exams genre. The online store that went live as a book rental website in 2014 provides books in almost every category to people across the country. Here you can avail academics as well as competitive books on rent and you get the facility for one month or even one year. Indiareads is one of its own kinds of service provider and makes available books in some most productive categories. The online store exists to provide books at cheap rents and takes special pride in helping people afford books on cheap rates to get best education. A perfect place for students to rent books on cheap rates- India is one country that ranks quite low on education. Here, many school going children does not get proper education due to lack of availability of books. It’s not about only kids there are millions ...
Read more