CustomReport_AlarmsEvents_SQL is a simple project designed to show how to use a custom report to display alarms/events stored in an SQL database. Within the System device, a tag named Level is defined. This tag has its operating limits fixed. There are also four alarms defined within the System device. The alarms are triggered when the Level tag's operating limits are exceeded. A custom report named Report

basic is defined via the Custom Report Manager.

To retrieve data from the database, objects named ADODatabase1 and ADOQuery1 are used in the Custom Report Designer. The connection to the SQL database defined in the ADODatabase1 object is automatically synchronized with the setting defined via Reliance's Project Options dialog box. The appearance of the alarm/event table is specified through two bands. The top band named PageHeader specifies the column header and the bottom band named MasterData specifies the data to display. To display data in the bands, objects of type TfrxRAEMemoView are used (Alarm/Event Table Column Text object). To configure the displayed table, there are two important properties named RAEDataField and RAETitle in those objects. The RAEDataField property specifies the data field (column) of an alarm/event's record, the RAETitle property determines whether to display the data field's title instead of data. The RAETitle property is active in the PageHeader band.

At runtime, you can change the Level tag's value in the visualization window.