Owner Mapping

SQL Delta 3.1 now provides object ownership mapping and now it is possible to perform comparisons between databases with different users and different ownership configurations. The user can map on a user to user basis or a many to one user basis and there is no limit to number of users that can be mapped.

Other New Features

Improved tools such as “star view” checking to ensure all views that may use “select * ..” are up to date and a qualify names tool for checking to see if stored procedures include qualified names, therefore ensuring best performance from your server.

Advanced ReportWriter programming

• Rw_ functions in Great Plains Dexterity. When you need cross-modules data on same report (Bill of Lading, which you could produce on base of Picking List) you need to move report you want to customize into your custom DYNAMICS.DIC and fill gaps with RW_ functions – these are allowed to be placed on report with parameters

If ReportWriter doesn’t do 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 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 job - give us a call 866-528-0577 or 630-961-5918! help@albaspectrum.com