Specifications

Creating Custom Reports with Excel
PlantScape Server and Client Configuration Guide 269
– Point parameter: pv
6 Click Add, then Next to display the next step.
7 Fill in the fields as follows:
– history type: Fast History Snapshots
– number of values: 20
– offset: 1
– Arrange data: vertically
– for all other fields accept the default.
8 Click Finish to display the result.
9 To include the date-time at the which the report is run, select an empty cell
and type Now().
Saving the Report Definition File
1 In Microsoft Excel go to File
⇒
Save As.
2 Browse to the server\user folder and enter sinewave as the filename.
3 Click OK and Exit Microsoft Excel.
Configuring the Report on Station
Note If you have a report definition file that was created by a user
account other than mngr, you need to:
a) Ensure you are logged on to Windows as mngr.
b) Open the workbook in Microsoft Excel.
c) Click Tools
⇒
Microsoft Excel Data Exchange
⇒
Update Formulas
in Workbook.
d) Save the workbook.
1 Start Station and log in at mngr security level.
2 Go to Configure
⇒
Reports. This opens the Reports display (see
“Configuring Reports” on page 242).
3 Go to an unassigned report row and click the Configure button.
4 In the Definition tab, complete the following:
– add a title and a name
– select Microsoft Excel from the Report type list.
– enable reporting on request
5 Click the Content tab.
6 Enter the full path to the file, sinewave.xls, saved above. For example,
C:\server\user\sinewave.xls.
plscpcg.book Page 269 Monday, May 28, 2001 10:11 AM