Great Plains Consultant: Crystal Reports Design

Microsoft Dynamics GP, or former ERP name is Great Plains Software Dynamics / eEnterprise gives you, programmer or software developer vide spectrum of report design tools: Crystal Reports, Microsoft SQL Server Reporting Services, GP ReportWriter, MS Access, MS Excel to name some of the popular. 

In this small technical paper we would like to introduce you into Crystal Reports design for Dynamics GP, assuming that you are new to GP and need some starting help.  We also assume here, that you are on MS SQL Server Database: GP 10.0, 9.0 and 8.0, if you are on GP 7.5 and earlier: 7.0, 6.0, 5.5, 5.0 or 4.0 where Great Plains was available on Ctree or Pervasive SQL/Btrieve, please review database connection options, described in our earlier articles ? you will need to install Ctree/Faircom or Pervasive ODBC drivers.  Let’s come back to Crystal for GP on MS SQL Server:

SQL Data Recovery - The Role Of This Software Tool

Ensuring that a database is up and running again as early as possible in the event of failure with SQL data recovery software

Even with the intrinsic data protection available in an SQL server database system the requirement of SQL data recovery cannot be entirely avoided. Even with the provision of other data security measures such as RAID (redundant array of disks), hard disk crashes, power-related and other inadvertent failures can result in corruption of the master data file and even the backup file of an SQL database.

Great Plains Installation and Implementation overview

Microsoft Dynamics GP, or also commonly known as Great Plains is Microsoft SQL Server database application and at the same time it has its own IDE and programming language, known as Great Plains Dexterity. 

Dexterity in turn is written on C as a shell.  Recent versions, such as 10.0, 9.0 are tightly integrated with Microsoft Outlook, plus version 10.0 has integration with Sharepoint and SQL Server Reporting Services (or SRS).  Having said that, however we would like to inform you that installation itself is streamlined and not overly difficult.  Let’s review:

Close
E-mail It