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.

Let's 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 doesn't 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

Andrew is Great Plains specialist in Alba Spectrum Technologies ( http://www.albaspectrum.com ) ? Microsoft Great Plains, Navision, Microsoft CRM Partner, serving clients in California, Minnesota, Illinois, Washington, Florida, Arizona, New York, New Jersey, Virginia, Georgia, Louisiana, Texas, Canada, UK, Australia, Brazil, Germany, Russia

In The News:


pen paper and inkwell


cat break through


Microsoft Great Plains Food Processing ? Implementation & Customization Highlights

Microsoft Great Plains might be considered as ERP platform to... Read More

Two Reasons to Use Timesheet Software

This short paper will expand on two key reasons to... Read More

Microsoft CRM Integration with IBM Lotus Notes Domino ? Machinery Dealership Example

IBM Lotus Notes with Domino email server is traditional document... Read More

Microsoft Blues

With the advent of 'Service Pack 2' for Windows XP... Read More

Dont Choose Adobe When Working With PDF

While Adobe is the most known maker of PDF tools,... Read More

Microsoft Great Plains Customization: Project Organization ? International Business Example

Microsoft Business Solutions Great Plains fits to majority of horizontal... Read More

Microsoft Great Plains Security Setup - Overview For Consultant

Microsoft Business Solutions Great Plains is very good fit for... Read More

Think Of This

Think of this, first we had the HAM Radio, then... Read More

Vlans

In order to implement VLANs in a network environment, you'll... Read More

Best Practices In Choosing Network Monitoring Software

Blue Cross and Blue Shield of Hawaii (HMSA) found itself... Read More

The XP Firewall Isnt Enough

You might think you don't need a firewall... Read More

You Can Write Microsoft Office Program in About 60 Minutes

Microsoft Office program is a programming tool called Visual Basic... Read More

Beware of The Pirated Software E-Mail Scams!

You have gotten those E_Mails buy software at deep discounts.... Read More

Make 2005 the Year You Save Time!

Today's business world is fast-paced. No matter what it is... Read More

Microsoft Small Business Manager Customization Options - Overview

Microsoft Business Solutions Small Business Manager is Great Plains Dexterity... Read More

Microsoft Great Plains Implementation ? Overview for IT Director/Controller

What is installation in the language of technology? Installation... Read More

Microsoft Great Plains Middle East - Arabic Language Support

Microsoft Business Solutions Great Plains is marketed for mid-size companies... Read More

Recent Studies Show that 9 out of 10 PCs Are Infected with Spyware

Spyware and malware are large problems for Internet users today... Read More

Spyware - The Internet Devil Of Our Times!

Spyware and Adware infest over 90 percent of computers in... Read More

Internet Faxing Service Review

The Internet is reshaping every form of communications medium, and... Read More

History of Java

The java programming language is becoming more and more popular... Read More

Introducing GRML

Creating a new markup language.Introduction.General Reuse Markup Langauge, or GRML,... Read More

Microsoft Great Plains Customization Tools ? Overview

Former Great Plains Software Dynamics/eEnterprise, and currently Microsoft Business Solutions... Read More

What is Spyware? Are You Being Watched?

Find out why Spyware Removal from computers is important and... Read More

Document Templates Give You The Perfect Framework For Your Documents

When it comes to running an office, the SOHO entrepreneur... Read More

Importance of Coding Standards

Programming Help for BeginnersWe write programs to instruct computers. When... Read More

Algebra Help Software

Need help making sense of algebra? Have algebra lectures in... Read More

Demand More From Your Lead Tracking Software

An integral part of any quality CRM system is lead... Read More

Off The Record - Tips For Picking Recording Software

Need software to record your voice, streaming audio or musical... Read More

Behave, Word, Behave!

If you copy something from a Web site or elsewhere...... Read More

About Microsoft Sysprep (System Preparation) Utility (Windows 2000)

The Microsoft system preparation utility for Windows 2000 is a... Read More

Reloading Windows XP

If you have been running Windows XP for a couple... Read More

Anti-Virus Software

Anti-virus software is used to find, remove or fix files... Read More