<?xml version="1.0" encoding="UTF-8"?>
<report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.23" id="1">
    <property name="createdBy">Eclipse BIRT Designer Version 4.6.0.v201606072122</property>
    <list-property name="propertyBindings">
        <structure>
            <property name="name">odaDriverClass</property>
            <property name="id">59</property>
        </structure>
        <structure>
            <property name="name">odaURL</property>
            <property name="id">59</property>
        </structure>
        <structure>
            <property name="name">odaUser</property>
            <property name="id">59</property>
        </structure>
        <structure>
            <property name="name">odaAutoCommit</property>
            <property name="id">59</property>
        </structure>
        <structure>
            <property name="name">odaIsolationMode</property>
            <property name="id">59</property>
        </structure>
        <structure>
            <property name="name">odaPassword</property>
            <property name="id">59</property>
        </structure>
        <structure>
            <property name="name">odaJndiName</property>
            <property name="id">59</property>
        </structure>
        <structure>
            <property name="name">OdaConnProfileName</property>
            <property name="id">59</property>
        </structure>
        <structure>
            <property name="name">OdaConnProfileStorePath</property>
            <property name="id">59</property>
        </structure>
    </list-property>
    <property name="units">in</property>
    <property name="iconFile">/templates/blank_report.gif</property>
    <property name="bidiLayoutOrientation">ltr</property>
    <property name="imageDPI">120</property>
    <parameters>
        <scalar-parameter name="start_date" id="343">
            <property name="valueType">static</property>
            <property name="isRequired">true</property>
            <property name="dataType">string</property>
            <property name="distinct">true</property>
            <simple-property-list name="defaultValue">
                <value type="constant">1430911320</value>
            </simple-property-list>
            <list-property name="selectionList"/>
            <property name="paramType">simple</property>
            <property name="concealValue">false</property>
            <property name="controlType">text-box</property>
            <structure name="format">
                <property name="category">Unformatted</property>
            </structure>
        </scalar-parameter>
        <scalar-parameter name="end_date" id="344">
            <property name="valueType">static</property>
            <property name="isRequired">true</property>
            <property name="dataType">string</property>
            <property name="distinct">true</property>
            <simple-property-list name="defaultValue">
                <value type="constant">2147483647</value>
            </simple-property-list>
            <list-property name="selectionList"/>
            <property name="paramType">simple</property>
            <property name="concealValue">false</property>
            <property name="controlType">text-box</property>
            <structure name="format">
                <property name="category">Unformatted</property>
            </structure>
        </scalar-parameter>
        <scalar-parameter name="job_card" id="345">
            <property name="valueType">static</property>
            <property name="dataType">string</property>
            <property name="distinct">true</property>
            <simple-property-list name="defaultValue">
                <value type="constant">%</value>
            </simple-property-list>
            <list-property name="selectionList"/>
            <property name="paramType">simple</property>
            <property name="controlType">text-box</property>
            <structure name="format">
                <property name="category">Unformatted</property>
            </structure>
        </scalar-parameter>
        <scalar-parameter name="is_deleted" id="346">
            <property name="valueType">static</property>
            <property name="dataType">string</property>
            <property name="distinct">true</property>
            <simple-property-list name="defaultValue">
                <value type="constant">%</value>
            </simple-property-list>
            <list-property name="selectionList"/>
            <property name="paramType">simple</property>
            <property name="controlType">text-box</property>
            <structure name="format">
                <property name="category">Unformatted</property>
            </structure>
        </scalar-parameter>
        <scalar-parameter name="date_format" id="347">
            <property name="valueType">static</property>
            <property name="dataType">string</property>
            <property name="distinct">true</property>
            <simple-property-list name="defaultValue">
                <value type="constant">yyyy/MM/dd HH:mm:ss</value>
            </simple-property-list>
            <list-property name="selectionList"/>
            <property name="paramType">simple</property>
            <property name="controlType">text-box</property>
            <structure name="format">
                <property name="category">Unformatted</property>
            </structure>
        </scalar-parameter>
    </parameters>
    <data-sources>
        <oda-data-source extensionID="org.eclipse.birt.report.data.oda.jdbc" name="Glam" id="59">
            <list-property name="privateDriverProperties">
                <ex-property>
                    <name>metadataBidiFormatStr</name>
                    <value>ILYNN</value>
                </ex-property>
                <ex-property>
                    <name>disabledMetadataBidiFormatStr</name>
                </ex-property>
                <ex-property>
                    <name>contentBidiFormatStr</name>
                    <value>ILYNN</value>
                </ex-property>
                <ex-property>
                    <name>disabledContentBidiFormatStr</name>
                </ex-property>
            </list-property>
            <property name="odaDriverClass">com.mysql.jdbc.Driver</property>
            <property name="odaURL">jdbc:mysql://localhost:3306/sog</property>
            <property name="odaUser">gis</property>
            <encrypted-property name="odaPassword" encryptionID="base64">V2U3bUpnNkBGYyN3</encrypted-property>
        </oda-data-source>
    </data-sources>
    <data-sets>
        <oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" name="UnifiedDataset" id="655">
            <list-property name="columnHints">
                <structure>
                    <property name="columnName">log_date</property>
                    <property name="analysis">dimension</property>
                    <text-property name="displayName">log_date</text-property>
                    <text-property name="heading">log_date</text-property>
                </structure>
                <structure>
                    <property name="columnName">log_notification_id</property>
                    <property name="analysis">measure</property>
                    <text-property name="displayName">log_notification_id</text-property>
                    <text-property name="heading">log_notification_id</text-property>
                </structure>
                <structure>
                    <property name="columnName">key_log_time</property>
                    <property name="analysis">measure</property>
                    <text-property name="displayName">key_log_time</text-property>
                    <text-property name="heading">key_log_time</text-property>
                </structure>
                <structure>
                    <property name="columnName">notification_desc</property>
                    <property name="analysis">dimension</property>
                    <text-property name="displayName">notification_desc</text-property>
                    <text-property name="heading">notification_desc</text-property>
                </structure>
                <structure>
                    <property name="columnName">key_box_no</property>
                    <property name="analysis">dimension</property>
                    <text-property name="displayName">key_box_no</text-property>
                    <text-property name="heading">key_box_no</text-property>
                </structure>
                <structure>
                    <property name="columnName">fullname</property>
                    <property name="analysis">dimension</property>
                    <text-property name="displayName">fullname</text-property>
                    <text-property name="heading">fullname</text-property>
                </structure>
                <structure>
                    <property name="columnName">job_card</property>
                    <property name="analysis">dimension</property>
                    <text-property name="displayName">job_card</text-property>
                    <text-property name="heading">job_card</text-property>
                </structure>
                <structure>
                    <property name="columnName">sched_field_a</property>
                    <property name="analysis">dimension</property>
                    <text-property name="displayName">sched_field_a</text-property>
                    <text-property name="heading">sched_field_a</text-property>
                </structure>
                <structure>
                    <property name="columnName">sched_field_b</property>
                    <property name="analysis">dimension</property>
                    <text-property name="displayName">sched_field_b</text-property>
                    <text-property name="heading">sched_field_b</text-property>
                </structure>
                <structure>
                    <property name="columnName">lock_description</property>
                    <property name="analysis">dimension</property>
                    <text-property name="displayName">lock_description</text-property>
                    <text-property name="heading">lock_description</text-property>
                </structure>
                <structure>
                    <property name="columnName">contact_cell_no</property>
                    <property name="analysis">dimension</property>
                    <text-property name="displayName">contact_cell_no</text-property>
                    <text-property name="heading">contact_cell_no</text-property>
                </structure>
            </list-property>
            <list-property name="parameters">
                <structure>
                    <property name="name">start</property>
                    <property name="paramName">start_date</property>
                    <property name="nativeName"></property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">-1</property>
                    <property name="position">1</property>
                    <property name="isInput">true</property>
                    <property name="isOutput">false</property>
                </structure>
                <structure>
                    <property name="name">end</property>
                    <property name="paramName">end_date</property>
                    <property name="nativeName"></property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">-1</property>
                    <property name="position">2</property>
                    <property name="isInput">true</property>
                    <property name="isOutput">false</property>
                </structure>
            </list-property>
            <structure name="cachedMetaData">
                <list-property name="resultSet">
                    <structure>
                        <property name="position">1</property>
                        <property name="name">log_date</property>
                        <property name="dataType">date-time</property>
                    </structure>
                    <structure>
                        <property name="position">2</property>
                        <property name="name">log_notification_id</property>
                        <property name="dataType">integer</property>
                    </structure>
                    <structure>
                        <property name="position">3</property>
                        <property name="name">key_log_time</property>
                        <property name="dataType">integer</property>
                    </structure>
                    <structure>
                        <property name="position">4</property>
                        <property name="name">notification_desc</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">5</property>
                        <property name="name">key_box_no</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">6</property>
                        <property name="name">fullname</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">7</property>
                        <property name="name">job_card</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">8</property>
                        <property name="name">sched_field_a</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">9</property>
                        <property name="name">sched_field_b</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">10</property>
                        <property name="name">lock_description</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">11</property>
                        <property name="name">contact_cell_no</property>
                        <property name="dataType">string</property>
                    </structure>
                </list-property>
            </structure>
            <property name="dataSource">Glam</property>
            <list-property name="resultSet">
                <structure>
                    <property name="position">1</property>
                    <property name="name">log_date</property>
                    <property name="nativeName">log_date</property>
                    <property name="dataType">date-time</property>
                    <property name="nativeDataType">93</property>
                </structure>
                <structure>
                    <property name="position">2</property>
                    <property name="name">log_notification_id</property>
                    <property name="nativeName">log_notification_id</property>
                    <property name="dataType">integer</property>
                    <property name="nativeDataType">4</property>
                </structure>
                <structure>
                    <property name="position">3</property>
                    <property name="name">key_log_time</property>
                    <property name="nativeName">key_log_time</property>
                    <property name="dataType">integer</property>
                    <property name="nativeDataType">4</property>
                </structure>
                <structure>
                    <property name="position">4</property>
                    <property name="name">notification_desc</property>
                    <property name="nativeName">notification_desc</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
                <structure>
                    <property name="position">5</property>
                    <property name="name">key_box_no</property>
                    <property name="nativeName">key_box_no</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
                <structure>
                    <property name="position">6</property>
                    <property name="name">fullname</property>
                    <property name="nativeName">fullname</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
                <structure>
                    <property name="position">7</property>
                    <property name="name">job_card</property>
                    <property name="nativeName">sched_job_card</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
                <structure>
                    <property name="position">8</property>
                    <property name="name">sched_field_a</property>
                    <property name="nativeName">sched_field_a</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
                <structure>
                    <property name="position">9</property>
                    <property name="name">sched_field_b</property>
                    <property name="nativeName">sched_field_b</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
                <structure>
                    <property name="position">10</property>
                    <property name="name">lock_description</property>
                    <property name="nativeName">access_point_description</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
                <structure>
                    <property name="position">11</property>
                    <property name="name">contact_cell_no</property>
                    <property name="nativeName">usr_contact_cell_no</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
            </list-property>
            <xml-property name="queryText"><![CDATA[select 
from_unixtime(key_log_time) as log_date,
glam_access_point_log.log_notification_id as log_notification_id,
glam_access_point_log.key_log_time as key_log_time,
glam_notification.notification_desc as notification_desc,
glam_access_object_key.key_box_no as key_box_no,
CONCAT(krf_user.usr_firstname ,' ',krf_user.usr_lastname) as fullname,
glam_transaction_schedule.sched_job_card as job_card,
glam_transaction_schedule.sched_field_a as sched_field_a,
glam_transaction_schedule.sched_field_b as sched_field_b,
glam_access_point.access_point_description as lock_description,
krf_user.usr_contact_cell_no as contact_cell_no
from glam_access_point_log
inner join glam_notification on glam_notification.notification_id = glam_access_point_log.log_notification_id
left join glam_access_object_key on glam_access_object_key.access_object_id = glam_access_point_log.access_object_id 
left join glam_access_point on glam_access_point.access_point_id = glam_access_point_log.access_point_id 
left join krf_user on krf_user.usr_id = glam_access_point_log.keyholder_id
left join glam_transaction_schedule on (glam_transaction_schedule.transaction_id = glam_access_point_log.transaction_id and
 glam_transaction_schedule.user_id =   glam_access_point_log.keyholder_id and 
 glam_transaction_schedule.access_point_id = glam_access_point_log.access_point_id)
WHERE (glam_access_point_log.key_log_time BETWEEN ? AND ?) and not isnull(glam_access_point_log.transaction_id) 
and glam_transaction_schedule.sched_job_card != ""]]></xml-property>
            <xml-property name="designerValues"><![CDATA[<?xml version="1.0" encoding="UTF-8"?>
<model:DesignValues xmlns:design="http://www.eclipse.org/datatools/connectivity/oda/design" xmlns:model="http://www.eclipse.org/birt/report/model/adapter/odaModel">
  <Version>2.0</Version>
  <design:ResultSets derivedMetaData="true">
    <design:resultSetDefinitions>
      <design:resultSetColumns>
        <design:resultColumnDefinitions>
          <design:attributes>
            <design:identifier>
              <design:name>log_date</design:name>
              <design:position>1</design:position>
            </design:identifier>
            <design:nativeDataTypeCode>93</design:nativeDataTypeCode>
            <design:precision>19</design:precision>
            <design:scale>0</design:scale>
            <design:nullability>Nullable</design:nullability>
            <design:uiHints>
              <design:displayName>log_date</design:displayName>
            </design:uiHints>
          </design:attributes>
          <design:usageHints>
            <design:label>log_date</design:label>
            <design:formattingHints>
              <design:displaySize>19</design:displaySize>
            </design:formattingHints>
          </design:usageHints>
        </design:resultColumnDefinitions>
        <design:resultColumnDefinitions>
          <design:attributes>
            <design:identifier>
              <design:name>log_notification_id</design:name>
              <design:position>2</design:position>
            </design:identifier>
            <design:nativeDataTypeCode>4</design:nativeDataTypeCode>
            <design:precision>10</design:precision>
            <design:scale>0</design:scale>
            <design:nullability>NotNullable</design:nullability>
            <design:uiHints>
              <design:displayName>log_notification_id</design:displayName>
            </design:uiHints>
          </design:attributes>
          <design:usageHints>
            <design:label>log_notification_id</design:label>
            <design:formattingHints>
              <design:displaySize>10</design:displaySize>
            </design:formattingHints>
          </design:usageHints>
        </design:resultColumnDefinitions>
        <design:resultColumnDefinitions>
          <design:attributes>
            <design:identifier>
              <design:name>key_log_time</design:name>
              <design:position>3</design:position>
            </design:identifier>
            <design:nativeDataTypeCode>4</design:nativeDataTypeCode>
            <design:precision>10</design:precision>
            <design:scale>0</design:scale>
            <design:nullability>NotNullable</design:nullability>
            <design:uiHints>
              <design:displayName>key_log_time</design:displayName>
            </design:uiHints>
          </design:attributes>
          <design:usageHints>
            <design:label>key_log_time</design:label>
            <design:formattingHints>
              <design:displaySize>10</design:displaySize>
            </design:formattingHints>
          </design:usageHints>
        </design:resultColumnDefinitions>
        <design:resultColumnDefinitions>
          <design:attributes>
            <design:identifier>
              <design:name>notification_desc</design:name>
              <design:position>4</design:position>
            </design:identifier>
            <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
            <design:precision>100</design:precision>
            <design:scale>0</design:scale>
            <design:nullability>Nullable</design:nullability>
            <design:uiHints>
              <design:displayName>notification_desc</design:displayName>
            </design:uiHints>
          </design:attributes>
          <design:usageHints>
            <design:label>notification_desc</design:label>
            <design:formattingHints>
              <design:displaySize>100</design:displaySize>
            </design:formattingHints>
          </design:usageHints>
        </design:resultColumnDefinitions>
        <design:resultColumnDefinitions>
          <design:attributes>
            <design:identifier>
              <design:name>key_box_no</design:name>
              <design:position>5</design:position>
            </design:identifier>
            <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
            <design:precision>24</design:precision>
            <design:scale>0</design:scale>
            <design:nullability>Nullable</design:nullability>
            <design:uiHints>
              <design:displayName>key_box_no</design:displayName>
            </design:uiHints>
          </design:attributes>
          <design:usageHints>
            <design:label>key_box_no</design:label>
            <design:formattingHints>
              <design:displaySize>24</design:displaySize>
            </design:formattingHints>
          </design:usageHints>
        </design:resultColumnDefinitions>
        <design:resultColumnDefinitions>
          <design:attributes>
            <design:identifier>
              <design:name>fullname</design:name>
              <design:position>6</design:position>
            </design:identifier>
            <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
            <design:precision>193</design:precision>
            <design:scale>0</design:scale>
            <design:nullability>Nullable</design:nullability>
            <design:uiHints>
              <design:displayName>fullname</design:displayName>
            </design:uiHints>
          </design:attributes>
          <design:usageHints>
            <design:label>fullname</design:label>
            <design:formattingHints>
              <design:displaySize>193</design:displaySize>
            </design:formattingHints>
          </design:usageHints>
        </design:resultColumnDefinitions>
        <design:resultColumnDefinitions>
          <design:attributes>
            <design:identifier>
              <design:name>sched_job_card</design:name>
              <design:position>7</design:position>
            </design:identifier>
            <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
            <design:precision>64</design:precision>
            <design:scale>0</design:scale>
            <design:nullability>Nullable</design:nullability>
            <design:uiHints>
              <design:displayName>job_card</design:displayName>
            </design:uiHints>
          </design:attributes>
          <design:usageHints>
            <design:label>job_card</design:label>
            <design:formattingHints>
              <design:displaySize>64</design:displaySize>
            </design:formattingHints>
          </design:usageHints>
        </design:resultColumnDefinitions>
        <design:resultColumnDefinitions>
          <design:attributes>
            <design:identifier>
              <design:name>sched_field_a</design:name>
              <design:position>8</design:position>
            </design:identifier>
            <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
            <design:precision>64</design:precision>
            <design:scale>0</design:scale>
            <design:nullability>Nullable</design:nullability>
            <design:uiHints>
              <design:displayName>sched_field_a</design:displayName>
            </design:uiHints>
          </design:attributes>
          <design:usageHints>
            <design:label>sched_field_a</design:label>
            <design:formattingHints>
              <design:displaySize>64</design:displaySize>
            </design:formattingHints>
          </design:usageHints>
        </design:resultColumnDefinitions>
        <design:resultColumnDefinitions>
          <design:attributes>
            <design:identifier>
              <design:name>sched_field_b</design:name>
              <design:position>9</design:position>
            </design:identifier>
            <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
            <design:precision>64</design:precision>
            <design:scale>0</design:scale>
            <design:nullability>Nullable</design:nullability>
            <design:uiHints>
              <design:displayName>sched_field_b</design:displayName>
            </design:uiHints>
          </design:attributes>
          <design:usageHints>
            <design:label>sched_field_b</design:label>
            <design:formattingHints>
              <design:displaySize>64</design:displaySize>
            </design:formattingHints>
          </design:usageHints>
        </design:resultColumnDefinitions>
      </design:resultSetColumns>
      <design:criteria/>
    </design:resultSetDefinitions>
  </design:ResultSets>
</model:DesignValues>]]></xml-property>
        </oda-data-set>
    </data-sets>
    <styles>
        <style name="report" id="4">
            <property name="fontFamily">sans-serif</property>
            <property name="fontSize">10pt</property>
        </style>
        <style name="crosstab-cell" id="5">
            <property name="borderBottomColor">#CCCCCC</property>
            <property name="borderBottomStyle">solid</property>
            <property name="borderBottomWidth">1pt</property>
            <property name="borderLeftColor">#CCCCCC</property>
            <property name="borderLeftStyle">solid</property>
            <property name="borderLeftWidth">1pt</property>
            <property name="borderRightColor">#CCCCCC</property>
            <property name="borderRightStyle">solid</property>
            <property name="borderRightWidth">1pt</property>
            <property name="borderTopColor">#CCCCCC</property>
            <property name="borderTopStyle">solid</property>
            <property name="borderTopWidth">1pt</property>
        </style>
        <style name="crosstab" id="6">
            <property name="borderBottomColor">#CCCCCC</property>
            <property name="borderBottomStyle">solid</property>
            <property name="borderBottomWidth">1pt</property>
            <property name="borderLeftColor">#CCCCCC</property>
            <property name="borderLeftStyle">solid</property>
            <property name="borderLeftWidth">1pt</property>
            <property name="borderRightColor">#CCCCCC</property>
            <property name="borderRightStyle">solid</property>
            <property name="borderRightWidth">1pt</property>
            <property name="borderTopColor">#CCCCCC</property>
            <property name="borderTopStyle">solid</property>
            <property name="borderTopWidth">1pt</property>
        </style>
    </styles>
    <page-setup>
        <simple-master-page name="Simple MasterPage" id="2">
            <page-header>
                <label id="58">
                    <property name="fontSize">14pt</property>
                    <text-property name="text">Job Card Report</text-property>
                </label>
            </page-header>
            <page-footer>
                <text id="3">
                    <property name="contentType">html</property>
                    <text-property name="content"><![CDATA[<value-of>new Date()</value-of>]]></text-property>
                </text>
            </page-footer>
        </simple-master-page>
    </page-setup>
    <body>
        <list id="686">
            <property name="dataSet">UnifiedDataset</property>
            <list-property name="boundDataColumns">
                <structure>
                    <property name="name">log_date</property>
                    <text-property name="displayName">log_date</text-property>
                    <expression name="expression" type="javascript">var temp = dataSetRow["log_date"]&#13;
var format = params["date_format"].value;&#13;
Formatter.format(temp,format)</expression>
                    <property name="dataType">string</property>
                    <property name="allowExport">true</property>
                </structure>
                <structure>
                    <property name="name">log_notification_id</property>
                    <text-property name="displayName">log_notification_id</text-property>
                    <expression name="expression" type="javascript">dataSetRow["log_notification_id"]</expression>
                    <property name="dataType">integer</property>
                </structure>
                <structure>
                    <property name="name">key_log_time</property>
                    <text-property name="displayName">key_log_time</text-property>
                    <expression name="expression" type="javascript">dataSetRow["key_log_time"]</expression>
                    <property name="dataType">integer</property>
                </structure>
                <structure>
                    <property name="name">notification_desc</property>
                    <text-property name="displayName">notification_desc</text-property>
                    <expression name="expression" type="javascript">dataSetRow["notification_desc"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">key_box_no</property>
                    <text-property name="displayName">key_box_no</text-property>
                    <expression name="expression" type="javascript">dataSetRow["key_box_no"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">fullname</property>
                    <text-property name="displayName">fullname</text-property>
                    <expression name="expression" type="javascript">dataSetRow["fullname"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">job_card</property>
                    <text-property name="displayName">job_card</text-property>
                    <expression name="expression" type="javascript">dataSetRow["job_card"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">sched_field_a</property>
                    <text-property name="displayName">sched_field_a</text-property>
                    <expression name="expression" type="javascript">dataSetRow["sched_field_a"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">sched_field_b</property>
                    <text-property name="displayName">sched_field_b</text-property>
                    <expression name="expression" type="javascript">dataSetRow["sched_field_b"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">lock_description</property>
                    <text-property name="displayName">lock_description</text-property>
                    <expression name="expression" type="javascript">dataSetRow["lock_description"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">contact_cell_no</property>
                    <text-property name="displayName">contact_cell_no</text-property>
                    <expression name="expression" type="javascript">dataSetRow["contact_cell_no"]</expression>
                    <property name="dataType">string</property>
                </structure>
            </list-property>
            <header>
                <grid id="656">
                    <column id="657"/>
                    <column id="658"/>
                    <column id="659"/>
                    <column id="660"/>
                    <column id="661"/>
                    <column id="662"/>
                    <column id="663"/>
                    <column id="664"/>
                    <column id="665"/>
                    <row id="666">
                        <cell id="667">
                            <label id="676">
                                <text-property name="text">Date</text-property>
                            </label>
                        </cell>
                        <cell id="668">
                            <label id="677">
                                <text-property name="text">Description</text-property>
                            </label>
                        </cell>
                        <cell id="669">
                            <label id="678">
                                <text-property name="text">Box</text-property>
                            </label>
                        </cell>
                        <cell id="670">
                            <label id="679">
                                <text-property name="text">Keyholder</text-property>
                            </label>
                        </cell>
                        <cell id="671">
                            <label id="680">
                                <text-property name="text">Notification</text-property>
                            </label>
                        </cell>
                        <cell id="672">
                            <label id="681">
                                <text-property name="text">Job Card</text-property>
                            </label>
                        </cell>
                        <cell id="673">
                            <label id="682">
                                <text-property name="text">Customer</text-property>
                            </label>
                        </cell>
                        <cell id="674">
                            <label id="683">
                                <text-property name="text">Reason</text-property>
                            </label>
                        </cell>
                        <cell id="675">
                            <label id="684">
                                <text-property name="text">Cellphone</text-property>
                            </label>
                        </cell>
                    </row>
                </grid>
            </header>
            <detail>
                <grid id="687">
                    <column id="688"/>
                    <column id="689"/>
                    <column id="690"/>
                    <column id="691"/>
                    <column id="692"/>
                    <column id="693"/>
                    <column id="694"/>
                    <column id="695"/>
                    <column id="696"/>
                    <row id="697">
                        <cell id="698">
                            <data id="707">
                                <property name="resultSetColumn">log_date</property>
                            </data>
                        </cell>
                        <cell id="699">
                            <data id="711">
                                <property name="resultSetColumn">lock_description</property>
                            </data>
                        </cell>
                        <cell id="700">
                            <data id="709">
                                <property name="resultSetColumn">key_box_no</property>
                            </data>
                        </cell>
                        <cell id="701">
                            <data id="710">
                                <property name="resultSetColumn">fullname</property>
                            </data>
                        </cell>
                        <cell id="702">
                            <data id="708">
                                <property name="resultSetColumn">notification_desc</property>
                            </data>
                        </cell>
                        <cell id="703">
                            <data id="712">
                                <property name="resultSetColumn">job_card</property>
                            </data>
                        </cell>
                        <cell id="704">
                            <data id="713">
                                <property name="resultSetColumn">sched_field_a</property>
                            </data>
                        </cell>
                        <cell id="705">
                            <data id="714">
                                <property name="resultSetColumn">sched_field_b</property>
                            </data>
                        </cell>
                        <cell id="706">
                            <data id="715">
                                <property name="resultSetColumn">contact_cell_no</property>
                            </data>
                        </cell>
                    </row>
                </grid>
            </detail>
        </list>
    </body>
</report>
