<?xml version="1.0" encoding="UTF-8"?>
<report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.23" id="1">
    <property name="comments">v 1.0.0</property>
    <property name="createdBy">Eclipse BIRT Designer Version 4.6.0.v201606072122</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="is_preview" id="355">
            <property name="valueType">static</property>
            <property name="isRequired">false</property>
            <property name="dataType">boolean</property>
            <property name="distinct">true</property>
            <simple-property-list name="defaultValue">
                <value type="constant">False</value>
            </simple-property-list>
            <list-property name="selectionList"/>
            <property name="paramType">simple</property>
            <property name="controlType">check-box</property>
            <structure name="format"/>
        </scalar-parameter>
        <scalar-parameter name="firstname" id="618">
            <property name="valueType">static</property>
            <property name="isRequired">false</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="lastname" id="619">
            <property name="valueType">static</property>
            <property name="isRequired">false</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="start_date" id="673">
            <property name="valueType">static</property>
            <property name="isRequired">false</property>
            <property name="dataType">string</property>
            <property name="distinct">true</property>
            <simple-property-list name="defaultValue">
                <value type="constant">2026-01-01 00:00:00</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="end_date" id="674">
            <property name="valueType">static</property>
            <property name="isRequired">false</property>
            <property name="dataType">string</property>
            <property name="distinct">true</property>
            <simple-property-list name="defaultValue">
                <value type="constant">2026-12-31 23:59:59</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="675">
            <property name="valueType">static</property>
            <property name="isRequired">false</property>
            <property name="dataType">string</property>
            <property name="distinct">true</property>
            <simple-property-list name="defaultValue">
                <value type="constant">dd MMM y 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="Glam2" id="217">
            <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://127.0.0.1:3306/sog</property>
            <property name="odaUser">gis</property>
            <encrypted-property name="odaPassword" encryptionID="base64">Z2lz</encrypted-property>
        </oda-data-source>
    </data-sources>
    <data-sets>
        <oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" name="SystemUserSet" id="474">
            <list-property name="columnHints">
                <structure>
                    <property name="columnName">usr_username</property>
                    <property name="analysis">dimension</property>
                    <text-property name="displayName">usr_username</text-property>
                    <text-property name="heading">usr_username</text-property>
                </structure>
                <structure>
                    <property name="columnName">usr_firstname</property>
                    <property name="analysis">dimension</property>
                    <text-property name="displayName">usr_firstname</text-property>
                    <text-property name="heading">usr_firstname</text-property>
                </structure>
                <structure>
                    <property name="columnName">usr_lastname</property>
                    <property name="analysis">dimension</property>
                    <text-property name="displayName">usr_lastname</text-property>
                    <text-property name="heading">usr_lastname</text-property>
                </structure>
                <structure>
                    <property name="columnName">is_active</property>
                    <property name="analysis">dimension</property>
                    <text-property name="displayName">is_active</text-property>
                    <text-property name="heading">is_active</text-property>
                </structure>
                <structure>
                    <property name="columnName">user_role</property>
                    <property name="analysis">dimension</property>
                    <text-property name="displayName">user_role</text-property>
                    <text-property name="heading">user_role</text-property>
                </structure>
                <structure>
                    <property name="columnName">his_action</property>
                    <property name="analysis">dimension</property>
                    <text-property name="displayName">his_action</text-property>
                    <text-property name="heading">his_action</text-property>
                </structure>
                <structure>
                    <property name="columnName">last_changed_on</property>
                    <property name="analysis">dimension</property>
                    <text-property name="displayName">last_changed_on</text-property>
                    <text-property name="heading">last_changed_on</text-property>
                </structure>
                <structure>
                    <property name="columnName">last_changed_by</property>
                    <property name="analysis">dimension</property>
                    <text-property name="displayName">last_changed_by</text-property>
                    <text-property name="heading">last_changed_by</text-property>
                </structure>
                <structure>
                    <property name="columnName">last_change_user</property>
                    <property name="analysis">dimension</property>
                    <text-property name="displayName">last_change_user</text-property>
                    <text-property name="heading">last_change_user</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>
                <structure>
                    <property name="name">start_objholder</property>
                    <property name="paramName">start_date</property>
                    <property name="nativeName"></property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">-1</property>
                    <property name="position">3</property>
                    <property name="isInput">true</property>
                    <property name="isOutput">false</property>
                </structure>
                <structure>
                    <property name="name">end_objholder</property>
                    <property name="paramName">end_date</property>
                    <property name="nativeName"></property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">-1</property>
                    <property name="position">4</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">usr_username</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">2</property>
                        <property name="name">usr_firstname</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">3</property>
                        <property name="name">usr_lastname</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">4</property>
                        <property name="name">is_active</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">5</property>
                        <property name="name">user_role</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">6</property>
                        <property name="name">his_action</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">7</property>
                        <property name="name">last_changed_on</property>
                        <property name="dataType">date-time</property>
                    </structure>
                    <structure>
                        <property name="position">8</property>
                        <property name="name">last_changed_by</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">9</property>
                        <property name="name">last_change_user</property>
                        <property name="dataType">string</property>
                    </structure>
                </list-property>
            </structure>
            <method name="beforeOpen"><![CDATA[var w;
w = ' ';
//Only interested if the parameter is not equal to %
if (params["firstname"] != null &amp;&amp; 
	params["firstname"].value != "" &amp;&amp;
	params["firstname"].value != "%")
{
 	//w = w + " AND glam_access_point.is_deleted = "+params["is_deleted"].value;
 	var query_firstname = " AND usr_firstname LIKE '" + params["firstname"].value + "' ";
 	w += query_firstname;
}

//Only interested if the parameter is not equal to %
if (params["lastname"] != null &amp;&amp; 
	params["lastname"].value != "" &amp;&amp;
	params["lastname"].value != "%")
{
 	//w = w + " AND glam_access_point.is_deleted = "+params["is_deleted"].value;
 	var query_lastname = " AND usr_lastname LIKE '" + params["lastname"].value + "' ";
 	w += query_lastname;
}
this.queryText = this.queryText.replace('$__filter',w);]]></method>
            <property name="dataSource">Glam2</property>
            <list-property name="resultSet">
                <structure>
                    <property name="position">1</property>
                    <property name="name">usr_username</property>
                    <property name="nativeName">usr_username</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
                <structure>
                    <property name="position">2</property>
                    <property name="name">usr_firstname</property>
                    <property name="nativeName">usr_firstname</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
                <structure>
                    <property name="position">3</property>
                    <property name="name">usr_lastname</property>
                    <property name="nativeName">usr_lastname</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
                <structure>
                    <property name="position">4</property>
                    <property name="name">is_active</property>
                    <property name="nativeName">is_active</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
                <structure>
                    <property name="position">5</property>
                    <property name="name">user_role</property>
                    <property name="nativeName">user_role</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
                <structure>
                    <property name="position">6</property>
                    <property name="name">his_action</property>
                    <property name="nativeName">his_action</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
                <structure>
                    <property name="position">7</property>
                    <property name="name">last_changed_on</property>
                    <property name="nativeName">last_changed_on</property>
                    <property name="dataType">date-time</property>
                    <property name="nativeDataType">93</property>
                </structure>
                <structure>
                    <property name="position">8</property>
                    <property name="name">last_changed_by</property>
                    <property name="nativeName">last_changed_by</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
                <structure>
                    <property name="position">9</property>
                    <property name="name">last_change_user</property>
                    <property name="nativeName">last_change_user</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
            </list-property>
            <xml-property name="queryText"><![CDATA[select ghsu.usr_username as usr_username,
	ghsu.usr_firstname as usr_firstname,
	ghsu.usr_lastname as usr_lastname,
	case 
	when ghsu.usr_is_active=b'1' 
		then 'Yes' 
	when ghsu.usr_is_active=b'0' 
		then 'No' 
	end as is_active, 
	(select group_concat(app_role_name) from glam_his_systemuser_role left join krf_application_role on krf_application_role.app_role_id=glam_his_systemuser_role.role_id where his_id=ghsu.his_id) as user_role,
	ghsu.his_action as his_action,
	ghsu.last_changed_on as last_changed_on,
	ghsu.last_changed_by as last_changed_by,
	case 
    	when not isnull(ghsu.last_changed_by) and not isnull(lcu.usr_firstname) 
	    	then concat(lcu.usr_firstname, ' ', lcu.usr_lastname)
    	when not isnull(ghsu.last_changed_by) and isnull(lcu.usr_firstname) 
	    	then (select  concat(usr_firstname, " ", usr_lastname) from krf_user_graveyard where krf_user_graveyard.usr_id = ghsu.last_changed_by limit 1) 
    	else 
		    null
      end as last_change_user
		from glam_his_systemuser as ghsu 
	left join krf_user as lcu on lcu.usr_id=ghsu.last_changed_by
		WHERE (ghsu.last_changed_on between ? and ?)
	$__filter
  union
  select ghoh.usr_username as usr_username,
	ghoh.usr_firstname as usr_firstname,
	ghoh.usr_lastname as usr_lastname,
	case 
	when ghoh.usr_is_active=b'1' 
		then 'Yes' 
	when ghoh.usr_is_active=b'0' 
		then 'No' 
	end as is_active, 
	(select group_concat(app_role_name) from glam_his_objholder_role left join krf_application_role on krf_application_role.app_role_id=glam_his_objholder_role.role_id where his_id=ghoh.his_id) as user_role,
	ghoh.his_action as his_action,
	ghoh.last_changed_on as last_changed_on,
	ghoh.last_changed_by as last_changed_by,
	case 
    	when not isnull(ghoh.last_changed_by) and not isnull(lcu.usr_firstname) 
	    	then concat(lcu.usr_firstname, ' ', lcu.usr_lastname)
    	when not isnull(ghoh.last_changed_by) and isnull(lcu.usr_firstname) 
	    	then (select  concat(usr_firstname, " ", usr_lastname) from krf_user_graveyard where krf_user_graveyard.usr_id = ghoh.last_changed_by limit 1) 
    	else 
		    null
      end as last_change_user
		from glam_his_objholder as ghoh 
	left join krf_user as lcu on lcu.usr_id=ghoh.last_changed_by
	WHERE (ghoh.last_changed_on between ? and ?)
	$__filter
	order by last_changed_on asc;
]]></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>usr_id</design:name>
              <design:position>1</design:position>
            </design:identifier>
            <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
            <design:precision>36</design:precision>
            <design:scale>0</design:scale>
            <design:nullability>Nullable</design:nullability>
            <design:uiHints>
              <design:displayName>usr_id</design:displayName>
            </design:uiHints>
          </design:attributes>
          <design:usageHints>
            <design:label>usr_id</design:label>
            <design:formattingHints>
              <design:displaySize>36</design:displaySize>
            </design:formattingHints>
          </design:usageHints>
        </design:resultColumnDefinitions>
        <design:resultColumnDefinitions>
          <design:attributes>
            <design:identifier>
              <design:name>usr_firstname</design:name>
              <design:position>2</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>usr_firstname</design:displayName>
            </design:uiHints>
          </design:attributes>
          <design:usageHints>
            <design:label>usr_firstname</design:label>
            <design:formattingHints>
              <design:displaySize>64</design:displaySize>
            </design:formattingHints>
          </design:usageHints>
        </design:resultColumnDefinitions>
        <design:resultColumnDefinitions>
          <design:attributes>
            <design:identifier>
              <design:name>usr_lastname</design:name>
              <design:position>3</design:position>
            </design:identifier>
            <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
            <design:precision>128</design:precision>
            <design:scale>0</design:scale>
            <design:nullability>Nullable</design:nullability>
            <design:uiHints>
              <design:displayName>usr_lastname</design:displayName>
            </design:uiHints>
          </design:attributes>
          <design:usageHints>
            <design:label>usr_lastname</design:label>
            <design:formattingHints>
              <design:displaySize>128</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">System users</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="620">
            <property name="dataSet">SystemUserSet</property>
            <list-property name="boundDataColumns">
                <structure>
                    <property name="name">usr_username</property>
                    <text-property name="displayName">usr_username</text-property>
                    <expression name="expression" type="javascript">dataSetRow["usr_username"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">usr_firstname</property>
                    <text-property name="displayName">usr_firstname</text-property>
                    <expression name="expression" type="javascript">dataSetRow["usr_firstname"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">usr_lastname</property>
                    <text-property name="displayName">usr_lastname</text-property>
                    <expression name="expression" type="javascript">dataSetRow["usr_lastname"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">is_active</property>
                    <text-property name="displayName">is_active</text-property>
                    <expression name="expression" type="javascript">dataSetRow["is_active"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">user_role</property>
                    <text-property name="displayName">user_role</text-property>
                    <expression name="expression" type="javascript">var updated = dataSetRow["user_role"]&#13;
if (updated) {&#13;
	updated = updated.replace("GLAM_SUPERVISOR", "Requester")&#13;
	updated = updated.replace("GLAM_KEYHOLDER", "Keyholder")&#13;
	&#13;
	updated = updated.replace("GLAM_NOC", "Approver")&#13;
	updated = updated.replace("GLAM_ADMIN", "BSC Admin")&#13;
	updated = updated.replace("GLAM_USER_ADMIN", "EUA Admin")&#13;
	updated = updated.replace("GLAM_CASH_MANAGEMENT", "Cash Management")&#13;
	updated = updated.replace("GLAM_SITE_REQUESTER", "Site access requester")&#13;
	updated = updated.replace("GLAM_SITE_APPROVER", "Site access approver")&#13;
	&#13;
	updated = updated.replace("GLAM_LAYOUT_MANAGER", "Site layout manager")&#13;
	updated = updated.replace("GLAM_BULK_SCHEDULE_UPLOADER", "Bulk schedule uploader")&#13;
}&#13;
updated</expression>
                    <property name="dataType">string</property>
                    <property name="allowExport">true</property>
                </structure>
                <structure>
                    <property name="name">last_changed_on</property>
                    <text-property name="displayName">last_changed_on</text-property>
                    <expression name="expression" type="javascript">var temp = dataSetRow["last_changed_on"]&#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">his_action</property>
                    <text-property name="displayName">his_action</text-property>
                    <expression name="expression" type="javascript">dataSetRow["his_action"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">last_change_user</property>
                    <text-property name="displayName">last_change_user</text-property>
                    <expression name="expression" type="javascript">dataSetRow["last_change_user"]</expression>
                    <property name="dataType">string</property>
                </structure>
            </list-property>
            <header>
                <grid id="633">
                    <column id="634"/>
                    <column id="635"/>
                    <column id="636"/>
                    <column id="637"/>
                    <column id="638"/>
                    <column id="656"/>
                    <column id="658"/>
                    <column id="660"/>
                    <row id="639">
                        <cell id="640">
                            <property name="borderBottomStyle">solid</property>
                            <property name="borderBottomWidth">thin</property>
                            <property name="borderLeftStyle">solid</property>
                            <property name="borderLeftWidth">thin</property>
                            <property name="borderRightStyle">solid</property>
                            <property name="borderRightWidth">thin</property>
                            <property name="borderTopStyle">solid</property>
                            <property name="borderTopWidth">thin</property>
                            <label id="645">
                                <property name="fontWeight">bold</property>
                                <text-property name="text">Action</text-property>
                            </label>
                        </cell>
                        <cell id="641">
                            <property name="borderBottomStyle">solid</property>
                            <property name="borderBottomWidth">thin</property>
                            <property name="borderLeftStyle">solid</property>
                            <property name="borderLeftWidth">thin</property>
                            <property name="borderRightStyle">solid</property>
                            <property name="borderRightWidth">thin</property>
                            <property name="borderTopStyle">solid</property>
                            <property name="borderTopWidth">thin</property>
                            <label id="646">
                                <property name="fontWeight">bold</property>
                                <text-property name="text">Performed By</text-property>
                            </label>
                        </cell>
                        <cell id="642">
                            <property name="borderBottomStyle">solid</property>
                            <property name="borderBottomWidth">thin</property>
                            <property name="borderLeftStyle">solid</property>
                            <property name="borderLeftWidth">thin</property>
                            <property name="borderRightStyle">solid</property>
                            <property name="borderRightWidth">thin</property>
                            <property name="borderTopStyle">solid</property>
                            <property name="borderTopWidth">thin</property>
                            <label id="647">
                                <property name="fontWeight">bold</property>
                                <text-property name="text">Username</text-property>
                            </label>
                        </cell>
                        <cell id="643">
                            <property name="borderBottomStyle">solid</property>
                            <property name="borderBottomWidth">thin</property>
                            <property name="borderLeftStyle">solid</property>
                            <property name="borderLeftWidth">thin</property>
                            <property name="borderRightStyle">solid</property>
                            <property name="borderRightWidth">thin</property>
                            <property name="borderTopStyle">solid</property>
                            <property name="borderTopWidth">thin</property>
                            <label id="648">
                                <property name="fontWeight">bold</property>
                                <text-property name="text">Firstname</text-property>
                            </label>
                        </cell>
                        <cell id="644">
                            <property name="borderBottomStyle">solid</property>
                            <property name="borderBottomWidth">thin</property>
                            <property name="borderLeftStyle">solid</property>
                            <property name="borderLeftWidth">thin</property>
                            <property name="borderRightStyle">solid</property>
                            <property name="borderRightWidth">thin</property>
                            <property name="borderTopStyle">solid</property>
                            <property name="borderTopWidth">thin</property>
                            <label id="649">
                                <property name="fontWeight">bold</property>
                                <text-property name="text">Lastname</text-property>
                            </label>
                        </cell>
                        <cell id="655">
                            <property name="borderBottomStyle">solid</property>
                            <property name="borderBottomWidth">thin</property>
                            <property name="borderLeftStyle">solid</property>
                            <property name="borderLeftWidth">thin</property>
                            <property name="borderRightStyle">solid</property>
                            <property name="borderRightWidth">thin</property>
                            <property name="borderTopStyle">solid</property>
                            <property name="borderTopWidth">thin</property>
                            <label id="661">
                                <property name="fontWeight">bold</property>
                                <text-property name="text">Role</text-property>
                            </label>
                        </cell>
                        <cell id="657">
                            <property name="borderBottomStyle">solid</property>
                            <property name="borderBottomWidth">thin</property>
                            <property name="borderLeftStyle">solid</property>
                            <property name="borderLeftWidth">thin</property>
                            <property name="borderRightStyle">solid</property>
                            <property name="borderRightWidth">thin</property>
                            <property name="borderTopStyle">solid</property>
                            <property name="borderTopWidth">thin</property>
                            <label id="662">
                                <property name="fontWeight">bold</property>
                                <text-property name="text">Active</text-property>
                            </label>
                        </cell>
                        <cell id="659">
                            <property name="borderBottomStyle">solid</property>
                            <property name="borderBottomWidth">thin</property>
                            <property name="borderLeftStyle">solid</property>
                            <property name="borderLeftWidth">thin</property>
                            <property name="borderRightStyle">solid</property>
                            <property name="borderRightWidth">thin</property>
                            <property name="borderTopStyle">solid</property>
                            <property name="borderTopWidth">thin</property>
                            <label id="663">
                                <property name="fontWeight">bold</property>
                                <text-property name="text">Changed on</text-property>
                            </label>
                        </cell>
                    </row>
                </grid>
            </header>
            <detail>
                <grid id="621">
                    <column id="622"/>
                    <column id="623"/>
                    <column id="624"/>
                    <column id="625"/>
                    <column id="626"/>
                    <column id="665"/>
                    <column id="667"/>
                    <column id="669"/>
                    <row id="627">
                        <property name="borderBottomStyle">solid</property>
                        <property name="borderBottomWidth">thin</property>
                        <property name="borderLeftStyle">solid</property>
                        <property name="borderLeftWidth">thin</property>
                        <property name="borderRightStyle">solid</property>
                        <property name="borderRightWidth">thin</property>
                        <property name="borderTopStyle">solid</property>
                        <property name="borderTopWidth">thin</property>
                        <cell id="628">
                            <property name="borderBottomStyle">solid</property>
                            <property name="borderBottomWidth">thin</property>
                            <property name="borderLeftStyle">solid</property>
                            <property name="borderLeftWidth">thin</property>
                            <property name="borderRightStyle">solid</property>
                            <property name="borderRightWidth">thin</property>
                            <property name="borderTopStyle">solid</property>
                            <property name="borderTopWidth">thin</property>
                            <data id="671">
                                <property name="resultSetColumn">his_action</property>
                            </data>
                        </cell>
                        <cell id="629">
                            <property name="borderBottomStyle">solid</property>
                            <property name="borderBottomWidth">thin</property>
                            <property name="borderLeftStyle">solid</property>
                            <property name="borderLeftWidth">thin</property>
                            <property name="borderRightStyle">solid</property>
                            <property name="borderRightWidth">thin</property>
                            <property name="borderTopStyle">solid</property>
                            <property name="borderTopWidth">thin</property>
                            <data id="672">
                                <property name="resultSetColumn">last_change_user</property>
                            </data>
                        </cell>
                        <cell id="630">
                            <property name="borderBottomStyle">solid</property>
                            <property name="borderBottomWidth">thin</property>
                            <property name="borderLeftStyle">solid</property>
                            <property name="borderLeftWidth">thin</property>
                            <property name="borderRightStyle">solid</property>
                            <property name="borderRightWidth">thin</property>
                            <property name="borderTopStyle">solid</property>
                            <property name="borderTopWidth">thin</property>
                            <data id="650">
                                <property name="resultSetColumn">usr_username</property>
                            </data>
                        </cell>
                        <cell id="631">
                            <property name="borderBottomStyle">solid</property>
                            <property name="borderBottomWidth">thin</property>
                            <property name="borderLeftStyle">solid</property>
                            <property name="borderLeftWidth">thin</property>
                            <property name="borderRightStyle">solid</property>
                            <property name="borderRightWidth">thin</property>
                            <property name="borderTopStyle">solid</property>
                            <property name="borderTopWidth">thin</property>
                            <data id="651">
                                <property name="resultSetColumn">usr_firstname</property>
                            </data>
                        </cell>
                        <cell id="632">
                            <property name="borderBottomStyle">solid</property>
                            <property name="borderBottomWidth">thin</property>
                            <property name="borderLeftStyle">solid</property>
                            <property name="borderLeftWidth">thin</property>
                            <property name="borderRightStyle">solid</property>
                            <property name="borderRightWidth">thin</property>
                            <property name="borderTopStyle">solid</property>
                            <property name="borderTopWidth">thin</property>
                            <data id="652">
                                <property name="resultSetColumn">usr_lastname</property>
                            </data>
                        </cell>
                        <cell id="664">
                            <property name="borderBottomStyle">solid</property>
                            <property name="borderBottomWidth">thin</property>
                            <property name="borderLeftStyle">solid</property>
                            <property name="borderLeftWidth">thin</property>
                            <property name="borderRightStyle">solid</property>
                            <property name="borderRightWidth">thin</property>
                            <property name="borderTopStyle">solid</property>
                            <property name="borderTopWidth">thin</property>
                            <data id="654">
                                <property name="resultSetColumn">user_role</property>
                            </data>
                        </cell>
                        <cell id="666">
                            <property name="borderBottomStyle">solid</property>
                            <property name="borderBottomWidth">thin</property>
                            <property name="borderLeftStyle">solid</property>
                            <property name="borderLeftWidth">thin</property>
                            <property name="borderRightStyle">solid</property>
                            <property name="borderRightWidth">thin</property>
                            <property name="borderTopStyle">solid</property>
                            <property name="borderTopWidth">thin</property>
                            <data id="653">
                                <property name="resultSetColumn">is_active</property>
                            </data>
                        </cell>
                        <cell id="668">
                            <property name="borderBottomStyle">solid</property>
                            <property name="borderBottomWidth">thin</property>
                            <property name="borderLeftStyle">solid</property>
                            <property name="borderLeftWidth">thin</property>
                            <property name="borderRightStyle">solid</property>
                            <property name="borderRightWidth">thin</property>
                            <property name="borderTopStyle">solid</property>
                            <property name="borderTopWidth">thin</property>
                            <data id="670">
                                <property name="resultSetColumn">last_changed_on</property>
                            </data>
                        </cell>
                    </row>
                </grid>
            </detail>
        </list>
    </body>
</report>
