求助PKS系统问题 点击：1263 | 回复：7
发表于：2006-09-15 17:12:00
7楼
Creating the Report Definition File
To create a report definition file which retrieves the last 20 fast history values of the point ID "sinewave".
Log on using the mngr user account.
Start Microsoft Excel.
Select Tools > Microsoft Excel Data Exchange > Wizard.
Select Get history values from server(s) and click Next.
Fill in the fields as follows:
Server: localhost
Point ID: sinewave
Point parameter: pv
Click Add, then Next to display the next step.
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.
Click Finish to display the result.
To include the date-time at the which the report is run, select an empty cell and type Now().
Saving the Report Definition File
In Microsoft Excel go to File > Save As.
Browse to the Program Files\Honeywell\Experion PKS\server\user folder and enter sinewave as the filename.
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:
Ensure you are logged on to Windows as mngr.
Open the workbook in Microsoft Excel.
Click Tools > Microsoft Excel Data Exchange > Update Formulas in Workbook.
Save the workbook.
Start Station and log on at mngr security level.
Go to Configure > Reports. This opens the Reports display (see Configuring Reports).
Go to an unassigned report row and click the Configure button.
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
Click the Content tab.
Enter the full path to the file, sinewave.xls, saved above. For example, c:\Program Files\Honeywell\Experion PKS\server\user\sinewave.xls where c is the drive where you saved the file (see Saving the Report Definition File).
To create a report definition file which retrieves the last 20 fast history values of the point ID "sinewave".
Log on using the mngr user account.
Start Microsoft Excel.
Select Tools > Microsoft Excel Data Exchange > Wizard.
Select Get history values from server(s) and click Next.
Fill in the fields as follows:
Server: localhost
Point ID: sinewave
Point parameter: pv
Click Add, then Next to display the next step.
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.
Click Finish to display the result.
To include the date-time at the which the report is run, select an empty cell and type Now().
Saving the Report Definition File
In Microsoft Excel go to File > Save As.
Browse to the Program Files\Honeywell\Experion PKS\server\user folder and enter sinewave as the filename.
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:
Ensure you are logged on to Windows as mngr.
Open the workbook in Microsoft Excel.
Click Tools > Microsoft Excel Data Exchange > Update Formulas in Workbook.
Save the workbook.
Start Station and log on at mngr security level.
Go to Configure > Reports. This opens the Reports display (see Configuring Reports).
Go to an unassigned report row and click the Configure button.
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
Click the Content tab.
Enter the full path to the file, sinewave.xls, saved above. For example, c:\Program Files\Honeywell\Experion PKS\server\user\sinewave.xls where c is the drive where you saved the file (see Saving the Report Definition File).
热门招聘
相关主题
- 请教关于水厂监控
[6444] - plc与dcs连接？[2383]
- 设备要求预留DCS接口，你怎么...[3146]
- DCS集散系统故障防范与维护措...[3144]
- 屏蔽线接在哪里抗干扰更好？[5701]
- 请问PLC与DCS在现代控制系统...[7599]
- ABB AC800M[5160]
- 求助：西门子PCS7该用PLC S40...[1830]
- 一起看一下ABB AC800系统[12747]
- 浙大中控计算机安装规范[3060]
官方公众号
智造工程师
-
客服
-
小程序
-
公众号
工控网智造工程师好文精选
