Please note that this functionality is only provided after registering the Gold Tag component of CompuPlants Gold.

After starting Microsoft Access to retrieve the CompuPlants Gold data select "File\Get External Data\Link Tables" as shown in the picture below. You may also select "Import" to import the data a single time. Linking will update the data as it is changed and will likely be more useful.

Select the drop down menu for "File of type:" and select "ODBC Databases". This will bring up another window to select the ODBC database.

Select the CompuPlants Gold database by selecting "cpgold.dsn" from the list. Then select "Ok" to continue.

A list of all the tables in the CompuPlants Gold database should appear. Select the "DBA.plants" to get the plants table which has the plant code and it's corresponding name. Then select "Ok" to continue.

Since we want to make a report for this data goto the "Reports" tab and press the "New" button.

To make this easy we're going to use the Report Wizard so select "Report Wizard" from the list and use the "DBA_plants" table. Then select "Ok" to continue.

Add the "pltno" and "pltnme" fields to the "Selected Fields" on the right. This will make it so that the plant code and name are showing in the finished report.

We don't need any grouping so continue to the next screen.

We want the list to be sorted by plant code so select "pltno" from the drop down list. The default sorting order is ascending so we don't need to change that. This is the last field we need to modify so select "Finish" to skip the rest of the screens.

And there we have it. Below is a picture of what the report will look like. Of course yours will likely have different plants and more of them.

Back to tutorials index