11
12-10-2 Compound Relation Hierarchy example: ............................................................................ 198
12-10-3 Hierarchy with Aggregate example: .................................................................................... 198
12-10-4 Group Hierarchy example: ................................................................................................. 198
12-10-5 Group Hierarchy with Aggregate example: ........................................................................ 198
12-10-6 Multiple Groupings example: ............................................................................................. 199
12-10-7 Grand Total example: ......................................................................................................... 199
12-10-8 Grouped Parent Related to Grouped Child example: ........................................................ 199
SECTION 13
CFR (Title 21 Part 11) Functionality ........................................201
13-1
Overview .......................................................................................................................................... 201
13-2
Supported Databases ...................................................................................................................... 201
13-3
CX-Supervisor Runtime User and Audit Trail UserID ...................................................................... 201
13-4
Creating / Running a CFR Application (Microsoft Access)............................................................... 202
13-4-1 CFR Test Application .......................................................................................................... 202
13-4-2 Configuring Points for Audit ................................................................................................ 203
13-4-3 Default Audit Trail Configuration ......................................................................................... 203
13-4-4 Default Connection String ................................................................................................... 204
13-4-5 Logged In User ................................................................................................................... 205
13-4-6 Starting and Stopping an Audit Trail ................................................................................... 205
13-4-7 Running the CFR Test Application and Logging to an Access Database........................... 205
13-4-8 Viewing the Audit Trail Database........................................................................................ 206
13-4-9 Audit Trail Configuration Settings – Alarms Errors and Events .......................................... 207
13-4-10 Configuring Alarms for Audit Trail Records......................................................................... 207
13-4-11 Generating Errors and Events in Audit Trail Records ......................................................... 209
13-4-12 Running the CFR Test Application to Generate Alarm Error and Event Records............... 209
13-4-13 Viewing the Alarm Error and Events Data Tables............................................................... 210
13-5
Logging Audit Trails to an SQL Database ........................................................................................ 210
13-5-1 SQL Server Database Prerequisites................................................................................... 211
13-5-2 Creating an SQL Server Test Project ................................................................................. 211
13-5-3 Connection String for an SQL Database............................................................................. 212
13-5-4 Running an SQL Server Test Project.................................................................................. 213
13-5-5 Viewing Audit Trail Records in an SQL Server Test Project ............................................... 213
13-6
Further Settings and Configuration .................................................................................................. 213
13-6-1 Database File Location ....................................................................................................... 214
13-6-2 Microsoft Access Database File Management.................................................................... 214
13-6-3 Audit Trail Notes ................................................................................................................. 215
13-6-4 SQL Statements.................................................................................................................. 216
13-7
How to Access Information from a CFR Database .......................................................................... 217
13-7-1 Using CX-Supervisor .......................................................................................................... 217
13-7-2 Using Microsoft Excel ......................................................................................................... 218
13-8
Limitations ........................................................................................................................................ 221
SECTION 14
Standard Web Pages ...................................................................223
14-1
Overview .......................................................................................................................................... 223
14-2
Access.............................................................................................................................................. 223
Содержание CX-Supervisor
Страница 1: ...CX Supervisor Software Cat No W10E EN 01 User Manual Software Release 3 1...
Страница 3: ...Copyright Notice 2...
Страница 16: ...15...
Страница 17: ...16...
Страница 27: ...Tip of the Day SECTION 1 Graphics Editor 26...
Страница 35: ...CX Supervisor Preferences SECTION 2 Pages 34...
Страница 79: ...Responding to Events SECTION 5 ActiveX Objects 78...
Страница 115: ...Printing the Graphics Library SECTION 7 Graphics Library 114...
Страница 181: ...Data Logging SECTION 11 Data Logging 180...
Страница 201: ...Examples SECTION 12 Databases 200...
Страница 243: ...Performance Monitor SECTION 16 Application Analysis Performance Monitor 242...
Страница 253: ...Using with Omron s CX Server OPC SECTION 17 Using CX Supervisor as an OPC Cli 252...
Страница 259: ...Creating a CX Supervisor Client application SECTION 18 Connecting to a remote CX 258...
Страница 263: ...Adding a Point Linked to a Parameter SECTION 19 Connecting to Omron Industrial 262...
Страница 271: ...Data Logging SECTION 20 Best Practices 270...
Страница 275: ...Configuring a Server PC running Windows NT or 2000 Appendix A Configuring a PC 274...
Страница 277: ...Appendix B Frequently Asked Questions 276...
Страница 296: ...Appendix B Frequently Asked Questions 295...
Страница 297: ...Appendix B Frequently Asked Questions 296...
Страница 298: ...Appendix B Frequently Asked Questions 297...
Страница 299: ...Appendix B Frequently Asked Questions 298...
Страница 333: ...Revision history 332...