usage_statistics.rptdesign

<?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.2.1.v201209101448 Build &lt;4.2.1.v20120912-1721></property>
    <list-property name="propertyBindings">
        <structure>
            <property name="name">queryText</property>
            <property name="id">8</property>
        </structure>
        <structure>
            <property name="name">queryTimeOut</property>
            <property name="id">8</property>
        </structure>
        <structure>
            <property name="name">rowFetchSize</property>
            <property name="id">8</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">96</property>
    <list-property name="libraries">
        <structure>
            <property name="fileName">oira.rptlibrary</property>
            <property name="namespace">oira</property>
        </structure>
    </list-property>
    <list-property name="cssStyleSheets">
        <structure>
            <property name="fileName">oira-reports.css</property>
        </structure>
    </list-property>
    <parameters>
        <scalar-parameter name="sector" id="1041">
            <text-property name="promptText">Sector to generate statistics for</text-property>
            <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>
    </parameters>
    <data-sources>
        <oda-data-source extensionID="org.eclipse.birt.report.data.oda.jdbc" name="OiRA Postgres DB" id="7"
 extends="oira.OiRA Postgres DB">
            <list-property name="privateDriverProperties">
                <ex-property>
                    <name>contentBidiFormatStr</name>
                    <value>ILYNN</value>
                </ex-property>
                <ex-property>
                    <name>metadataBidiFormatStr</name>
                    <value>ILYNN</value>
                </ex-property>
                <ex-property>
                    <name>disabledMetadataBidiFormatStr</name>
                </ex-property>
                <ex-property>
                    <name>disabledContentBidiFormatStr</name>
                </ex-property>
            </list-property>
            <property name="odaDriverClass">org.postgresql.Driver</property>
            <property name="odaURL">jdbc:{{component.database_url}}</property>
            <property name="odaUser">{{component.database_user}}</property>
            <encrypted-property name="odaPassword" encryptionID="base64">{{component.database_password}}</encrypted-property>
        </oda-data-source>
    </data-sources>
    <data-sets>
        <oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" name="Assessments By Zodb-Path" id="8"
 extends="oira.Assessments By Zodb-Path">
            <property name="nullsOrdering">nulls lowest</property>
            <list-property name="columnHints">
                <structure>
                    <property name="columnName">zodb_path</property>
                    <property name="analysis">attribute</property>
                    <text-property name="displayName">zodb_path</text-property>
                    <text-property name="heading">zodb_path</text-property>
                    <property name="displayLength">128</property>
                    <property name="horizontalAlign">justify</property>
                    <property name="wordWrap">false</property>
                </structure>
                <structure>
                    <property name="columnName">count</property>
                    <property name="analysis">measure</property>
                    <text-property name="displayName">count</text-property>
                    <text-property name="heading">count</text-property>
                    <property name="displayLength">20</property>
                    <property name="horizontalAlign">justify</property>
                    <property name="wordWrap">false</property>
                </structure>
            </list-property>
            <list-property name="parameters">
                <structure>
                    <property name="name">sector</property>
                    <property name="paramName">sector</property>
                    <property name="nativeName"></property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                    <property name="position">1</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">zodb_path</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">2</property>
                        <property name="name">count</property>
                        <property name="dataType">decimal</property>
                    </structure>
                    <structure>
                        <property name="position">3</property>
                        <property name="name">zodb_path</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">4</property>
                        <property name="name">count</property>
                        <property name="dataType">decimal</property>
                    </structure>
                </list-property>
            </structure>
            <property name="rowFetchLimit">0</property>
            <list-property name="resultSet">
                <structure>
                    <property name="position">1</property>
                    <property name="name">zodb_path</property>
                    <property name="nativeName">zodb_path</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
                <structure>
                    <property name="position">2</property>
                    <property name="name">count</property>
                    <property name="nativeName">count</property>
                    <property name="dataType">decimal</property>
                    <property name="nativeDataType">-5</property>
                </structure>
                <structure>
                    <property name="position">1</property>
                    <property name="name">zodb_path</property>
                    <property name="nativeName">zodb_path</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
                <structure>
                    <property name="position">2</property>
                    <property name="name">count</property>
                    <property name="nativeName">count</property>
                    <property name="dataType">decimal</property>
                    <property name="nativeDataType">-5</property>
                </structure>
            </list-property>
            <xml-property name="queryText"><![CDATA[select zodb_path,count(*)
from session
where substring(zodb_path from '../(.*)/.*') like ?
group by zodb_path
order by count desc;]]></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>
  <DataSetParameters>
    <parameter>
      <design:ParameterDefinition>
        <design:inOutMode>In</design:inOutMode>
        <design:attributes>
          <design:identifier>
            <design:name></design:name>
            <design:position>1</design:position>
          </design:identifier>
          <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
          <design:precision>0</design:precision>
          <design:scale>0</design:scale>
          <design:nullability>Unknown</design:nullability>
        </design:attributes>
      </design:ParameterDefinition>
    </parameter>
  </DataSetParameters>
  <design:ResultSets derivedMetaData="true">
    <design:resultSetDefinitions>
      <design:resultSetColumns>
        <design:resultColumnDefinitions>
          <design:attributes>
            <design:identifier>
              <design:name>zodb_path</design:name>
              <design:position>1</design:position>
            </design:identifier>
            <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
            <design:precision>128</design:precision>
            <design:scale>0</design:scale>
            <design:nullability>NotNullable</design:nullability>
            <design:uiHints>
              <design:displayName>zodb_path</design:displayName>
            </design:uiHints>
          </design:attributes>
          <design:usageHints>
            <design:label>zodb_path</design:label>
            <design:formattingHints>
              <design:displaySize>128</design:displaySize>
            </design:formattingHints>
          </design:usageHints>
        </design:resultColumnDefinitions>
        <design:resultColumnDefinitions>
          <design:attributes>
            <design:identifier>
              <design:name>count</design:name>
              <design:position>2</design:position>
            </design:identifier>
            <design:nativeDataTypeCode>-5</design:nativeDataTypeCode>
            <design:precision>19</design:precision>
            <design:scale>0</design:scale>
            <design:nullability>Unknown</design:nullability>
            <design:uiHints>
              <design:displayName>count</design:displayName>
            </design:uiHints>
          </design:attributes>
          <design:usageHints>
            <design:label>count</design:label>
            <design:formattingHints>
              <design:displaySize>20</design:displaySize>
            </design:formattingHints>
          </design:usageHints>
        </design:resultColumnDefinitions>
      </design:resultSetColumns>
      <design:criteria/>
    </design:resultSetDefinitions>
  </design:ResultSets>
</model:DesignValues>]]></xml-property>
        </oda-data-set>
        <oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" name="Assessments by Country" id="9"
 extends="oira.Assessments by Country"/>
        <oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" name="Assessments By Sector" id="86">
            <list-property name="columnHints">
                <structure>
                    <property name="columnName">sector</property>
                    <property name="analysis">attribute</property>
                    <text-property name="displayName">sector</text-property>
                    <text-property name="heading">sector</text-property>
                </structure>
                <structure>
                    <property name="columnName">count</property>
                    <property name="analysis">measure</property>
                    <text-property name="displayName">count</text-property>
                    <text-property name="heading">count</text-property>
                </structure>
            </list-property>
            <list-property name="parameters">
                <structure>
                    <property name="name">sector</property>
                    <property name="paramName">sector</property>
                    <property name="nativeName"></property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                    <property name="position">1</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">sector</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">2</property>
                        <property name="name">count</property>
                        <property name="dataType">decimal</property>
                    </structure>
                </list-property>
            </structure>
            <property name="dataSource">OiRA Postgres DB</property>
            <list-property name="resultSet">
                <structure>
                    <property name="position">1</property>
                    <property name="name">sector</property>
                    <property name="nativeName">sector</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
                <structure>
                    <property name="position">2</property>
                    <property name="name">count</property>
                    <property name="nativeName">count</property>
                    <property name="dataType">decimal</property>
                    <property name="nativeDataType">-5</property>
                </structure>
            </list-property>
            <xml-property name="queryText"><![CDATA[select substring(zodb_path from '../\([^/]*\)/') as sector,count(*)
from session
where substring(zodb_path from '../(.*)/.*') like ?
group by sector
order by count desc;]]></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>
  <DataSetParameters>
    <parameter>
      <design:ParameterDefinition>
        <design:inOutMode>In</design:inOutMode>
        <design:attributes>
          <design:identifier>
            <design:name></design:name>
            <design:position>1</design:position>
          </design:identifier>
          <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
          <design:precision>0</design:precision>
          <design:scale>0</design:scale>
          <design:nullability>Unknown</design:nullability>
        </design:attributes>
      </design:ParameterDefinition>
    </parameter>
  </DataSetParameters>
  <design:ResultSets derivedMetaData="true">
    <design:resultSetDefinitions>
      <design:resultSetColumns>
        <design:resultColumnDefinitions>
          <design:attributes>
            <design:identifier>
              <design:name>sector</design:name>
              <design:position>1</design:position>
            </design:identifier>
            <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
            <design:precision>2147483647</design:precision>
            <design:scale>0</design:scale>
            <design:nullability>Unknown</design:nullability>
            <design:uiHints>
              <design:displayName>sector</design:displayName>
            </design:uiHints>
          </design:attributes>
          <design:usageHints>
            <design:label>sector</design:label>
            <design:formattingHints>
              <design:displaySize>2147483647</design:displaySize>
            </design:formattingHints>
          </design:usageHints>
        </design:resultColumnDefinitions>
        <design:resultColumnDefinitions>
          <design:attributes>
            <design:identifier>
              <design:name>count</design:name>
              <design:position>2</design:position>
            </design:identifier>
            <design:nativeDataTypeCode>-5</design:nativeDataTypeCode>
            <design:precision>19</design:precision>
            <design:scale>0</design:scale>
            <design:nullability>Unknown</design:nullability>
            <design:uiHints>
              <design:displayName>count</design:displayName>
            </design:uiHints>
          </design:attributes>
          <design:usageHints>
            <design:label>count</design:label>
            <design:formattingHints>
              <design:displaySize>20</design:displaySize>
            </design:formattingHints>
          </design:usageHints>
        </design:resultColumnDefinitions>
      </design:resultSetColumns>
      <design:criteria/>
    </design:resultSetDefinitions>
  </design:ResultSets>
</model:DesignValues>]]></xml-property>
        </oda-data-set>
        <oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" name="Assessments By Country" id="108">
            <list-property name="columnHints">
                <structure>
                    <property name="columnName">country</property>
                    <property name="analysis">attribute</property>
                    <text-property name="displayName">country</text-property>
                    <text-property name="heading">country</text-property>
                </structure>
                <structure>
                    <property name="columnName">count</property>
                    <property name="analysis">measure</property>
                    <text-property name="displayName">count</text-property>
                    <text-property name="heading">count</text-property>
                </structure>
            </list-property>
            <list-property name="parameters">
                <structure>
                    <property name="name">sector</property>
                    <property name="paramName">sector</property>
                    <property name="nativeName"></property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                    <property name="position">1</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">country</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">2</property>
                        <property name="name">count</property>
                        <property name="dataType">decimal</property>
                    </structure>
                </list-property>
            </structure>
            <property name="dataSource">OiRA Postgres DB</property>
            <list-property name="resultSet">
                <structure>
                    <property name="position">1</property>
                    <property name="name">country</property>
                    <property name="nativeName">country</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
                <structure>
                    <property name="position">2</property>
                    <property name="name">count</property>
                    <property name="nativeName">count</property>
                    <property name="dataType">decimal</property>
                    <property name="nativeDataType">-5</property>
                </structure>
            </list-property>
            <xml-property name="queryText"><![CDATA[select substring(zodb_path from E'^..') as country,count(*)
from session
where substring(zodb_path from '../(.*)/.*') like ?
group by country
order by count desc;]]></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>
  <DataSetParameters>
    <parameter>
      <design:ParameterDefinition>
        <design:inOutMode>In</design:inOutMode>
        <design:attributes>
          <design:identifier>
            <design:name></design:name>
            <design:position>1</design:position>
          </design:identifier>
          <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
          <design:precision>0</design:precision>
          <design:scale>0</design:scale>
          <design:nullability>Unknown</design:nullability>
        </design:attributes>
      </design:ParameterDefinition>
    </parameter>
  </DataSetParameters>
  <design:ResultSets derivedMetaData="true">
    <design:resultSetDefinitions>
      <design:resultSetColumns>
        <design:resultColumnDefinitions>
          <design:attributes>
            <design:identifier>
              <design:name>country</design:name>
              <design:position>1</design:position>
            </design:identifier>
            <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
            <design:precision>2147483647</design:precision>
            <design:scale>0</design:scale>
            <design:nullability>Unknown</design:nullability>
            <design:uiHints>
              <design:displayName>country</design:displayName>
            </design:uiHints>
          </design:attributes>
          <design:usageHints>
            <design:label>country</design:label>
            <design:formattingHints>
              <design:displaySize>2147483647</design:displaySize>
            </design:formattingHints>
          </design:usageHints>
        </design:resultColumnDefinitions>
        <design:resultColumnDefinitions>
          <design:attributes>
            <design:identifier>
              <design:name>count</design:name>
              <design:position>2</design:position>
            </design:identifier>
            <design:nativeDataTypeCode>-5</design:nativeDataTypeCode>
            <design:precision>19</design:precision>
            <design:scale>0</design:scale>
            <design:nullability>Unknown</design:nullability>
            <design:uiHints>
              <design:displayName>count</design:displayName>
            </design:uiHints>
          </design:attributes>
          <design:usageHints>
            <design:label>count</design:label>
            <design:formattingHints>
              <design:displaySize>20</design:displaySize>
            </design:formattingHints>
          </design:usageHints>
        </design:resultColumnDefinitions>
      </design:resultSetColumns>
      <design:criteria/>
    </design:resultSetDefinitions>
  </design:ResultSets>
</model:DesignValues>]]></xml-property>
        </oda-data-set>
        <oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" name="Number Of Accounts" id="125">
            <list-property name="columnHints">
                <structure>
                    <property name="columnName">count</property>
                    <property name="analysis">measure</property>
                    <text-property name="displayName">count</text-property>
                    <text-property name="heading">count</text-property>
                </structure>
            </list-property>
            <list-property name="parameters"/>
            <structure name="cachedMetaData">
                <list-property name="resultSet">
                    <structure>
                        <property name="position">1</property>
                        <property name="name">count</property>
                        <property name="dataType">decimal</property>
                    </structure>
                </list-property>
            </structure>
            <property name="dataSource">OiRA Postgres DB</property>
            <list-property name="resultSet">
                <structure>
                    <property name="position">1</property>
                    <property name="name">count</property>
                    <property name="nativeName">count</property>
                    <property name="dataType">decimal</property>
                    <property name="nativeDataType">-5</property>
                </structure>
            </list-property>
            <xml-property name="queryText"><![CDATA[select count(*)
from account]]></xml-property>
        </oda-data-set>
        <oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" name="Tools" id="136">
            <list-property name="columnHints">
                <structure>
                    <property name="columnName">zodb_path</property>
                    <property name="analysis">attribute</property>
                    <text-property name="displayName">zodb_path</text-property>
                    <text-property name="heading">zodb_path</text-property>
                </structure>
                <structure>
                    <property name="columnName">language</property>
                    <property name="analysis">attribute</property>
                    <text-property name="displayName">language</text-property>
                    <text-property name="heading">language</text-property>
                </structure>
                <structure>
                    <property name="columnName">published</property>
                    <property name="analysis">measure</property>
                    <text-property name="displayName">published</text-property>
                    <text-property name="heading">published</text-property>
                </structure>
            </list-property>
            <list-property name="parameters">
                <structure>
                    <property name="name">param_1</property>
                    <property name="paramName">sector</property>
                    <property name="nativeName"></property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                    <property name="position">1</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">zodb_path</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">2</property>
                        <property name="name">language</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">3</property>
                        <property name="name">published</property>
                        <property name="dataType">integer</property>
                    </structure>
                </list-property>
            </structure>
            <property name="dataSource">OiRA Postgres DB</property>
            <list-property name="resultSet">
                <structure>
                    <property name="position">1</property>
                    <property name="name">zodb_path</property>
                    <property name="nativeName">zodb_path</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
                <structure>
                    <property name="position">2</property>
                    <property name="name">language</property>
                    <property name="nativeName">language</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
                <structure>
                    <property name="position">3</property>
                    <property name="name">published</property>
                    <property name="nativeName">published</property>
                    <property name="dataType">integer</property>
                    <property name="nativeDataType">-7</property>
                </structure>
            </list-property>
            <xml-property name="queryText"><![CDATA[select *
from statistics_surveys
where substring(zodb_path from '../(.*)/.*') like ?]]></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>
  <DataSetParameters>
    <parameter>
      <design:ParameterDefinition>
        <design:inOutMode>In</design:inOutMode>
        <design:attributes>
          <design:identifier>
            <design:name></design:name>
            <design:position>1</design:position>
          </design:identifier>
          <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
          <design:precision>0</design:precision>
          <design:scale>0</design:scale>
          <design:nullability>Unknown</design:nullability>
        </design:attributes>
      </design:ParameterDefinition>
    </parameter>
  </DataSetParameters>
  <design:ResultSets derivedMetaData="true">
    <design:resultSetDefinitions>
      <design:resultSetColumns>
        <design:resultColumnDefinitions>
          <design:attributes>
            <design:identifier>
              <design:name>zodb_path</design:name>
              <design:position>1</design:position>
            </design:identifier>
            <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
            <design:precision>128</design:precision>
            <design:scale>0</design:scale>
            <design:nullability>NotNullable</design:nullability>
            <design:uiHints>
              <design:displayName>zodb_path</design:displayName>
            </design:uiHints>
          </design:attributes>
          <design:usageHints>
            <design:label>zodb_path</design:label>
            <design:formattingHints>
              <design:displaySize>128</design:displaySize>
            </design:formattingHints>
          </design:usageHints>
        </design:resultColumnDefinitions>
        <design:resultColumnDefinitions>
          <design:attributes>
            <design:identifier>
              <design:name>language</design:name>
              <design:position>2</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>language</design:displayName>
            </design:uiHints>
          </design:attributes>
          <design:usageHints>
            <design:label>language</design:label>
            <design:formattingHints>
              <design:displaySize>128</design:displaySize>
            </design:formattingHints>
          </design:usageHints>
        </design:resultColumnDefinitions>
        <design:resultColumnDefinitions>
          <design:attributes>
            <design:identifier>
              <design:name>review_state</design:name>
              <design:position>3</design:position>
            </design:identifier>
            <design:nativeDataTypeCode>1111</design:nativeDataTypeCode>
            <design:precision>2147483647</design:precision>
            <design:scale>0</design:scale>
            <design:nullability>Nullable</design:nullability>
            <design:uiHints>
              <design:displayName>review_state</design:displayName>
            </design:uiHints>
          </design:attributes>
          <design:usageHints>
            <design:label>review_state</design:label>
            <design:formattingHints>
              <design:displaySize>2147483647</design:displaySize>
            </design:formattingHints>
          </design:usageHints>
        </design:resultColumnDefinitions>
        <design:resultColumnDefinitions>
          <design:attributes>
            <design:identifier>
              <design:name>no_risks</design:name>
              <design:position>4</design:position>
            </design:identifier>
            <design:nativeDataTypeCode>4</design:nativeDataTypeCode>
            <design:precision>10</design:precision>
            <design:scale>0</design:scale>
            <design:nullability>Nullable</design:nullability>
            <design:uiHints>
              <design:displayName>no_risks</design:displayName>
            </design:uiHints>
          </design:attributes>
          <design:usageHints>
            <design:label>no_risks</design:label>
            <design:formattingHints>
              <design:displaySize>11</design:displaySize>
            </design:formattingHints>
          </design:usageHints>
        </design:resultColumnDefinitions>
      </design:resultSetColumns>
      <design:criteria/>
    </design:resultSetDefinitions>
  </design:ResultSets>
</model:DesignValues>]]></xml-property>
        </oda-data-set>
        <oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" name="Completed Assessments" id="444">
            <property name="nullsOrdering">nulls lowest</property>
            <list-property name="computedColumns">
                <structure>
                    <property name="name">percent_complete</property>
                    <expression name="expression">!row["total_risks"] ? 0 : row["answered_risks"]/row["total_risks"]</expression>
                    <property name="dataType">decimal</property>
                </structure>
            </list-property>
            <list-property name="columnHints">
                <structure>
                    <property name="columnName">zodb_path</property>
                    <property name="analysis">attribute</property>
                    <text-property name="displayName">zodb_path</text-property>
                    <text-property name="heading">zodb_path</text-property>
                </structure>
                <structure>
                    <property name="columnName">answered_risks</property>
                    <property name="analysis">measure</property>
                    <text-property name="displayName">answered_risks</text-property>
                    <text-property name="heading">answered_risks</text-property>
                </structure>
                <structure>
                    <property name="columnName">total_risks</property>
                    <property name="analysis">measure</property>
                    <text-property name="displayName">total_risks</text-property>
                    <text-property name="heading">total_risks</text-property>
                </structure>
            </list-property>
            <list-property name="parameters">
                <structure>
                    <property name="name">param_1</property>
                    <property name="paramName">sector</property>
                    <property name="nativeName"></property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                    <property name="position">1</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">zodb_path</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">2</property>
                        <property name="name">answered_risks</property>
                        <property name="dataType">decimal</property>
                    </structure>
                    <structure>
                        <property name="position">3</property>
                        <property name="name">total_risks</property>
                        <property name="dataType">decimal</property>
                    </structure>
                    <structure>
                        <property name="position">4</property>
                        <property name="name">percent_complete</property>
                        <property name="dataType">decimal</property>
                    </structure>
                </list-property>
            </structure>
            <property name="dataSource">OiRA Postgres DB</property>
            <list-property name="resultSet">
                <structure>
                    <property name="position">1</property>
                    <property name="name">zodb_path</property>
                    <property name="nativeName">zodb_path</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
                <structure>
                    <property name="position">2</property>
                    <property name="name">answered_risks</property>
                    <property name="nativeName">answered_risks</property>
                    <property name="dataType">decimal</property>
                    <property name="nativeDataType">-5</property>
                </structure>
                <structure>
                    <property name="position">3</property>
                    <property name="name">total_risks</property>
                    <property name="nativeName">total_risks</property>
                    <property name="dataType">decimal</property>
                    <property name="nativeDataType">-5</property>
                </structure>
            </list-property>
            <xml-property name="queryText"><![CDATA[select risks_a.zodb_path, risks_a.answered_risks, risks_t.total_risks
from (select session.id as session_id, max(session.zodb_path) as zodb_path, count(tree.id) as answered_risks
  from session left outer join tree
  on tree.session_id = session.id and tree.type = 'risk'
  group by session.id) as risks_a,
  (select session_id, max(session_modules.session_path), sum(no_risks) as total_risks
  from (select session.id as session_id, session.zodb_path as session_path, tree.zodb_path as tree_path from session left outer join tree on session.id = tree.session_id and tree.type = 'module' --- and tree.skip_children = false
    order by session.id,tree.zodb_path) as session_modules
  left outer join statistics_modules on statistics_modules.zodb_path like (session_modules.session_path || '%/' || session_modules.tree_path)
  group by session_id order by session_id) as risks_t
where risks_a.session_id = risks_t.session_id
and substring(zodb_path from '../(.*)/.*') like ?
order by total_risks;]]></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>
  <DataSetParameters>
    <parameter>
      <design:ParameterDefinition>
        <design:inOutMode>In</design:inOutMode>
        <design:attributes>
          <design:identifier>
            <design:name></design:name>
            <design:position>1</design:position>
          </design:identifier>
          <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
          <design:precision>0</design:precision>
          <design:scale>0</design:scale>
          <design:nullability>Unknown</design:nullability>
        </design:attributes>
      </design:ParameterDefinition>
    </parameter>
  </DataSetParameters>
  <design:ResultSets derivedMetaData="true">
    <design:resultSetDefinitions>
      <design:resultSetColumns>
        <design:resultColumnDefinitions>
          <design:attributes>
            <design:identifier>
              <design:name>id</design:name>
              <design:position>1</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>id</design:displayName>
            </design:uiHints>
          </design:attributes>
          <design:usageHints>
            <design:label>id</design:label>
            <design:formattingHints>
              <design:displaySize>11</design:displaySize>
            </design:formattingHints>
          </design:usageHints>
        </design:resultColumnDefinitions>
        <design:resultColumnDefinitions>
          <design:attributes>
            <design:identifier>
              <design:name>zodb_path</design:name>
              <design:position>2</design:position>
            </design:identifier>
            <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
            <design:precision>128</design:precision>
            <design:scale>0</design:scale>
            <design:nullability>NotNullable</design:nullability>
            <design:uiHints>
              <design:displayName>zodb_path</design:displayName>
            </design:uiHints>
          </design:attributes>
          <design:usageHints>
            <design:label>zodb_path</design:label>
            <design:formattingHints>
              <design:displaySize>128</design:displaySize>
            </design:formattingHints>
          </design:usageHints>
        </design:resultColumnDefinitions>
        <design:resultColumnDefinitions>
          <design:attributes>
            <design:identifier>
              <design:name>risks_total</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>Nullable</design:nullability>
            <design:uiHints>
              <design:displayName>risks_total</design:displayName>
            </design:uiHints>
          </design:attributes>
          <design:usageHints>
            <design:label>risks_total</design:label>
            <design:formattingHints>
              <design:displaySize>11</design:displaySize>
            </design:formattingHints>
          </design:usageHints>
        </design:resultColumnDefinitions>
        <design:resultColumnDefinitions>
          <design:attributes>
            <design:identifier>
              <design:name>risks_answered</design:name>
              <design:position>4</design:position>
            </design:identifier>
            <design:nativeDataTypeCode>-5</design:nativeDataTypeCode>
            <design:precision>19</design:precision>
            <design:scale>0</design:scale>
            <design:nullability>Unknown</design:nullability>
            <design:uiHints>
              <design:displayName>risks_answered</design:displayName>
            </design:uiHints>
          </design:attributes>
          <design:usageHints>
            <design:label>risks_answered</design:label>
            <design:formattingHints>
              <design:displaySize>20</design:displaySize>
            </design:formattingHints>
          </design:usageHints>
        </design:resultColumnDefinitions>
        <design:resultColumnDefinitions>
          <design:attributes>
            <design:identifier>
              <design:name>percent_answered</design:name>
              <design:position>5</design:position>
            </design:identifier>
            <design:nativeDataTypeCode>2</design:nativeDataTypeCode>
            <design:precision>0</design:precision>
            <design:scale>0</design:scale>
            <design:nullability>Unknown</design:nullability>
            <design:uiHints>
              <design:displayName>percent_answered</design:displayName>
            </design:uiHints>
          </design:attributes>
          <design:usageHints>
            <design:label>percent_answered</design:label>
            <design:formattingHints>
              <design:displaySize>131089</design:displaySize>
            </design:formattingHints>
          </design:usageHints>
        </design:resultColumnDefinitions>
      </design:resultSetColumns>
      <design:criteria/>
    </design:resultSetDefinitions>
  </design:ResultSets>
</model:DesignValues>]]></xml-property>
        </oda-data-set>
        <oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" name="Logins" id="497">
            <list-property name="columnHints">
                <structure>
                    <property name="columnName">loginname</property>
                    <property name="analysis">attribute</property>
                    <text-property name="displayName">loginname</text-property>
                    <text-property name="heading">loginname</text-property>
                </structure>
                <structure>
                    <property name="columnName">month</property>
                    <property name="analysis">measure</property>
                    <text-property name="displayName">month</text-property>
                    <text-property name="heading">month</text-property>
                </structure>
                <structure>
                    <property name="columnName">year</property>
                    <property name="analysis">measure</property>
                    <text-property name="displayName">year</text-property>
                    <text-property name="heading">year</text-property>
                </structure>
                <structure>
                    <property name="columnName">count</property>
                    <property name="analysis">measure</property>
                    <text-property name="displayName">count</text-property>
                    <text-property name="heading">count</text-property>
                </structure>
            </list-property>
            <list-property name="parameters"/>
            <structure name="cachedMetaData">
                <list-property name="resultSet">
                    <structure>
                        <property name="position">1</property>
                        <property name="name">loginname</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">2</property>
                        <property name="name">month</property>
                        <property name="dataType">float</property>
                    </structure>
                    <structure>
                        <property name="position">3</property>
                        <property name="name">year</property>
                        <property name="dataType">float</property>
                    </structure>
                    <structure>
                        <property name="position">4</property>
                        <property name="name">count</property>
                        <property name="dataType">decimal</property>
                    </structure>
                </list-property>
            </structure>
            <property name="dataSource">OiRA Postgres DB</property>
            <list-property name="resultSet">
                <structure>
                    <property name="position">1</property>
                    <property name="name">loginname</property>
                    <property name="nativeName">loginname</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
                <structure>
                    <property name="position">2</property>
                    <property name="name">month</property>
                    <property name="nativeName">month</property>
                    <property name="dataType">float</property>
                    <property name="nativeDataType">8</property>
                </structure>
                <structure>
                    <property name="position">3</property>
                    <property name="name">year</property>
                    <property name="nativeName">year</property>
                    <property name="dataType">float</property>
                    <property name="nativeDataType">8</property>
                </structure>
                <structure>
                    <property name="position">4</property>
                    <property name="name">count</property>
                    <property name="nativeName">count</property>
                    <property name="dataType">decimal</property>
                    <property name="nativeDataType">-5</property>
                </structure>
            </list-property>
            <xml-property name="queryText"><![CDATA[select loginname, date_part('month', time) as month, date_part('year', time) as year, count(statistics_login.id)
from statistics_login, account
where account.id = statistics_login.account_id
group by year,month,loginname
order by year,month,loginname;]]></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>loginname</design:name>
              <design:position>1</design:position>
            </design:identifier>
            <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
            <design:precision>255</design:precision>
            <design:scale>0</design:scale>
            <design:nullability>NotNullable</design:nullability>
            <design:uiHints>
              <design:displayName>loginname</design:displayName>
            </design:uiHints>
          </design:attributes>
          <design:usageHints>
            <design:label>loginname</design:label>
            <design:formattingHints>
              <design:displaySize>255</design:displaySize>
            </design:formattingHints>
          </design:usageHints>
        </design:resultColumnDefinitions>
        <design:resultColumnDefinitions>
          <design:attributes>
            <design:identifier>
              <design:name>time</design:name>
              <design:position>2</design:position>
            </design:identifier>
            <design:nativeDataTypeCode>93</design:nativeDataTypeCode>
            <design:precision>29</design:precision>
            <design:scale>6</design:scale>
            <design:nullability>NotNullable</design:nullability>
            <design:uiHints>
              <design:displayName>time</design:displayName>
            </design:uiHints>
          </design:attributes>
          <design:usageHints>
            <design:label>time</design:label>
            <design:formattingHints>
              <design:displaySize>29</design:displaySize>
            </design:formattingHints>
          </design:usageHints>
        </design:resultColumnDefinitions>
      </design:resultSetColumns>
      <design:criteria/>
    </design:resultSetDefinitions>
  </design:ResultSets>
</model:DesignValues>]]></xml-property>
        </oda-data-set>
        <oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" name="Assessments By Language" id="598">
            <list-property name="columnHints">
                <structure>
                    <property name="columnName">language</property>
                    <property name="analysis">attribute</property>
                    <text-property name="displayName">language</text-property>
                    <text-property name="heading">language</text-property>
                </structure>
                <structure>
                    <property name="columnName">count</property>
                    <property name="analysis">measure</property>
                    <text-property name="displayName">count</text-property>
                    <text-property name="heading">count</text-property>
                </structure>
            </list-property>
            <list-property name="parameters">
                <structure>
                    <property name="name">sector</property>
                    <property name="paramName">sector</property>
                    <property name="nativeName"></property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                    <property name="position">1</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">language</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">2</property>
                        <property name="name">count</property>
                        <property name="dataType">decimal</property>
                    </structure>
                </list-property>
            </structure>
            <property name="dataSource">OiRA Postgres DB</property>
            <list-property name="resultSet">
                <structure>
                    <property name="position">1</property>
                    <property name="name">language</property>
                    <property name="nativeName">language</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
                <structure>
                    <property name="position">2</property>
                    <property name="name">count</property>
                    <property name="nativeName">count</property>
                    <property name="dataType">decimal</property>
                    <property name="nativeDataType">-5</property>
                </structure>
            </list-property>
            <xml-property name="queryText"><![CDATA[select language,count(session.*)
from session left join statistics_surveys on session.zodb_path = statistics_surveys.zodb_path
where substring(session.zodb_path from '../(.*)/.*') like ?
group by language
order by count desc;]]></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>
  <DataSetParameters>
    <parameter>
      <design:ParameterDefinition>
        <design:inOutMode>In</design:inOutMode>
        <design:attributes>
          <design:identifier>
            <design:name></design:name>
            <design:position>1</design:position>
          </design:identifier>
          <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
          <design:precision>0</design:precision>
          <design:scale>0</design:scale>
          <design:nullability>Unknown</design:nullability>
        </design:attributes>
      </design:ParameterDefinition>
    </parameter>
  </DataSetParameters>
  <design:ResultSets derivedMetaData="true">
    <design:resultSetDefinitions>
      <design:resultSetColumns>
        <design:resultColumnDefinitions>
          <design:attributes>
            <design:identifier>
              <design:name>language</design:name>
              <design:position>1</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>language</design:displayName>
            </design:uiHints>
          </design:attributes>
          <design:usageHints>
            <design:label>language</design:label>
            <design:formattingHints>
              <design:displaySize>128</design:displaySize>
            </design:formattingHints>
          </design:usageHints>
        </design:resultColumnDefinitions>
        <design:resultColumnDefinitions>
          <design:attributes>
            <design:identifier>
              <design:name>count</design:name>
              <design:position>2</design:position>
            </design:identifier>
            <design:nativeDataTypeCode>-5</design:nativeDataTypeCode>
            <design:precision>19</design:precision>
            <design:scale>0</design:scale>
            <design:nullability>Unknown</design:nullability>
            <design:uiHints>
              <design:displayName>count</design:displayName>
            </design:uiHints>
          </design:attributes>
          <design:usageHints>
            <design:label>count</design:label>
            <design:formattingHints>
              <design:displaySize>20</design:displaySize>
            </design:formattingHints>
          </design:usageHints>
        </design:resultColumnDefinitions>
      </design:resultSetColumns>
      <design:criteria/>
    </design:resultSetDefinitions>
  </design:ResultSets>
</model:DesignValues>]]></xml-property>
        </oda-data-set>
        <oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" name="employees by tool" id="673">
            <list-property name="columnHints">
                <structure>
                    <property name="columnName">zodb_path</property>
                    <property name="analysis">attribute</property>
                    <text-property name="displayName">zodb_path</text-property>
                    <text-property name="heading">zodb_path</text-property>
                </structure>
                <structure>
                    <property name="columnName">employees</property>
                    <property name="analysis">attribute</property>
                    <text-property name="displayName">employees</text-property>
                    <text-property name="heading">employees</text-property>
                </structure>
                <structure>
                    <property name="columnName">count</property>
                    <property name="analysis">measure</property>
                    <text-property name="displayName">count</text-property>
                    <text-property name="heading">count</text-property>
                </structure>
            </list-property>
            <list-property name="parameters">
                <structure>
                    <property name="name">param_1</property>
                    <property name="paramName">sector</property>
                    <property name="nativeName"></property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                    <property name="position">1</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">zodb_path</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">2</property>
                        <property name="name">employees</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">3</property>
                        <property name="name">count</property>
                        <property name="dataType">decimal</property>
                    </structure>
                </list-property>
            </structure>
            <property name="dataSource">OiRA Postgres DB</property>
            <list-property name="resultSet">
                <structure>
                    <property name="position">1</property>
                    <property name="name">zodb_path</property>
                    <property name="nativeName">zodb_path</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
                <structure>
                    <property name="position">2</property>
                    <property name="name">employees</property>
                    <property name="nativeName">employees</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
                <structure>
                    <property name="position">3</property>
                    <property name="name">count</property>
                    <property name="nativeName">count</property>
                    <property name="dataType">decimal</property>
                    <property name="nativeDataType">-5</property>
                </structure>
            </list-property>
            <xml-property name="queryText"><![CDATA[select zodb_path, employees, count(session_id)
from company,session
where company.session_id = session.id
and substring(zodb_path from '../(.*)/.*') like ?
group by zodb_path, employees order by zodb_path, employees;]]></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>
  <DataSetParameters>
    <parameter>
      <design:ParameterDefinition>
        <design:inOutMode>In</design:inOutMode>
        <design:attributes>
          <design:identifier>
            <design:name></design:name>
            <design:position>1</design:position>
          </design:identifier>
          <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
          <design:precision>0</design:precision>
          <design:scale>0</design:scale>
          <design:nullability>Unknown</design:nullability>
        </design:attributes>
      </design:ParameterDefinition>
    </parameter>
  </DataSetParameters>
  <design:ResultSets derivedMetaData="true">
    <design:resultSetDefinitions>
      <design:resultSetColumns>
        <design:resultColumnDefinitions>
          <design:attributes>
            <design:identifier>
              <design:name>zodb_path</design:name>
              <design:position>1</design:position>
            </design:identifier>
            <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
            <design:precision>128</design:precision>
            <design:scale>0</design:scale>
            <design:nullability>NotNullable</design:nullability>
            <design:uiHints>
              <design:displayName>zodb_path</design:displayName>
            </design:uiHints>
          </design:attributes>
          <design:usageHints>
            <design:label>zodb_path</design:label>
            <design:formattingHints>
              <design:displaySize>128</design:displaySize>
            </design:formattingHints>
          </design:usageHints>
        </design:resultColumnDefinitions>
        <design:resultColumnDefinitions>
          <design:attributes>
            <design:identifier>
              <design:name>employees</design:name>
              <design:position>2</design:position>
            </design:identifier>
            <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
            <design:precision>6</design:precision>
            <design:scale>0</design:scale>
            <design:nullability>Nullable</design:nullability>
            <design:uiHints>
              <design:displayName>employees</design:displayName>
            </design:uiHints>
          </design:attributes>
          <design:usageHints>
            <design:label>employees</design:label>
            <design:formattingHints>
              <design:displaySize>6</design:displaySize>
            </design:formattingHints>
          </design:usageHints>
        </design:resultColumnDefinitions>
        <design:resultColumnDefinitions>
          <design:attributes>
            <design:identifier>
              <design:name>count</design:name>
              <design:position>3</design:position>
            </design:identifier>
            <design:nativeDataTypeCode>-5</design:nativeDataTypeCode>
            <design:precision>19</design:precision>
            <design:scale>0</design:scale>
            <design:nullability>Unknown</design:nullability>
            <design:uiHints>
              <design:displayName>count</design:displayName>
            </design:uiHints>
          </design:attributes>
          <design:usageHints>
            <design:label>count</design:label>
            <design:formattingHints>
              <design:displaySize>20</design:displaySize>
            </design:formattingHints>
          </design:usageHints>
        </design:resultColumnDefinitions>
      </design:resultSetColumns>
      <design:criteria/>
    </design:resultSetDefinitions>
  </design:ResultSets>
</model:DesignValues>]]></xml-property>
        </oda-data-set>
        <oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" name="employees by sector" id="696">
            <list-property name="columnHints">
                <structure>
                    <property name="columnName">sector</property>
                    <property name="analysis">attribute</property>
                    <text-property name="displayName">sector</text-property>
                    <text-property name="heading">sector</text-property>
                </structure>
                <structure>
                    <property name="columnName">employees</property>
                    <property name="analysis">attribute</property>
                    <text-property name="displayName">employees</text-property>
                    <text-property name="heading">employees</text-property>
                </structure>
                <structure>
                    <property name="columnName">count</property>
                    <property name="analysis">measure</property>
                    <text-property name="displayName">count</text-property>
                    <text-property name="heading">count</text-property>
                </structure>
            </list-property>
            <list-property name="parameters">
                <structure>
                    <property name="name">param_1</property>
                    <property name="paramName">sector</property>
                    <property name="nativeName"></property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                    <property name="position">1</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">sector</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">2</property>
                        <property name="name">employees</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">3</property>
                        <property name="name">count</property>
                        <property name="dataType">decimal</property>
                    </structure>
                </list-property>
            </structure>
            <property name="dataSource">OiRA Postgres DB</property>
            <list-property name="resultSet">
                <structure>
                    <property name="position">1</property>
                    <property name="name">sector</property>
                    <property name="nativeName">sector</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
                <structure>
                    <property name="position">2</property>
                    <property name="name">employees</property>
                    <property name="nativeName">employees</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
                <structure>
                    <property name="position">3</property>
                    <property name="name">count</property>
                    <property name="nativeName">count</property>
                    <property name="dataType">decimal</property>
                    <property name="nativeDataType">-5</property>
                </structure>
            </list-property>
            <xml-property name="queryText"><![CDATA[select substring(zodb_path from E'../\([^/]*\)/') as sector, employees, count(session_id)
from company,session
where company.session_id = session.id
and substring(zodb_path from '../(.*)/.*') like ?
group by sector, employees order by sector, employees;]]></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>
  <DataSetParameters>
    <parameter>
      <design:ParameterDefinition>
        <design:inOutMode>In</design:inOutMode>
        <design:attributes>
          <design:identifier>
            <design:name></design:name>
            <design:position>1</design:position>
          </design:identifier>
          <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
          <design:precision>0</design:precision>
          <design:scale>0</design:scale>
          <design:nullability>Unknown</design:nullability>
        </design:attributes>
      </design:ParameterDefinition>
    </parameter>
  </DataSetParameters>
  <design:ResultSets derivedMetaData="true">
    <design:resultSetDefinitions>
      <design:resultSetColumns>
        <design:resultColumnDefinitions>
          <design:attributes>
            <design:identifier>
              <design:name>sector</design:name>
              <design:position>1</design:position>
            </design:identifier>
            <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
            <design:precision>2147483647</design:precision>
            <design:scale>0</design:scale>
            <design:nullability>Unknown</design:nullability>
            <design:uiHints>
              <design:displayName>sector</design:displayName>
            </design:uiHints>
          </design:attributes>
          <design:usageHints>
            <design:label>sector</design:label>
            <design:formattingHints>
              <design:displaySize>2147483647</design:displaySize>
            </design:formattingHints>
          </design:usageHints>
        </design:resultColumnDefinitions>
        <design:resultColumnDefinitions>
          <design:attributes>
            <design:identifier>
              <design:name>employees</design:name>
              <design:position>2</design:position>
            </design:identifier>
            <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
            <design:precision>6</design:precision>
            <design:scale>0</design:scale>
            <design:nullability>Nullable</design:nullability>
            <design:uiHints>
              <design:displayName>employees</design:displayName>
            </design:uiHints>
          </design:attributes>
          <design:usageHints>
            <design:label>employees</design:label>
            <design:formattingHints>
              <design:displaySize>6</design:displaySize>
            </design:formattingHints>
          </design:usageHints>
        </design:resultColumnDefinitions>
        <design:resultColumnDefinitions>
          <design:attributes>
            <design:identifier>
              <design:name>count</design:name>
              <design:position>3</design:position>
            </design:identifier>
            <design:nativeDataTypeCode>-5</design:nativeDataTypeCode>
            <design:precision>19</design:precision>
            <design:scale>0</design:scale>
            <design:nullability>Unknown</design:nullability>
            <design:uiHints>
              <design:displayName>count</design:displayName>
            </design:uiHints>
          </design:attributes>
          <design:usageHints>
            <design:label>count</design:label>
            <design:formattingHints>
              <design:displaySize>20</design:displaySize>
            </design:formattingHints>
          </design:usageHints>
        </design:resultColumnDefinitions>
      </design:resultSetColumns>
      <design:criteria/>
    </design:resultSetDefinitions>
  </design:ResultSets>
</model:DesignValues>]]></xml-property>
        </oda-data-set>
        <oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" name="employees by country" id="697">
            <list-property name="columnHints">
                <structure>
                    <property name="columnName">country</property>
                    <property name="analysis">attribute</property>
                    <text-property name="displayName">country</text-property>
                    <text-property name="heading">country</text-property>
                </structure>
                <structure>
                    <property name="columnName">employees</property>
                    <property name="analysis">attribute</property>
                    <text-property name="displayName">employees</text-property>
                    <text-property name="heading">employees</text-property>
                </structure>
                <structure>
                    <property name="columnName">count</property>
                    <property name="analysis">measure</property>
                    <text-property name="displayName">count</text-property>
                    <text-property name="heading">count</text-property>
                </structure>
            </list-property>
            <list-property name="parameters">
                <structure>
                    <property name="name">param_1</property>
                    <property name="paramName">sector</property>
                    <property name="nativeName"></property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                    <property name="position">1</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">country</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">2</property>
                        <property name="name">employees</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">3</property>
                        <property name="name">count</property>
                        <property name="dataType">decimal</property>
                    </structure>
                </list-property>
            </structure>
            <property name="dataSource">OiRA Postgres DB</property>
            <list-property name="resultSet">
                <structure>
                    <property name="position">1</property>
                    <property name="name">country</property>
                    <property name="nativeName">country</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
                <structure>
                    <property name="position">2</property>
                    <property name="name">employees</property>
                    <property name="nativeName">employees</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
                <structure>
                    <property name="position">3</property>
                    <property name="name">count</property>
                    <property name="nativeName">count</property>
                    <property name="dataType">decimal</property>
                    <property name="nativeDataType">-5</property>
                </structure>
            </list-property>
            <xml-property name="queryText"><![CDATA[select substring(zodb_path from '^..') as country, employees, count(session_id)
from company,session
where company.session_id = session.id
and substring(zodb_path from '../(.*)/.*') like ?
group by substring(zodb_path from '^..'), employees order by country, employees;]]></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>
  <DataSetParameters>
    <parameter>
      <design:ParameterDefinition>
        <design:inOutMode>In</design:inOutMode>
        <design:attributes>
          <design:identifier>
            <design:name></design:name>
            <design:position>1</design:position>
          </design:identifier>
          <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
          <design:precision>0</design:precision>
          <design:scale>0</design:scale>
          <design:nullability>Unknown</design:nullability>
        </design:attributes>
      </design:ParameterDefinition>
    </parameter>
  </DataSetParameters>
  <design:ResultSets derivedMetaData="true">
    <design:resultSetDefinitions>
      <design:resultSetColumns>
        <design:resultColumnDefinitions>
          <design:attributes>
            <design:identifier>
              <design:name>country</design:name>
              <design:position>1</design:position>
            </design:identifier>
            <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
            <design:precision>2147483647</design:precision>
            <design:scale>0</design:scale>
            <design:nullability>Unknown</design:nullability>
            <design:uiHints>
              <design:displayName>country</design:displayName>
            </design:uiHints>
          </design:attributes>
          <design:usageHints>
            <design:label>country</design:label>
            <design:formattingHints>
              <design:displaySize>2147483647</design:displaySize>
            </design:formattingHints>
          </design:usageHints>
        </design:resultColumnDefinitions>
        <design:resultColumnDefinitions>
          <design:attributes>
            <design:identifier>
              <design:name>employees</design:name>
              <design:position>2</design:position>
            </design:identifier>
            <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
            <design:precision>6</design:precision>
            <design:scale>0</design:scale>
            <design:nullability>Nullable</design:nullability>
            <design:uiHints>
              <design:displayName>employees</design:displayName>
            </design:uiHints>
          </design:attributes>
          <design:usageHints>
            <design:label>employees</design:label>
            <design:formattingHints>
              <design:displaySize>6</design:displaySize>
            </design:formattingHints>
          </design:usageHints>
        </design:resultColumnDefinitions>
        <design:resultColumnDefinitions>
          <design:attributes>
            <design:identifier>
              <design:name>count</design:name>
              <design:position>3</design:position>
            </design:identifier>
            <design:nativeDataTypeCode>-5</design:nativeDataTypeCode>
            <design:precision>19</design:precision>
            <design:scale>0</design:scale>
            <design:nullability>Unknown</design:nullability>
            <design:uiHints>
              <design:displayName>count</design:displayName>
            </design:uiHints>
          </design:attributes>
          <design:usageHints>
            <design:label>count</design:label>
            <design:formattingHints>
              <design:displaySize>20</design:displaySize>
            </design:formattingHints>
          </design:usageHints>
        </design:resultColumnDefinitions>
      </design:resultSetColumns>
      <design:criteria/>
    </design:resultSetDefinitions>
  </design:ResultSets>
</model:DesignValues>]]></xml-property>
        </oda-data-set>
        <oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" name="country_company by tool" id="698">
            <list-property name="columnHints">
                <structure>
                    <property name="columnName">zodb_path</property>
                    <property name="analysis">attribute</property>
                    <text-property name="displayName">zodb_path</text-property>
                    <text-property name="heading">zodb_path</text-property>
                </structure>
                <structure>
                    <property name="columnName">country_company</property>
                    <property name="analysis">attribute</property>
                    <text-property name="displayName">country_company</text-property>
                    <text-property name="heading">country_company</text-property>
                </structure>
                <structure>
                    <property name="columnName">count</property>
                    <property name="analysis">measure</property>
                    <text-property name="displayName">count</text-property>
                    <text-property name="heading">count</text-property>
                </structure>
            </list-property>
            <list-property name="parameters">
                <structure>
                    <property name="name">param_1</property>
                    <property name="paramName">sector</property>
                    <property name="nativeName"></property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                    <property name="position">1</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">zodb_path</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">2</property>
                        <property name="name">country_company</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">3</property>
                        <property name="name">count</property>
                        <property name="dataType">decimal</property>
                    </structure>
                </list-property>
            </structure>
            <property name="dataSource">OiRA Postgres DB</property>
            <list-property name="resultSet">
                <structure>
                    <property name="position">1</property>
                    <property name="name">zodb_path</property>
                    <property name="nativeName">zodb_path</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
                <structure>
                    <property name="position">2</property>
                    <property name="name">country_company</property>
                    <property name="nativeName">country_company</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
                <structure>
                    <property name="position">3</property>
                    <property name="name">count</property>
                    <property name="nativeName">count</property>
                    <property name="dataType">decimal</property>
                    <property name="nativeDataType">-5</property>
                </structure>
            </list-property>
            <xml-property name="queryText"><![CDATA[select zodb_path, country as country_company, count(session_id)
from company,session
where company.session_id = session.id
and substring(zodb_path from '../(.*)/.*') like ?
group by zodb_path, country order by zodb_path, count desc;]]></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>
  <DataSetParameters>
    <parameter>
      <design:ParameterDefinition>
        <design:inOutMode>In</design:inOutMode>
        <design:attributes>
          <design:identifier>
            <design:name></design:name>
            <design:position>1</design:position>
          </design:identifier>
          <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
          <design:precision>0</design:precision>
          <design:scale>0</design:scale>
          <design:nullability>Unknown</design:nullability>
        </design:attributes>
      </design:ParameterDefinition>
    </parameter>
  </DataSetParameters>
  <design:ResultSets derivedMetaData="true">
    <design:resultSetDefinitions>
      <design:resultSetColumns>
        <design:resultColumnDefinitions>
          <design:attributes>
            <design:identifier>
              <design:name>zodb_path</design:name>
              <design:position>1</design:position>
            </design:identifier>
            <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
            <design:precision>128</design:precision>
            <design:scale>0</design:scale>
            <design:nullability>NotNullable</design:nullability>
            <design:uiHints>
              <design:displayName>zodb_path</design:displayName>
            </design:uiHints>
          </design:attributes>
          <design:usageHints>
            <design:label>zodb_path</design:label>
            <design:formattingHints>
              <design:displaySize>128</design:displaySize>
            </design:formattingHints>
          </design:usageHints>
        </design:resultColumnDefinitions>
        <design:resultColumnDefinitions>
          <design:attributes>
            <design:identifier>
              <design:name>country_company</design:name>
              <design:position>2</design:position>
            </design:identifier>
            <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
            <design:precision>3</design:precision>
            <design:scale>0</design:scale>
            <design:nullability>Nullable</design:nullability>
            <design:uiHints>
              <design:displayName>country_company</design:displayName>
            </design:uiHints>
          </design:attributes>
          <design:usageHints>
            <design:label>country_company</design:label>
            <design:formattingHints>
              <design:displaySize>3</design:displaySize>
            </design:formattingHints>
          </design:usageHints>
        </design:resultColumnDefinitions>
        <design:resultColumnDefinitions>
          <design:attributes>
            <design:identifier>
              <design:name>count</design:name>
              <design:position>3</design:position>
            </design:identifier>
            <design:nativeDataTypeCode>-5</design:nativeDataTypeCode>
            <design:precision>19</design:precision>
            <design:scale>0</design:scale>
            <design:nullability>Unknown</design:nullability>
            <design:uiHints>
              <design:displayName>count</design:displayName>
            </design:uiHints>
          </design:attributes>
          <design:usageHints>
            <design:label>count</design:label>
            <design:formattingHints>
              <design:displaySize>20</design:displaySize>
            </design:formattingHints>
          </design:usageHints>
        </design:resultColumnDefinitions>
      </design:resultSetColumns>
      <design:criteria/>
    </design:resultSetDefinitions>
  </design:ResultSets>
</model:DesignValues>]]></xml-property>
        </oda-data-set>
        <oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" name="country_company by sector" id="699">
            <list-property name="columnHints">
                <structure>
                    <property name="columnName">sector</property>
                    <property name="analysis">attribute</property>
                    <text-property name="displayName">sector</text-property>
                    <text-property name="heading">sector</text-property>
                </structure>
                <structure>
                    <property name="columnName">country_company</property>
                    <property name="analysis">attribute</property>
                    <text-property name="displayName">country_company</text-property>
                    <text-property name="heading">country_company</text-property>
                </structure>
                <structure>
                    <property name="columnName">count</property>
                    <property name="analysis">measure</property>
                    <text-property name="displayName">count</text-property>
                    <text-property name="heading">count</text-property>
                </structure>
            </list-property>
            <list-property name="parameters">
                <structure>
                    <property name="name">param_1</property>
                    <property name="paramName">sector</property>
                    <property name="nativeName"></property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                    <property name="position">1</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">sector</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">2</property>
                        <property name="name">country_company</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">3</property>
                        <property name="name">count</property>
                        <property name="dataType">decimal</property>
                    </structure>
                </list-property>
            </structure>
            <property name="dataSource">OiRA Postgres DB</property>
            <list-property name="resultSet">
                <structure>
                    <property name="position">1</property>
                    <property name="name">sector</property>
                    <property name="nativeName">sector</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
                <structure>
                    <property name="position">2</property>
                    <property name="name">country_company</property>
                    <property name="nativeName">country_company</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
                <structure>
                    <property name="position">3</property>
                    <property name="name">count</property>
                    <property name="nativeName">count</property>
                    <property name="dataType">decimal</property>
                    <property name="nativeDataType">-5</property>
                </structure>
            </list-property>
            <xml-property name="queryText"><![CDATA[select substring(zodb_path from E'../\([^/]*\)/') as sector, country as country_company, count(session_id)
from company,session
where company.session_id = session.id
and substring(zodb_path from '../(.*)/.*') like ?
group by sector, country_company order by sector, country_company;]]></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>
  <DataSetParameters>
    <parameter>
      <design:ParameterDefinition>
        <design:inOutMode>In</design:inOutMode>
        <design:attributes>
          <design:identifier>
            <design:name></design:name>
            <design:position>1</design:position>
          </design:identifier>
          <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
          <design:precision>0</design:precision>
          <design:scale>0</design:scale>
          <design:nullability>Unknown</design:nullability>
        </design:attributes>
      </design:ParameterDefinition>
    </parameter>
  </DataSetParameters>
</model:DesignValues>]]></xml-property>
        </oda-data-set>
        <oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" name="country_company by country_path" id="700">
            <list-property name="columnHints">
                <structure>
                    <property name="columnName">country_path</property>
                    <property name="analysis">attribute</property>
                    <text-property name="displayName">country_path</text-property>
                    <text-property name="heading">country_path</text-property>
                </structure>
                <structure>
                    <property name="columnName">country_company</property>
                    <property name="analysis">attribute</property>
                    <text-property name="displayName">country_company</text-property>
                    <text-property name="heading">country_company</text-property>
                </structure>
                <structure>
                    <property name="columnName">count</property>
                    <property name="analysis">measure</property>
                    <text-property name="displayName">count</text-property>
                    <text-property name="heading">count</text-property>
                </structure>
            </list-property>
            <list-property name="parameters">
                <structure>
                    <property name="name">param_1</property>
                    <property name="paramName">sector</property>
                    <property name="nativeName"></property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                    <property name="position">1</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">country_path</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">2</property>
                        <property name="name">country_company</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">3</property>
                        <property name="name">count</property>
                        <property name="dataType">decimal</property>
                    </structure>
                </list-property>
            </structure>
            <property name="dataSource">OiRA Postgres DB</property>
            <list-property name="resultSet">
                <structure>
                    <property name="position">1</property>
                    <property name="name">country_path</property>
                    <property name="nativeName">country_path</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
                <structure>
                    <property name="position">2</property>
                    <property name="name">country_company</property>
                    <property name="nativeName">country_company</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
                <structure>
                    <property name="position">3</property>
                    <property name="name">count</property>
                    <property name="nativeName">count</property>
                    <property name="dataType">decimal</property>
                    <property name="nativeDataType">-5</property>
                </structure>
            </list-property>
            <xml-property name="queryText"><![CDATA[select substring(zodb_path from '^..') as country_path, country as country_company, count(session_id)
from company,session
where company.session_id = session.id
and substring(zodb_path from '../(.*)/.*') like ?
group by substring(zodb_path from '^..'), country order by country_path, count desc;]]></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>
  <DataSetParameters>
    <parameter>
      <design:ParameterDefinition>
        <design:inOutMode>In</design:inOutMode>
        <design:attributes>
          <design:identifier>
            <design:name></design:name>
            <design:position>1</design:position>
          </design:identifier>
          <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
          <design:precision>0</design:precision>
          <design:scale>0</design:scale>
          <design:nullability>Unknown</design:nullability>
        </design:attributes>
      </design:ParameterDefinition>
    </parameter>
  </DataSetParameters>
  <design:ResultSets derivedMetaData="true">
    <design:resultSetDefinitions>
      <design:resultSetColumns>
        <design:resultColumnDefinitions>
          <design:attributes>
            <design:identifier>
              <design:name>country_path</design:name>
              <design:position>1</design:position>
            </design:identifier>
            <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
            <design:precision>2147483647</design:precision>
            <design:scale>0</design:scale>
            <design:nullability>Unknown</design:nullability>
            <design:uiHints>
              <design:displayName>country_path</design:displayName>
            </design:uiHints>
          </design:attributes>
          <design:usageHints>
            <design:label>country_path</design:label>
            <design:formattingHints>
              <design:displaySize>2147483647</design:displaySize>
            </design:formattingHints>
          </design:usageHints>
        </design:resultColumnDefinitions>
        <design:resultColumnDefinitions>
          <design:attributes>
            <design:identifier>
              <design:name>country_company</design:name>
              <design:position>2</design:position>
            </design:identifier>
            <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
            <design:precision>3</design:precision>
            <design:scale>0</design:scale>
            <design:nullability>Nullable</design:nullability>
            <design:uiHints>
              <design:displayName>country_company</design:displayName>
            </design:uiHints>
          </design:attributes>
          <design:usageHints>
            <design:label>country_company</design:label>
            <design:formattingHints>
              <design:displaySize>3</design:displaySize>
            </design:formattingHints>
          </design:usageHints>
        </design:resultColumnDefinitions>
        <design:resultColumnDefinitions>
          <design:attributes>
            <design:identifier>
              <design:name>count</design:name>
              <design:position>3</design:position>
            </design:identifier>
            <design:nativeDataTypeCode>-5</design:nativeDataTypeCode>
            <design:precision>19</design:precision>
            <design:scale>0</design:scale>
            <design:nullability>Unknown</design:nullability>
            <design:uiHints>
              <design:displayName>count</design:displayName>
            </design:uiHints>
          </design:attributes>
          <design:usageHints>
            <design:label>count</design:label>
            <design:formattingHints>
              <design:displaySize>20</design:displaySize>
            </design:formattingHints>
          </design:usageHints>
        </design:resultColumnDefinitions>
      </design:resultSetColumns>
      <design:criteria/>
    </design:resultSetDefinitions>
  </design:ResultSets>
</model:DesignValues>]]></xml-property>
        </oda-data-set>
        <oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" name="conductor by tool" id="701">
            <list-property name="columnHints">
                <structure>
                    <property name="columnName">zodb_path</property>
                    <property name="analysis">attribute</property>
                    <text-property name="displayName">zodb_path</text-property>
                    <text-property name="heading">zodb_path</text-property>
                </structure>
                <structure>
                    <property name="columnName">conductor</property>
                    <property name="analysis">attribute</property>
                    <text-property name="displayName">conductor</text-property>
                    <text-property name="heading">conductor</text-property>
                </structure>
                <structure>
                    <property name="columnName">count</property>
                    <property name="analysis">measure</property>
                    <text-property name="displayName">count</text-property>
                    <text-property name="heading">count</text-property>
                </structure>
            </list-property>
            <list-property name="parameters">
                <structure>
                    <property name="name">param_1</property>
                    <property name="paramName">sector</property>
                    <property name="nativeName"></property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                    <property name="position">1</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">zodb_path</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">2</property>
                        <property name="name">conductor</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">3</property>
                        <property name="name">count</property>
                        <property name="dataType">decimal</property>
                    </structure>
                </list-property>
            </structure>
            <property name="dataSource">OiRA Postgres DB</property>
            <list-property name="resultSet">
                <structure>
                    <property name="position">1</property>
                    <property name="name">zodb_path</property>
                    <property name="nativeName">zodb_path</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
                <structure>
                    <property name="position">2</property>
                    <property name="name">conductor</property>
                    <property name="nativeName">conductor</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
                <structure>
                    <property name="position">3</property>
                    <property name="name">count</property>
                    <property name="nativeName">count</property>
                    <property name="dataType">decimal</property>
                    <property name="nativeDataType">-5</property>
                </structure>
            </list-property>
            <xml-property name="queryText"><![CDATA[select zodb_path, conductor, count(session_id) from company,session
where company.session_id = session.id
and substring(zodb_path from '../(.*)/.*') like ?
group by zodb_path, conductor order by zodb_path, conductor;
]]></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>
  <DataSetParameters>
    <parameter>
      <design:ParameterDefinition>
        <design:inOutMode>In</design:inOutMode>
        <design:attributes>
          <design:identifier>
            <design:name></design:name>
            <design:position>1</design:position>
          </design:identifier>
          <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
          <design:precision>0</design:precision>
          <design:scale>0</design:scale>
          <design:nullability>Unknown</design:nullability>
        </design:attributes>
      </design:ParameterDefinition>
    </parameter>
  </DataSetParameters>
  <design:ResultSets derivedMetaData="true">
    <design:resultSetDefinitions>
      <design:resultSetColumns>
        <design:resultColumnDefinitions>
          <design:attributes>
            <design:identifier>
              <design:name>zodb_path</design:name>
              <design:position>1</design:position>
            </design:identifier>
            <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
            <design:precision>128</design:precision>
            <design:scale>0</design:scale>
            <design:nullability>NotNullable</design:nullability>
            <design:uiHints>
              <design:displayName>zodb_path</design:displayName>
            </design:uiHints>
          </design:attributes>
          <design:usageHints>
            <design:label>zodb_path</design:label>
            <design:formattingHints>
              <design:displaySize>128</design:displaySize>
            </design:formattingHints>
          </design:usageHints>
        </design:resultColumnDefinitions>
        <design:resultColumnDefinitions>
          <design:attributes>
            <design:identifier>
              <design:name>conductor</design:name>
              <design:position>2</design:position>
            </design:identifier>
            <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
            <design:precision>11</design:precision>
            <design:scale>0</design:scale>
            <design:nullability>Nullable</design:nullability>
            <design:uiHints>
              <design:displayName>conductor</design:displayName>
            </design:uiHints>
          </design:attributes>
          <design:usageHints>
            <design:label>conductor</design:label>
            <design:formattingHints>
              <design:displaySize>11</design:displaySize>
            </design:formattingHints>
          </design:usageHints>
        </design:resultColumnDefinitions>
        <design:resultColumnDefinitions>
          <design:attributes>
            <design:identifier>
              <design:name>count</design:name>
              <design:position>3</design:position>
            </design:identifier>
            <design:nativeDataTypeCode>-5</design:nativeDataTypeCode>
            <design:precision>19</design:precision>
            <design:scale>0</design:scale>
            <design:nullability>Unknown</design:nullability>
            <design:uiHints>
              <design:displayName>count</design:displayName>
            </design:uiHints>
          </design:attributes>
          <design:usageHints>
            <design:label>count</design:label>
            <design:formattingHints>
              <design:displaySize>20</design:displaySize>
            </design:formattingHints>
          </design:usageHints>
        </design:resultColumnDefinitions>
      </design:resultSetColumns>
      <design:criteria/>
    </design:resultSetDefinitions>
  </design:ResultSets>
</model:DesignValues>]]></xml-property>
        </oda-data-set>
        <oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" name="conductor by sector" id="702">
            <list-property name="columnHints">
                <structure>
                    <property name="columnName">sector</property>
                    <property name="analysis">attribute</property>
                    <text-property name="displayName">sector</text-property>
                    <text-property name="heading">sector</text-property>
                </structure>
                <structure>
                    <property name="columnName">conductor</property>
                    <property name="analysis">attribute</property>
                    <text-property name="displayName">conductor</text-property>
                    <text-property name="heading">conductor</text-property>
                </structure>
                <structure>
                    <property name="columnName">count</property>
                    <property name="analysis">measure</property>
                    <text-property name="displayName">count</text-property>
                    <text-property name="heading">count</text-property>
                </structure>
            </list-property>
            <list-property name="parameters">
                <structure>
                    <property name="name">param_1</property>
                    <property name="paramName">sector</property>
                    <property name="nativeName"></property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                    <property name="position">1</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">sector</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">2</property>
                        <property name="name">conductor</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">3</property>
                        <property name="name">count</property>
                        <property name="dataType">decimal</property>
                    </structure>
                </list-property>
            </structure>
            <property name="dataSource">OiRA Postgres DB</property>
            <list-property name="resultSet">
                <structure>
                    <property name="position">1</property>
                    <property name="name">sector</property>
                    <property name="nativeName">sector</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
                <structure>
                    <property name="position">2</property>
                    <property name="name">conductor</property>
                    <property name="nativeName">conductor</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
                <structure>
                    <property name="position">3</property>
                    <property name="name">count</property>
                    <property name="nativeName">count</property>
                    <property name="dataType">decimal</property>
                    <property name="nativeDataType">-5</property>
                </structure>
            </list-property>
            <xml-property name="queryText"><![CDATA[select substring(zodb_path from E'../\([^/]*\)/') as sector, conductor, count(session_id)
from company,session
where company.session_id = session.id
and substring(zodb_path from '../(.*)/.*') like ?
group by sector, conductor order by sector, conductor;]]></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>
  <DataSetParameters>
    <parameter>
      <design:ParameterDefinition>
        <design:inOutMode>In</design:inOutMode>
        <design:attributes>
          <design:identifier>
            <design:name></design:name>
            <design:position>1</design:position>
          </design:identifier>
          <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
          <design:precision>0</design:precision>
          <design:scale>0</design:scale>
          <design:nullability>Unknown</design:nullability>
        </design:attributes>
      </design:ParameterDefinition>
    </parameter>
  </DataSetParameters>
  <design:ResultSets derivedMetaData="true">
    <design:resultSetDefinitions>
      <design:resultSetColumns>
        <design:resultColumnDefinitions>
          <design:attributes>
            <design:identifier>
              <design:name>sector</design:name>
              <design:position>1</design:position>
            </design:identifier>
            <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
            <design:precision>2147483647</design:precision>
            <design:scale>0</design:scale>
            <design:nullability>Unknown</design:nullability>
            <design:uiHints>
              <design:displayName>sector</design:displayName>
            </design:uiHints>
          </design:attributes>
          <design:usageHints>
            <design:label>sector</design:label>
            <design:formattingHints>
              <design:displaySize>2147483647</design:displaySize>
            </design:formattingHints>
          </design:usageHints>
        </design:resultColumnDefinitions>
        <design:resultColumnDefinitions>
          <design:attributes>
            <design:identifier>
              <design:name>conductor</design:name>
              <design:position>2</design:position>
            </design:identifier>
            <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
            <design:precision>11</design:precision>
            <design:scale>0</design:scale>
            <design:nullability>Nullable</design:nullability>
            <design:uiHints>
              <design:displayName>conductor</design:displayName>
            </design:uiHints>
          </design:attributes>
          <design:usageHints>
            <design:label>conductor</design:label>
            <design:formattingHints>
              <design:displaySize>11</design:displaySize>
            </design:formattingHints>
          </design:usageHints>
        </design:resultColumnDefinitions>
        <design:resultColumnDefinitions>
          <design:attributes>
            <design:identifier>
              <design:name>count</design:name>
              <design:position>3</design:position>
            </design:identifier>
            <design:nativeDataTypeCode>-5</design:nativeDataTypeCode>
            <design:precision>19</design:precision>
            <design:scale>0</design:scale>
            <design:nullability>Unknown</design:nullability>
            <design:uiHints>
              <design:displayName>count</design:displayName>
            </design:uiHints>
          </design:attributes>
          <design:usageHints>
            <design:label>count</design:label>
            <design:formattingHints>
              <design:displaySize>20</design:displaySize>
            </design:formattingHints>
          </design:usageHints>
        </design:resultColumnDefinitions>
      </design:resultSetColumns>
      <design:criteria/>
    </design:resultSetDefinitions>
  </design:ResultSets>
</model:DesignValues>]]></xml-property>
        </oda-data-set>
        <oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" name="conductor by country" id="703">
            <list-property name="columnHints">
                <structure>
                    <property name="columnName">country</property>
                    <property name="analysis">attribute</property>
                    <text-property name="displayName">country</text-property>
                    <text-property name="heading">country</text-property>
                </structure>
                <structure>
                    <property name="columnName">conductor</property>
                    <property name="analysis">attribute</property>
                    <text-property name="displayName">conductor</text-property>
                    <text-property name="heading">conductor</text-property>
                </structure>
                <structure>
                    <property name="columnName">count</property>
                    <property name="analysis">measure</property>
                    <text-property name="displayName">count</text-property>
                    <text-property name="heading">count</text-property>
                </structure>
            </list-property>
            <list-property name="parameters">
                <structure>
                    <property name="name">param_1</property>
                    <property name="paramName">sector</property>
                    <property name="nativeName"></property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                    <property name="position">1</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">country</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">2</property>
                        <property name="name">conductor</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">3</property>
                        <property name="name">count</property>
                        <property name="dataType">decimal</property>
                    </structure>
                </list-property>
            </structure>
            <property name="dataSource">OiRA Postgres DB</property>
            <list-property name="resultSet">
                <structure>
                    <property name="position">1</property>
                    <property name="name">country</property>
                    <property name="nativeName">country</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
                <structure>
                    <property name="position">2</property>
                    <property name="name">conductor</property>
                    <property name="nativeName">conductor</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
                <structure>
                    <property name="position">3</property>
                    <property name="name">count</property>
                    <property name="nativeName">count</property>
                    <property name="dataType">decimal</property>
                    <property name="nativeDataType">-5</property>
                </structure>
            </list-property>
            <xml-property name="queryText"><![CDATA[select substring(zodb_path from '^..') as country, conductor, count(session_id)
from company,session where company.session_id = session.id and substring(zodb_path from '../(.*)/.*') like ? group by substring(zodb_path from '^..'), conductor order by country, conductor;]]></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>
  <DataSetParameters>
    <parameter>
      <design:ParameterDefinition>
        <design:inOutMode>In</design:inOutMode>
        <design:attributes>
          <design:identifier>
            <design:name></design:name>
            <design:position>1</design:position>
          </design:identifier>
          <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
          <design:precision>0</design:precision>
          <design:scale>0</design:scale>
          <design:nullability>Unknown</design:nullability>
        </design:attributes>
      </design:ParameterDefinition>
    </parameter>
  </DataSetParameters>
  <design:ResultSets derivedMetaData="true">
    <design:resultSetDefinitions>
      <design:resultSetColumns>
        <design:resultColumnDefinitions>
          <design:attributes>
            <design:identifier>
              <design:name>country</design:name>
              <design:position>1</design:position>
            </design:identifier>
            <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
            <design:precision>2147483647</design:precision>
            <design:scale>0</design:scale>
            <design:nullability>Unknown</design:nullability>
            <design:uiHints>
              <design:displayName>country</design:displayName>
            </design:uiHints>
          </design:attributes>
          <design:usageHints>
            <design:label>country</design:label>
            <design:formattingHints>
              <design:displaySize>2147483647</design:displaySize>
            </design:formattingHints>
          </design:usageHints>
        </design:resultColumnDefinitions>
        <design:resultColumnDefinitions>
          <design:attributes>
            <design:identifier>
              <design:name>conductor</design:name>
              <design:position>2</design:position>
            </design:identifier>
            <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
            <design:precision>11</design:precision>
            <design:scale>0</design:scale>
            <design:nullability>Nullable</design:nullability>
            <design:uiHints>
              <design:displayName>conductor</design:displayName>
            </design:uiHints>
          </design:attributes>
          <design:usageHints>
            <design:label>conductor</design:label>
            <design:formattingHints>
              <design:displaySize>11</design:displaySize>
            </design:formattingHints>
          </design:usageHints>
        </design:resultColumnDefinitions>
        <design:resultColumnDefinitions>
          <design:attributes>
            <design:identifier>
              <design:name>count</design:name>
              <design:position>3</design:position>
            </design:identifier>
            <design:nativeDataTypeCode>-5</design:nativeDataTypeCode>
            <design:precision>19</design:precision>
            <design:scale>0</design:scale>
            <design:nullability>Unknown</design:nullability>
            <design:uiHints>
              <design:displayName>count</design:displayName>
            </design:uiHints>
          </design:attributes>
          <design:usageHints>
            <design:label>count</design:label>
            <design:formattingHints>
              <design:displaySize>20</design:displaySize>
            </design:formattingHints>
          </design:usageHints>
        </design:resultColumnDefinitions>
      </design:resultSetColumns>
      <design:criteria/>
    </design:resultSetDefinitions>
  </design:ResultSets>
</model:DesignValues>]]></xml-property>
        </oda-data-set>
        <oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" name="referer by tool" id="704">
            <list-property name="columnHints">
                <structure>
                    <property name="columnName">zodb_path</property>
                    <property name="analysis">attribute</property>
                    <text-property name="displayName">zodb_path</text-property>
                    <text-property name="heading">zodb_path</text-property>
                </structure>
                <structure>
                    <property name="columnName">referer</property>
                    <property name="analysis">attribute</property>
                    <text-property name="displayName">referer</text-property>
                    <text-property name="heading">referer</text-property>
                </structure>
                <structure>
                    <property name="columnName">count</property>
                    <property name="analysis">measure</property>
                    <text-property name="displayName">count</text-property>
                    <text-property name="heading">count</text-property>
                </structure>
            </list-property>
            <list-property name="parameters">
                <structure>
                    <property name="name">param_1</property>
                    <property name="paramName">sector</property>
                    <property name="nativeName"></property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                    <property name="position">1</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">zodb_path</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">2</property>
                        <property name="name">referer</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">3</property>
                        <property name="name">count</property>
                        <property name="dataType">decimal</property>
                    </structure>
                </list-property>
            </structure>
            <property name="dataSource">OiRA Postgres DB</property>
            <list-property name="resultSet">
                <structure>
                    <property name="position">1</property>
                    <property name="name">zodb_path</property>
                    <property name="nativeName">zodb_path</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
                <structure>
                    <property name="position">2</property>
                    <property name="name">referer</property>
                    <property name="nativeName">referer</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
                <structure>
                    <property name="position">3</property>
                    <property name="name">count</property>
                    <property name="nativeName">count</property>
                    <property name="dataType">decimal</property>
                    <property name="nativeDataType">-5</property>
                </structure>
            </list-property>
            <xml-property name="queryText"><![CDATA[select zodb_path, referer, count(session_id)
from company,session
where company.session_id = session.id
and substring(zodb_path from '../(.*)/.*') like ?
group by zodb_path, referer order by zodb_path, referer;]]></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>
  <DataSetParameters>
    <parameter>
      <design:ParameterDefinition>
        <design:inOutMode>In</design:inOutMode>
        <design:attributes>
          <design:identifier>
            <design:name></design:name>
            <design:position>1</design:position>
          </design:identifier>
          <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
          <design:precision>0</design:precision>
          <design:scale>0</design:scale>
          <design:nullability>Unknown</design:nullability>
        </design:attributes>
      </design:ParameterDefinition>
    </parameter>
  </DataSetParameters>
  <design:ResultSets derivedMetaData="true">
    <design:resultSetDefinitions>
      <design:resultSetColumns>
        <design:resultColumnDefinitions>
          <design:attributes>
            <design:identifier>
              <design:name>zodb_path</design:name>
              <design:position>1</design:position>
            </design:identifier>
            <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
            <design:precision>128</design:precision>
            <design:scale>0</design:scale>
            <design:nullability>NotNullable</design:nullability>
            <design:uiHints>
              <design:displayName>zodb_path</design:displayName>
            </design:uiHints>
          </design:attributes>
          <design:usageHints>
            <design:label>zodb_path</design:label>
            <design:formattingHints>
              <design:displaySize>128</design:displaySize>
            </design:formattingHints>
          </design:usageHints>
        </design:resultColumnDefinitions>
        <design:resultColumnDefinitions>
          <design:attributes>
            <design:identifier>
              <design:name>referer</design:name>
              <design:position>2</design:position>
            </design:identifier>
            <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
            <design:precision>27</design:precision>
            <design:scale>0</design:scale>
            <design:nullability>Nullable</design:nullability>
            <design:uiHints>
              <design:displayName>referer</design:displayName>
            </design:uiHints>
          </design:attributes>
          <design:usageHints>
            <design:label>referer</design:label>
            <design:formattingHints>
              <design:displaySize>27</design:displaySize>
            </design:formattingHints>
          </design:usageHints>
        </design:resultColumnDefinitions>
        <design:resultColumnDefinitions>
          <design:attributes>
            <design:identifier>
              <design:name>count</design:name>
              <design:position>3</design:position>
            </design:identifier>
            <design:nativeDataTypeCode>-5</design:nativeDataTypeCode>
            <design:precision>19</design:precision>
            <design:scale>0</design:scale>
            <design:nullability>Unknown</design:nullability>
            <design:uiHints>
              <design:displayName>count</design:displayName>
            </design:uiHints>
          </design:attributes>
          <design:usageHints>
            <design:label>count</design:label>
            <design:formattingHints>
              <design:displaySize>20</design:displaySize>
            </design:formattingHints>
          </design:usageHints>
        </design:resultColumnDefinitions>
      </design:resultSetColumns>
      <design:criteria/>
    </design:resultSetDefinitions>
  </design:ResultSets>
</model:DesignValues>]]></xml-property>
        </oda-data-set>
        <oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" name="referer by sector" id="705">
            <list-property name="columnHints">
                <structure>
                    <property name="columnName">sector</property>
                    <property name="analysis">attribute</property>
                    <text-property name="displayName">sector</text-property>
                    <text-property name="heading">sector</text-property>
                </structure>
                <structure>
                    <property name="columnName">referer</property>
                    <property name="analysis">attribute</property>
                    <text-property name="displayName">referer</text-property>
                    <text-property name="heading">referer</text-property>
                </structure>
                <structure>
                    <property name="columnName">count</property>
                    <property name="analysis">measure</property>
                    <text-property name="displayName">count</text-property>
                    <text-property name="heading">count</text-property>
                </structure>
            </list-property>
            <list-property name="parameters">
                <structure>
                    <property name="name">param_1</property>
                    <property name="paramName">sector</property>
                    <property name="nativeName"></property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                    <property name="position">1</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">sector</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">2</property>
                        <property name="name">referer</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">3</property>
                        <property name="name">count</property>
                        <property name="dataType">decimal</property>
                    </structure>
                </list-property>
            </structure>
            <property name="dataSource">OiRA Postgres DB</property>
            <list-property name="resultSet">
                <structure>
                    <property name="position">1</property>
                    <property name="name">sector</property>
                    <property name="nativeName">sector</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
                <structure>
                    <property name="position">2</property>
                    <property name="name">referer</property>
                    <property name="nativeName">referer</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
                <structure>
                    <property name="position">3</property>
                    <property name="name">count</property>
                    <property name="nativeName">count</property>
                    <property name="dataType">decimal</property>
                    <property name="nativeDataType">-5</property>
                </structure>
            </list-property>
            <xml-property name="queryText"><![CDATA[select substring(zodb_path from E'../\([^/]*\)/') as sector, referer, count(session_id)
from company,session
where company.session_id = session.id
and substring(zodb_path from '../(.*)/.*') like ?
group by sector, referer order by sector, referer;]]></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>
  <DataSetParameters>
    <parameter>
      <design:ParameterDefinition>
        <design:inOutMode>In</design:inOutMode>
        <design:attributes>
          <design:identifier>
            <design:name></design:name>
            <design:position>1</design:position>
          </design:identifier>
          <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
          <design:precision>0</design:precision>
          <design:scale>0</design:scale>
          <design:nullability>Unknown</design:nullability>
        </design:attributes>
      </design:ParameterDefinition>
    </parameter>
  </DataSetParameters>
  <design:ResultSets derivedMetaData="true">
    <design:resultSetDefinitions>
      <design:resultSetColumns>
        <design:resultColumnDefinitions>
          <design:attributes>
            <design:identifier>
              <design:name>sector</design:name>
              <design:position>1</design:position>
            </design:identifier>
            <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
            <design:precision>2147483647</design:precision>
            <design:scale>0</design:scale>
            <design:nullability>Unknown</design:nullability>
            <design:uiHints>
              <design:displayName>sector</design:displayName>
            </design:uiHints>
          </design:attributes>
          <design:usageHints>
            <design:label>sector</design:label>
            <design:formattingHints>
              <design:displaySize>2147483647</design:displaySize>
            </design:formattingHints>
          </design:usageHints>
        </design:resultColumnDefinitions>
        <design:resultColumnDefinitions>
          <design:attributes>
            <design:identifier>
              <design:name>referer</design:name>
              <design:position>2</design:position>
            </design:identifier>
            <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
            <design:precision>27</design:precision>
            <design:scale>0</design:scale>
            <design:nullability>Nullable</design:nullability>
            <design:uiHints>
              <design:displayName>referer</design:displayName>
            </design:uiHints>
          </design:attributes>
          <design:usageHints>
            <design:label>referer</design:label>
            <design:formattingHints>
              <design:displaySize>27</design:displaySize>
            </design:formattingHints>
          </design:usageHints>
        </design:resultColumnDefinitions>
        <design:resultColumnDefinitions>
          <design:attributes>
            <design:identifier>
              <design:name>count</design:name>
              <design:position>3</design:position>
            </design:identifier>
            <design:nativeDataTypeCode>-5</design:nativeDataTypeCode>
            <design:precision>19</design:precision>
            <design:scale>0</design:scale>
            <design:nullability>Unknown</design:nullability>
            <design:uiHints>
              <design:displayName>count</design:displayName>
            </design:uiHints>
          </design:attributes>
          <design:usageHints>
            <design:label>count</design:label>
            <design:formattingHints>
              <design:displaySize>20</design:displaySize>
            </design:formattingHints>
          </design:usageHints>
        </design:resultColumnDefinitions>
      </design:resultSetColumns>
      <design:criteria/>
    </design:resultSetDefinitions>
  </design:ResultSets>
</model:DesignValues>]]></xml-property>
        </oda-data-set>
        <oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" name="referer by country" id="706">
            <list-property name="columnHints">
                <structure>
                    <property name="columnName">country</property>
                    <property name="analysis">attribute</property>
                    <text-property name="displayName">country</text-property>
                    <text-property name="heading">country</text-property>
                </structure>
                <structure>
                    <property name="columnName">referer</property>
                    <property name="analysis">attribute</property>
                    <text-property name="displayName">referer</text-property>
                    <text-property name="heading">referer</text-property>
                </structure>
                <structure>
                    <property name="columnName">count</property>
                    <property name="analysis">measure</property>
                    <text-property name="displayName">count</text-property>
                    <text-property name="heading">count</text-property>
                </structure>
            </list-property>
            <list-property name="parameters">
                <structure>
                    <property name="name">param_1</property>
                    <property name="paramName">sector</property>
                    <property name="nativeName"></property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                    <property name="position">1</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">country</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">2</property>
                        <property name="name">referer</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">3</property>
                        <property name="name">count</property>
                        <property name="dataType">decimal</property>
                    </structure>
                </list-property>
            </structure>
            <property name="dataSource">OiRA Postgres DB</property>
            <list-property name="resultSet">
                <structure>
                    <property name="position">1</property>
                    <property name="name">country</property>
                    <property name="nativeName">country</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
                <structure>
                    <property name="position">2</property>
                    <property name="name">referer</property>
                    <property name="nativeName">referer</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
                <structure>
                    <property name="position">3</property>
                    <property name="name">count</property>
                    <property name="nativeName">count</property>
                    <property name="dataType">decimal</property>
                    <property name="nativeDataType">-5</property>
                </structure>
            </list-property>
            <xml-property name="queryText"><![CDATA[select substring(zodb_path from '^..') as country, referer, count(session_id)
from company,session
where company.session_id = session.id
and substring(zodb_path from '../(.*)/.*') like ?
group by substring(zodb_path from '^..'), referer order by country, referer;]]></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>
  <DataSetParameters>
    <parameter>
      <design:ParameterDefinition>
        <design:inOutMode>In</design:inOutMode>
        <design:attributes>
          <design:identifier>
            <design:name></design:name>
            <design:position>1</design:position>
          </design:identifier>
          <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
          <design:precision>0</design:precision>
          <design:scale>0</design:scale>
          <design:nullability>Unknown</design:nullability>
        </design:attributes>
      </design:ParameterDefinition>
    </parameter>
  </DataSetParameters>
  <design:ResultSets derivedMetaData="true">
    <design:resultSetDefinitions>
      <design:resultSetColumns>
        <design:resultColumnDefinitions>
          <design:attributes>
            <design:identifier>
              <design:name>country</design:name>
              <design:position>1</design:position>
            </design:identifier>
            <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
            <design:precision>2147483647</design:precision>
            <design:scale>0</design:scale>
            <design:nullability>Unknown</design:nullability>
            <design:uiHints>
              <design:displayName>country</design:displayName>
            </design:uiHints>
          </design:attributes>
          <design:usageHints>
            <design:label>country</design:label>
            <design:formattingHints>
              <design:displaySize>2147483647</design:displaySize>
            </design:formattingHints>
          </design:usageHints>
        </design:resultColumnDefinitions>
        <design:resultColumnDefinitions>
          <design:attributes>
            <design:identifier>
              <design:name>referer</design:name>
              <design:position>2</design:position>
            </design:identifier>
            <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
            <design:precision>27</design:precision>
            <design:scale>0</design:scale>
            <design:nullability>Nullable</design:nullability>
            <design:uiHints>
              <design:displayName>referer</design:displayName>
            </design:uiHints>
          </design:attributes>
          <design:usageHints>
            <design:label>referer</design:label>
            <design:formattingHints>
              <design:displaySize>27</design:displaySize>
            </design:formattingHints>
          </design:usageHints>
        </design:resultColumnDefinitions>
        <design:resultColumnDefinitions>
          <design:attributes>
            <design:identifier>
              <design:name>count</design:name>
              <design:position>3</design:position>
            </design:identifier>
            <design:nativeDataTypeCode>-5</design:nativeDataTypeCode>
            <design:precision>19</design:precision>
            <design:scale>0</design:scale>
            <design:nullability>Unknown</design:nullability>
            <design:uiHints>
              <design:displayName>count</design:displayName>
            </design:uiHints>
          </design:attributes>
          <design:usageHints>
            <design:label>count</design:label>
            <design:formattingHints>
              <design:displaySize>20</design:displaySize>
            </design:formattingHints>
          </design:usageHints>
        </design:resultColumnDefinitions>
      </design:resultSetColumns>
      <design:criteria/>
    </design:resultSetDefinitions>
  </design:ResultSets>
</model:DesignValues>]]></xml-property>
        </oda-data-set>
        <oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" name="workers_participated by tool" id="707">
            <list-property name="columnHints">
                <structure>
                    <property name="columnName">zodb_path</property>
                    <property name="analysis">attribute</property>
                    <text-property name="displayName">zodb_path</text-property>
                    <text-property name="heading">zodb_path</text-property>
                </structure>
                <structure>
                    <property name="columnName">workers_participated</property>
                    <property name="analysis">measure</property>
                    <text-property name="displayName">workers_participated</text-property>
                    <text-property name="heading">workers_participated</text-property>
                </structure>
                <structure>
                    <property name="columnName">count</property>
                    <property name="analysis">measure</property>
                    <text-property name="displayName">count</text-property>
                    <text-property name="heading">count</text-property>
                </structure>
            </list-property>
            <list-property name="parameters">
                <structure>
                    <property name="name">param_1</property>
                    <property name="paramName">sector</property>
                    <property name="nativeName"></property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                    <property name="position">1</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">zodb_path</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">2</property>
                        <property name="name">workers_participated</property>
                        <property name="dataType">integer</property>
                    </structure>
                    <structure>
                        <property name="position">3</property>
                        <property name="name">count</property>
                        <property name="dataType">decimal</property>
                    </structure>
                </list-property>
            </structure>
            <property name="dataSource">OiRA Postgres DB</property>
            <list-property name="resultSet">
                <structure>
                    <property name="position">1</property>
                    <property name="name">zodb_path</property>
                    <property name="nativeName">zodb_path</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
                <structure>
                    <property name="position">2</property>
                    <property name="name">workers_participated</property>
                    <property name="nativeName">workers_participated</property>
                    <property name="dataType">integer</property>
                    <property name="nativeDataType">-7</property>
                </structure>
                <structure>
                    <property name="position">3</property>
                    <property name="name">count</property>
                    <property name="nativeName">count</property>
                    <property name="dataType">decimal</property>
                    <property name="nativeDataType">-5</property>
                </structure>
            </list-property>
            <xml-property name="queryText"><![CDATA[select zodb_path, workers_participated, count(session_id)
from company,session
where company.session_id = session.id
and substring(zodb_path from '../(.*)/.*') like ?
group by zodb_path, workers_participated order by zodb_path, workers_participated;]]></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>
  <DataSetParameters>
    <parameter>
      <design:ParameterDefinition>
        <design:inOutMode>In</design:inOutMode>
        <design:attributes>
          <design:identifier>
            <design:name></design:name>
            <design:position>1</design:position>
          </design:identifier>
          <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
          <design:precision>0</design:precision>
          <design:scale>0</design:scale>
          <design:nullability>Unknown</design:nullability>
        </design:attributes>
      </design:ParameterDefinition>
    </parameter>
  </DataSetParameters>
  <design:ResultSets derivedMetaData="true">
    <design:resultSetDefinitions>
      <design:resultSetColumns>
        <design:resultColumnDefinitions>
          <design:attributes>
            <design:identifier>
              <design:name>zodb_path</design:name>
              <design:position>1</design:position>
            </design:identifier>
            <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
            <design:precision>128</design:precision>
            <design:scale>0</design:scale>
            <design:nullability>NotNullable</design:nullability>
            <design:uiHints>
              <design:displayName>zodb_path</design:displayName>
            </design:uiHints>
          </design:attributes>
          <design:usageHints>
            <design:label>zodb_path</design:label>
            <design:formattingHints>
              <design:displaySize>128</design:displaySize>
            </design:formattingHints>
          </design:usageHints>
        </design:resultColumnDefinitions>
        <design:resultColumnDefinitions>
          <design:attributes>
            <design:identifier>
              <design:name>workers_participated</design:name>
              <design:position>2</design:position>
            </design:identifier>
            <design:nativeDataTypeCode>-7</design:nativeDataTypeCode>
            <design:precision>1</design:precision>
            <design:scale>0</design:scale>
            <design:nullability>Nullable</design:nullability>
            <design:uiHints>
              <design:displayName>workers_participated</design:displayName>
            </design:uiHints>
          </design:attributes>
          <design:usageHints>
            <design:label>workers_participated</design:label>
            <design:formattingHints>
              <design:displaySize>1</design:displaySize>
            </design:formattingHints>
          </design:usageHints>
        </design:resultColumnDefinitions>
        <design:resultColumnDefinitions>
          <design:attributes>
            <design:identifier>
              <design:name>count</design:name>
              <design:position>3</design:position>
            </design:identifier>
            <design:nativeDataTypeCode>-5</design:nativeDataTypeCode>
            <design:precision>19</design:precision>
            <design:scale>0</design:scale>
            <design:nullability>Unknown</design:nullability>
            <design:uiHints>
              <design:displayName>count</design:displayName>
            </design:uiHints>
          </design:attributes>
          <design:usageHints>
            <design:label>count</design:label>
            <design:formattingHints>
              <design:displaySize>20</design:displaySize>
            </design:formattingHints>
          </design:usageHints>
        </design:resultColumnDefinitions>
      </design:resultSetColumns>
      <design:criteria/>
    </design:resultSetDefinitions>
  </design:ResultSets>
</model:DesignValues>]]></xml-property>
        </oda-data-set>
        <oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" name="workers_participated by sector" id="708">
            <list-property name="columnHints">
                <structure>
                    <property name="columnName">sector</property>
                    <property name="analysis">attribute</property>
                    <text-property name="displayName">sector</text-property>
                    <text-property name="heading">sector</text-property>
                </structure>
                <structure>
                    <property name="columnName">workers_participated</property>
                    <property name="analysis">measure</property>
                    <text-property name="displayName">workers_participated</text-property>
                    <text-property name="heading">workers_participated</text-property>
                </structure>
                <structure>
                    <property name="columnName">count</property>
                    <property name="analysis">measure</property>
                    <text-property name="displayName">count</text-property>
                    <text-property name="heading">count</text-property>
                </structure>
            </list-property>
            <list-property name="parameters">
                <structure>
                    <property name="name">param_1</property>
                    <property name="paramName">sector</property>
                    <property name="nativeName"></property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                    <property name="position">1</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">sector</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">2</property>
                        <property name="name">workers_participated</property>
                        <property name="dataType">integer</property>
                    </structure>
                    <structure>
                        <property name="position">3</property>
                        <property name="name">count</property>
                        <property name="dataType">decimal</property>
                    </structure>
                </list-property>
            </structure>
            <property name="dataSource">OiRA Postgres DB</property>
            <list-property name="resultSet">
                <structure>
                    <property name="position">1</property>
                    <property name="name">sector</property>
                    <property name="nativeName">sector</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
                <structure>
                    <property name="position">2</property>
                    <property name="name">workers_participated</property>
                    <property name="nativeName">workers_participated</property>
                    <property name="dataType">integer</property>
                    <property name="nativeDataType">-7</property>
                </structure>
                <structure>
                    <property name="position">3</property>
                    <property name="name">count</property>
                    <property name="nativeName">count</property>
                    <property name="dataType">decimal</property>
                    <property name="nativeDataType">-5</property>
                </structure>
            </list-property>
            <xml-property name="queryText"><![CDATA[select substring(zodb_path from E'../\([^/]*\)/') as sector, workers_participated, count(session_id)
from company,session
where company.session_id = session.id
and substring(zodb_path from '../(.*)/.*') like ?
group by sector, workers_participated order by sector, workers_participated;]]></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>
  <DataSetParameters>
    <parameter>
      <design:ParameterDefinition>
        <design:inOutMode>In</design:inOutMode>
        <design:attributes>
          <design:identifier>
            <design:name></design:name>
            <design:position>1</design:position>
          </design:identifier>
          <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
          <design:precision>0</design:precision>
          <design:scale>0</design:scale>
          <design:nullability>Unknown</design:nullability>
        </design:attributes>
      </design:ParameterDefinition>
    </parameter>
  </DataSetParameters>
  <design:ResultSets derivedMetaData="true">
    <design:resultSetDefinitions>
      <design:resultSetColumns>
        <design:resultColumnDefinitions>
          <design:attributes>
            <design:identifier>
              <design:name>sector</design:name>
              <design:position>1</design:position>
            </design:identifier>
            <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
            <design:precision>2147483647</design:precision>
            <design:scale>0</design:scale>
            <design:nullability>Unknown</design:nullability>
            <design:uiHints>
              <design:displayName>sector</design:displayName>
            </design:uiHints>
          </design:attributes>
          <design:usageHints>
            <design:label>sector</design:label>
            <design:formattingHints>
              <design:displaySize>2147483647</design:displaySize>
            </design:formattingHints>
          </design:usageHints>
        </design:resultColumnDefinitions>
        <design:resultColumnDefinitions>
          <design:attributes>
            <design:identifier>
              <design:name>workers_participated</design:name>
              <design:position>2</design:position>
            </design:identifier>
            <design:nativeDataTypeCode>-7</design:nativeDataTypeCode>
            <design:precision>1</design:precision>
            <design:scale>0</design:scale>
            <design:nullability>Nullable</design:nullability>
            <design:uiHints>
              <design:displayName>workers_participated</design:displayName>
            </design:uiHints>
          </design:attributes>
          <design:usageHints>
            <design:label>workers_participated</design:label>
            <design:formattingHints>
              <design:displaySize>1</design:displaySize>
            </design:formattingHints>
          </design:usageHints>
        </design:resultColumnDefinitions>
        <design:resultColumnDefinitions>
          <design:attributes>
            <design:identifier>
              <design:name>count</design:name>
              <design:position>3</design:position>
            </design:identifier>
            <design:nativeDataTypeCode>-5</design:nativeDataTypeCode>
            <design:precision>19</design:precision>
            <design:scale>0</design:scale>
            <design:nullability>Unknown</design:nullability>
            <design:uiHints>
              <design:displayName>count</design:displayName>
            </design:uiHints>
          </design:attributes>
          <design:usageHints>
            <design:label>count</design:label>
            <design:formattingHints>
              <design:displaySize>20</design:displaySize>
            </design:formattingHints>
          </design:usageHints>
        </design:resultColumnDefinitions>
      </design:resultSetColumns>
      <design:criteria/>
    </design:resultSetDefinitions>
  </design:ResultSets>
</model:DesignValues>]]></xml-property>
        </oda-data-set>
        <oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" name="workers_participated by country" id="709">
            <list-property name="columnHints">
                <structure>
                    <property name="columnName">country</property>
                    <property name="analysis">attribute</property>
                    <text-property name="displayName">country</text-property>
                    <text-property name="heading">country</text-property>
                </structure>
                <structure>
                    <property name="columnName">workers_participated</property>
                    <property name="analysis">measure</property>
                    <text-property name="displayName">workers_participated</text-property>
                    <text-property name="heading">workers_participated</text-property>
                </structure>
                <structure>
                    <property name="columnName">count</property>
                    <property name="analysis">measure</property>
                    <text-property name="displayName">count</text-property>
                    <text-property name="heading">count</text-property>
                </structure>
            </list-property>
            <list-property name="parameters">
                <structure>
                    <property name="name">param_1</property>
                    <property name="paramName">sector</property>
                    <property name="nativeName"></property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                    <property name="position">1</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">country</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">2</property>
                        <property name="name">workers_participated</property>
                        <property name="dataType">integer</property>
                    </structure>
                    <structure>
                        <property name="position">3</property>
                        <property name="name">count</property>
                        <property name="dataType">decimal</property>
                    </structure>
                </list-property>
            </structure>
            <property name="dataSource">OiRA Postgres DB</property>
            <list-property name="resultSet">
                <structure>
                    <property name="position">1</property>
                    <property name="name">country</property>
                    <property name="nativeName">country</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
                <structure>
                    <property name="position">2</property>
                    <property name="name">workers_participated</property>
                    <property name="nativeName">workers_participated</property>
                    <property name="dataType">integer</property>
                    <property name="nativeDataType">-7</property>
                </structure>
                <structure>
                    <property name="position">3</property>
                    <property name="name">count</property>
                    <property name="nativeName">count</property>
                    <property name="dataType">decimal</property>
                    <property name="nativeDataType">-5</property>
                </structure>
            </list-property>
            <xml-property name="queryText"><![CDATA[select substring(zodb_path from '^..') as country, workers_participated, count(session_id)
from company,session
where company.session_id = session.id
and substring(zodb_path from '../(.*)/.*') like ?
group by substring(zodb_path from '^..'), workers_participated order by country, workers_participated;]]></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>
  <DataSetParameters>
    <parameter>
      <design:ParameterDefinition>
        <design:inOutMode>In</design:inOutMode>
        <design:attributes>
          <design:identifier>
            <design:name></design:name>
            <design:position>1</design:position>
          </design:identifier>
          <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
          <design:precision>0</design:precision>
          <design:scale>0</design:scale>
          <design:nullability>Unknown</design:nullability>
        </design:attributes>
      </design:ParameterDefinition>
    </parameter>
  </DataSetParameters>
  <design:ResultSets derivedMetaData="true">
    <design:resultSetDefinitions>
      <design:resultSetColumns>
        <design:resultColumnDefinitions>
          <design:attributes>
            <design:identifier>
              <design:name>country</design:name>
              <design:position>1</design:position>
            </design:identifier>
            <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
            <design:precision>2147483647</design:precision>
            <design:scale>0</design:scale>
            <design:nullability>Unknown</design:nullability>
            <design:uiHints>
              <design:displayName>country</design:displayName>
            </design:uiHints>
          </design:attributes>
          <design:usageHints>
            <design:label>country</design:label>
            <design:formattingHints>
              <design:displaySize>2147483647</design:displaySize>
            </design:formattingHints>
          </design:usageHints>
        </design:resultColumnDefinitions>
        <design:resultColumnDefinitions>
          <design:attributes>
            <design:identifier>
              <design:name>workers_participated</design:name>
              <design:position>2</design:position>
            </design:identifier>
            <design:nativeDataTypeCode>-7</design:nativeDataTypeCode>
            <design:precision>1</design:precision>
            <design:scale>0</design:scale>
            <design:nullability>Nullable</design:nullability>
            <design:uiHints>
              <design:displayName>workers_participated</design:displayName>
            </design:uiHints>
          </design:attributes>
          <design:usageHints>
            <design:label>workers_participated</design:label>
            <design:formattingHints>
              <design:displaySize>1</design:displaySize>
            </design:formattingHints>
          </design:usageHints>
        </design:resultColumnDefinitions>
        <design:resultColumnDefinitions>
          <design:attributes>
            <design:identifier>
              <design:name>count</design:name>
              <design:position>3</design:position>
            </design:identifier>
            <design:nativeDataTypeCode>-5</design:nativeDataTypeCode>
            <design:precision>19</design:precision>
            <design:scale>0</design:scale>
            <design:nullability>Unknown</design:nullability>
            <design:uiHints>
              <design:displayName>count</design:displayName>
            </design:uiHints>
          </design:attributes>
          <design:usageHints>
            <design:label>count</design:label>
            <design:formattingHints>
              <design:displaySize>20</design:displaySize>
            </design:formattingHints>
          </design:usageHints>
        </design:resultColumnDefinitions>
      </design:resultSetColumns>
      <design:criteria/>
    </design:resultSetDefinitions>
  </design:ResultSets>
</model:DesignValues>]]></xml-property>
        </oda-data-set>
        <oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" name="Assessments by Zodb-Path" id="1052">
            <list-property name="columnHints">
                <structure>
                    <property name="columnName">zodb_path</property>
                    <property name="analysis">attribute</property>
                    <text-property name="displayName">zodb_path</text-property>
                    <text-property name="heading">zodb_path</text-property>
                </structure>
                <structure>
                    <property name="columnName">count</property>
                    <property name="analysis">measure</property>
                    <text-property name="displayName">count</text-property>
                    <text-property name="heading">count</text-property>
                </structure>
            </list-property>
            <list-property name="parameters">
                <structure>
                    <property name="name">sector</property>
                    <property name="paramName">sector</property>
                    <property name="dataType">string</property>
                    <property name="position">1</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">zodb_path</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">2</property>
                        <property name="name">count</property>
                        <property name="dataType">decimal</property>
                    </structure>
                </list-property>
            </structure>
            <property name="dataSource">OiRA Postgres DB</property>
            <list-property name="resultSet">
                <structure>
                    <property name="position">1</property>
                    <property name="name">zodb_path</property>
                    <property name="nativeName">zodb_path</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
                <structure>
                    <property name="position">2</property>
                    <property name="name">count</property>
                    <property name="nativeName">count</property>
                    <property name="dataType">decimal</property>
                    <property name="nativeDataType">-5</property>
                </structure>
            </list-property>
            <xml-property name="queryText"><![CDATA[select zodb_path,count(*)
from session
where substring(zodb_path from '../(.*)/.*') like ?
group by zodb_path
order by count desc;]]></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>zodb_path</design:name>
              <design:position>1</design:position>
            </design:identifier>
            <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
            <design:precision>128</design:precision>
            <design:scale>0</design:scale>
            <design:nullability>NotNullable</design:nullability>
            <design:uiHints>
              <design:displayName>zodb_path</design:displayName>
            </design:uiHints>
          </design:attributes>
          <design:usageHints>
            <design:label>zodb_path</design:label>
            <design:formattingHints>
              <design:displaySize>128</design:displaySize>
            </design:formattingHints>
          </design:usageHints>
        </design:resultColumnDefinitions>
        <design:resultColumnDefinitions>
          <design:attributes>
            <design:identifier>
              <design:name>count</design:name>
              <design:position>2</design:position>
            </design:identifier>
            <design:nativeDataTypeCode>-5</design:nativeDataTypeCode>
            <design:precision>19</design:precision>
            <design:scale>0</design:scale>
            <design:nullability>Unknown</design:nullability>
            <design:uiHints>
              <design:displayName>count</design:displayName>
            </design:uiHints>
          </design:attributes>
          <design:usageHints>
            <design:label>count</design:label>
            <design:formattingHints>
              <design:displaySize>20</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-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>
        <label id="10">
            <property name="style">report-heading</property>
            <text-property name="text">OiRA Usage Statistics</text-property>
        </label>
        <text-data id="1043">
            <expression name="valueExpr">"Statistics for sector: " + params["sector"].value</expression>
            <property name="contentType">html</property>
        </text-data>
        <text id="11">
            <property name="style">description</property>
            <property name="contentType">auto</property>
            <text-property name="content"><![CDATA[This document presents usage statistics for the Online Risk assessment Tool (OiRA).]]></text-property>
        </text>
        <table id="126">
            <property name="width">2.4895833333333335in</property>
            <property name="dataSet">Number Of Accounts</property>
            <list-property name="visibility">
                <structure>
                    <property name="format">all</property>
                    <expression name="valueExpr" type="javascript">params["sector"].value != '%'</expression>
                </structure>
            </list-property>
            <list-property name="boundDataColumns">
                <structure>
                    <property name="name">count</property>
                    <text-property name="displayName">count</text-property>
                    <expression name="expression" type="javascript">dataSetRow["count"]</expression>
                    <property name="dataType">decimal</property>
                </structure>
            </list-property>
            <column id="135">
                <property name="width">2.4895833333333335in</property>
            </column>
            <header>
                <row id="127">
                    <cell id="128">
                        <label id="129">
                            <text-property name="text">Total Number Of Accounts Created</text-property>
                        </label>
                    </cell>
                </row>
            </header>
            <detail>
                <row id="130">
                    <cell id="131">
                        <data id="132">
                            <property name="resultSetColumn">count</property>
                        </data>
                    </cell>
                </row>
            </detail>
            <footer>
                <row id="133">
                    <cell id="134"/>
                </row>
            </footer>
        </table>
        <label id="514">
            <list-property name="visibility">
                <structure>
                    <property name="format">all</property>
                    <expression name="valueExpr" type="javascript">params["sector"].value != '%'</expression>
                </structure>
            </list-property>
            <text-property name="text">Logins per Month and Account</text-property>
        </label>
        <table id="533">
            <property name="borderBottomColor">#000000</property>
            <property name="borderLeftColor">#000000</property>
            <property name="borderRightColor">#000000</property>
            <property name="borderTopColor">#000000</property>
            <property name="dataSet">Logins</property>
            <list-property name="visibility">
                <structure>
                    <property name="format">all</property>
                    <expression name="valueExpr" type="javascript">params["sector"].value != '%'</expression>
                </structure>
            </list-property>
            <list-property name="boundDataColumns">
                <structure>
                    <property name="name">loginname</property>
                    <text-property name="displayName">loginname</text-property>
                    <expression name="expression" type="javascript">dataSetRow["loginname"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">month</property>
                    <text-property name="displayName">month</text-property>
                    <expression name="expression" type="javascript">dataSetRow["month"]</expression>
                    <property name="dataType">float</property>
                </structure>
                <structure>
                    <property name="name">year</property>
                    <text-property name="displayName">year</text-property>
                    <expression name="expression" type="javascript">dataSetRow["year"]</expression>
                    <property name="dataType">float</property>
                </structure>
                <structure>
                    <property name="name">count</property>
                    <text-property name="displayName">count</text-property>
                    <expression name="expression" type="javascript">dataSetRow["count"]</expression>
                    <property name="dataType">decimal</property>
                </structure>
            </list-property>
            <column id="557"/>
            <column id="560"/>
            <header>
                <row id="534">
                    <cell id="535">
                        <label id="536">
                            <text-property name="text">Login Name</text-property>
                        </label>
                    </cell>
                    <cell id="541">
                        <label id="542">
                            <text-property name="text">Number of Logins</text-property>
                        </label>
                    </cell>
                </row>
            </header>
            <group id="561">
                <property name="groupName">Year</property>
                <expression name="keyExpr" type="javascript">row["year"]</expression>
                <structure name="toc">
                    <expression name="expressionValue" type="javascript">row["year"]</expression>
                </structure>
                <property name="hideDetail">false</property>
                <header>
                    <row id="562">
                        <cell id="563">
                            <data id="572">
                                <property name="resultSetColumn">year</property>
                            </data>
                        </cell>
                        <cell id="566"/>
                    </row>
                </header>
                <footer>
                    <row id="567">
                        <cell id="568"/>
                        <cell id="571"/>
                    </row>
                </footer>
            </group>
            <group id="573">
                <property name="groupName">Month</property>
                <expression name="keyExpr" type="javascript">row["month"]</expression>
                <structure name="toc">
                    <expression name="expressionValue" type="javascript">row["month"]</expression>
                </structure>
                <property name="hideDetail">false</property>
                <header>
                    <row id="574">
                        <cell id="575">
                            <data id="584">
                                <property name="style">indented-1</property>
                                <property name="resultSetColumn">month</property>
                            </data>
                        </cell>
                        <cell id="578"/>
                    </row>
                </header>
                <footer>
                    <row id="579">
                        <cell id="580"/>
                        <cell id="583"/>
                    </row>
                </footer>
            </group>
            <detail>
                <row id="543">
                    <cell id="544">
                        <data id="545">
                            <property name="style">indented-2</property>
                            <property name="resultSetColumn">loginname</property>
                        </data>
                    </cell>
                    <cell id="550">
                        <data id="551">
                            <property name="resultSetColumn">count</property>
                        </data>
                    </cell>
                </row>
            </detail>
            <footer>
                <row id="552">
                    <cell id="553"/>
                    <cell id="556"/>
                </row>
            </footer>
        </table>
        <table id="283">
            <property name="borderBottomColor">#000000</property>
            <property name="borderBottomWidth">thin</property>
            <property name="borderLeftColor">#000000</property>
            <property name="borderLeftWidth">thin</property>
            <property name="borderRightColor">#000000</property>
            <property name="borderRightWidth">thin</property>
            <property name="borderTopColor">#000000</property>
            <property name="borderTopWidth">thin</property>
            <property name="width">7.947916666666667in</property>
            <property name="dataSet">Tools</property>
            <list-property name="boundDataColumns">
                <structure>
                    <property name="name">zodb_path</property>
                    <text-property name="displayName">zodb_path</text-property>
                    <expression name="expression" type="javascript">dataSetRow["zodb_path"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">language</property>
                    <text-property name="displayName">language</text-property>
                    <expression name="expression" type="javascript">dataSetRow["language"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">review_state</property>
                    <text-property name="displayName">published</text-property>
                    <expression name="expression" type="javascript">dataSetRow["published"] ? 'published' : 'unpublished'</expression>
                    <property name="dataType">string</property>
                    <property name="allowExport">true</property>
                </structure>
                <structure>
                    <property name="name">count</property>
                    <text-property name="displayName">count</text-property>
                    <property name="dataType">integer</property>
                    <simple-property-list name="aggregateOn">
                        <value>Language</value>
                    </simple-property-list>
                    <property name="aggregateFunction">COUNT</property>
                    <list-property name="arguments">
                        <structure>
                            <property name="name">Expression</property>
                            <expression name="value" type="javascript">row["zodb_path"]</expression>
                        </structure>
                    </list-property>
                    <property name="allowExport">true</property>
                </structure>
            </list-property>
            <column id="307">
                <property name="width">1.4791666666666667in</property>
            </column>
            <column id="308">
                <property name="width">6.46875in</property>
            </column>
            <header>
                <row id="284">
                    <cell id="285">
                        <label id="328">
                            <text-property name="text">Number of Tools per Language</text-property>
                        </label>
                    </cell>
                    <cell id="287"/>
                </row>
            </header>
            <group id="311">
                <property name="groupName">review_state</property>
                <expression name="keyExpr" type="javascript">row["review_state"]</expression>
                <structure name="toc">
                    <expression name="expressionValue" type="javascript">row["review_state"]</expression>
                </structure>
                <property name="hideDetail">false</property>
                <header>
                    <row id="312">
                        <cell id="313">
                            <data id="318">
                                <property name="resultSetColumn">review_state</property>
                            </data>
                        </cell>
                        <cell id="314"/>
                    </row>
                </header>
                <footer>
                    <row id="315">
                        <cell id="316"/>
                        <cell id="317"/>
                    </row>
                </footer>
            </group>
            <group id="319">
                <property name="groupName">Language</property>
                <expression name="keyExpr" type="javascript">row["language"]</expression>
                <structure name="toc">
                    <expression name="expressionValue" type="javascript">row["language"]</expression>
                </structure>
                <property name="hideDetail">false</property>
                <header>
                    <row id="320">
                        <property name="borderBottomColor">#000000</property>
                        <property name="borderBottomStyle">solid</property>
                        <property name="borderBottomWidth">thin</property>
                        <property name="borderLeftColor">#000000</property>
                        <property name="borderLeftStyle">solid</property>
                        <property name="borderLeftWidth">thin</property>
                        <property name="borderRightColor">#000000</property>
                        <property name="borderRightStyle">solid</property>
                        <property name="borderRightWidth">thin</property>
                        <property name="borderTopColor">#000000</property>
                        <property name="borderTopStyle">solid</property>
                        <property name="borderTopWidth">thin</property>
                        <cell id="321">
                            <data id="326">
                                <property name="style">indented-1</property>
                                <property name="resultSetColumn">language</property>
                            </data>
                        </cell>
                        <cell id="322">
                            <data id="327">
                                <property name="resultSetColumn">count</property>
                            </data>
                        </cell>
                    </row>
                </header>
            </group>
            <footer>
                <row id="302">
                    <cell id="303"/>
                    <cell id="304"/>
                </row>
            </footer>
        </table>
        <table id="371">
            <property name="borderBottomColor">#000000</property>
            <property name="borderLeftColor">#000000</property>
            <property name="borderRightColor">#000000</property>
            <property name="borderTopColor">#000000</property>
            <property name="width">7.947916666666667in</property>
            <property name="dataSet">Tools</property>
            <list-property name="boundDataColumns">
                <structure>
                    <property name="name">zodb_path</property>
                    <text-property name="displayName">zodb_path</text-property>
                    <expression name="expression" type="javascript">dataSetRow["zodb_path"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">language</property>
                    <text-property name="displayName">language</text-property>
                    <expression name="expression" type="javascript">dataSetRow["language"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">review_state</property>
                    <text-property name="displayName">published</text-property>
                    <expression name="expression" type="javascript">dataSetRow["published"] ? 'published' : 'unpublished'</expression>
                    <property name="dataType">string</property>
                    <property name="allowExport">true</property>
                </structure>
                <structure>
                    <property name="name">Country</property>
                    <text-property name="displayName">Country</text-property>
                    <expression name="expression" type="javascript">row["zodb_path"].match(/^(..)\//)[1]</expression>
                    <property name="dataType">string</property>
                    <property name="allowExport">true</property>
                </structure>
                <structure>
                    <property name="name">country_count</property>
                    <text-property name="displayName">count</text-property>
                    <property name="dataType">integer</property>
                    <simple-property-list name="aggregateOn">
                        <value>Country</value>
                    </simple-property-list>
                    <property name="aggregateFunction">COUNT</property>
                    <list-property name="arguments">
                        <structure>
                            <property name="name">Expression</property>
                            <expression name="value" type="javascript">row["zodb_path"]</expression>
                        </structure>
                    </list-property>
                    <property name="allowExport">true</property>
                </structure>
            </list-property>
            <column id="395">
                <property name="width">1.4791666666666667in</property>
            </column>
            <column id="396">
                <property name="width">6.46875in</property>
            </column>
            <header>
                <row id="372">
                    <cell id="373">
                        <label id="374">
                            <text-property name="text">Number of Tools per Country</text-property>
                        </label>
                    </cell>
                    <cell id="375"/>
                </row>
            </header>
            <group id="399">
                <property name="groupName">review_state</property>
                <expression name="keyExpr" type="javascript">row["review_state"]</expression>
                <structure name="toc">
                    <expression name="expressionValue" type="javascript">row["review_state"]</expression>
                </structure>
                <property name="hideDetail">false</property>
                <header>
                    <row id="400">
                        <cell id="401">
                            <data id="406">
                                <property name="resultSetColumn">review_state</property>
                            </data>
                        </cell>
                        <cell id="402"/>
                    </row>
                </header>
                <footer>
                    <row id="403">
                        <cell id="404"/>
                        <cell id="405"/>
                    </row>
                </footer>
            </group>
            <group id="407">
                <property name="groupName">Country</property>
                <expression name="keyExpr" type="javascript">row["zodb_path"].match(/..\//)[0]</expression>
                <property name="hideDetail">true</property>
                <header>
                    <row id="408">
                        <property name="borderBottomColor">#000000</property>
                        <property name="borderBottomStyle">solid</property>
                        <property name="borderBottomWidth">thin</property>
                        <property name="borderLeftColor">#000000</property>
                        <property name="borderLeftStyle">solid</property>
                        <property name="borderLeftWidth">thin</property>
                        <property name="borderRightColor">#000000</property>
                        <property name="borderRightStyle">solid</property>
                        <property name="borderRightWidth">thin</property>
                        <property name="borderTopColor">#000000</property>
                        <property name="borderTopStyle">solid</property>
                        <property name="borderTopWidth">thin</property>
                        <cell id="409">
                            <data id="414">
                                <property name="style">indented-1</property>
                                <property name="resultSetColumn">Country</property>
                            </data>
                        </cell>
                        <cell id="410">
                            <data id="416">
                                <property name="resultSetColumn">country_count</property>
                            </data>
                        </cell>
                    </row>
                </header>
            </group>
            <footer>
                <row id="390">
                    <cell id="391"/>
                    <cell id="392"/>
                </row>
            </footer>
        </table>
        <table id="417">
            <property name="borderBottomColor">#000000</property>
            <property name="borderBottomWidth">thin</property>
            <property name="borderLeftColor">#000000</property>
            <property name="borderLeftWidth">thin</property>
            <property name="borderRightColor">#000000</property>
            <property name="borderRightWidth">thin</property>
            <property name="borderTopColor">#000000</property>
            <property name="borderTopWidth">thin</property>
            <property name="width">7.947916666666667in</property>
            <property name="dataSet">Tools</property>
            <list-property name="boundDataColumns">
                <structure>
                    <property name="name">zodb_path</property>
                    <text-property name="displayName">zodb_path</text-property>
                    <expression name="expression" type="javascript">dataSetRow["zodb_path"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">language</property>
                    <text-property name="displayName">language</text-property>
                    <expression name="expression" type="javascript">dataSetRow["language"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">review_state</property>
                    <text-property name="displayName">published</text-property>
                    <expression name="expression" type="javascript">dataSetRow["published"] ? 'published' : 'unpublished'</expression>
                    <property name="dataType">string</property>
                    <property name="allowExport">true</property>
                </structure>
                <structure>
                    <property name="name">Country</property>
                    <text-property name="displayName">Sector</text-property>
                    <expression name="expression" type="javascript">row["zodb_path"].match(/^..\/([^/]*)/)[1]</expression>
                    <property name="dataType">string</property>
                    <property name="allowExport">true</property>
                </structure>
                <structure>
                    <property name="name">country_count</property>
                    <text-property name="displayName">count</text-property>
                    <property name="dataType">integer</property>
                    <simple-property-list name="aggregateOn">
                        <value>Sector</value>
                    </simple-property-list>
                    <property name="aggregateFunction">COUNT</property>
                    <list-property name="arguments">
                        <structure>
                            <property name="name">Expression</property>
                            <expression name="value" type="javascript">row["zodb_path"]</expression>
                        </structure>
                    </list-property>
                    <property name="allowExport">true</property>
                </structure>
                <structure>
                    <property name="name">published</property>
                    <text-property name="displayName">published</text-property>
                    <expression name="expression" type="javascript">dataSetRow["published"]</expression>
                    <property name="dataType">integer</property>
                </structure>
            </list-property>
            <column id="442">
                <property name="width">2.4375in</property>
            </column>
            <column id="443">
                <property name="width">5.510416666666667in</property>
            </column>
            <header>
                <row id="418">
                    <cell id="419">
                        <label id="420">
                            <text-property name="text">Number of Tools per Sector</text-property>
                        </label>
                    </cell>
                    <cell id="421"/>
                </row>
            </header>
            <group id="422">
                <property name="groupName">published</property>
                <expression name="keyExpr" type="javascript">row["published"]</expression>
                <structure name="toc">
                    <expression name="expressionValue" type="javascript">row["published"] ? 'published' : 'unpublished'</expression>
                </structure>
                <property name="hideDetail">false</property>
                <header>
                    <row id="423">
                        <cell id="424">
                            <data id="425">
                                <property name="resultSetColumn">review_state</property>
                            </data>
                        </cell>
                        <cell id="426"/>
                    </row>
                </header>
                <footer>
                    <row id="427">
                        <cell id="428"/>
                        <cell id="429"/>
                    </row>
                </footer>
            </group>
            <group id="430">
                <property name="groupName">Sector</property>
                <expression name="keyExpr" type="javascript">row["zodb_path"].match(/^..\/([^/]*)/)[1]</expression>
                <property name="hideDetail">true</property>
                <header>
                    <row id="431">
                        <property name="borderBottomColor">#000000</property>
                        <property name="borderBottomStyle">solid</property>
                        <property name="borderBottomWidth">thin</property>
                        <property name="borderLeftColor">#000000</property>
                        <property name="borderLeftStyle">solid</property>
                        <property name="borderLeftWidth">thin</property>
                        <property name="borderRightColor">#000000</property>
                        <property name="borderRightStyle">solid</property>
                        <property name="borderRightWidth">thin</property>
                        <property name="borderTopColor">#000000</property>
                        <property name="borderTopStyle">solid</property>
                        <property name="borderTopWidth">thin</property>
                        <cell id="432">
                            <data id="433">
                                <property name="style">indented-1</property>
                                <property name="resultSetColumn">Country</property>
                            </data>
                        </cell>
                        <cell id="434">
                            <data id="435">
                                <property name="resultSetColumn">country_count</property>
                            </data>
                        </cell>
                    </row>
                </header>
            </group>
            <footer>
                <row id="439">
                    <cell id="440"/>
                    <cell id="441"/>
                </row>
            </footer>
        </table>
        <label id="479">
            <text-property name="text">Number of assessments per tool</text-property>
        </label>
        <table id="25">
            <property name="dataSet">Assessments by Zodb-Path</property>
            <list-property name="boundDataColumns">
                <structure>
                    <property name="name">zodb_path</property>
                    <text-property name="displayName">zodb_path</text-property>
                    <expression name="expression" type="javascript">dataSetRow["zodb_path"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">count</property>
                    <text-property name="displayName">count</text-property>
                    <expression name="expression" type="javascript">dataSetRow["count"]</expression>
                    <property name="dataType">decimal</property>
                </structure>
                <structure>
                    <property name="name">total_count_zodb_path</property>
                    <text-property name="displayName">Total</text-property>
                    <property name="dataType">float</property>
                    <property name="aggregateFunction">SUM</property>
                    <list-property name="arguments">
                        <structure>
                            <property name="name">Expression</property>
                            <expression name="value" type="javascript">row["count"]</expression>
                        </structure>
                    </list-property>
                    <property name="allowExport">true</property>
                </structure>
            </list-property>
            <column id="39"/>
            <column id="40"/>
            <header>
                <row id="26">
                    <cell id="27">
                        <label id="28">
                            <text-property name="text">tool</text-property>
                        </label>
                    </cell>
                    <cell id="29">
                        <label id="30">
                            <text-property name="text">count</text-property>
                        </label>
                    </cell>
                </row>
            </header>
            <detail>
                <row id="31">
                    <cell id="32">
                        <data id="33">
                            <property name="textAlign">justify</property>
                            <property name="whiteSpace">nowrap</property>
                            <property name="resultSetColumn">zodb_path</property>
                        </data>
                    </cell>
                    <cell id="34">
                        <data id="35">
                            <property name="textAlign">justify</property>
                            <property name="whiteSpace">nowrap</property>
                            <property name="resultSetColumn">count</property>
                        </data>
                    </cell>
                </row>
            </detail>
            <footer>
                <row id="36">
                    <cell id="37">
                        <label id="105">
                            <text-property name="text">Total</text-property>
                        </label>
                    </cell>
                    <cell id="38">
                        <data id="103">
                            <property name="resultSetColumn">total_count_zodb_path</property>
                        </data>
                    </cell>
                </row>
            </footer>
        </table>
        <label id="482">
            <text-property name="text">Number of assessments per language</text-property>
        </label>
        <table id="599">
            <property name="dataSet">Assessments By Language</property>
            <list-property name="boundDataColumns">
                <structure>
                    <property name="name">language</property>
                    <text-property name="displayName">language</text-property>
                    <expression name="expression" type="javascript">dataSetRow["language"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">count</property>
                    <text-property name="displayName">count</text-property>
                    <expression name="expression" type="javascript">dataSetRow["count"]</expression>
                    <property name="dataType">decimal</property>
                </structure>
                <structure>
                    <property name="name">Total</property>
                    <text-property name="displayName">Total</text-property>
                    <property name="dataType">integer</property>
                    <property name="aggregateFunction">SUM</property>
                    <list-property name="arguments">
                        <structure>
                            <property name="name">Expression</property>
                            <expression name="value" type="javascript">row["count"]</expression>
                        </structure>
                    </list-property>
                    <property name="allowExport">true</property>
                </structure>
            </list-property>
            <column id="613"/>
            <column id="614"/>
            <header>
                <row id="600">
                    <cell id="601">
                        <label id="602">
                            <text-property name="text">language</text-property>
                        </label>
                    </cell>
                    <cell id="603">
                        <label id="604">
                            <text-property name="text">count</text-property>
                        </label>
                    </cell>
                </row>
            </header>
            <detail>
                <row id="605">
                    <cell id="606">
                        <data id="607">
                            <property name="resultSetColumn">language</property>
                        </data>
                    </cell>
                    <cell id="608">
                        <data id="609">
                            <property name="resultSetColumn">count</property>
                        </data>
                    </cell>
                </row>
            </detail>
            <footer>
                <row id="610">
                    <cell id="611"/>
                    <cell id="612">
                        <data id="615">
                            <property name="resultSetColumn">Total</property>
                        </data>
                    </cell>
                </row>
            </footer>
        </table>
        <label id="480">
            <text-property name="text">Number of assessments per sector</text-property>
        </label>
        <table id="87">
            <property name="dataSet">Assessments By Sector</property>
            <list-property name="boundDataColumns">
                <structure>
                    <property name="name">sector</property>
                    <text-property name="displayName">sector</text-property>
                    <expression name="expression" type="javascript">dataSetRow["sector"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">count</property>
                    <text-property name="displayName">count</text-property>
                    <expression name="expression" type="javascript">dataSetRow["count"]</expression>
                    <property name="dataType">decimal</property>
                </structure>
                <structure>
                    <property name="name">total_count_sector</property>
                    <text-property name="displayName">Total</text-property>
                    <property name="dataType">float</property>
                    <property name="aggregateFunction">SUM</property>
                    <list-property name="arguments">
                        <structure>
                            <property name="name">Expression</property>
                            <expression name="value" type="javascript">row["count"]</expression>
                        </structure>
                    </list-property>
                    <property name="allowExport">true</property>
                </structure>
            </list-property>
            <column id="101"/>
            <column id="102"/>
            <header>
                <row id="88">
                    <cell id="89">
                        <label id="90">
                            <text-property name="text">sector</text-property>
                        </label>
                    </cell>
                    <cell id="91">
                        <label id="92">
                            <text-property name="text">count</text-property>
                        </label>
                    </cell>
                </row>
            </header>
            <detail>
                <row id="93">
                    <cell id="94">
                        <data id="95">
                            <property name="resultSetColumn">sector</property>
                        </data>
                    </cell>
                    <cell id="96">
                        <data id="97">
                            <property name="resultSetColumn">count</property>
                        </data>
                    </cell>
                </row>
            </detail>
            <footer>
                <row id="98">
                    <cell id="99">
                        <label id="106">
                            <text-property name="text">Total</text-property>
                        </label>
                    </cell>
                    <cell id="100">
                        <data id="107">
                            <property name="resultSetColumn">total_count_sector</property>
                        </data>
                    </cell>
                </row>
            </footer>
        </table>
        <label id="481">
            <text-property name="text">Number of assessments per country</text-property>
        </label>
        <table id="109">
            <property name="dataSet">Assessments By Country</property>
            <list-property name="boundDataColumns">
                <structure>
                    <property name="name">country</property>
                    <text-property name="displayName">country</text-property>
                    <expression name="expression" type="javascript">dataSetRow["country"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">count</property>
                    <text-property name="displayName">count</text-property>
                    <expression name="expression" type="javascript">dataSetRow["count"]</expression>
                    <property name="dataType">decimal</property>
                </structure>
            </list-property>
            <column id="123"/>
            <column id="124"/>
            <header>
                <row id="110">
                    <cell id="111">
                        <label id="112">
                            <text-property name="text">country</text-property>
                        </label>
                    </cell>
                    <cell id="113">
                        <label id="114">
                            <text-property name="text">count</text-property>
                        </label>
                    </cell>
                </row>
            </header>
            <detail>
                <row id="115">
                    <cell id="116">
                        <data id="117">
                            <property name="resultSetColumn">country</property>
                        </data>
                    </cell>
                    <cell id="118">
                        <data id="119">
                            <property name="resultSetColumn">count</property>
                        </data>
                    </cell>
                </row>
            </detail>
            <footer>
                <row id="120">
                    <cell id="121"/>
                    <cell id="122"/>
                </row>
            </footer>
        </table>
        <label id="483">
            <text-property name="text">Number of top assessments</text-property>
        </label>
        <table id="445">
            <property name="borderBottomColor">#000000</property>
            <property name="borderLeftColor">#000000</property>
            <property name="borderRightColor">#000000</property>
            <property name="borderTopColor">#000000</property>
            <property name="width">7.979166666666667in</property>
            <property name="dataSet">Completed Assessments</property>
            <list-property name="boundDataColumns">
                <structure>
                    <property name="name">session_path</property>
                    <text-property name="displayName">session_path</text-property>
                    <expression name="expression" type="javascript">dataSetRow["zodb_path"]</expression>
                    <property name="dataType">string</property>
                    <property name="allowExport">true</property>
                </structure>
                <structure>
                    <property name="name">answered_risks</property>
                    <text-property name="displayName">answered_risks</text-property>
                    <expression name="expression" type="javascript">dataSetRow["answered_risks"]</expression>
                    <property name="dataType">decimal</property>
                </structure>
                <structure>
                    <property name="name">no_risks</property>
                    <text-property name="displayName">no_risks</text-property>
                    <expression name="expression" type="javascript">dataSetRow["total_risks"]</expression>
                    <property name="dataType">decimal</property>
                    <property name="allowExport">true</property>
                </structure>
                <structure>
                    <property name="name">percentage</property>
                    <text-property name="displayName">percent_complete</text-property>
                    <expression name="expression" type="javascript">dataSetRow["percent_complete"]</expression>
                    <property name="dataType">decimal</property>
                    <property name="allowExport">true</property>
                </structure>
                <structure>
                    <property name="name">completed</property>
                    <text-property name="displayName">completed</text-property>
                    <expression name="expression" type="javascript">dataSetRow["percent_complete"] > .7 ? 'completed' : 'not completed'</expression>
                    <property name="dataType">string</property>
                    <property name="allowExport">true</property>
                </structure>
                <structure>
                    <property name="name">count</property>
                    <text-property name="displayName">count</text-property>
                    <property name="dataType">integer</property>
                    <simple-property-list name="aggregateOn">
                        <value>Completed</value>
                    </simple-property-list>
                    <property name="aggregateFunction">COUNT</property>
                    <list-property name="arguments">
                        <structure>
                            <property name="name">Expression</property>
                            <expression name="value" type="javascript">row["session_path"]</expression>
                        </structure>
                    </list-property>
                    <property name="allowExport">true</property>
                </structure>
                <structure>
                    <property name="name">total_risks</property>
                    <text-property name="displayName">total_risks</text-property>
                    <expression name="expression" type="javascript">dataSetRow["total_risks"]</expression>
                    <property name="dataType">decimal</property>
                </structure>
            </list-property>
            <list-property name="sort">
                <structure>
                    <expression name="key" type="javascript">row["percentage"]</expression>
                    <property name="direction">desc</property>
                    <property name="strength">0</property>
                </structure>
            </list-property>
            <column id="475">
                <property name="width">3.1770833333333335in</property>
            </column>
            <column id="1051">
                <property name="width">2.4166666666666665in</property>
            </column>
            <column id="476">
                <property name="width">0.84375in</property>
            </column>
            <column id="477">
                <property name="width">0.6666666666666666in</property>
            </column>
            <column id="478">
                <property name="width">0.875in</property>
            </column>
            <header>
                <row id="446">
                    <cell id="449">
                        <label id="450">
                            <text-property name="text">Tool</text-property>
                        </label>
                    </cell>
                    <cell id="1044"/>
                    <cell id="451">
                        <label id="452">
                            <text-property name="text">Answered Risks</text-property>
                        </label>
                    </cell>
                    <cell id="453">
                        <label id="454">
                            <text-property name="text">Total Risks</text-property>
                        </label>
                    </cell>
                    <cell id="455">
                        <label id="456">
                            <text-property name="text">percent complete</text-property>
                        </label>
                    </cell>
                </row>
            </header>
            <group id="616">
                <property name="groupName">Tool</property>
                <expression name="keyExpr" type="javascript">row["session_path"]</expression>
                <structure name="toc">
                    <expression name="expressionValue" type="javascript">row["session_path"]</expression>
                </structure>
                <property name="hideDetail">false</property>
                <header>
                    <row id="617">
                        <cell id="618">
                            <data id="627">
                                <property name="resultSetColumn">session_path</property>
                            </data>
                        </cell>
                        <cell id="1045"/>
                        <cell id="619"/>
                        <cell id="620"/>
                        <cell id="621"/>
                    </row>
                </header>
                <footer>
                    <row id="622">
                        <cell id="623"/>
                        <cell id="1049"/>
                        <cell id="624"/>
                        <cell id="625"/>
                        <cell id="626"/>
                    </row>
                </footer>
            </group>
            <group id="484">
                <property name="groupName">Completed</property>
                <property name="sortDirection">desc</property>
                <expression name="keyExpr" type="javascript">row["percentage"] > .7</expression>
                <property name="hideDetail">false</property>
                <list-property name="sort">
                    <structure>
                        <expression name="key" type="javascript">row["percentage"]</expression>
                        <property name="direction">desc</property>
                        <property name="strength">3</property>
                    </structure>
                </list-property>
                <header>
                    <row id="485">
                        <cell id="486"/>
                        <cell id="1046">
                            <data id="496">
                                <property name="resultSetColumn">count</property>
                            </data>
                            <data id="495">
                                <property name="style">indented-1</property>
                                <structure name="numberFormat">
                                    <property name="category">Unformatted</property>
                                </structure>
                                <property name="resultSetColumn">completed</property>
                            </data>
                        </cell>
                        <cell id="487"/>
                        <cell id="488"/>
                        <cell id="489"/>
                    </row>
                </header>
                <footer>
                    <row id="490">
                        <cell id="491"/>
                        <cell id="1048"/>
                        <cell id="492"/>
                        <cell id="493"/>
                        <cell id="494"/>
                    </row>
                </footer>
            </group>
            <detail>
                <row id="457">
                    <cell id="460"/>
                    <cell id="1047"/>
                    <cell id="462">
                        <data id="463">
                            <property name="resultSetColumn">answered_risks</property>
                        </data>
                    </cell>
                    <cell id="464">
                        <data id="465">
                            <property name="resultSetColumn">no_risks</property>
                        </data>
                    </cell>
                    <cell id="466">
                        <data id="467">
                            <structure name="numberFormat">
                                <property name="category">Percent</property>
                                <property name="pattern">###0.00%{RoundingMode=HALF_UP}</property>
                            </structure>
                            <property name="resultSetColumn">percentage</property>
                        </data>
                    </cell>
                </row>
            </detail>
            <footer>
                <row id="468">
                    <cell id="470"/>
                    <cell id="1050"/>
                    <cell id="471"/>
                    <cell id="472"/>
                    <cell id="473"/>
                </row>
            </footer>
        </table>
        <label id="710">
            <text-property name="text">Company survey data</text-property>
        </label>
        <table id="711">
            <property name="dataSet">country_company by tool</property>
            <list-property name="boundDataColumns">
                <structure>
                    <property name="name">zodb_path</property>
                    <text-property name="displayName">zodb_path</text-property>
                    <expression name="expression" type="javascript">dataSetRow["zodb_path"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">country_company</property>
                    <text-property name="displayName">country_company</text-property>
                    <expression name="expression" type="javascript">dataSetRow["country_company"] === null ? 'N/A' : dataSetRow["country_company"]</expression>
                    <property name="dataType">string</property>
                    <property name="allowExport">true</property>
                </structure>
                <structure>
                    <property name="name">count</property>
                    <text-property name="displayName">count</text-property>
                    <expression name="expression" type="javascript">dataSetRow["count"]</expression>
                    <property name="dataType">decimal</property>
                </structure>
            </list-property>
            <column id="730"/>
            <column id="731"/>
            <column id="732"/>
            <header>
                <row id="712">
                    <cell id="713">
                        <label id="714">
                            <text-property name="text">tool</text-property>
                        </label>
                    </cell>
                    <cell id="715">
                        <label id="716">
                            <text-property name="text">country (company)</text-property>
                        </label>
                    </cell>
                    <cell id="717">
                        <label id="718">
                            <text-property name="text">count</text-property>
                        </label>
                    </cell>
                </row>
            </header>
            <detail>
                <row id="719">
                    <cell id="720">
                        <data id="721">
                            <property name="resultSetColumn">zodb_path</property>
                        </data>
                    </cell>
                    <cell id="722">
                        <data id="723">
                            <property name="resultSetColumn">country_company</property>
                        </data>
                    </cell>
                    <cell id="724">
                        <data id="725">
                            <property name="resultSetColumn">count</property>
                        </data>
                    </cell>
                </row>
            </detail>
            <footer>
                <row id="726">
                    <cell id="727"/>
                    <cell id="728"/>
                    <cell id="729"/>
                </row>
            </footer>
        </table>
        <table id="733">
            <property name="dataSet">country_company by sector</property>
            <list-property name="boundDataColumns">
                <structure>
                    <property name="name">sector</property>
                    <text-property name="displayName">sector</text-property>
                    <expression name="expression" type="javascript">dataSetRow["sector"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">country_company</property>
                    <text-property name="displayName">country_company</text-property>
                    <expression name="expression" type="javascript">dataSetRow["country_company"] === null ? 'N/A' : dataSetRow["country_company"]</expression>
                    <property name="dataType">string</property>
                    <property name="allowExport">true</property>
                </structure>
                <structure>
                    <property name="name">count</property>
                    <text-property name="displayName">count</text-property>
                    <expression name="expression" type="javascript">dataSetRow["count"]</expression>
                    <property name="dataType">decimal</property>
                </structure>
            </list-property>
            <column id="752"/>
            <column id="753"/>
            <column id="754"/>
            <header>
                <row id="734">
                    <cell id="735">
                        <label id="736">
                            <text-property name="text">sector</text-property>
                        </label>
                    </cell>
                    <cell id="737">
                        <label id="738">
                            <text-property name="text">country (company)</text-property>
                        </label>
                    </cell>
                    <cell id="739">
                        <label id="740">
                            <text-property name="text">count</text-property>
                        </label>
                    </cell>
                </row>
            </header>
            <detail>
                <row id="741">
                    <cell id="742">
                        <data id="743">
                            <property name="resultSetColumn">sector</property>
                        </data>
                    </cell>
                    <cell id="744">
                        <data id="745">
                            <property name="resultSetColumn">country_company</property>
                        </data>
                    </cell>
                    <cell id="746">
                        <data id="747">
                            <property name="resultSetColumn">count</property>
                        </data>
                    </cell>
                </row>
            </detail>
            <footer>
                <row id="748">
                    <cell id="749"/>
                    <cell id="750"/>
                    <cell id="751"/>
                </row>
            </footer>
        </table>
        <table id="755">
            <property name="dataSet">country_company by country_path</property>
            <list-property name="boundDataColumns">
                <structure>
                    <property name="name">country_path</property>
                    <text-property name="displayName">country_path</text-property>
                    <expression name="expression" type="javascript">dataSetRow["country_path"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">country_company</property>
                    <text-property name="displayName">country_company</text-property>
                    <expression name="expression" type="javascript">dataSetRow["country_company"] === null ? 'N/A' : dataSetRow["country_company"]</expression>
                    <property name="dataType">string</property>
                    <property name="allowExport">true</property>
                </structure>
                <structure>
                    <property name="name">count</property>
                    <text-property name="displayName">count</text-property>
                    <expression name="expression" type="javascript">dataSetRow["count"]</expression>
                    <property name="dataType">decimal</property>
                </structure>
            </list-property>
            <column id="774"/>
            <column id="775"/>
            <column id="776"/>
            <header>
                <row id="756">
                    <cell id="757">
                        <label id="758">
                            <text-property name="text">country (tool)</text-property>
                        </label>
                    </cell>
                    <cell id="759">
                        <label id="760">
                            <text-property name="text">country (company)</text-property>
                        </label>
                    </cell>
                    <cell id="761">
                        <label id="762">
                            <text-property name="text">count</text-property>
                        </label>
                    </cell>
                </row>
            </header>
            <detail>
                <row id="763">
                    <cell id="764">
                        <data id="765">
                            <property name="resultSetColumn">country_path</property>
                        </data>
                    </cell>
                    <cell id="766">
                        <data id="767">
                            <property name="resultSetColumn">country_company</property>
                        </data>
                    </cell>
                    <cell id="768">
                        <data id="769">
                            <property name="resultSetColumn">count</property>
                        </data>
                    </cell>
                </row>
            </detail>
            <footer>
                <row id="770">
                    <cell id="771"/>
                    <cell id="772"/>
                    <cell id="773"/>
                </row>
            </footer>
        </table>
        <table id="777">
            <property name="dataSet">employees by tool</property>
            <list-property name="boundDataColumns">
                <structure>
                    <property name="name">zodb_path</property>
                    <text-property name="displayName">zodb_path</text-property>
                    <expression name="expression" type="javascript">dataSetRow["zodb_path"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">employees</property>
                    <text-property name="displayName">employees</text-property>
                    <expression name="expression" type="javascript">dataSetRow["employees"] === null ? 'N/A' : dataSetRow["employees"]</expression>
                    <property name="dataType">string</property>
                    <property name="allowExport">true</property>
                </structure>
                <structure>
                    <property name="name">count</property>
                    <text-property name="displayName">count</text-property>
                    <expression name="expression" type="javascript">dataSetRow["count"]</expression>
                    <property name="dataType">decimal</property>
                </structure>
            </list-property>
            <column id="796"/>
            <column id="797"/>
            <column id="798"/>
            <header>
                <row id="778">
                    <cell id="779">
                        <label id="780">
                            <text-property name="text">tool</text-property>
                        </label>
                    </cell>
                    <cell id="781">
                        <label id="782">
                            <text-property name="text">employees</text-property>
                        </label>
                    </cell>
                    <cell id="783">
                        <label id="784">
                            <text-property name="text">count</text-property>
                        </label>
                    </cell>
                </row>
            </header>
            <detail>
                <row id="785">
                    <cell id="786">
                        <data id="787">
                            <property name="resultSetColumn">zodb_path</property>
                        </data>
                    </cell>
                    <cell id="788">
                        <data id="789">
                            <property name="resultSetColumn">employees</property>
                        </data>
                    </cell>
                    <cell id="790">
                        <data id="791">
                            <property name="resultSetColumn">count</property>
                        </data>
                    </cell>
                </row>
            </detail>
            <footer>
                <row id="792">
                    <cell id="793"/>
                    <cell id="794"/>
                    <cell id="795"/>
                </row>
            </footer>
        </table>
        <table id="799">
            <property name="dataSet">employees by sector</property>
            <list-property name="boundDataColumns">
                <structure>
                    <property name="name">sector</property>
                    <text-property name="displayName">sector</text-property>
                    <expression name="expression" type="javascript">dataSetRow["sector"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">employees</property>
                    <text-property name="displayName">employees</text-property>
                    <expression name="expression" type="javascript">dataSetRow["employees"] === null ? 'N/A' : dataSetRow["employees"]</expression>
                    <property name="dataType">string</property>
                    <property name="allowExport">true</property>
                </structure>
                <structure>
                    <property name="name">count</property>
                    <text-property name="displayName">count</text-property>
                    <expression name="expression" type="javascript">dataSetRow["count"]</expression>
                    <property name="dataType">decimal</property>
                </structure>
            </list-property>
            <column id="818"/>
            <column id="819"/>
            <column id="820"/>
            <header>
                <row id="800">
                    <cell id="801">
                        <label id="802">
                            <text-property name="text">sector</text-property>
                        </label>
                    </cell>
                    <cell id="803">
                        <label id="804">
                            <text-property name="text">employees</text-property>
                        </label>
                    </cell>
                    <cell id="805">
                        <label id="806">
                            <text-property name="text">count</text-property>
                        </label>
                    </cell>
                </row>
            </header>
            <detail>
                <row id="807">
                    <cell id="808">
                        <data id="809">
                            <property name="resultSetColumn">sector</property>
                        </data>
                    </cell>
                    <cell id="810">
                        <data id="811">
                            <property name="resultSetColumn">employees</property>
                        </data>
                    </cell>
                    <cell id="812">
                        <data id="813">
                            <property name="resultSetColumn">count</property>
                        </data>
                    </cell>
                </row>
            </detail>
            <footer>
                <row id="814">
                    <cell id="815"/>
                    <cell id="816"/>
                    <cell id="817"/>
                </row>
            </footer>
        </table>
        <table id="821">
            <property name="dataSet">employees by country</property>
            <list-property name="boundDataColumns">
                <structure>
                    <property name="name">country</property>
                    <text-property name="displayName">country</text-property>
                    <expression name="expression" type="javascript">dataSetRow["country"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">employees</property>
                    <text-property name="displayName">employees</text-property>
                    <expression name="expression" type="javascript">dataSetRow["employees"] === null ? 'N/A' : dataSetRow["employees"]</expression>
                    <property name="dataType">string</property>
                    <property name="allowExport">true</property>
                </structure>
                <structure>
                    <property name="name">count</property>
                    <text-property name="displayName">count</text-property>
                    <expression name="expression" type="javascript">dataSetRow["count"]</expression>
                    <property name="dataType">decimal</property>
                </structure>
            </list-property>
            <column id="840"/>
            <column id="841"/>
            <column id="842"/>
            <header>
                <row id="822">
                    <cell id="823">
                        <label id="824">
                            <text-property name="text">country</text-property>
                        </label>
                    </cell>
                    <cell id="825">
                        <label id="826">
                            <text-property name="text">employees</text-property>
                        </label>
                    </cell>
                    <cell id="827">
                        <label id="828">
                            <text-property name="text">count</text-property>
                        </label>
                    </cell>
                </row>
            </header>
            <detail>
                <row id="829">
                    <cell id="830">
                        <data id="831">
                            <property name="resultSetColumn">country</property>
                        </data>
                    </cell>
                    <cell id="832">
                        <data id="833">
                            <property name="resultSetColumn">employees</property>
                        </data>
                    </cell>
                    <cell id="834">
                        <data id="835">
                            <property name="resultSetColumn">count</property>
                        </data>
                    </cell>
                </row>
            </detail>
            <footer>
                <row id="836">
                    <cell id="837"/>
                    <cell id="838"/>
                    <cell id="839"/>
                </row>
            </footer>
        </table>
        <table id="843">
            <property name="width">6.770833333333333in</property>
            <property name="dataSet">conductor by tool</property>
            <list-property name="boundDataColumns">
                <structure>
                    <property name="name">zodb_path</property>
                    <text-property name="displayName">zodb_path</text-property>
                    <expression name="expression" type="javascript">dataSetRow["zodb_path"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">conductor</property>
                    <text-property name="displayName">conductor</text-property>
                    <expression name="expression" type="javascript">dataSetRow["conductor"] === null ? 'N/A' : dataSetRow["conductor"]</expression>
                    <property name="dataType">string</property>
                    <property name="allowExport">true</property>
                </structure>
                <structure>
                    <property name="name">count</property>
                    <text-property name="displayName">count</text-property>
                    <expression name="expression" type="javascript">dataSetRow["count"]</expression>
                    <property name="dataType">decimal</property>
                </structure>
            </list-property>
            <column id="862">
                <property name="width">4.270833333333333in</property>
            </column>
            <column id="863">
                <property name="width">1.875in</property>
            </column>
            <column id="864">
                <property name="width">0.625in</property>
            </column>
            <header>
                <row id="844">
                    <cell id="845">
                        <label id="846">
                            <text-property name="text">tool</text-property>
                        </label>
                    </cell>
                    <cell id="847">
                        <label id="848">
                            <text-property name="text">conductor</text-property>
                        </label>
                    </cell>
                    <cell id="849">
                        <label id="850">
                            <text-property name="text">count</text-property>
                        </label>
                    </cell>
                </row>
            </header>
            <detail>
                <row id="851">
                    <cell id="852">
                        <data id="853">
                            <property name="resultSetColumn">zodb_path</property>
                        </data>
                    </cell>
                    <cell id="854">
                        <data id="855">
                            <property name="resultSetColumn">conductor</property>
                        </data>
                    </cell>
                    <cell id="856">
                        <data id="857">
                            <property name="resultSetColumn">count</property>
                        </data>
                    </cell>
                </row>
            </detail>
            <footer>
                <row id="858">
                    <cell id="859"/>
                    <cell id="860"/>
                    <cell id="861"/>
                </row>
            </footer>
        </table>
        <table id="865">
            <property name="width">4.895833333333333in</property>
            <property name="dataSet">conductor by sector</property>
            <list-property name="boundDataColumns">
                <structure>
                    <property name="name">sector</property>
                    <text-property name="displayName">sector</text-property>
                    <expression name="expression" type="javascript">dataSetRow["sector"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">conductor</property>
                    <text-property name="displayName">conductor</text-property>
                    <expression name="expression" type="javascript">dataSetRow["conductor"] === null ? 'N/A' : dataSetRow["conductor"]</expression>
                    <property name="dataType">string</property>
                    <property name="allowExport">true</property>
                </structure>
                <structure>
                    <property name="name">count</property>
                    <text-property name="displayName">count</text-property>
                    <expression name="expression" type="javascript">dataSetRow["count"]</expression>
                    <property name="dataType">decimal</property>
                </structure>
            </list-property>
            <column id="884">
                <property name="width">2.3958333333333335in</property>
            </column>
            <column id="885">
                <property name="width">1.875in</property>
            </column>
            <column id="886">
                <property name="width">0.625in</property>
            </column>
            <header>
                <row id="866">
                    <cell id="867">
                        <label id="868">
                            <text-property name="text">sector</text-property>
                        </label>
                    </cell>
                    <cell id="869">
                        <label id="870">
                            <text-property name="text">conductor</text-property>
                        </label>
                    </cell>
                    <cell id="871">
                        <label id="872">
                            <text-property name="text">count</text-property>
                        </label>
                    </cell>
                </row>
            </header>
            <detail>
                <row id="873">
                    <cell id="874">
                        <data id="875">
                            <property name="resultSetColumn">sector</property>
                        </data>
                    </cell>
                    <cell id="876">
                        <data id="877">
                            <property name="resultSetColumn">conductor</property>
                        </data>
                    </cell>
                    <cell id="878">
                        <data id="879">
                            <property name="resultSetColumn">count</property>
                        </data>
                    </cell>
                </row>
            </detail>
            <footer>
                <row id="880">
                    <cell id="881"/>
                    <cell id="882"/>
                    <cell id="883"/>
                </row>
            </footer>
        </table>
        <table id="887">
            <property name="width">4.90625in</property>
            <property name="dataSet">conductor by country</property>
            <list-property name="boundDataColumns">
                <structure>
                    <property name="name">country</property>
                    <text-property name="displayName">country</text-property>
                    <expression name="expression" type="javascript">dataSetRow["country"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">conductor</property>
                    <text-property name="displayName">conductor</text-property>
                    <expression name="expression" type="javascript">dataSetRow["conductor"] === null ? 'N/A' : dataSetRow["conductor"]</expression>
                    <property name="dataType">string</property>
                    <property name="allowExport">true</property>
                </structure>
                <structure>
                    <property name="name">count</property>
                    <text-property name="displayName">count</text-property>
                    <expression name="expression" type="javascript">dataSetRow["count"]</expression>
                    <property name="dataType">decimal</property>
                </structure>
            </list-property>
            <column id="906">
                <property name="width">2.40625in</property>
            </column>
            <column id="907">
                <property name="width">1.8854166666666667in</property>
            </column>
            <column id="908">
                <property name="width">0.6145833333333334in</property>
            </column>
            <header>
                <row id="888">
                    <cell id="889">
                        <label id="890">
                            <text-property name="text">country</text-property>
                        </label>
                    </cell>
                    <cell id="891">
                        <label id="892">
                            <text-property name="text">conductor</text-property>
                        </label>
                    </cell>
                    <cell id="893">
                        <label id="894">
                            <text-property name="text">count</text-property>
                        </label>
                    </cell>
                </row>
            </header>
            <detail>
                <row id="895">
                    <cell id="896">
                        <data id="897">
                            <property name="resultSetColumn">country</property>
                        </data>
                    </cell>
                    <cell id="898">
                        <data id="899">
                            <property name="resultSetColumn">conductor</property>
                        </data>
                    </cell>
                    <cell id="900">
                        <data id="901">
                            <property name="resultSetColumn">count</property>
                        </data>
                    </cell>
                </row>
            </detail>
            <footer>
                <row id="902">
                    <cell id="903"/>
                    <cell id="904"/>
                    <cell id="905"/>
                </row>
            </footer>
        </table>
        <table id="909">
            <property name="width">7.84375in</property>
            <property name="dataSet">referer by tool</property>
            <list-property name="boundDataColumns">
                <structure>
                    <property name="name">zodb_path</property>
                    <text-property name="displayName">zodb_path</text-property>
                    <expression name="expression" type="javascript">dataSetRow["zodb_path"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">referer</property>
                    <text-property name="displayName">referer</text-property>
                    <expression name="expression" type="javascript">dataSetRow["referer"] === null ? 'N/A' : dataSetRow["referer"]</expression>
                    <property name="dataType">string</property>
                    <property name="allowExport">true</property>
                </structure>
                <structure>
                    <property name="name">count</property>
                    <text-property name="displayName">count</text-property>
                    <expression name="expression" type="javascript">dataSetRow["count"]</expression>
                    <property name="dataType">decimal</property>
                </structure>
            </list-property>
            <column id="928">
                <property name="width">4.3125in</property>
            </column>
            <column id="929">
                <property name="width">2.9166666666666665in</property>
            </column>
            <column id="930">
                <property name="width">0.6145833333333334in</property>
            </column>
            <header>
                <row id="910">
                    <cell id="911">
                        <label id="912">
                            <text-property name="text">tool</text-property>
                        </label>
                    </cell>
                    <cell id="913">
                        <label id="914">
                            <text-property name="text">referer</text-property>
                        </label>
                    </cell>
                    <cell id="915">
                        <label id="916">
                            <text-property name="text">count</text-property>
                        </label>
                    </cell>
                </row>
            </header>
            <detail>
                <row id="917">
                    <cell id="918">
                        <data id="919">
                            <property name="resultSetColumn">zodb_path</property>
                        </data>
                    </cell>
                    <cell id="920">
                        <data id="921">
                            <property name="resultSetColumn">referer</property>
                        </data>
                    </cell>
                    <cell id="922">
                        <data id="923">
                            <property name="resultSetColumn">count</property>
                        </data>
                    </cell>
                </row>
            </detail>
            <footer>
                <row id="924">
                    <cell id="925"/>
                    <cell id="926"/>
                    <cell id="927"/>
                </row>
            </footer>
        </table>
        <table id="931">
            <property name="width">5.958333333333333in</property>
            <property name="dataSet">referer by sector</property>
            <list-property name="boundDataColumns">
                <structure>
                    <property name="name">sector</property>
                    <text-property name="displayName">sector</text-property>
                    <expression name="expression" type="javascript">dataSetRow["sector"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">referer</property>
                    <text-property name="displayName">referer</text-property>
                    <expression name="expression" type="javascript">dataSetRow["referer"] === null ? 'N/A' : dataSetRow["referer"]</expression>
                    <property name="dataType">string</property>
                    <property name="allowExport">true</property>
                </structure>
                <structure>
                    <property name="name">count</property>
                    <text-property name="displayName">count</text-property>
                    <expression name="expression" type="javascript">dataSetRow["count"]</expression>
                    <property name="dataType">decimal</property>
                </structure>
            </list-property>
            <column id="950">
                <property name="width">2.4166666666666665in</property>
            </column>
            <column id="951">
                <property name="width">2.9166666666666665in</property>
            </column>
            <column id="952">
                <property name="width">0.625in</property>
            </column>
            <header>
                <row id="932">
                    <cell id="933">
                        <label id="934">
                            <text-property name="text">sector</text-property>
                        </label>
                    </cell>
                    <cell id="935">
                        <label id="936">
                            <text-property name="text">referer</text-property>
                        </label>
                    </cell>
                    <cell id="937">
                        <label id="938">
                            <text-property name="text">count</text-property>
                        </label>
                    </cell>
                </row>
            </header>
            <detail>
                <row id="939">
                    <cell id="940">
                        <data id="941">
                            <property name="resultSetColumn">sector</property>
                        </data>
                    </cell>
                    <cell id="942">
                        <data id="943">
                            <property name="resultSetColumn">referer</property>
                        </data>
                    </cell>
                    <cell id="944">
                        <data id="945">
                            <property name="resultSetColumn">count</property>
                        </data>
                    </cell>
                </row>
            </detail>
            <footer>
                <row id="946">
                    <cell id="947"/>
                    <cell id="948"/>
                    <cell id="949"/>
                </row>
            </footer>
        </table>
        <table id="953">
            <property name="width">5.958333333333333in</property>
            <property name="dataSet">referer by country</property>
            <list-property name="boundDataColumns">
                <structure>
                    <property name="name">country</property>
                    <text-property name="displayName">country</text-property>
                    <expression name="expression" type="javascript">dataSetRow["country"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">referer</property>
                    <text-property name="displayName">referer</text-property>
                    <expression name="expression" type="javascript">dataSetRow["referer"] === null ? 'N/A' : dataSetRow["referer"]</expression>
                    <property name="dataType">string</property>
                    <property name="allowExport">true</property>
                </structure>
                <structure>
                    <property name="name">count</property>
                    <text-property name="displayName">count</text-property>
                    <expression name="expression" type="javascript">dataSetRow["count"]</expression>
                    <property name="dataType">decimal</property>
                </structure>
            </list-property>
            <column id="972">
                <property name="width">2.4166666666666665in</property>
            </column>
            <column id="973">
                <property name="width">2.9166666666666665in</property>
            </column>
            <column id="974">
                <property name="width">0.625in</property>
            </column>
            <header>
                <row id="954">
                    <cell id="955">
                        <label id="956">
                            <text-property name="text">country</text-property>
                        </label>
                    </cell>
                    <cell id="957">
                        <label id="958">
                            <text-property name="text">referer</text-property>
                        </label>
                    </cell>
                    <cell id="959">
                        <label id="960">
                            <text-property name="text">count</text-property>
                        </label>
                    </cell>
                </row>
            </header>
            <detail>
                <row id="961">
                    <cell id="962">
                        <data id="963">
                            <property name="resultSetColumn">country</property>
                        </data>
                    </cell>
                    <cell id="964">
                        <data id="965">
                            <property name="resultSetColumn">referer</property>
                        </data>
                    </cell>
                    <cell id="966">
                        <data id="967">
                            <property name="resultSetColumn">count</property>
                        </data>
                    </cell>
                </row>
            </detail>
            <footer>
                <row id="968">
                    <cell id="969"/>
                    <cell id="970"/>
                    <cell id="971"/>
                </row>
            </footer>
        </table>
        <table id="975">
            <property name="width">6.59375in</property>
            <property name="dataSet">workers_participated by tool</property>
            <list-property name="boundDataColumns">
                <structure>
                    <property name="name">zodb_path</property>
                    <text-property name="displayName">zodb_path</text-property>
                    <expression name="expression" type="javascript">dataSetRow["zodb_path"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">workers_participated</property>
                    <text-property name="displayName">workers_participated</text-property>
                    <expression name="expression" type="javascript">dataSetRow["workers_participated"] === 1 ? 'yes' : dataSetRow["workers_participated"] === 0 ? 'no' : "N/A"</expression>
                    <property name="dataType">string</property>
                    <property name="allowExport">true</property>
                </structure>
                <structure>
                    <property name="name">count</property>
                    <text-property name="displayName">count</text-property>
                    <expression name="expression" type="javascript">dataSetRow["count"]</expression>
                    <property name="dataType">decimal</property>
                </structure>
            </list-property>
            <column id="994">
                <property name="width">4.302083333333333in</property>
            </column>
            <column id="995">
                <property name="width">1.6458333333333333in</property>
            </column>
            <column id="996">
                <property name="width">0.6458333333333334in</property>
            </column>
            <header>
                <row id="976">
                    <cell id="977">
                        <label id="978">
                            <text-property name="text">tool</text-property>
                        </label>
                    </cell>
                    <cell id="979">
                        <label id="980">
                            <text-property name="text">workers participated</text-property>
                        </label>
                    </cell>
                    <cell id="981">
                        <label id="982">
                            <text-property name="text">count</text-property>
                        </label>
                    </cell>
                </row>
            </header>
            <detail>
                <row id="983">
                    <cell id="984">
                        <data id="985">
                            <property name="resultSetColumn">zodb_path</property>
                        </data>
                    </cell>
                    <cell id="986">
                        <data id="987">
                            <property name="resultSetColumn">workers_participated</property>
                        </data>
                    </cell>
                    <cell id="988">
                        <data id="989">
                            <property name="resultSetColumn">count</property>
                        </data>
                    </cell>
                </row>
            </detail>
            <footer>
                <row id="990">
                    <cell id="991"/>
                    <cell id="992"/>
                    <cell id="993"/>
                </row>
            </footer>
        </table>
        <table id="997">
            <property name="width">4.916666666666667in</property>
            <property name="dataSet">workers_participated by sector</property>
            <list-property name="boundDataColumns">
                <structure>
                    <property name="name">sector</property>
                    <text-property name="displayName">sector</text-property>
                    <expression name="expression" type="javascript">dataSetRow["sector"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">workers_participated</property>
                    <text-property name="displayName">workers_participated</text-property>
                    <expression name="expression" type="javascript">dataSetRow["workers_participated"] === 1 ? 'yes' : dataSetRow["workers_participated"] === 0 ? 'no' : "N/A"</expression>
                    <property name="dataType">string</property>
                    <property name="allowExport">true</property>
                </structure>
                <structure>
                    <property name="name">count</property>
                    <text-property name="displayName">count</text-property>
                    <expression name="expression" type="javascript">dataSetRow["count"]</expression>
                    <property name="dataType">decimal</property>
                </structure>
            </list-property>
            <column id="1016">
                <property name="width">2.4583333333333335in</property>
            </column>
            <column id="1017">
                <property name="width">1.8333333333333333in</property>
            </column>
            <column id="1018">
                <property name="width">0.625in</property>
            </column>
            <header>
                <row id="998">
                    <cell id="999">
                        <label id="1000">
                            <text-property name="text">sector</text-property>
                        </label>
                    </cell>
                    <cell id="1001">
                        <label id="1002">
                            <text-property name="text">workers participated</text-property>
                        </label>
                    </cell>
                    <cell id="1003">
                        <label id="1004">
                            <text-property name="text">count</text-property>
                        </label>
                    </cell>
                </row>
            </header>
            <detail>
                <row id="1005">
                    <cell id="1006">
                        <data id="1007">
                            <property name="resultSetColumn">sector</property>
                        </data>
                    </cell>
                    <cell id="1008">
                        <data id="1009">
                            <property name="resultSetColumn">workers_participated</property>
                        </data>
                    </cell>
                    <cell id="1010">
                        <data id="1011">
                            <property name="resultSetColumn">count</property>
                        </data>
                    </cell>
                </row>
            </detail>
            <footer>
                <row id="1012">
                    <cell id="1013"/>
                    <cell id="1014"/>
                    <cell id="1015"/>
                </row>
            </footer>
        </table>
        <table id="1019">
            <property name="width">4.90625in</property>
            <property name="dataSet">workers_participated by country</property>
            <list-property name="boundDataColumns">
                <structure>
                    <property name="name">country</property>
                    <text-property name="displayName">country</text-property>
                    <expression name="expression" type="javascript">dataSetRow["country"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">workers_participated</property>
                    <text-property name="displayName">workers_participated</text-property>
                    <expression name="expression" type="javascript">dataSetRow["workers_participated"] === 1 ? 'yes' : dataSetRow["workers_participated"] === 0 ? 'no' : "N/A"</expression>
                    <property name="dataType">string</property>
                    <property name="allowExport">true</property>
                </structure>
                <structure>
                    <property name="name">count</property>
                    <text-property name="displayName">count</text-property>
                    <expression name="expression" type="javascript">dataSetRow["count"]</expression>
                    <property name="dataType">decimal</property>
                </structure>
            </list-property>
            <column id="1038">
                <property name="width">2.4583333333333335in</property>
            </column>
            <column id="1039">
                <property name="width">1.8229166666666667in</property>
            </column>
            <column id="1040">
                <property name="width">0.625in</property>
            </column>
            <header>
                <row id="1020">
                    <cell id="1021">
                        <label id="1022">
                            <text-property name="text">country</text-property>
                        </label>
                    </cell>
                    <cell id="1023">
                        <label id="1024">
                            <text-property name="text">workers participated</text-property>
                        </label>
                    </cell>
                    <cell id="1025">
                        <label id="1026">
                            <text-property name="text">count</text-property>
                        </label>
                    </cell>
                </row>
            </header>
            <detail>
                <row id="1027">
                    <cell id="1028">
                        <data id="1029">
                            <property name="resultSetColumn">country</property>
                        </data>
                    </cell>
                    <cell id="1030">
                        <data id="1031">
                            <property name="resultSetColumn">workers_participated</property>
                        </data>
                    </cell>
                    <cell id="1032">
                        <data id="1033">
                            <property name="resultSetColumn">count</property>
                        </data>
                    </cell>
                </row>
            </detail>
            <footer>
                <row id="1034">
                    <cell id="1035"/>
                    <cell id="1036"/>
                    <cell id="1037"/>
                </row>
            </footer>
        </table>
    </body>
</report>