

Place FIELD.DDF, FILE.DDF, and INDEX.DDF in the same directory as the four populated ManageWise Inventory database files. DDF files include the database and key structures of the four ManageWise inventory database files in Btrieve's format.Īdditionally, MW21_DDF.ZIP contains a FORMATS.DOC file that gives an overview of the ManageWise Inventory database file details. DDFs are Data Definition Files and they contain the internal schema necessary to read and export Btrieve files into Crystal Reports. It is also assumed that Crystal Reports is installed on the ManageWise 2.x Console workstation, because the ManageWise Console will already have Btrieve installed and properly configured.Ĭomplete the following steps to set up Crystal Reports:Įxtract MWS002.EXE then unzip MW21_DDF.ZIP to get the three DDF files (FIELD.DDF, FILE.DDF, and INDEX.DDF). For this AppNote, it is assumed that Crystal Reports 6.0 is being used. Seagate Crystal Reports, running on a Windows workstation with Btrieve installed and properly configured. This file contains the database schema for the ManageWise Inventory database.

The default directory for these files is SYS:MW\LDT on your ManageWise inventory server. You will need the four populated ManageWise 2.x Btrieve Inventory database files, which are: Setting Up the Softwareįollow these instructions to obtain the ManageWise inventory database files and to set up Crystal Reports. and detailed information on Crystal Reports. The References section at the end of this AppNote lists where to get additional information on ManageWise 2.x. Accordingly, ManageWise will be referred to as ManageWise 2.x throughout this AppNote, unless a feature is specific to a certain version of ManageWise. The latest shipping version of ManageWise is 2.6 however, the procedures outlined in this AppNote will work with any version of ManageWise 2.x. Also, this is not intended to be a complete tutorial on Crystal Reports, nor does it walk through its installation process.

It is assumed that you already have the inventory component of ManageWise 2.x installed and are familiar with its functionality. Much of the information contained in this AppNote can be applied to other reporting software, such as Microsoft Access. This AppNote introduces the use of Seagate's Crystal Reports 6.0 product for creating custom ManageWise inventory reports. However, many customers want to generate specific reports that are unique to their company's business needs. ManageWise 2.6 ships with the tools necessary to generate ManageWise Inventory reports (the Query Tool on the ManageWise Console and Kansmen's SyncComplete product). If you've ever wanted to design your own custom reports from the inventory information gathered by ManageWise, this AppNote will tell you how.
