Software Information

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


MORE RESOURCES:

IEWatch Software LLC Has Released WebReplay 2.0
PR Web (press release), WA - 2 hours ago
IEWatch Software LLC has released WebReplay 2.0, a plug-in for the Internet Explorer browser that allows automated web surfing, form filling, ...


Voting software does not ensure accountability
Albany Times Union, NY - 5 hours ago
Software experts have proven that votes cannot be secured on any electronic voting equipment. Vote manipulation was found despite these machines being ...


Software helps 'observant'choppers
Times of India, India - 15 hours ago
The researchers have revealed that their software could learn and flawlessly replicate more than 20 years of radio-controlled helicopter expertise in just ...


A Charity Fails Families Of Fallen Firefighters After 9/11
Hartford Courant, United States - 52 minutes ago
Careaga, a one-time volunteer firefighter and reserve police officer, had been trying to make money selling computer software to rural fire departments in ...


Advent Software to buy Tamale
San Antonio Business Journal, TX - 16 hours ago
Advent (NASDAQ: ADVS), which makes financial software, is based in San Francisco and is led by CEO Stephanie DiMarco. Privately held Tamale is based in New ...


Times Online

Open Sauce Software
ZDNet UK, UK - Sep 5, 2008
Chrome is still my default browser, and there are everyday things I can't do so easily in it as in Firefox. Perversely. I think what I want is a Google ...
Video: Tech Test: Google Chrome Lacks Polish AssociatedPress
Google sees new browser displacing desktop software Reuters
Google Chrome: A Hit with Online Software Vendors CIO
Seeking Alpha - Chicago Tribune
all 3,447 news articles


AFS Technologies gains 2 tech firms, raises funds
Arizona Republic, AZ - 5 hours ago
7, 2008 12:00 AM Phoenix-based software firm AFS Technologies Inc. recently acquired two technology firms and raised $38 million in debt and private-equity ...


News 8 Austin

Happy birthday, Google - now you can take on the world
guardian.co.uk, UK - 10 hours ago
In its original (early 1990s) form, a browser was software that provided a passive window on to the web: a way of reading web pages. ...
Video: Tech Test: Google Chrome Lacks Polish AssociatedPress
Web Visitors Swarm Google Chrome InformationWeek
What Cloud Computing Needs Motley Fool
Independent - CNET News
all 251 news articles


InternetNews.com

Sun Microsystems Hopes to Shake Up Storage Industry
New York Times, United States - 18 hours ago
Its systems, once so prized during the Internet buildout, were spurned as cheaper servers packed with open source software caught customers’ attention. ...
Sun Microsystems Outpaces Disk Storage Systems Market Nearly Three ... WELT ONLINE
Highest Year-Over-Year Growth in External Disk Storage Systems ... MarketWatch
all 65 news articles


The Boeing Company announced today that it has completed software ...
Azom.com - Sep 6, 2008
"This flight marks the completion of the developmental stage of both the aircraft's hardware and software. We are ready to begin Low Rate Initial Production ...

Software - Google News

home | site map
© 2006