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:

Reuters India

Whistleblower details alleged Oracle contract violations
San Jose Mercury News
Oracle salespeople used a variety of questionable tactics to hide the fact they were overcharging the federal government for software, ...
DOJ Joins Suit Accusing Oracle of Overcharging USNew York Times (blog)
US suing Oracle alleging software contracts fraudThe Associated Press
US accuses Oracle of software contract fraudAFP
IT Business Edge (blog) -BusinessWeek -ZDNet UK
all 316 news articles »


CNET (blog)

Sony, McAfee, sued over software activation patent
CNET (blog)
In a suit filed in US District Court in the eastern district of Texas Thursday, Uniloc is alleging that its patent for software activation is being violated ...
Irvine's Uniloc Sues Sony, Activision Blizzard, OthersOrange County Business Journal
Sony, Activision, Others Sued Over Software Activation By UnilocNASDAQ
Uniloc USA Inc. Files Patent Infringement Lawsuit against Sony America, McAfee ...MarketWatch (press release)
Barron's (blog) -Techconnect Magazine (blog)
all 21 news articles »


Software maker SAP completes Sybase acquisition
BusinessWeek
German business software maker SAP AG said Friday it has completed its $5.8 billion acquisition of US database software maker Sybase Inc. SAP, ...
SAP closes buy of US business software firm SybaseTMCnet
SAP acquires SybaseTrading Markets (press release)

all 25 news articles »


Quest Software shares jump after solid 2Q results
The Associated Press
NEW YORK — Shares of Quest Software Inc. got a boost Friday after the business software maker posted better-than-expected second-quarter results. ...

and more »


msnbc.com

Security experts release software to attack Android phones
Apple Insider
A day ago, security researchers at Lookout reported the potential for mobile software to take invisible actions that users were not aware were happening, ...
Software released for attacking Android phonesReuters (press release)
Software released to attack Android phonesCIOL

all 33 news articles »


Moneycontrol.com

Adobe Buys Day Software
SYS-CON Media (press release) (blog)
Swiss-based web content management (WCM) house Day Software Holding AG got bought Wednesday by Adobe for roughly $240 million (255 million Swiss francs). ...
Adobe to Launch $240 Million Tender Offer for Day SoftwareWall Street Journal
Adobe acquires Web software maker for US$240 millionBusinessWeek
Adobe agrees to buy Day SoftwareBoston Globe
San Jose Mercury News -Reuters -The Mac Observer
all 237 news articles »




SYS-CON Media (press release) (blog)

SAP Warms to Open Source
PC World
In 2005, Shai Agassi, then the SAP executive in charge of the company's product group, expressed ambivalence over using open-source software. ...
SAP Trails Oracle; Its On-Demand Widgetry About to PopSYS-CON Media (press release) (blog)

all 8 news articles »


Software AG: webMethods License Revenue Doubles in the U.S. in Q2
MarketWatch (press release)
Software AG continued to show strong growth in Q2 2010. The high growth was driven by the webMethods business division. In the US, webMethods license ...

and more »

Google News

Home | Site Map

Powered By: Free Work At Home Business Opportunity!

© 2006