complete remodeling services harvard tri state remodeling additions to double wide homes remodel green oaks split level home kitchen remodel .. Chicago Drug testing

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:

Free Preventive Maintenance Software

While several preventive maintenance software manufacturers offer free trials for... Read More

These Items Are A Must Before Making The Decision To Purchase Any Off-The-Shelf Software

1. What determines the software price? Is it Per Seat... Read More

Monitoring Software Can be Used for Spying as Well

We all already got used to computer monitoring both at... Read More

How to Evaluate Staffing Software

If you are in the market for new staffing software,... Read More

Guide to Software Marketing

Intro This concise article will tell you in plain English... Read More

Review on QuarkXpress 6.0

After almost two decades of existence, Quark has become the... Read More

Save Your Resources - Combine Your IM Clients

There are so many different programs that clutter up your... Read More

Causes of ERP Failures

ERP is the acronym of Enterprise Resource Planning. Multi-module ERP... Read More

Tools for Customizing Great Plains

Microsoft Business Solutions ? Great Plains has captured the US... Read More

Software Development in 2005 - Back to the Future

2005 ? Back to the Future.What does the future hold?... Read More

Corporate ERP: Standard vs. Rich functionality ? Microsoft Great Plains

Traditionally we were considering functionally rich systems, such as SAP,... Read More

Crystal Reports For Microsoft RMS ? Overview For Developer/Report Designer

If you are software developer or database administrator - we... Read More

Great Plains DOS Support ? Notes for Consultant

Great Plains Accounting, accounting package for mid-size and small companies... Read More

Not All Project Management Software is Created Equal

The purpose of Project Management Software is to provide an... Read More

Microsoft Great Plains Installation ? Overview for IT Director/Controller

Microsoft Great Plains is main mid-market application from Microsoft Business... Read More

Microsoft Great Plains: Data Conversion & Migration Scenarios ? Overview for Consultant

Microsoft Business Solutions Great Plains serves multiple industries in the... Read More

Basic Tips and tricks for Windows XP

Running Applications in Compatibility Mode With Windows XP, you can... Read More

Make 2005 the Year You Save Time!

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

Getting Patched with Windows Service Pack

Are you one of those people that keeps track of... Read More

7 Things to Consider Before Buying Small Business Accounting Software

The world of small business accounting software can be a... Read More

MCP Market News: Microsoft SQL Server & SQL Reporting Services

Are you ready? SQL Server 2005, the next-generation data management... Read More

Business Plan Software Review: Ultimate Business Planner?

One of the main reasons business owners and entrepreneurs use... Read More

Partitioning, Formatting and Reinstalling in Windows 98

Formatting and reinstalling windows 98 is very easy if you... Read More

The Dirt on Screensavers

Remember back in the days where screensavers were the coolest... Read More

A Case Study on Selecting Contract Management Software

Professional services firm cuts costs and improves productivity with integrated... Read More

retrofit led street lights led wallpacks Pete's produce ..
retrofit led street lights led wallpacks Pete's produce ..