Specifications

13 – Configuring Reports
268 R400
Configuring the Report Details
Microsoft Excel reports, like other PlantScape reports, need to be configured on
Station. This is done on the Microsoft Excel Report Configuration display.
To configure an Microsoft Excel report:
1 Click the Definition tab (see “Configuring a New Report” on page 243) and
enter the report definition details.
2 Select Microsoft Excel from the Type selection list.
3 Click the Content tab.
4 Fill in the Definition File field with the full path name of the report
definition file.
Example Using Microsoft Excel reports with Microsoft Excel Data Exchange.
This example leads you through the steps involved in producing an Microsoft
Excel report which uses Microsoft Excel Data Exchange to access the server
database. It assumes that you have already completed the installation of your
PlantScape system. In particular that you have:
• Installed Microsoft Excel and Microsoft Query on the server.
• Enabled Microsoft Excel Data Exchange on the server using the Windows
mngr account (see “Enabling Microsoft Excel Data Exchange under
Different User Accounts” on page 457).
• Disabled the Ask to update automatic links prompt on Microsoft Excel.
This report retrieves the last 20 history values of a system sinewave point.
Before continuing, configure a system sinewave point, called sinewave, and
assign it to fast history. For details on how to do this see “Using PlantScape
ODBC Driver and Microsoft Access” on page 408.
Creating the Report Definition File
To create a report definition file which retrieves the last 20 fast history values of the point
ID “sinewave”.
1 Log in using the mngr user account.
2 Start Microsoft Excel.
3 Choose Tools
⇒
Microsoft Excel Data Exchange
⇒
Wizard.
4 Select Get history values from server(s) and click Next.
5 Fill in the fields as follows:
– Server: localhost
– Point ID: sinewave
plscpcg.book Page 268 Monday, May 28, 2001 10:11 AM