<?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.7.0.v201706222054</property>
    <list-property name="propertyBindings">
        <structure>
            <property name="name">odaURL</property>
            <property name="id">209</property>
            <expression name="value" type="javascript">params["DBName"].value</expression>
        </structure>
        <structure>
            <property name="name">odaUser</property>
            <property name="id">209</property>
            <expression name="value" type="javascript">params["UserName"].value</expression>
        </structure>
        <structure>
            <property name="name">odaPassword</property>
            <property name="id">209</property>
            <expression name="value" type="javascript">params["Password"].value</expression>
        </structure>
        <structure>
            <property name="name">odaDriverClass</property>
            <property name="id">209</property>
            <expression name="value" type="javascript">params["DefaultDriver"].value</expression>
        </structure>
    </list-property>
    <property name="units">cm</property>
    <property name="layoutPreference">auto layout</property>
    <property name="bidiLayoutOrientation">ltr</property>
    <property name="imageDPI">96</property>
    <parameters>
        <scalar-parameter name="StockLocationId" id="3265">
            <property name="hidden">true</property>
            <property name="valueType">static</property>
            <property name="isRequired">true</property>
            <property name="dataType">string</property>
            <property name="distinct">true</property>
            <list-property name="selectionList"/>
            <property name="paramType">simple</property>
            <property name="concealValue">false</property>
            <property name="controlType">text-box</property>
            <structure name="format">
                <property name="category">Unformatted</property>
            </structure>
        </scalar-parameter>
        <scalar-parameter name="Locale" id="3740">
            <property name="hidden">true</property>
            <property name="valueType">static</property>
            <property name="isRequired">false</property>
            <property name="dataType">string</property>
            <property name="distinct">true</property>
            <simple-property-list name="defaultValue">
                <value type="constant">fr</value>
            </simple-property-list>
            <list-property name="selectionList"/>
            <property name="paramType">simple</property>
            <property name="concealValue">false</property>
            <property name="controlType">text-box</property>
            <structure name="format">
                <property name="category">Unformatted</property>
            </structure>
        </scalar-parameter>
        <scalar-parameter name="DBName" id="3946">
            <property name="hidden">true</property>
            <property name="valueType">static</property>
            <property name="isRequired">true</property>
            <property name="dataType">string</property>
            <property name="distinct">true</property>
            <list-property name="selectionList"/>
            <property name="paramType">simple</property>
            <property name="controlType">text-box</property>
            <structure name="format">
                <property name="category">Unformatted</property>
            </structure>
        </scalar-parameter>
        <scalar-parameter name="UserName" id="3947">
            <property name="hidden">true</property>
            <property name="valueType">static</property>
            <property name="isRequired">true</property>
            <property name="dataType">string</property>
            <property name="distinct">true</property>
            <list-property name="selectionList"/>
            <property name="paramType">simple</property>
            <property name="controlType">text-box</property>
            <structure name="format">
                <property name="category">Unformatted</property>
            </structure>
        </scalar-parameter>
        <scalar-parameter name="Password" id="3675">
            <property name="hidden">true</property>
            <property name="valueType">static</property>
            <property name="isRequired">true</property>
            <property name="dataType">string</property>
            <property name="distinct">true</property>
            <list-property name="selectionList"/>
            <property name="paramType">simple</property>
            <property name="controlType">text-box</property>
            <structure name="format">
                <property name="category">Unformatted</property>
            </structure>
        </scalar-parameter>
        <scalar-parameter name="AttachmentPath" id="4629">
            <property name="hidden">true</property>
            <property name="valueType">static</property>
            <property name="isRequired">false</property>
            <property name="dataType">string</property>
            <property name="distinct">true</property>
            <simple-property-list name="defaultValue">
                <value type="constant"></value>
            </simple-property-list>
            <list-property name="selectionList"/>
            <property name="paramType">simple</property>
            <property name="controlType">text-box</property>
            <structure name="format">
                <property name="category">Unformatted</property>
            </structure>
        </scalar-parameter>
        <scalar-parameter name="DefaultDriver" id="3819">
            <property name="hidden">true</property>
            <property name="valueType">static</property>
            <property name="isRequired">true</property>
            <property name="dataType">string</property>
            <property name="distinct">true</property>
            <simple-property-list name="defaultValue">
                <value type="constant">org.postgresql.Driver</value>
            </simple-property-list>
            <list-property name="selectionList"/>
            <property name="paramType">simple</property>
            <property name="controlType">text-box</property>
            <structure name="format">
                <property name="category">Unformatted</property>
            </structure>
        </scalar-parameter>
        <scalar-parameter name="PrintType" id="5360">
            <property name="valueType">static</property>
            <property name="dataType">string</property>
            <property name="distinct">true</property>
            <simple-property-list name="defaultValue">
                <value type="constant">1</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="Data Source" id="209">
            <list-property name="privateDriverProperties">
                <ex-property>
                    <name>disabledMetadataBidiFormatStr</name>
                </ex-property>
                <ex-property>
                    <name>disabledContentBidiFormatStr</name>
                </ex-property>
                <ex-property>
                    <name>contentBidiFormatStr</name>
                    <value>ILYNN</value>
                </ex-property>
                <ex-property>
                    <name>metadataBidiFormatStr</name>
                    <value>ILYNN</value>
                </ex-property>
            </list-property>
            <property name="odaDriverClass">org.postgresql.Driver</property>
            <property name="odaURL">jdbc:postgresql://localhost:5432/</property>
        </oda-data-source>
    </data-sources>
    <data-sets>
        <oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" name="StockLocationDS" id="3692">
            <property name="nullsOrdering">nulls lowest</property>
            <list-property name="computedColumns">
                <structure>
                    <property name="name">raw_count</property>
                    <property name="dataType">integer</property>
                    <property name="aggregateFunction">COUNT</property>
                    <list-property name="arguments">
                        <structure>
                            <property name="name">Expression</property>
                            <expression name="value">row["location_id"]</expression>
                        </structure>
                    </list-property>
                </structure>
                <structure>
                    <property name="name">Locations</property>
                    <property name="dataType">string</property>
                    <property name="aggregateFunction">CONCATENATE</property>
                    <list-property name="arguments">
                        <structure>
                            <property name="name">Expression</property>
                            <expression name="value">row["location_name"]</expression>
                        </structure>
                        <structure>
                            <property name="name">Separat&amp;or</property>
                            <expression name="value">", "</expression>
                        </structure>
                    </list-property>
                </structure>
            </list-property>
            <list-property name="columnHints">
                <structure>
                    <property name="columnName">location_id</property>
                    <property name="analysis">measure</property>
                    <text-property name="displayName">location_id</text-property>
                    <text-property name="heading">location_id</text-property>
                </structure>
                <structure>
                    <property name="columnName">logo_path</property>
                    <property name="analysis">dimension</property>
                    <text-property name="displayName">logo_path</text-property>
                    <text-property name="heading">logo_path</text-property>
                </structure>
                <structure>
                    <property name="columnName">location_name</property>
                    <property name="analysis">dimension</property>
                    <text-property name="displayName">location_name</text-property>
                    <text-property name="heading">location_name</text-property>
                </structure>
                <structure>
                    <property name="columnName">logo_height</property>
                    <property name="analysis">measure</property>
                    <text-property name="displayName">logo_height</text-property>
                    <text-property name="heading">logo_height</text-property>
                </structure>
                <structure>
                    <property name="columnName">logo_width</property>
                    <property name="analysis">measure</property>
                    <text-property name="displayName">logo_width</text-property>
                    <text-property name="heading">logo_width</text-property>
                </structure>
            </list-property>
            <list-property name="filter"/>
            <list-property name="parameters"/>
            <structure name="cachedMetaData">
                <list-property name="resultSet">
                    <structure>
                        <property name="position">1</property>
                        <property name="name">location_id</property>
                        <property name="dataType">decimal</property>
                    </structure>
                    <structure>
                        <property name="position">2</property>
                        <property name="name">logo_path</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">3</property>
                        <property name="name">location_name</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">4</property>
                        <property name="name">logo_height</property>
                        <property name="dataType">integer</property>
                    </structure>
                    <structure>
                        <property name="position">5</property>
                        <property name="name">logo_width</property>
                        <property name="dataType">integer</property>
                    </structure>
                    <structure>
                        <property name="position">6</property>
                        <property name="name">raw_count</property>
                        <property name="dataType">integer</property>
                    </structure>
                    <structure>
                        <property name="position">7</property>
                        <property name="name">Locations</property>
                        <property name="dataType">string</property>
                    </structure>
                </list-property>
            </structure>
            <method name="beforeOpen"><![CDATA[this.queryText = this.queryText.replace('@INJECTID', params["StockLocationId"])]]></method>
            <property name="dataSource">Data Source</property>
            <list-property name="resultSet">
                <structure>
                    <property name="position">1</property>
                    <property name="name">location_id</property>
                    <property name="nativeName">location_id</property>
                    <property name="dataType">decimal</property>
                    <property name="nativeDataType">-5</property>
                </structure>
                <structure>
                    <property name="position">2</property>
                    <property name="name">logo_path</property>
                    <property name="nativeName">logo_path</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
                <structure>
                    <property name="position">3</property>
                    <property name="name">location_name</property>
                    <property name="nativeName">location_name</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
                <structure>
                    <property name="position">4</property>
                    <property name="name">logo_height</property>
                    <property name="nativeName">logo_height</property>
                    <property name="dataType">integer</property>
                    <property name="nativeDataType">4</property>
                </structure>
                <structure>
                    <property name="position">5</property>
                    <property name="name">logo_width</property>
                    <property name="nativeName">logo_width</property>
                    <property name="dataType">integer</property>
                    <property name="nativeDataType">4</property>
                </structure>
            </list-property>
            <xml-property name="queryText"><![CDATA[SELECT Location.id as location_id, MetaFile.file_path as logo_path, Location.name as location_name,
Company.height as logo_height, Company.width as logo_width
FROM 
	stock_stock_location AS Location
LEFT JOIN 
	base_company AS Company ON (Company.id = Location.company)
LEFT JOIN 
	meta_file AS MetaFile ON (MetaFile.id = Company.logo)
WHERE
	Location.type_select in (1,2)
AND
	Location.id in (@INJECTID)]]></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>id</design:name>
              <design:position>1</design:position>
            </design:identifier>
            <design:nativeDataTypeCode>-5</design:nativeDataTypeCode>
            <design:precision>19</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>20</design:displaySize>
            </design:formattingHints>
          </design:usageHints>
        </design:resultColumnDefinitions>
        <design:resultColumnDefinitions>
          <design:attributes>
            <design:identifier>
              <design:name>status_select</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>status_select</design:displayName>
            </design:uiHints>
          </design:attributes>
          <design:usageHints>
            <design:label>status_select</design:label>
            <design:formattingHints>
              <design:displaySize>11</design:displaySize>
            </design:formattingHints>
          </design:usageHints>
        </design:resultColumnDefinitions>
        <design:resultColumnDefinitions>
          <design:attributes>
            <design:identifier>
              <design:name>title_select</design:name>
              <design:position>4</design:position>
            </design:identifier>
            <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
            <design:precision>255</design:precision>
            <design:scale>0</design:scale>
            <design:nullability>Nullable</design:nullability>
            <design:uiHints>
              <design:displayName>title_select</design:displayName>
            </design:uiHints>
          </design:attributes>
          <design:usageHints>
            <design:label>title_select</design:label>
            <design:formattingHints>
              <design:displaySize>255</design:displaySize>
            </design:formattingHints>
          </design:usageHints>
        </design:resultColumnDefinitions>
        <design:resultColumnDefinitions>
          <design:attributes>
            <design:identifier>
              <design:name>name</design:name>
              <design:position>5</design:position>
            </design:identifier>
            <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
            <design:precision>255</design:precision>
            <design:scale>0</design:scale>
            <design:nullability>Nullable</design:nullability>
            <design:uiHints>
              <design:displayName>name</design:displayName>
            </design:uiHints>
          </design:attributes>
          <design:usageHints>
            <design:label>name</design:label>
            <design:formattingHints>
              <design:displaySize>255</design:displaySize>
            </design:formattingHints>
          </design:usageHints>
        </design:resultColumnDefinitions>
        <design:resultColumnDefinitions>
          <design:attributes>
            <design:identifier>
              <design:name>first_name</design:name>
              <design:position>6</design:position>
            </design:identifier>
            <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
            <design:precision>255</design:precision>
            <design:scale>0</design:scale>
            <design:nullability>Nullable</design:nullability>
            <design:uiHints>
              <design:displayName>first_name</design:displayName>
            </design:uiHints>
          </design:attributes>
          <design:usageHints>
            <design:label>first_name</design:label>
            <design:formattingHints>
              <design:displaySize>255</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="TranslateDS" id="3799">
            <list-property name="columnHints">
                <structure>
                    <property name="columnName">key</property>
                    <property name="analysis">dimension</property>
                    <text-property name="displayName">key</text-property>
                    <text-property name="heading">key</text-property>
                </structure>
                <structure>
                    <property name="columnName">translation</property>
                    <property name="analysis">dimension</property>
                    <text-property name="displayName">translation</text-property>
                    <text-property name="heading">translation</text-property>
                </structure>
            </list-property>
            <list-property name="parameters">
                <structure>
                    <property name="name">param_1</property>
                    <property name="nativeName"></property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                    <property name="position">1</property>
                    <property name="isOptional">false</property>
                    <property name="isInput">true</property>
                </structure>
                <structure>
                    <property name="name">param_2</property>
                    <property name="paramName">Locale</property>
                    <property name="nativeName"></property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                    <property name="position">2</property>
                    <property name="isInput">true</property>
                    <property name="isOutput">false</property>
                </structure>
            </list-property>
            <structure name="cachedMetaData">
                <list-property name="resultSet">
                    <structure>
                        <property name="position">1</property>
                        <property name="name">key</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">2</property>
                        <property name="name">translation</property>
                        <property name="dataType">string</property>
                    </structure>
                </list-property>
            </structure>
            <property name="dataSource">Data Source</property>
            <list-property name="resultSet">
                <structure>
                    <property name="position">1</property>
                    <property name="name">key</property>
                    <property name="nativeName">key</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
                <structure>
                    <property name="position">2</property>
                    <property name="name">translation</property>
                    <property name="nativeName">translation</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
            </list-property>
            <xml-property name="queryText"><![CDATA[select LangTranslate.message_key, LangTranslate.message_value as "translation" 
from meta_translation as LangTranslate 
where LangTranslate.message_key = ? and LangTranslate.language = ?]]></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>
    <parameter>
      <design:ParameterDefinition>
        <design:inOutMode>In</design:inOutMode>
        <design:attributes>
          <design:identifier>
            <design:name></design:name>
            <design:position>2</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="StockLocationLineDS" id="4450">
            <list-property name="columnHints">
                <structure>
                    <property name="columnName">location_id</property>
                    <property name="analysis">measure</property>
                    <text-property name="displayName">location_id</text-property>
                    <text-property name="heading">location_id</text-property>
                </structure>
                <structure>
                    <property name="columnName">location_line_id</property>
                    <property name="analysis">measure</property>
                    <text-property name="displayName">location_line_id</text-property>
                    <text-property name="heading">location_line_id</text-property>
                </structure>
                <structure>
                    <property name="columnName">location_name</property>
                    <property name="analysis">dimension</property>
                    <text-property name="displayName">location_name</text-property>
                    <text-property name="heading">location_name</text-property>
                </structure>
                <structure>
                    <property name="columnName">product_name</property>
                    <property name="analysis">dimension</property>
                    <text-property name="displayName">product_name</text-property>
                    <text-property name="heading">product_name</text-property>
                </structure>
                <structure>
                    <property name="columnName">product_code</property>
                    <property name="analysis">dimension</property>
                    <text-property name="displayName">product_code</text-property>
                    <text-property name="heading">product_code</text-property>
                </structure>
                <structure>
                    <property name="columnName">current_qty</property>
                    <property name="analysis">measure</property>
                    <text-property name="displayName">current_qty</text-property>
                    <text-property name="heading">current_qty</text-property>
                </structure>
                <structure>
                    <property name="columnName">unit_code</property>
                    <property name="analysis">dimension</property>
                    <text-property name="displayName">unit_code</text-property>
                    <text-property name="heading">unit_code</text-property>
                </structure>
                <structure>
                    <property name="columnName">sale_price</property>
                    <property name="analysis">measure</property>
                    <text-property name="displayName">sale_price</text-property>
                    <text-property name="heading">sale_price</text-property>
                </structure>
                <structure>
                    <property name="columnName">currency_code</property>
                    <property name="analysis">dimension</property>
                    <text-property name="displayName">currency_code</text-property>
                    <text-property name="heading">currency_code</text-property>
                </structure>
                <structure>
                    <property name="columnName">product_family</property>
                    <property name="analysis">dimension</property>
                    <text-property name="displayName">product_family</text-property>
                    <text-property name="heading">product_family</text-property>
                </structure>
                <structure>
                    <property name="columnName">cost_price</property>
                    <property name="analysis">measure</property>
                    <text-property name="displayName">cost_price</text-property>
                    <text-property name="heading">cost_price</text-property>
                </structure>
                <structure>
                    <property name="columnName">wap</property>
                    <property name="analysis">measure</property>
                    <text-property name="displayName">wap</text-property>
                    <text-property name="heading">wap</text-property>
                </structure>
                <structure>
                    <property name="columnName">cost_type_select</property>
                    <property name="analysis">measure</property>
                    <text-property name="displayName">cost_type_select</text-property>
                    <text-property name="heading">cost_type_select</text-property>
                </structure>
                <structure>
                    <property name="columnName">is_display_sale_value_in_printing</property>
                    <property name="analysis">measure</property>
                    <text-property name="displayName">is_display_sale_value_in_printing</text-property>
                    <text-property name="heading">is_display_sale_value_in_printing</text-property>
                </structure>
                <structure>
                    <property name="columnName">is_display_accounting_value_in_printing</property>
                    <property name="analysis">measure</property>
                    <text-property name="displayName">is_display_accounting_value_in_printing</text-property>
                    <text-property name="heading">is_display_accounting_value_in_printing</text-property>
                </structure>
                <structure>
                    <property name="columnName">is_display_ag_price_in_printing</property>
                    <property name="analysis">measure</property>
                    <text-property name="displayName">is_display_ag_price_in_printing</text-property>
                    <text-property name="heading">is_display_ag_price_in_printing</text-property>
                </structure>
            </list-property>
            <list-property name="filter"/>
            <list-property name="parameters"/>
            <structure name="cachedMetaData">
                <list-property name="resultSet">
                    <structure>
                        <property name="position">1</property>
                        <property name="name">location_id</property>
                        <property name="dataType">decimal</property>
                    </structure>
                    <structure>
                        <property name="position">2</property>
                        <property name="name">location_line_id</property>
                        <property name="dataType">decimal</property>
                    </structure>
                    <structure>
                        <property name="position">3</property>
                        <property name="name">location_name</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">4</property>
                        <property name="name">product_name</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">5</property>
                        <property name="name">product_code</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">6</property>
                        <property name="name">current_qty</property>
                        <property name="dataType">decimal</property>
                    </structure>
                    <structure>
                        <property name="position">7</property>
                        <property name="name">unit_code</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">8</property>
                        <property name="name">sale_price</property>
                        <property name="dataType">decimal</property>
                    </structure>
                    <structure>
                        <property name="position">9</property>
                        <property name="name">currency_code</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">10</property>
                        <property name="name">product_family</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">11</property>
                        <property name="name">cost_price</property>
                        <property name="dataType">decimal</property>
                    </structure>
                    <structure>
                        <property name="position">12</property>
                        <property name="name">wap</property>
                        <property name="dataType">decimal</property>
                    </structure>
                    <structure>
                        <property name="position">13</property>
                        <property name="name">cost_type_select</property>
                        <property name="dataType">integer</property>
                    </structure>
                    <structure>
                        <property name="position">14</property>
                        <property name="name">is_display_sale_value_in_printing</property>
                        <property name="dataType">integer</property>
                    </structure>
                    <structure>
                        <property name="position">15</property>
                        <property name="name">is_display_accounting_value_in_printing</property>
                        <property name="dataType">integer</property>
                    </structure>
                    <structure>
                        <property name="position">16</property>
                        <property name="name">is_display_ag_price_in_printing</property>
                        <property name="dataType">integer</property>
                    </structure>
                </list-property>
            </structure>
            <method name="beforeOpen"><![CDATA[this.queryText = this.queryText.replace('@INJECTID', params["StockLocationId"])]]></method>
            <property name="dataSource">Data Source</property>
            <list-property name="resultSet">
                <structure>
                    <property name="position">1</property>
                    <property name="name">location_id</property>
                    <property name="nativeName">location_id</property>
                    <property name="dataType">decimal</property>
                    <property name="nativeDataType">-5</property>
                </structure>
                <structure>
                    <property name="position">2</property>
                    <property name="name">location_line_id</property>
                    <property name="nativeName">location_line_id</property>
                    <property name="dataType">decimal</property>
                    <property name="nativeDataType">-5</property>
                </structure>
                <structure>
                    <property name="position">3</property>
                    <property name="name">location_name</property>
                    <property name="nativeName">location_name</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
                <structure>
                    <property name="position">4</property>
                    <property name="name">product_name</property>
                    <property name="nativeName">product_name</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
                <structure>
                    <property name="position">5</property>
                    <property name="name">product_code</property>
                    <property name="nativeName">product_code</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
                <structure>
                    <property name="position">6</property>
                    <property name="name">current_qty</property>
                    <property name="nativeName">current_qty</property>
                    <property name="dataType">decimal</property>
                    <property name="nativeDataType">2</property>
                </structure>
                <structure>
                    <property name="position">7</property>
                    <property name="name">unit_code</property>
                    <property name="nativeName">unit_code</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
                <structure>
                    <property name="position">8</property>
                    <property name="name">sale_price</property>
                    <property name="nativeName">sale_price</property>
                    <property name="dataType">decimal</property>
                    <property name="nativeDataType">2</property>
                </structure>
                <structure>
                    <property name="position">9</property>
                    <property name="name">currency_code</property>
                    <property name="nativeName">currency_code</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
                <structure>
                    <property name="position">10</property>
                    <property name="name">product_family</property>
                    <property name="nativeName">product_family</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
                <structure>
                    <property name="position">11</property>
                    <property name="name">cost_price</property>
                    <property name="nativeName">cost_price</property>
                    <property name="dataType">decimal</property>
                    <property name="nativeDataType">2</property>
                </structure>
                <structure>
                    <property name="position">12</property>
                    <property name="name">wap</property>
                    <property name="nativeName">wap</property>
                    <property name="dataType">decimal</property>
                    <property name="nativeDataType">2</property>
                </structure>
                <structure>
                    <property name="position">13</property>
                    <property name="name">cost_type_select</property>
                    <property name="nativeName">cost_type_select</property>
                    <property name="dataType">integer</property>
                    <property name="nativeDataType">4</property>
                </structure>
                <structure>
                    <property name="position">14</property>
                    <property name="name">is_display_sale_value_in_printing</property>
                    <property name="nativeName">is_display_sale_value_in_printing</property>
                    <property name="dataType">integer</property>
                    <property name="nativeDataType">-7</property>
                </structure>
                <structure>
                    <property name="position">15</property>
                    <property name="name">is_display_accounting_value_in_printing</property>
                    <property name="nativeName">is_display_accounting_value_in_printing</property>
                    <property name="dataType">integer</property>
                    <property name="nativeDataType">-7</property>
                </structure>
                <structure>
                    <property name="position">16</property>
                    <property name="name">is_display_ag_price_in_printing</property>
                    <property name="nativeName">is_display_ag_price_in_printing</property>
                    <property name="dataType">integer</property>
                    <property name="nativeDataType">-7</property>
                </structure>
            </list-property>
            <xml-property name="queryText"><![CDATA[SELECT 	Location.id as location_id, StockLocationLine.id as location_line_id, Location.name as location_name, Product.name AS product_name,
		Product.code AS product_code, StockLocationLine.current_qty, Unit.label_to_printing as unit_code, Product.sale_price,
		Currency.code AS currency_code, ProductFamily.name as product_family,
		(CASE WHEN Product.cost_type_select = 3 THEN StockLocationLine.avg_price ELSE Product.cost_price END) as "cost_price",
		StockLocationLine.avg_price as "wap", Product.cost_type_select,
		StockConfig.is_display_sale_value_in_printing,StockConfig.is_display_accounting_value_in_printing,
		StockConfig.is_display_ag_price_in_printing
FROM 
	stock_stock_location as Location 
LEFT OUTER JOIN 
	stock_stock_location_line as StockLocationLine ON (StockLocationLine.stock_location = Location.id)
LEFT JOIN 
	base_product AS Product ON (Product.id = StockLocationLine.product)	
LEFT JOIN
	base_product_family AS ProductFamily ON (Product.product_family = ProductFamily.id)
LEFT JOIN
	base_unit AS Unit ON (Unit.id = Product.unit)
LEFT JOIN 
	base_company AS Company ON (Company.id = Location.company)
LEFT OUTER JOIN 
	stock_stock_config AS StockConfig ON (StockConfig.company = Company.id) 
LEFT JOIN 
	base_currency AS Currency ON (Currency.id = Company.currency)
where StockLocationLine.current_qty != 0	and Location.type_select in (1,2) and Location.id in (@INJECTID)
order by Product.code
]]></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>location_id</design:name>
              <design:position>1</design:position>
            </design:identifier>
            <design:nativeDataTypeCode>-5</design:nativeDataTypeCode>
            <design:precision>19</design:precision>
            <design:scale>0</design:scale>
            <design:nullability>NotNullable</design:nullability>
            <design:uiHints>
              <design:displayName>location_id</design:displayName>
            </design:uiHints>
          </design:attributes>
          <design:usageHints>
            <design:label>location_id</design:label>
            <design:formattingHints>
              <design:displaySize>20</design:displaySize>
            </design:formattingHints>
          </design:usageHints>
        </design:resultColumnDefinitions>
        <design:resultColumnDefinitions>
          <design:attributes>
            <design:identifier>
              <design:name>location_line_id</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>NotNullable</design:nullability>
            <design:uiHints>
              <design:displayName>location_line_id</design:displayName>
            </design:uiHints>
          </design:attributes>
          <design:usageHints>
            <design:label>location_line_id</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">
            <property name="type">a4</property>
            <property name="topMargin">0.47625cm</property>
            <property name="leftMargin">0.3958333333333333in</property>
            <property name="rightMargin">0.396875cm</property>
            <property name="showFooterOnLast">true</property>
            <property name="headerHeight">0in</property>
            <property name="footerHeight">0.2in</property>
            <page-footer>
                <grid id="4662">
                    <property name="width">19cm</property>
                    <column id="4674">
                        <property name="suppressDuplicates">false</property>
                        <property name="width">85%</property>
                    </column>
                    <column id="4663"/>
                    <column id="4664"/>
                    <column id="4665"/>
                    <row id="4666">
                        <cell id="4673"/>
                        <cell id="4667">
                            <auto-text id="4668">
                                <property name="type">page-number</property>
                            </auto-text>
                        </cell>
                        <cell id="4669">
                            <text id="4670">
                                <property name="contentType">plain</property>
                                <text-property name="content"><![CDATA[/]]></text-property>
                            </text>
                        </cell>
                        <cell id="4671">
                            <auto-text id="4672">
                                <property name="type">total-page</property>
                            </auto-text>
                        </cell>
                    </row>
                </grid>
            </page-footer>
        </simple-master-page>
    </page-setup>
    <body>
        <grid id="3342">
            <property name="fontSize">8pt</property>
            <property name="marginLeft">0pt</property>
            <property name="height">6.164791666666667cm</property>
            <property name="width">19.341041666666666cm</property>
            <property name="dataSet">StockLocationDS</property>
            <list-property name="boundDataColumns">
                <structure>
                    <property name="name">location_id</property>
                    <text-property name="displayName">location_id</text-property>
                    <expression name="expression" type="javascript">dataSetRow["location_id"]</expression>
                    <property name="dataType">decimal</property>
                </structure>
                <structure>
                    <property name="name">logo_path</property>
                    <text-property name="displayName">logo_path</text-property>
                    <expression name="expression" type="javascript">dataSetRow["logo_path"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">location_name</property>
                    <text-property name="displayName">location_name</text-property>
                    <expression name="expression" type="javascript">dataSetRow["location_name"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">raw_count</property>
                    <text-property name="displayName">raw_count</text-property>
                    <expression name="expression" type="javascript">dataSetRow["raw_count"]</expression>
                    <property name="dataType">integer</property>
                </structure>
                <structure>
                    <property name="name">Locations</property>
                    <text-property name="displayName">Locations</text-property>
                    <expression name="expression" type="javascript">dataSetRow["Locations"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">logo_height</property>
                    <text-property name="displayName">logo_height</text-property>
                    <expression name="expression" type="javascript">if(dataSetRow["logo_height"]>0){dataSetRow["logo_height"]+'px'}else{'60px'}</expression>
                    <property name="dataType">string</property>
                    <property name="allowExport">true</property>
                </structure>
                <structure>
                    <property name="name">logo_width</property>
                    <text-property name="displayName">logo_width</text-property>
                    <expression name="expression" type="javascript">if(dataSetRow["logo_width"]>0){dataSetRow["logo_width"]+'px'}else{'154px'}</expression>
                    <property name="dataType">string</property>
                    <property name="allowExport">true</property>
                </structure>
            </list-property>
            <column id="3343">
                <property name="width">20%</property>
            </column>
            <column id="3347">
                <property name="width">80%</property>
            </column>
            <row id="3349">
                <property name="height">1.2in</property>
                <cell id="3350">
                    <property name="colSpan">1</property>
                    <property name="rowSpan">1</property>
                    <text id="5359">
                        <list-property name="visibility">
                            <structure>
                                <property name="format">all</property>
                                <expression name="valueExpr" type="javascript">row["logo_path"] == null</expression>
                            </structure>
                        </list-property>
                        <structure name="toc"/>
                        <property name="contentType">html</property>
                        <text-property name="content"><![CDATA[<TABLE>
	<TR>
		<VALUE-OF format="HTML">
			"<TD><IMG src='"+params["AttachmentPath"].value+row["logo_path"]+"' alt='' height='"+row["logo_height"]+"' width='"+row["logo_width"]+"'/></TD>"
		</VALUE-OF>
	</TR>
</TABLE>]]></text-property>
                    </text>
                </cell>
                <cell id="4400">
                    <property name="colSpan">1</property>
                    <property name="rowSpan">1</property>
                    <property name="textAlign">center</property>
                    <property name="verticalAlign">top</property>
                    <text id="3804">
                        <property name="fontSize">18pt</property>
                        <property name="fontWeight">bold</property>
                        <property name="marginLeft">0pt</property>
                        <property name="dataSet">TranslateDS</property>
                        <list-property name="paramBindings">
                            <structure>
                                <property name="paramName">param_1</property>
                                <simple-property-list name="expression">
                                    <value type="javascript">if(params["PrintType"].value.equals('1'))
'StockLocation.locationFinancialData'
if(params["PrintType"].value.equals('2'))
'StockLocation.stockLocationContent'</value>
                                </simple-property-list>
                            </structure>
                        </list-property>
                        <list-property name="boundDataColumns">
                            <structure>
                                <property name="name">key</property>
                                <text-property name="displayName">key</text-property>
                                <expression name="expression" type="javascript">dataSetRow["message_key"]</expression>
                                <property name="dataType">string</property>
                            </structure>
                            <structure>
                                <property name="name">translation</property>
                                <text-property name="displayName">translation</text-property>
                                <expression name="expression" type="javascript">dataSetRow["translation"]</expression>
                                <property name="dataType">string</property>
                            </structure>
                        </list-property>
                        <property name="contentType">html</property>
                        <text-property name="content"><![CDATA[<VALUE-OF>row["translation"]</VALUE-OF>]]></text-property>
                    </text>
                </cell>
            </row>
        </grid>
        <grid id="5284">
            <property name="dataSet">StockLocationDS</property>
            <list-property name="boundDataColumns">
                <structure>
                    <property name="name">location_id</property>
                    <text-property name="displayName">location_id</text-property>
                    <expression name="expression" type="javascript">dataSetRow["location_id"]</expression>
                    <property name="dataType">decimal</property>
                </structure>
                <structure>
                    <property name="name">logo_path</property>
                    <text-property name="displayName">logo_path</text-property>
                    <expression name="expression" type="javascript">dataSetRow["logo_path"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">location_name</property>
                    <text-property name="displayName">location_name</text-property>
                    <expression name="expression" type="javascript">dataSetRow["location_name"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">raw_count</property>
                    <text-property name="displayName">raw_count</text-property>
                    <expression name="expression" type="javascript">dataSetRow["raw_count"]</expression>
                    <property name="dataType">integer</property>
                </structure>
                <structure>
                    <property name="name">Locations</property>
                    <text-property name="displayName">Locations</text-property>
                    <expression name="expression" type="javascript">dataSetRow["Locations"]</expression>
                    <property name="dataType">string</property>
                </structure>
            </list-property>
            <column id="5285"/>
            <row id="5287">
                <cell id="5288">
                    <grid id="5290">
                        <property name="dataSet">StockLocationLineDS</property>
                        <list-property name="boundDataColumns">
                            <structure>
                                <property name="name">location_id</property>
                                <text-property name="displayName">location_id</text-property>
                                <expression name="expression" type="javascript">dataSetRow["location_id"]</expression>
                                <property name="dataType">decimal</property>
                            </structure>
                            <structure>
                                <property name="name">location_line_id</property>
                                <text-property name="displayName">location_line_id</text-property>
                                <expression name="expression" type="javascript">dataSetRow["location_line_id"]</expression>
                                <property name="dataType">decimal</property>
                            </structure>
                            <structure>
                                <property name="name">location_name</property>
                                <text-property name="displayName">location_name</text-property>
                                <expression name="expression" type="javascript">dataSetRow["location_name"]</expression>
                                <property name="dataType">string</property>
                            </structure>
                            <structure>
                                <property name="name">product_name</property>
                                <text-property name="displayName">product_name</text-property>
                                <expression name="expression" type="javascript">dataSetRow["product_name"]</expression>
                                <property name="dataType">string</property>
                            </structure>
                            <structure>
                                <property name="name">product_code</property>
                                <text-property name="displayName">product_code</text-property>
                                <expression name="expression" type="javascript">dataSetRow["product_code"]</expression>
                                <property name="dataType">string</property>
                            </structure>
                            <structure>
                                <property name="name">current_qty</property>
                                <text-property name="displayName">current_qty</text-property>
                                <expression name="expression" type="javascript">dataSetRow["current_qty"]</expression>
                                <property name="dataType">decimal</property>
                            </structure>
                            <structure>
                                <property name="name">unit_code</property>
                                <text-property name="displayName">unit_code</text-property>
                                <expression name="expression" type="javascript">dataSetRow["unit_code"]</expression>
                                <property name="dataType">string</property>
                            </structure>
                            <structure>
                                <property name="name">sale_price</property>
                                <text-property name="displayName">sale_price</text-property>
                                <expression name="expression" type="javascript">dataSetRow["sale_price"]</expression>
                                <property name="dataType">decimal</property>
                            </structure>
                            <structure>
                                <property name="name">currency_code</property>
                                <text-property name="displayName">currency_code</text-property>
                                <expression name="expression" type="javascript">dataSetRow["currency_code"]</expression>
                                <property name="dataType">string</property>
                            </structure>
                            <structure>
                                <property name="name">product_family</property>
                                <text-property name="displayName">product_family</text-property>
                                <expression name="expression" type="javascript">dataSetRow["product_family"]</expression>
                                <property name="dataType">string</property>
                            </structure>
                            <structure>
                                <property name="name">cost_price</property>
                                <text-property name="displayName">cost_price</text-property>
                                <expression name="expression" type="javascript">dataSetRow["cost_price"]</expression>
                                <property name="dataType">decimal</property>
                            </structure>
                            <structure>
                                <property name="name">wap</property>
                                <text-property name="displayName">wap</text-property>
                                <expression name="expression" type="javascript">dataSetRow["wap"]</expression>
                                <property name="dataType">decimal</property>
                            </structure>
                            <structure>
                                <property name="name">cost_type_select</property>
                                <text-property name="displayName">cost_type_select</text-property>
                                <expression name="expression" type="javascript">dataSetRow["cost_type_select"]</expression>
                                <property name="dataType">integer</property>
                            </structure>
                            <structure>
                                <property name="name">is_display_sale_value_in_printing</property>
                                <text-property name="displayName">is_display_sale_value_in_printing</text-property>
                                <expression name="expression" type="javascript">dataSetRow["is_display_sale_value_in_printing"]</expression>
                                <property name="dataType">integer</property>
                            </structure>
                            <structure>
                                <property name="name">is_display_accounting_value_in_printing</property>
                                <text-property name="displayName">is_display_accounting_value_in_printing</text-property>
                                <expression name="expression" type="javascript">dataSetRow["is_display_accounting_value_in_printing"]</expression>
                                <property name="dataType">integer</property>
                            </structure>
                            <structure>
                                <property name="name">totalSaleValue</property>
                                <text-property name="displayName">Total Sale Value</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["sale_price"]</expression>
                                    </structure>
                                </list-property>
                                <property name="allowExport">true</property>
                            </structure>
                            <structure>
                                <property name="name">totalSalePrice</property>
                                <text-property name="displayName">Total Sale Value</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["sale_price"] * row["current_qty"]</expression>
                                    </structure>
                                </list-property>
                                <property name="allowExport">true</property>
                            </structure>
                            <structure>
                                <property name="name">totalWapPrice</property>
                                <text-property name="displayName">Total Wap Value</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["wap"] * row["current_qty"]</expression>
                                    </structure>
                                </list-property>
                                <property name="allowExport">true</property>
                            </structure>
                            <structure>
                                <property name="name">totalAccountValue</property>
                                <text-property name="displayName">Total Account Value</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["current_qty"] * row["cost_price"]</expression>
                                    </structure>
                                </list-property>
                                <property name="allowExport">true</property>
                            </structure>
                        </list-property>
                        <column id="5291">
                            <property name="width">50%</property>
                        </column>
                        <column id="5308">
                            <property name="width">50%</property>
                        </column>
                        <row id="5361">
                            <list-property name="visibility">
                                <structure>
                                    <property name="format">all</property>
                                    <expression name="valueExpr" type="javascript">params["PrintType"].value.equals('1')</expression>
                                </structure>
                            </list-property>
                            <cell id="5362">
                                <text id="5364">
                                    <property name="marginTop">0pt</property>
                                    <property name="marginLeft">2pt</property>
                                    <property name="marginRight">0pt</property>
                                    <property name="textAlign">left</property>
                                    <property name="dataSet">TranslateDS</property>
                                    <list-property name="paramBindings">
                                        <structure>
                                            <property name="paramName">param_1</property>
                                            <simple-property-list name="expression">
                                                <value type="javascript">'StockLocation.date'</value>
                                            </simple-property-list>
                                        </structure>
                                    </list-property>
                                    <list-property name="boundDataColumns">
                                        <structure>
                                            <property name="name">key</property>
                                            <text-property name="displayName">key</text-property>
                                            <expression name="expression" type="javascript">dataSetRow["message_key"]</expression>
                                            <property name="dataType">string</property>
                                        </structure>
                                        <structure>
                                            <property name="name">translation</property>
                                            <text-property name="displayName">translation</text-property>
                                            <expression name="expression" type="javascript">dataSetRow["translation"]</expression>
                                            <property name="dataType">string</property>
                                        </structure>
                                    </list-property>
                                    <property name="contentType">html</property>
                                    <text-property name="content"><![CDATA[<B><VALUE-OF>row["translation"]</VALUE-OF></B> : <VALUE-OF format="dd/MM/yyyy kk:mm">new Date()</VALUE-OF> ]]></text-property>
                                </text>
                            </cell>
                            <cell id="5363">
                                <text id="5365">
                                    <property name="marginTop">0pt</property>
                                    <property name="marginLeft">2pt</property>
                                    <property name="marginRight">0pt</property>
                                    <property name="textAlign">left</property>
                                    <property name="dataSet">TranslateDS</property>
                                    <list-property name="paramBindings">
                                        <structure>
                                            <property name="paramName">param_1</property>
                                            <simple-property-list name="expression">
                                                <value type="javascript">if( row._outer["raw_count"] ==  1){
'StockLocation.location'
}else{
'StockLocation.locations'
}</value>
                                            </simple-property-list>
                                        </structure>
                                    </list-property>
                                    <list-property name="boundDataColumns">
                                        <structure>
                                            <property name="name">key</property>
                                            <text-property name="displayName">key</text-property>
                                            <expression name="expression" type="javascript">dataSetRow["message_key"]</expression>
                                            <property name="dataType">string</property>
                                        </structure>
                                        <structure>
                                            <property name="name">translation</property>
                                            <text-property name="displayName">translation</text-property>
                                            <expression name="expression" type="javascript">dataSetRow["translation"]</expression>
                                            <property name="dataType">string</property>
                                        </structure>
                                    </list-property>
                                    <property name="contentType">html</property>
                                    <text-property name="content"><![CDATA[<B><VALUE-OF>row["translation"]</VALUE-OF></B> : <VALUE-OF>row._outer._outer["Locations"]</VALUE-OF>]]></text-property>
                                </text>
                            </cell>
                        </row>
                        <row id="5292">
                            <list-property name="visibility">
                                <structure>
                                    <property name="format">all</property>
                                    <expression name="valueExpr" type="javascript">params["PrintType"].value.equals('2')</expression>
                                </structure>
                            </list-property>
                            <cell id="5293">
                                <text id="5298">
                                    <property name="marginTop">0pt</property>
                                    <property name="marginLeft">2pt</property>
                                    <property name="marginRight">0pt</property>
                                    <property name="textAlign">left</property>
                                    <property name="dataSet">TranslateDS</property>
                                    <list-property name="paramBindings">
                                        <structure>
                                            <property name="paramName">param_1</property>
                                            <simple-property-list name="expression">
                                                <value type="javascript">'StockLocation.date'</value>
                                            </simple-property-list>
                                        </structure>
                                    </list-property>
                                    <list-property name="boundDataColumns">
                                        <structure>
                                            <property name="name">key</property>
                                            <text-property name="displayName">key</text-property>
                                            <expression name="expression" type="javascript">dataSetRow["message_key"]</expression>
                                            <property name="dataType">string</property>
                                        </structure>
                                        <structure>
                                            <property name="name">translation</property>
                                            <text-property name="displayName">translation</text-property>
                                            <expression name="expression" type="javascript">dataSetRow["translation"]</expression>
                                            <property name="dataType">string</property>
                                        </structure>
                                    </list-property>
                                    <property name="contentType">html</property>
                                    <text-property name="content"><![CDATA[<B><VALUE-OF>row["translation"]</VALUE-OF></B> : <VALUE-OF format="dd/MM/yyyy kk:mm">new Date()</VALUE-OF> ]]></text-property>
                                </text>
                            </cell>
                            <cell id="5305">
                                <property name="colSpan">1</property>
                                <property name="rowSpan">3</property>
                                <grid id="5338">
                                    <column id="5339"/>
                                    <row id="5351">
                                        <list-property name="visibility">
                                            <structure>
                                                <property name="format">all</property>
                                                <expression name="valueExpr" type="javascript">!row["is_display_accounting_value_in_printing"]</expression>
                                            </structure>
                                        </list-property>
                                        <cell id="5352">
                                            <text id="5354">
                                                <property name="marginTop">0pt</property>
                                                <property name="marginLeft">2pt</property>
                                                <property name="marginRight">0pt</property>
                                                <property name="textAlign">left</property>
                                                <property name="display">inline</property>
                                                <property name="dataSet">TranslateDS</property>
                                                <list-property name="paramBindings">
                                                    <structure>
                                                        <property name="paramName">param_1</property>
                                                        <simple-property-list name="expression">
                                                            <value type="javascript">'StockLocation.totalAccountingValue'</value>
                                                        </simple-property-list>
                                                    </structure>
                                                </list-property>
                                                <list-property name="boundDataColumns">
                                                    <structure>
                                                        <property name="name">key</property>
                                                        <text-property name="displayName">key</text-property>
                                                        <expression name="expression" type="javascript">dataSetRow["message_key"]</expression>
                                                        <property name="dataType">string</property>
                                                    </structure>
                                                    <structure>
                                                        <property name="name">translation</property>
                                                        <text-property name="displayName">translation</text-property>
                                                        <expression name="expression" type="javascript">dataSetRow["translation"]</expression>
                                                        <property name="dataType">string</property>
                                                    </structure>
                                                </list-property>
                                                <property name="contentType">html</property>
                                                <text-property name="content"><![CDATA[<B><VALUE-OF>row["translation"]</VALUE-OF></B> : ]]></text-property>
                                            </text>
                                            <data id="5355">
                                                <structure name="numberFormat">
                                                    <property name="category">Custom</property>
                                                    <property name="pattern">###,##0.00</property>
                                                </structure>
                                                <property name="display">inline</property>
                                                <property name="resultSetColumn">totalAccountValue</property>
                                            </data>
                                            <text id="5358">
                                                <property name="paddingLeft">2pt</property>
                                                <property name="display">inline</property>
                                                <property name="contentType">html</property>
                                                <text-property name="content"><![CDATA[<VALUE-OF>row["currency_code"]</VALUE-OF>]]></text-property>
                                            </text>
                                        </cell>
                                    </row>
                                    <row id="5340">
                                        <list-property name="visibility">
                                            <structure>
                                                <property name="format">all</property>
                                                <expression name="valueExpr" type="javascript">!row["is_display_sale_value_in_printing"]</expression>
                                            </structure>
                                        </list-property>
                                        <cell id="5341">
                                            <text id="5346">
                                                <property name="color">black</property>
                                                <property name="marginTop">0pt</property>
                                                <property name="marginLeft">2pt</property>
                                                <property name="marginRight">0pt</property>
                                                <property name="textAlign">left</property>
                                                <property name="display">inline</property>
                                                <property name="dataSet">TranslateDS</property>
                                                <list-property name="paramBindings">
                                                    <structure>
                                                        <property name="paramName">param_1</property>
                                                        <simple-property-list name="expression">
                                                            <value type="javascript">'StockLocation.totalSaleValue'</value>
                                                        </simple-property-list>
                                                    </structure>
                                                </list-property>
                                                <list-property name="boundDataColumns">
                                                    <structure>
                                                        <property name="name">key</property>
                                                        <text-property name="displayName">key</text-property>
                                                        <expression name="expression" type="javascript">dataSetRow["message_key"]</expression>
                                                        <property name="dataType">string</property>
                                                    </structure>
                                                    <structure>
                                                        <property name="name">translation</property>
                                                        <text-property name="displayName">translation</text-property>
                                                        <expression name="expression" type="javascript">dataSetRow["translation"]</expression>
                                                        <property name="dataType">string</property>
                                                    </structure>
                                                </list-property>
                                                <property name="contentType">html</property>
                                                <text-property name="content"><![CDATA[<B><VALUE-OF>row["translation"]</VALUE-OF></B> :]]></text-property>
                                            </text>
                                            <data id="5347">
                                                <property name="paddingLeft">2pt</property>
                                                <structure name="numberFormat">
                                                    <property name="category">Custom</property>
                                                    <property name="pattern">###,##0.00</property>
                                                </structure>
                                                <property name="display">inline</property>
                                                <property name="resultSetColumn">totalSalePrice</property>
                                            </data>
                                            <text id="5348">
                                                <property name="paddingLeft">2pt</property>
                                                <property name="display">inline</property>
                                                <property name="contentType">html</property>
                                                <text-property name="content"><![CDATA[<VALUE-OF>row["currency_code"]</VALUE-OF>]]></text-property>
                                            </text>
                                        </cell>
                                    </row>
                                </grid>
                            </cell>
                        </row>
                        <row id="5294">
                            <list-property name="visibility">
                                <structure>
                                    <property name="format">all</property>
                                    <expression name="valueExpr" type="javascript">params["PrintType"].value.equals('2')</expression>
                                </structure>
                            </list-property>
                            <cell id="5295">
                                <text id="5299">
                                    <property name="marginTop">0pt</property>
                                    <property name="marginLeft">2pt</property>
                                    <property name="marginRight">0pt</property>
                                    <property name="textAlign">left</property>
                                    <property name="dataSet">TranslateDS</property>
                                    <list-property name="paramBindings">
                                        <structure>
                                            <property name="paramName">param_1</property>
                                            <simple-property-list name="expression">
                                                <value type="javascript">if( row._outer["raw_count"] ==  1){
'StockLocation.location'
}else{
'StockLocation.locations'
}</value>
                                            </simple-property-list>
                                        </structure>
                                    </list-property>
                                    <list-property name="boundDataColumns">
                                        <structure>
                                            <property name="name">key</property>
                                            <text-property name="displayName">key</text-property>
                                            <expression name="expression" type="javascript">dataSetRow["message_key"]</expression>
                                            <property name="dataType">string</property>
                                        </structure>
                                        <structure>
                                            <property name="name">translation</property>
                                            <text-property name="displayName">translation</text-property>
                                            <expression name="expression" type="javascript">dataSetRow["translation"]</expression>
                                            <property name="dataType">string</property>
                                        </structure>
                                    </list-property>
                                    <property name="contentType">html</property>
                                    <text-property name="content"><![CDATA[<B><VALUE-OF>row["translation"]</VALUE-OF></B> : <VALUE-OF>row._outer._outer["Locations"]</VALUE-OF>]]></text-property>
                                </text>
                            </cell>
                        </row>
                        <row id="5296">
                            <list-property name="visibility">
                                <structure>
                                    <property name="format">all</property>
                                    <expression name="valueExpr" type="javascript">params["PrintType"].value.equals('2')</expression>
                                </structure>
                            </list-property>
                            <cell id="5297">
                                <text id="5300">
                                    <property name="color">black</property>
                                    <property name="marginTop">0pt</property>
                                    <property name="marginLeft">2pt</property>
                                    <property name="marginRight">0pt</property>
                                    <property name="textAlign">left</property>
                                    <property name="display">inline</property>
                                    <property name="dataSet">TranslateDS</property>
                                    <list-property name="paramBindings">
                                        <structure>
                                            <property name="paramName">param_1</property>
                                            <simple-property-list name="expression">
                                                <value type="javascript">'StockLocation.totalWapValue'</value>
                                            </simple-property-list>
                                        </structure>
                                    </list-property>
                                    <list-property name="boundDataColumns">
                                        <structure>
                                            <property name="name">key</property>
                                            <text-property name="displayName">key</text-property>
                                            <expression name="expression" type="javascript">dataSetRow["message_key"]</expression>
                                            <property name="dataType">string</property>
                                        </structure>
                                        <structure>
                                            <property name="name">translation</property>
                                            <text-property name="displayName">translation</text-property>
                                            <expression name="expression" type="javascript">dataSetRow["translation"]</expression>
                                            <property name="dataType">string</property>
                                        </structure>
                                    </list-property>
                                    <property name="contentType">html</property>
                                    <text-property name="content"><![CDATA[<B><VALUE-OF>row["translation"]</VALUE-OF></B> :]]></text-property>
                                </text>
                                <data id="5349">
                                    <property name="marginLeft">2pt</property>
                                    <structure name="numberFormat">
                                        <property name="category">Custom</property>
                                        <property name="pattern">###,##0.00</property>
                                    </structure>
                                    <property name="display">inline</property>
                                    <property name="resultSetColumn">totalWapPrice</property>
                                </data>
                                <text id="5350">
                                    <property name="paddingLeft">2pt</property>
                                    <property name="display">inline</property>
                                    <property name="contentType">html</property>
                                    <text-property name="content"><![CDATA[<VALUE-OF>row["currency_code"]</VALUE-OF>]]></text-property>
                                </text>
                            </cell>
                        </row>
                    </grid>
                </cell>
            </row>
        </grid>
        <table id="4484">
            <property name="color">#FFFFFF</property>
            <property name="width">19.473333333333333cm</property>
            <property name="dataSet">StockLocationLineDS</property>
            <list-property name="boundDataColumns">
                <structure>
                    <property name="name">location_id</property>
                    <text-property name="displayName">location_id</text-property>
                    <expression name="expression" type="javascript">dataSetRow["location_id"]</expression>
                    <property name="dataType">decimal</property>
                </structure>
                <structure>
                    <property name="name">location_line_id</property>
                    <text-property name="displayName">location_line_id</text-property>
                    <expression name="expression" type="javascript">dataSetRow["location_line_id"]</expression>
                    <property name="dataType">decimal</property>
                </structure>
                <structure>
                    <property name="name">location_name</property>
                    <text-property name="displayName">location_name</text-property>
                    <expression name="expression" type="javascript">dataSetRow["location_name"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">product_name</property>
                    <text-property name="displayName">product_name</text-property>
                    <expression name="expression" type="javascript">dataSetRow["product_name"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">product_code</property>
                    <text-property name="displayName">product_code</text-property>
                    <expression name="expression" type="javascript">dataSetRow["product_code"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">current_qty</property>
                    <text-property name="displayName">current_qty</text-property>
                    <expression name="expression" type="javascript">dataSetRow["current_qty"]</expression>
                    <property name="dataType">decimal</property>
                </structure>
                <structure>
                    <property name="name">unit_code</property>
                    <text-property name="displayName">unit_code</text-property>
                    <expression name="expression" type="javascript">dataSetRow["unit_code"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">sale_price</property>
                    <text-property name="displayName">sale_price</text-property>
                    <expression name="expression" type="javascript">dataSetRow["sale_price"]</expression>
                    <property name="dataType">decimal</property>
                </structure>
                <structure>
                    <property name="name">currency_code</property>
                    <text-property name="displayName">currency_code</text-property>
                    <expression name="expression" type="javascript">dataSetRow["currency_code"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">cost_price</property>
                    <text-property name="displayName">cost_price</text-property>
                    <expression name="expression" type="javascript">dataSetRow["cost_price"]</expression>
                    <property name="dataType">decimal</property>
                </structure>
                <structure>
                    <property name="name">wap</property>
                    <text-property name="displayName">wap</text-property>
                    <expression name="expression" type="javascript">dataSetRow["wap"]</expression>
                    <property name="dataType">decimal</property>
                </structure>
                <structure>
                    <property name="name">countLocation</property>
                    <text-property name="displayName">Count Location</text-property>
                    <property name="dataType">integer</property>
                    <property name="aggregateFunction">COUNTDISTINCT</property>
                    <list-property name="arguments">
                        <structure>
                            <property name="name">Expression</property>
                            <expression name="value" type="javascript">row["location_id"]</expression>
                        </structure>
                    </list-property>
                    <property name="allowExport">true</property>
                </structure>
                <structure>
                    <property name="name">LocationTotalSaleValue</property>
                    <text-property name="displayName">Location Sale Value</text-property>
                    <property name="dataType">float</property>
                    <simple-property-list name="aggregateOn">
                        <value>GroupByLocation</value>
                    </simple-property-list>
                    <property name="aggregateFunction">SUM</property>
                    <list-property name="arguments">
                        <structure>
                            <property name="name">Expression</property>
                            <expression name="value" type="javascript">row["current_qty"] * row["sale_price"]</expression>
                        </structure>
                    </list-property>
                    <property name="allowExport">true</property>
                </structure>
                <structure>
                    <property name="name">LocationTotalAccValue</property>
                    <text-property name="displayName">Location Accounting Value</text-property>
                    <property name="dataType">float</property>
                    <simple-property-list name="aggregateOn">
                        <value>GroupByLocation</value>
                    </simple-property-list>
                    <property name="aggregateFunction">SUM</property>
                    <list-property name="arguments">
                        <structure>
                            <property name="name">Expression</property>
                            <expression name="value" type="javascript">row["current_qty"] * row["cost_price"]</expression>
                        </structure>
                    </list-property>
                    <property name="allowExport">true</property>
                </structure>
                <structure>
                    <property name="name">LocationTotalWapValue</property>
                    <text-property name="displayName">Location Wap value</text-property>
                    <property name="dataType">float</property>
                    <simple-property-list name="aggregateOn">
                        <value>GroupByLocation</value>
                    </simple-property-list>
                    <property name="aggregateFunction">SUM</property>
                    <list-property name="arguments">
                        <structure>
                            <property name="name">Expression</property>
                            <expression name="value" type="javascript">row["current_qty"] * row["wap"]</expression>
                        </structure>
                    </list-property>
                    <property name="allowExport">true</property>
                </structure>
                <structure>
                    <property name="name">product_family</property>
                    <text-property name="displayName">product_family</text-property>
                    <expression name="expression" type="javascript">dataSetRow["product_family"]</expression>
                    <property name="dataType">string</property>
                    <property name="allowExport">true</property>
                </structure>
                <structure>
                    <property name="name">LocationTotalSaleValue1</property>
                    <text-property name="displayName">Location Sale Value 1</text-property>
                    <property name="dataType">float</property>
                    <simple-property-list name="aggregateOn">
                        <value>GroupByProductFamily</value>
                    </simple-property-list>
                    <property name="aggregateFunction">SUM</property>
                    <list-property name="arguments">
                        <structure>
                            <property name="name">Expression</property>
                            <expression name="value" type="javascript">row["current_qty"] * row["sale_price"]</expression>
                        </structure>
                    </list-property>
                    <property name="allowExport">true</property>
                </structure>
                <structure>
                    <property name="name">LocationTotalAccValue1</property>
                    <text-property name="displayName">Location Accounting Value 1</text-property>
                    <property name="dataType">float</property>
                    <simple-property-list name="aggregateOn">
                        <value>GroupByProductFamily</value>
                    </simple-property-list>
                    <property name="aggregateFunction">SUM</property>
                    <list-property name="arguments">
                        <structure>
                            <property name="name">Expression</property>
                            <expression name="value" type="javascript">row["current_qty"] * row["cost_price"]</expression>
                        </structure>
                    </list-property>
                    <property name="allowExport">true</property>
                </structure>
                <structure>
                    <property name="name">LocationTotalWapValue1</property>
                    <text-property name="displayName">Location Wap value 1</text-property>
                    <property name="dataType">float</property>
                    <simple-property-list name="aggregateOn">
                        <value>GroupByProductFamily</value>
                    </simple-property-list>
                    <property name="aggregateFunction">SUM</property>
                    <list-property name="arguments">
                        <structure>
                            <property name="name">Expression</property>
                            <expression name="value" type="javascript">row["current_qty"] * row["wap"]</expression>
                        </structure>
                    </list-property>
                    <property name="allowExport">true</property>
                </structure>
                <structure>
                    <property name="name">is_display_sale_value_in_printing</property>
                    <text-property name="displayName">is_display_sale_value_in_printing</text-property>
                    <expression name="expression" type="javascript">dataSetRow["is_display_sale_value_in_printing"]</expression>
                    <property name="dataType">boolean</property>
                    <property name="allowExport">true</property>
                </structure>
                <structure>
                    <property name="name">is_display_accounting_value_in_printing</property>
                    <text-property name="displayName">is_display_accounting_value_in_printing</text-property>
                    <expression name="expression" type="javascript">dataSetRow["is_display_accounting_value_in_printing"]</expression>
                    <property name="dataType">boolean</property>
                    <property name="allowExport">true</property>
                </structure>
                <structure>
                    <property name="name">cost_type_select</property>
                    <text-property name="displayName">cost_type_select</text-property>
                    <expression name="expression" type="javascript">dataSetRow["cost_type_select"]</expression>
                    <property name="dataType">integer</property>
                </structure>
                <structure>
                    <property name="name">is_display_sale_value_in_printing_1</property>
                    <text-property name="displayName">is_display_sale_value_in_printing</text-property>
                    <expression name="expression" type="javascript">dataSetRow["is_display_sale_value_in_printing"]</expression>
                    <property name="dataType">integer</property>
                </structure>
                <structure>
                    <property name="name">is_display_accounting_value_in_printing_1</property>
                    <text-property name="displayName">is_display_accounting_value_in_printing</text-property>
                    <expression name="expression" type="javascript">dataSetRow["is_display_accounting_value_in_printing"]</expression>
                    <property name="dataType">integer</property>
                </structure>
                <structure>
                    <property name="name">is_display_ag_price_in_printing</property>
                    <text-property name="displayName">is_display_ag_price_in_printing</text-property>
                    <expression name="expression" type="javascript">dataSetRow["is_display_ag_price_in_printing"]</expression>
                    <property name="dataType">integer</property>
                </structure>
            </list-property>
            <list-property name="sort">
                <structure>
                    <expression name="key" type="javascript">row["product_code"]</expression>
                    <property name="direction">asc</property>
                    <property name="strength">-1</property>
                </structure>
            </list-property>
            <column id="4503">
                <property name="width">2cm</property>
            </column>
            <column id="4504">
                <property name="width">5cm</property>
            </column>
            <column id="4505">
                <property name="width">1.6404166666666669cm</property>
            </column>
            <column id="4549">
                <property name="width">1.5cm</property>
            </column>
            <column id="4506">
                <list-property name="visibility">
                    <structure>
                        <property name="format">all</property>
                        <expression name="valueExpr" type="javascript">!row["is_display_sale_value_in_printing"] || params["PrintType"].value.equals('2')</expression>
                    </structure>
                </list-property>
                <property name="width">3.1cm</property>
            </column>
            <column id="4557">
                <list-property name="visibility">
                    <structure>
                        <property name="format">all</property>
                        <expression name="valueExpr" type="javascript">!row["is_display_accounting_value_in_printing"] || params["PrintType"].value.equals('2')</expression>
                    </structure>
                </list-property>
                <property name="width">3.1cm</property>
            </column>
            <column id="4639">
                <list-property name="visibility">
                    <structure>
                        <property name="format">all</property>
                        <expression name="valueExpr" type="javascript">!row["is_display_ag_price_in_printing"] || params["PrintType"].value.equals('2')</expression>
                    </structure>
                </list-property>
                <property name="width">3.1cm</property>
            </column>
            <header>
                <row id="4675">
                    <property name="height">0.5cm</property>
                    <cell id="4676"/>
                    <cell id="4677"/>
                    <cell id="4678"/>
                    <cell id="4679"/>
                    <cell id="4680"/>
                    <cell id="4681"/>
                    <cell id="4682"/>
                </row>
                <row id="4603">
                    <list-property name="visibility">
                        <structure>
                            <property name="format">all</property>
                            <expression name="valueExpr" type="javascript">row["countLocation"] == 1</expression>
                        </structure>
                    </list-property>
                    <cell id="4604">
                        <property name="colSpan">6</property>
                        <property name="rowSpan">1</property>
                        <property name="borderBottomColor">#000000</property>
                        <property name="borderBottomStyle">solid</property>
                        <property name="borderBottomWidth">thin</property>
                        <text id="4592">
                            <property name="fontWeight">bold</property>
                            <property name="color">#000000</property>
                            <property name="textAlign">left</property>
                            <property name="dataSet">TranslateDS</property>
                            <list-property name="paramBindings">
                                <structure>
                                    <property name="paramName">param_1</property>
                                    <simple-property-list name="expression">
                                        <value type="javascript">'StockLocation.detailsByStockLocation'</value>
                                    </simple-property-list>
                                </structure>
                            </list-property>
                            <list-property name="boundDataColumns">
                                <structure>
                                    <property name="name">key</property>
                                    <text-property name="displayName">key</text-property>
                                    <expression name="expression" type="javascript">dataSetRow["message_key"]</expression>
                                    <property name="dataType">string</property>
                                </structure>
                                <structure>
                                    <property name="name">translation</property>
                                    <text-property name="displayName">translation</text-property>
                                    <expression name="expression" type="javascript">dataSetRow["translation"]</expression>
                                    <property name="dataType">string</property>
                                </structure>
                            </list-property>
                            <property name="contentType">html</property>
                            <text-property name="content"><![CDATA[<VALUE-OF>row["translation"]</VALUE-OF>]]></text-property>
                        </text>
                    </cell>
                    <cell id="4630">
                        <property name="borderBottomColor">#000000</property>
                        <property name="borderBottomStyle">solid</property>
                        <property name="borderBottomWidth">thin</property>
                    </cell>
                </row>
                <row id="4596">
                    <property name="height">0.5cm</property>
                    <list-property name="visibility">
                        <structure>
                            <property name="format">all</property>
                            <expression name="valueExpr" type="javascript">row["countLocation"] == 1</expression>
                        </structure>
                    </list-property>
                    <cell id="4597"/>
                    <cell id="4598"/>
                    <cell id="4599"/>
                    <cell id="4600"/>
                    <cell id="4601"/>
                    <cell id="4602"/>
                    <cell id="4631"/>
                </row>
            </header>
            <group id="4508">
                <property name="groupName">GroupByLocation</property>
                <expression name="keyExpr" type="javascript">row["location_name"]</expression>
                <structure name="toc">
                    <expression name="expressionValue" type="javascript">row["location_name"]</expression>
                </structure>
                <property name="hideDetail">false</property>
                <header>
                    <row id="4509">
                        <property name="height">0.3020833333333333in</property>
                        <list-property name="visibility">
                            <structure>
                                <property name="format">all</property>
                                <expression name="valueExpr" type="javascript">row["countLocation"] == 1</expression>
                            </structure>
                        </list-property>
                        <cell id="4510">
                            <property name="colSpan">7</property>
                            <property name="rowSpan">1</property>
                            <property name="backgroundColor">#606062</property>
                            <property name="verticalAlign">middle</property>
                            <text id="4528">
                                <property name="fontSize">11pt</property>
                                <property name="fontWeight">bold</property>
                                <property name="textAlign">center</property>
                                <property name="dataSet">TranslateDS</property>
                                <list-property name="paramBindings">
                                    <structure>
                                        <property name="paramName">param_1</property>
                                        <simple-property-list name="expression">
                                            <value type="javascript">'StockLocation.location'</value>
                                        </simple-property-list>
                                    </structure>
                                </list-property>
                                <list-property name="boundDataColumns">
                                    <structure>
                                        <property name="name">key</property>
                                        <text-property name="displayName">key</text-property>
                                        <expression name="expression" type="javascript">dataSetRow["message_key"]</expression>
                                        <property name="dataType">string</property>
                                    </structure>
                                    <structure>
                                        <property name="name">translation</property>
                                        <text-property name="displayName">translation</text-property>
                                        <expression name="expression" type="javascript">dataSetRow["translation"]</expression>
                                        <property name="dataType">string</property>
                                    </structure>
                                </list-property>
                                <property name="contentType">html</property>
                                <text-property name="content"><![CDATA[<VALUE-OF>row["translation"]</VALUE-OF> : <VALUE-OF>row._outer["location_name"]</VALUE-OF>]]></text-property>
                            </text>
                        </cell>
                    </row>
                    <row id="4530">
                        <property name="height">0.2916666666666667in</property>
                        <list-property name="visibility">
                            <structure>
                                <property name="format">all</property>
                                <expression name="valueExpr" type="javascript">row["countLocation"] > 1</expression>
                            </structure>
                        </list-property>
                        <cell id="4531">
                            <property name="colSpan">7</property>
                            <property name="rowSpan">1</property>
                            <property name="backgroundColor">#606062</property>
                            <property name="verticalAlign">middle</property>
                            <text id="4536">
                                <property name="fontSize">11pt</property>
                                <property name="fontWeight">bold</property>
                                <property name="color">#FFFFFF</property>
                                <property name="borderBottomColor">#606062</property>
                                <property name="borderBottomStyle">solid</property>
                                <property name="borderBottomWidth">thin</property>
                                <property name="borderLeftColor">#606062</property>
                                <property name="borderLeftStyle">solid</property>
                                <property name="borderLeftWidth">thin</property>
                                <property name="borderRightColor">#606062</property>
                                <property name="borderRightStyle">solid</property>
                                <property name="borderRightWidth">thin</property>
                                <property name="borderTopColor">#606062</property>
                                <property name="borderTopStyle">solid</property>
                                <property name="borderTopWidth">thin</property>
                                <property name="marginTop">-2pt</property>
                                <property name="textAlign">center</property>
                                <property name="dataSet">TranslateDS</property>
                                <list-property name="paramBindings">
                                    <structure>
                                        <property name="paramName">param_1</property>
                                        <simple-property-list name="expression">
                                            <value type="javascript">'StockLocation.locationTotalContent'</value>
                                        </simple-property-list>
                                    </structure>
                                </list-property>
                                <list-property name="boundDataColumns">
                                    <structure>
                                        <property name="name">key</property>
                                        <text-property name="displayName">key</text-property>
                                        <expression name="expression" type="javascript">dataSetRow["message_key"]</expression>
                                        <property name="dataType">string</property>
                                    </structure>
                                    <structure>
                                        <property name="name">translation</property>
                                        <text-property name="displayName">translation</text-property>
                                        <expression name="expression" type="javascript">dataSetRow["translation"]</expression>
                                        <property name="dataType">string</property>
                                    </structure>
                                </list-property>
                                <property name="contentType">html</property>
                                <text-property name="content"><![CDATA[<VALUE-OF>row["translation"]</VALUE-OF>]]></text-property>
                            </text>
                        </cell>
                    </row>
                    <row id="4522">
                        <property name="verticalAlign">middle</property>
                        <cell id="4523">
                            <property name="backgroundColor">#7F7F7F</property>
                            <property name="borderBottomColor">#606062</property>
                            <property name="borderBottomStyle">solid</property>
                            <property name="borderBottomWidth">thin</property>
                            <property name="borderLeftColor">#606062</property>
                            <property name="borderLeftStyle">solid</property>
                            <property name="borderLeftWidth">thin</property>
                            <property name="borderRightColor">#606062</property>
                            <property name="borderRightStyle">solid</property>
                            <property name="borderRightWidth">thin</property>
                            <property name="borderTopColor">#606062</property>
                            <property name="borderTopStyle">solid</property>
                            <property name="borderTopWidth">thin</property>
                            <text id="4538">
                                <property name="fontSize">10pt</property>
                                <property name="fontWeight">bold</property>
                                <property name="color">#FFFFFF</property>
                                <property name="borderBottomColor">#7F7F7F</property>
                                <property name="borderBottomStyle">solid</property>
                                <property name="borderBottomWidth">thin</property>
                                <property name="borderLeftColor">#7F7F7F</property>
                                <property name="borderLeftStyle">solid</property>
                                <property name="borderLeftWidth">thin</property>
                                <property name="borderRightColor">#7F7F7F</property>
                                <property name="borderRightStyle">solid</property>
                                <property name="borderRightWidth">thin</property>
                                <property name="borderTopColor">#7F7F7F</property>
                                <property name="borderTopStyle">solid</property>
                                <property name="borderTopWidth">thin</property>
                                <property name="marginTop">-2pt</property>
                                <property name="textAlign">center</property>
                                <property name="dataSet">TranslateDS</property>
                                <list-property name="paramBindings">
                                    <structure>
                                        <property name="paramName">param_1</property>
                                        <simple-property-list name="expression">
                                            <value type="javascript">'StockLocation.code'</value>
                                        </simple-property-list>
                                    </structure>
                                </list-property>
                                <list-property name="boundDataColumns">
                                    <structure>
                                        <property name="name">key</property>
                                        <text-property name="displayName">key</text-property>
                                        <expression name="expression" type="javascript">dataSetRow["message_key"]</expression>
                                        <property name="dataType">string</property>
                                    </structure>
                                    <structure>
                                        <property name="name">translation</property>
                                        <text-property name="displayName">translation</text-property>
                                        <expression name="expression" type="javascript">dataSetRow["translation"]</expression>
                                        <property name="dataType">string</property>
                                    </structure>
                                </list-property>
                                <property name="contentType">html</property>
                                <text-property name="content"><![CDATA[<VALUE-OF>row["translation"]</VALUE-OF>]]></text-property>
                            </text>
                        </cell>
                        <cell id="4524">
                            <property name="backgroundColor">#7F7F7F</property>
                            <property name="borderBottomColor">#606062</property>
                            <property name="borderBottomStyle">solid</property>
                            <property name="borderBottomWidth">thin</property>
                            <property name="borderLeftColor">#606062</property>
                            <property name="borderLeftStyle">solid</property>
                            <property name="borderLeftWidth">thin</property>
                            <property name="borderRightColor">#606062</property>
                            <property name="borderRightStyle">solid</property>
                            <property name="borderRightWidth">thin</property>
                            <property name="borderTopColor">#606062</property>
                            <property name="borderTopStyle">solid</property>
                            <property name="borderTopWidth">thin</property>
                            <text id="4539">
                                <property name="fontSize">10pt</property>
                                <property name="fontWeight">bold</property>
                                <property name="color">#FFFFFF</property>
                                <property name="borderBottomColor">#7F7F7F</property>
                                <property name="borderBottomStyle">solid</property>
                                <property name="borderBottomWidth">thin</property>
                                <property name="borderLeftColor">#7F7F7F</property>
                                <property name="borderLeftStyle">solid</property>
                                <property name="borderLeftWidth">thin</property>
                                <property name="borderRightColor">#7F7F7F</property>
                                <property name="borderRightStyle">solid</property>
                                <property name="borderRightWidth">thin</property>
                                <property name="borderTopColor">#7F7F7F</property>
                                <property name="borderTopStyle">solid</property>
                                <property name="borderTopWidth">thin</property>
                                <property name="marginTop">-2pt</property>
                                <property name="textAlign">center</property>
                                <property name="dataSet">TranslateDS</property>
                                <list-property name="paramBindings">
                                    <structure>
                                        <property name="paramName">param_1</property>
                                        <simple-property-list name="expression">
                                            <value type="javascript">'StockLocation.productName'</value>
                                        </simple-property-list>
                                    </structure>
                                </list-property>
                                <list-property name="boundDataColumns">
                                    <structure>
                                        <property name="name">key</property>
                                        <text-property name="displayName">key</text-property>
                                        <expression name="expression" type="javascript">dataSetRow["message_key"]</expression>
                                        <property name="dataType">string</property>
                                    </structure>
                                    <structure>
                                        <property name="name">translation</property>
                                        <text-property name="displayName">translation</text-property>
                                        <expression name="expression" type="javascript">dataSetRow["translation"]</expression>
                                        <property name="dataType">string</property>
                                    </structure>
                                </list-property>
                                <property name="contentType">html</property>
                                <text-property name="content"><![CDATA[<VALUE-OF>row["translation"]</VALUE-OF>]]></text-property>
                            </text>
                        </cell>
                        <cell id="4525">
                            <property name="colSpan">2</property>
                            <property name="rowSpan">1</property>
                            <property name="backgroundColor">#7F7F7F</property>
                            <property name="borderBottomColor">#606062</property>
                            <property name="borderBottomStyle">solid</property>
                            <property name="borderBottomWidth">thin</property>
                            <property name="borderLeftColor">#606062</property>
                            <property name="borderLeftStyle">solid</property>
                            <property name="borderLeftWidth">thin</property>
                            <property name="borderRightColor">#606062</property>
                            <property name="borderRightStyle">solid</property>
                            <property name="borderRightWidth">thin</property>
                            <property name="borderTopColor">#606062</property>
                            <property name="borderTopStyle">solid</property>
                            <property name="borderTopWidth">thin</property>
                            <text id="4540">
                                <property name="fontSize">10pt</property>
                                <property name="fontWeight">bold</property>
                                <property name="color">#FFFFFF</property>
                                <property name="borderBottomColor">#7F7F7F</property>
                                <property name="borderBottomStyle">solid</property>
                                <property name="borderBottomWidth">thin</property>
                                <property name="borderLeftColor">#7F7F7F</property>
                                <property name="borderLeftStyle">solid</property>
                                <property name="borderLeftWidth">thin</property>
                                <property name="borderRightColor">#7F7F7F</property>
                                <property name="borderRightStyle">solid</property>
                                <property name="borderRightWidth">thin</property>
                                <property name="borderTopColor">#7F7F7F</property>
                                <property name="borderTopStyle">solid</property>
                                <property name="borderTopWidth">thin</property>
                                <property name="marginTop">-2pt</property>
                                <property name="textAlign">center</property>
                                <property name="dataSet">TranslateDS</property>
                                <list-property name="paramBindings">
                                    <structure>
                                        <property name="paramName">param_1</property>
                                        <simple-property-list name="expression">
                                            <value type="javascript">'StockLocation.qtyUnit'</value>
                                        </simple-property-list>
                                    </structure>
                                </list-property>
                                <list-property name="boundDataColumns">
                                    <structure>
                                        <property name="name">key</property>
                                        <text-property name="displayName">key</text-property>
                                        <expression name="expression" type="javascript">dataSetRow["message_key"]</expression>
                                        <property name="dataType">string</property>
                                    </structure>
                                    <structure>
                                        <property name="name">translation</property>
                                        <text-property name="displayName">translation</text-property>
                                        <expression name="expression" type="javascript">dataSetRow["translation"]</expression>
                                        <property name="dataType">string</property>
                                    </structure>
                                </list-property>
                                <property name="contentType">html</property>
                                <text-property name="content"><![CDATA[<VALUE-OF>row["translation"]</VALUE-OF>]]></text-property>
                            </text>
                        </cell>
                        <cell id="4526">
                            <property name="backgroundColor">#7F7F7F</property>
                            <property name="borderBottomColor">#606062</property>
                            <property name="borderBottomStyle">solid</property>
                            <property name="borderBottomWidth">thin</property>
                            <property name="borderLeftColor">#606062</property>
                            <property name="borderLeftStyle">solid</property>
                            <property name="borderLeftWidth">thin</property>
                            <property name="borderRightColor">#606062</property>
                            <property name="borderRightStyle">solid</property>
                            <property name="borderRightWidth">thin</property>
                            <property name="borderTopColor">#606062</property>
                            <property name="borderTopStyle">solid</property>
                            <property name="borderTopWidth">thin</property>
                            <text id="4541">
                                <property name="fontSize">10pt</property>
                                <property name="fontWeight">bold</property>
                                <property name="color">#FFFFFF</property>
                                <property name="borderBottomColor">#7F7F7F</property>
                                <property name="borderBottomStyle">solid</property>
                                <property name="borderBottomWidth">thin</property>
                                <property name="borderLeftColor">#7F7F7F</property>
                                <property name="borderLeftStyle">solid</property>
                                <property name="borderLeftWidth">thin</property>
                                <property name="borderRightColor">#7F7F7F</property>
                                <property name="borderRightStyle">solid</property>
                                <property name="borderRightWidth">thin</property>
                                <property name="borderTopColor">#7F7F7F</property>
                                <property name="borderTopStyle">solid</property>
                                <property name="borderTopWidth">thin</property>
                                <property name="marginTop">-2pt</property>
                                <property name="textAlign">center</property>
                                <property name="dataSet">TranslateDS</property>
                                <list-property name="paramBindings">
                                    <structure>
                                        <property name="paramName">param_1</property>
                                        <simple-property-list name="expression">
                                            <value type="javascript">'StockLocation.saleValue'</value>
                                        </simple-property-list>
                                    </structure>
                                </list-property>
                                <list-property name="boundDataColumns">
                                    <structure>
                                        <property name="name">key</property>
                                        <text-property name="displayName">key</text-property>
                                        <expression name="expression" type="javascript">dataSetRow["message_key"]</expression>
                                        <property name="dataType">string</property>
                                    </structure>
                                    <structure>
                                        <property name="name">translation</property>
                                        <text-property name="displayName">translation</text-property>
                                        <expression name="expression" type="javascript">dataSetRow["translation"]</expression>
                                        <property name="dataType">string</property>
                                    </structure>
                                </list-property>
                                <property name="contentType">html</property>
                                <text-property name="content"><![CDATA[<VALUE-OF>row["translation"]</VALUE-OF>]]></text-property>
                            </text>
                        </cell>
                        <cell id="4553">
                            <property name="backgroundColor">#7F7F7F</property>
                            <property name="borderBottomColor">#606062</property>
                            <property name="borderBottomStyle">solid</property>
                            <property name="borderBottomWidth">thin</property>
                            <property name="borderLeftColor">#606062</property>
                            <property name="borderLeftStyle">solid</property>
                            <property name="borderLeftWidth">thin</property>
                            <property name="borderRightColor">#606062</property>
                            <property name="borderRightStyle">solid</property>
                            <property name="borderRightWidth">thin</property>
                            <property name="borderTopColor">#606062</property>
                            <property name="borderTopStyle">solid</property>
                            <property name="borderTopWidth">thin</property>
                            <text id="4558">
                                <property name="fontSize">10pt</property>
                                <property name="fontWeight">bold</property>
                                <property name="color">#FFFFFF</property>
                                <property name="borderBottomColor">#7F7F7F</property>
                                <property name="borderBottomStyle">solid</property>
                                <property name="borderBottomWidth">thin</property>
                                <property name="borderLeftColor">#7F7F7F</property>
                                <property name="borderLeftStyle">solid</property>
                                <property name="borderLeftWidth">thin</property>
                                <property name="borderRightColor">#7F7F7F</property>
                                <property name="borderRightStyle">solid</property>
                                <property name="borderRightWidth">thin</property>
                                <property name="borderTopColor">#7F7F7F</property>
                                <property name="borderTopStyle">solid</property>
                                <property name="borderTopWidth">thin</property>
                                <property name="marginTop">-2pt</property>
                                <property name="textAlign">center</property>
                                <property name="dataSet">TranslateDS</property>
                                <list-property name="paramBindings">
                                    <structure>
                                        <property name="paramName">param_1</property>
                                        <simple-property-list name="expression">
                                            <value type="javascript">'StockLocation.accountingValue'</value>
                                        </simple-property-list>
                                    </structure>
                                </list-property>
                                <list-property name="boundDataColumns">
                                    <structure>
                                        <property name="name">key</property>
                                        <text-property name="displayName">key</text-property>
                                        <expression name="expression" type="javascript">dataSetRow["message_key"]</expression>
                                        <property name="dataType">string</property>
                                    </structure>
                                    <structure>
                                        <property name="name">translation</property>
                                        <text-property name="displayName">translation</text-property>
                                        <expression name="expression" type="javascript">dataSetRow["translation"]</expression>
                                        <property name="dataType">string</property>
                                    </structure>
                                </list-property>
                                <property name="contentType">html</property>
                                <text-property name="content"><![CDATA[<VALUE-OF>row["translation"]</VALUE-OF>]]></text-property>
                            </text>
                        </cell>
                        <cell id="4634">
                            <property name="backgroundColor">#7F7F7F</property>
                            <property name="borderBottomColor">#606062</property>
                            <property name="borderBottomStyle">solid</property>
                            <property name="borderBottomWidth">thin</property>
                            <property name="borderLeftColor">#606062</property>
                            <property name="borderLeftStyle">solid</property>
                            <property name="borderLeftWidth">thin</property>
                            <property name="borderRightColor">#606062</property>
                            <property name="borderRightStyle">solid</property>
                            <property name="borderRightWidth">thin</property>
                            <property name="borderTopColor">#606062</property>
                            <property name="borderTopStyle">solid</property>
                            <property name="borderTopWidth">thin</property>
                            <text id="4640">
                                <property name="fontSize">10pt</property>
                                <property name="fontWeight">bold</property>
                                <property name="color">#FFFFFF</property>
                                <property name="borderBottomColor">#7F7F7F</property>
                                <property name="borderBottomStyle">solid</property>
                                <property name="borderBottomWidth">thin</property>
                                <property name="borderLeftColor">#7F7F7F</property>
                                <property name="borderLeftStyle">solid</property>
                                <property name="borderLeftWidth">thin</property>
                                <property name="borderRightColor">#7F7F7F</property>
                                <property name="borderRightStyle">solid</property>
                                <property name="borderRightWidth">thin</property>
                                <property name="borderTopColor">#7F7F7F</property>
                                <property name="borderTopStyle">solid</property>
                                <property name="borderTopWidth">thin</property>
                                <property name="marginTop">-2pt</property>
                                <property name="textAlign">center</property>
                                <property name="dataSet">TranslateDS</property>
                                <list-property name="paramBindings">
                                    <structure>
                                        <property name="paramName">param_1</property>
                                        <simple-property-list name="expression">
                                            <value type="javascript">'StockLocation.wapValue'</value>
                                        </simple-property-list>
                                    </structure>
                                </list-property>
                                <list-property name="boundDataColumns">
                                    <structure>
                                        <property name="name">key</property>
                                        <text-property name="displayName">key</text-property>
                                        <expression name="expression" type="javascript">dataSetRow["message_key"]</expression>
                                        <property name="dataType">string</property>
                                    </structure>
                                    <structure>
                                        <property name="name">translation</property>
                                        <text-property name="displayName">translation</text-property>
                                        <expression name="expression" type="javascript">dataSetRow["translation"]</expression>
                                        <property name="dataType">string</property>
                                    </structure>
                                </list-property>
                                <property name="contentType">html</property>
                                <text-property name="content"><![CDATA[<VALUE-OF>row["translation"]</VALUE-OF>]]></text-property>
                            </text>
                        </cell>
                    </row>
                </header>
                <footer>
                    <row id="4571">
                        <property name="height">0.6879166666666666cm</property>
                        <list-property name="visibility">
                            <structure>
                                <property name="format">all</property>
                                <expression name="valueExpr" type="javascript">!row["is_display_accounting_value_in_printing"] &amp;&amp; !row["is_display_sale_value_in_printing"] &amp;&amp; !row["is_display_ag_price_in_printing"]</expression>
                            </structure>
                        </list-property>
                        <cell id="4572"/>
                        <cell id="4573"/>
                        <cell id="4574">
                            <property name="colSpan">2</property>
                            <property name="rowSpan">1</property>
                            <property name="backgroundColor">#7F7F7F</property>
                            <property name="textAlign">right</property>
                            <property name="verticalAlign">middle</property>
                            <text id="4570">
                                <property name="fontSize">10pt</property>
                                <property name="fontWeight">bold</property>
                                <property name="color">#FFFFFF</property>
                                <property name="borderBottomColor">#7F7F7F</property>
                                <property name="borderBottomStyle">solid</property>
                                <property name="borderBottomWidth">thin</property>
                                <property name="borderLeftColor">#7F7F7F</property>
                                <property name="borderLeftStyle">solid</property>
                                <property name="borderLeftWidth">thin</property>
                                <property name="borderRightColor">#7F7F7F</property>
                                <property name="borderRightStyle">solid</property>
                                <property name="borderRightWidth">thin</property>
                                <property name="borderTopColor">#7F7F7F</property>
                                <property name="borderTopStyle">solid</property>
                                <property name="borderTopWidth">thin</property>
                                <property name="marginTop">-2pt</property>
                                <property name="textAlign">right</property>
                                <property name="dataSet">TranslateDS</property>
                                <list-property name="paramBindings">
                                    <structure>
                                        <property name="paramName">param_1</property>
                                        <simple-property-list name="expression">
                                            <value type="javascript">'StockLocation.total'</value>
                                        </simple-property-list>
                                    </structure>
                                </list-property>
                                <list-property name="boundDataColumns">
                                    <structure>
                                        <property name="name">key</property>
                                        <text-property name="displayName">key</text-property>
                                        <expression name="expression" type="javascript">dataSetRow["message_key"]</expression>
                                        <property name="dataType">string</property>
                                    </structure>
                                    <structure>
                                        <property name="name">translation</property>
                                        <text-property name="displayName">translation</text-property>
                                        <expression name="expression" type="javascript">dataSetRow["translation"]</expression>
                                        <property name="dataType">string</property>
                                    </structure>
                                </list-property>
                                <property name="contentType">html</property>
                                <text-property name="content"><![CDATA[<VALUE-OF>row["translation"]</VALUE-OF>]]></text-property>
                            </text>
                        </cell>
                        <cell id="4576">
                            <property name="backgroundColor">#7F7F7F</property>
                            <property name="verticalAlign">middle</property>
                            <text id="4594">
                                <property name="fontSize">10pt</property>
                                <property name="fontWeight">bold</property>
                                <property name="color">#FFFFFF</property>
                                <property name="borderBottomColor">#7F7F7F</property>
                                <property name="borderBottomStyle">solid</property>
                                <property name="borderBottomWidth">thin</property>
                                <property name="borderLeftColor">#7F7F7F</property>
                                <property name="borderLeftStyle">solid</property>
                                <property name="borderLeftWidth">thin</property>
                                <property name="borderRightColor">#7F7F7F</property>
                                <property name="borderRightStyle">solid</property>
                                <property name="borderRightWidth">thin</property>
                                <property name="borderTopColor">#7F7F7F</property>
                                <property name="borderTopStyle">solid</property>
                                <property name="borderTopWidth">thin</property>
                                <property name="marginTop">-2pt</property>
                                <property name="textAlign">right</property>
                                <property name="contentType">html</property>
                                <text-property name="content"><![CDATA[<VALUE-OF format="###,##0.00">row["LocationTotalSaleValue"]</VALUE-OF> <VALUE-OF format="^">"  "</VALUE-OF> <VALUE-OF>row["currency_code"]</VALUE-OF>]]></text-property>
                            </text>
                        </cell>
                        <cell id="4577">
                            <property name="backgroundColor">#7F7F7F</property>
                            <property name="verticalAlign">middle</property>
                            <text id="4595">
                                <property name="fontSize">10pt</property>
                                <property name="fontWeight">bold</property>
                                <property name="color">#FFFFFF</property>
                                <property name="borderBottomColor">#7F7F7F</property>
                                <property name="borderBottomStyle">solid</property>
                                <property name="borderBottomWidth">thin</property>
                                <property name="borderLeftColor">#7F7F7F</property>
                                <property name="borderLeftStyle">solid</property>
                                <property name="borderLeftWidth">thin</property>
                                <property name="borderRightColor">#7F7F7F</property>
                                <property name="borderRightStyle">solid</property>
                                <property name="borderRightWidth">thin</property>
                                <property name="borderTopColor">#7F7F7F</property>
                                <property name="borderTopStyle">solid</property>
                                <property name="borderTopWidth">thin</property>
                                <property name="marginTop">-2pt</property>
                                <property name="textAlign">right</property>
                                <property name="contentType">html</property>
                                <text-property name="content"><![CDATA[<VALUE-OF format="###,##0.00">row["LocationTotalAccValue"]</VALUE-OF>  <VALUE-OF format="^">"  "</VALUE-OF> <VALUE-OF>row["currency_code"]</VALUE-OF>]]></text-property>
                            </text>
                        </cell>
                        <cell id="4636">
                            <property name="backgroundColor">#7F7F7F</property>
                            <property name="textAlign">right</property>
                            <property name="verticalAlign">middle</property>
                            <text id="4643">
                                <property name="fontSize">10pt</property>
                                <property name="fontWeight">bold</property>
                                <property name="color">#FFFFFF</property>
                                <property name="borderBottomColor">#7F7F7F</property>
                                <property name="borderBottomStyle">solid</property>
                                <property name="borderBottomWidth">thin</property>
                                <property name="borderLeftColor">#7F7F7F</property>
                                <property name="borderLeftStyle">solid</property>
                                <property name="borderLeftWidth">thin</property>
                                <property name="borderRightColor">#7F7F7F</property>
                                <property name="borderRightStyle">solid</property>
                                <property name="borderRightWidth">thin</property>
                                <property name="borderTopColor">#7F7F7F</property>
                                <property name="borderTopStyle">solid</property>
                                <property name="borderTopWidth">thin</property>
                                <property name="marginTop">-2pt</property>
                                <property name="textAlign">right</property>
                                <property name="contentType">html</property>
                                <text-property name="content"><![CDATA[<VALUE-OF format="###,##0.00">row["LocationTotalWapValue"]</VALUE-OF>  <VALUE-OF format="^">"  "</VALUE-OF> <VALUE-OF>row["currency_code"]</VALUE-OF>]]></text-property>
                            </text>
                        </cell>
                    </row>
                    <row id="4515">
                        <property name="height">0.6145833333333334in</property>
                        <cell id="4516"/>
                        <cell id="4517"/>
                        <cell id="4518"/>
                        <cell id="4547"/>
                        <cell id="4519"/>
                        <cell id="4555"/>
                        <cell id="4637"/>
                    </row>
                </footer>
            </group>
            <group id="5201">
                <property name="groupName">GroupByProductFamily</property>
                <expression name="keyExpr" type="javascript">row["product_family"]</expression>
                <structure name="toc">
                    <expression name="expressionValue" type="javascript">row["product_family"]</expression>
                </structure>
                <property name="hideDetail">false</property>
                <header>
                    <row id="5202">
                        <cell id="5203">
                            <property name="colSpan">2</property>
                            <property name="rowSpan">1</property>
                            <property name="backgroundColor">white</property>
                            <property name="verticalAlign">middle</property>
                            <data id="5218">
                                <property name="fontSize">10pt</property>
                                <property name="fontWeight">bold</property>
                                <property name="color">#000000</property>
                                <property name="resultSetColumn">product_family</property>
                            </data>
                        </cell>
                        <cell id="5205"/>
                        <cell id="5206"/>
                        <cell id="5207"/>
                        <cell id="5208"/>
                        <cell id="5209"/>
                    </row>
                </header>
                <footer>
                    <row id="5210">
                        <cell id="5211"/>
                        <cell id="5212"/>
                        <cell id="5213"/>
                        <cell id="5214"/>
                        <cell id="5215">
                            <property name="backgroundColor">#7F7F7F</property>
                            <text id="5219">
                                <property name="fontSize">10pt</property>
                                <property name="fontWeight">bold</property>
                                <property name="color">#FFFFFF</property>
                                <property name="borderBottomColor">#7F7F7F</property>
                                <property name="borderBottomStyle">solid</property>
                                <property name="borderBottomWidth">thin</property>
                                <property name="borderLeftColor">#7F7F7F</property>
                                <property name="borderLeftStyle">solid</property>
                                <property name="borderLeftWidth">thin</property>
                                <property name="borderRightColor">#7F7F7F</property>
                                <property name="borderRightStyle">solid</property>
                                <property name="borderRightWidth">thin</property>
                                <property name="borderTopColor">#7F7F7F</property>
                                <property name="borderTopStyle">solid</property>
                                <property name="borderTopWidth">thin</property>
                                <property name="marginTop">-2pt</property>
                                <property name="textAlign">right</property>
                                <property name="contentType">html</property>
                                <text-property name="content"><![CDATA[<VALUE-OF format="###,##0.00">row["LocationTotalSaleValue1"]</VALUE-OF> <VALUE-OF format="^">"  "</VALUE-OF> <VALUE-OF>row["currency_code"]</VALUE-OF>]]></text-property>
                            </text>
                        </cell>
                        <cell id="5216">
                            <property name="backgroundColor">#7F7F7F</property>
                            <text id="5221">
                                <property name="fontSize">10pt</property>
                                <property name="fontWeight">bold</property>
                                <property name="color">#FFFFFF</property>
                                <property name="borderBottomColor">#7F7F7F</property>
                                <property name="borderBottomStyle">solid</property>
                                <property name="borderBottomWidth">thin</property>
                                <property name="borderLeftColor">#7F7F7F</property>
                                <property name="borderLeftStyle">solid</property>
                                <property name="borderLeftWidth">thin</property>
                                <property name="borderRightColor">#7F7F7F</property>
                                <property name="borderRightStyle">solid</property>
                                <property name="borderRightWidth">thin</property>
                                <property name="borderTopColor">#7F7F7F</property>
                                <property name="borderTopStyle">solid</property>
                                <property name="borderTopWidth">thin</property>
                                <property name="marginTop">-2pt</property>
                                <property name="textAlign">right</property>
                                <property name="contentType">html</property>
                                <text-property name="content"><![CDATA[<VALUE-OF format="###,##0.00">row["LocationTotalAccValue1"]</VALUE-OF>  <VALUE-OF format="^">"  "</VALUE-OF> <VALUE-OF>row["currency_code"]</VALUE-OF>]]></text-property>
                            </text>
                        </cell>
                        <cell id="5217">
                            <property name="backgroundColor">#7F7F7F</property>
                            <text id="5222">
                                <property name="fontSize">10pt</property>
                                <property name="fontWeight">bold</property>
                                <property name="color">#FFFFFF</property>
                                <property name="borderBottomColor">#7F7F7F</property>
                                <property name="borderBottomStyle">solid</property>
                                <property name="borderBottomWidth">thin</property>
                                <property name="borderLeftColor">#7F7F7F</property>
                                <property name="borderLeftStyle">solid</property>
                                <property name="borderLeftWidth">thin</property>
                                <property name="borderRightColor">#7F7F7F</property>
                                <property name="borderRightStyle">solid</property>
                                <property name="borderRightWidth">thin</property>
                                <property name="borderTopColor">#7F7F7F</property>
                                <property name="borderTopStyle">solid</property>
                                <property name="borderTopWidth">thin</property>
                                <property name="marginTop">-2pt</property>
                                <property name="textAlign">right</property>
                                <property name="contentType">html</property>
                                <text-property name="content"><![CDATA[<VALUE-OF format="###,##0.00">row["LocationTotalWapValue1"]</VALUE-OF>  <VALUE-OF format="^">"  "</VALUE-OF> <VALUE-OF>row["currency_code"]</VALUE-OF>]]></text-property>
                            </text>
                        </cell>
                    </row>
                </footer>
            </group>
            <detail>
                <row id="4491">
                    <property name="height">0.7672916666666666cm</property>
                    <cell id="4492">
                        <property name="borderBottomColor">#606062</property>
                        <property name="borderBottomStyle">solid</property>
                        <property name="borderBottomWidth">thin</property>
                        <property name="borderLeftColor">#606062</property>
                        <property name="borderLeftStyle">solid</property>
                        <property name="borderLeftWidth">thin</property>
                        <property name="borderRightColor">#606062</property>
                        <property name="borderRightStyle">solid</property>
                        <property name="borderRightWidth">thin</property>
                        <property name="borderTopColor">#606062</property>
                        <property name="borderTopStyle">solid</property>
                        <property name="borderTopWidth">thin</property>
                        <property name="verticalAlign">middle</property>
                        <text id="4560">
                            <property name="fontSize">9pt</property>
                            <property name="color">#000000</property>
                            <property name="contentType">html</property>
                            <text-property name="content"><![CDATA[<VALUE-OF>row["product_code"]</VALUE-OF>]]></text-property>
                        </text>
                    </cell>
                    <cell id="4493">
                        <property name="borderBottomColor">#606062</property>
                        <property name="borderBottomStyle">solid</property>
                        <property name="borderBottomWidth">thin</property>
                        <property name="borderLeftColor">#606062</property>
                        <property name="borderLeftStyle">solid</property>
                        <property name="borderLeftWidth">thin</property>
                        <property name="borderRightColor">#606062</property>
                        <property name="borderRightStyle">solid</property>
                        <property name="borderRightWidth">thin</property>
                        <property name="borderTopColor">#606062</property>
                        <property name="borderTopStyle">solid</property>
                        <property name="borderTopWidth">thin</property>
                        <property name="verticalAlign">middle</property>
                        <text id="4496">
                            <property name="fontSize">9pt</property>
                            <property name="color">black</property>
                            <property name="display">block</property>
                            <property name="canShrink">true</property>
                            <property name="dataSet">TranslateDS</property>
                            <list-property name="paramBindings">
                                <structure>
                                    <property name="paramName">param_1</property>
                                    <simple-property-list name="expression">
                                        <value type="javascript">'value:'+row["product_name"]</value>
                                    </simple-property-list>
                                </structure>
                            </list-property>
                            <list-property name="boundDataColumns">
                                <structure>
                                    <property name="name">message_key</property>
                                    <text-property name="displayName">message_key</text-property>
                                    <expression name="expression" type="javascript">dataSetRow["message_key"]</expression>
                                    <property name="dataType">string</property>
                                </structure>
                                <structure>
                                    <property name="name">translation</property>
                                    <text-property name="displayName">translation</text-property>
                                    <expression name="expression" type="javascript">dataSetRow["translation"]</expression>
                                    <property name="dataType">string</property>
                                </structure>
                            </list-property>
                            <structure name="toc"/>
                            <property name="contentType">html</property>
                            <text-property name="content"><![CDATA[<VALUE-OF>if(row["translation"] != null){row["translation"]}else{row._outer["product_name"]}</VALUE-OF>]]></text-property>
                        </text>
                    </cell>
                    <cell id="4494">
                        <property name="borderBottomColor">#606062</property>
                        <property name="borderBottomStyle">solid</property>
                        <property name="borderBottomWidth">thin</property>
                        <property name="borderLeftColor">#606062</property>
                        <property name="borderLeftStyle">solid</property>
                        <property name="borderLeftWidth">thin</property>
                        <property name="borderTopColor">#606062</property>
                        <property name="borderTopStyle">solid</property>
                        <property name="borderTopWidth">thin</property>
                        <property name="verticalAlign">middle</property>
                        <text id="4561">
                            <property name="fontSize">9pt</property>
                            <property name="color">#000000</property>
                            <property name="textAlign">right</property>
                            <property name="contentType">html</property>
                            <text-property name="content"><![CDATA[<VALUE-OF format="###,##0.00">row["current_qty"]</VALUE-OF>]]></text-property>
                        </text>
                    </cell>
                    <cell id="4546">
                        <property name="borderBottomColor">#606062</property>
                        <property name="borderBottomStyle">solid</property>
                        <property name="borderBottomWidth">thin</property>
                        <property name="borderRightColor">#606062</property>
                        <property name="borderRightStyle">solid</property>
                        <property name="borderRightWidth">thin</property>
                        <property name="borderTopColor">#606062</property>
                        <property name="borderTopStyle">solid</property>
                        <property name="borderTopWidth">thin</property>
                        <property name="verticalAlign">middle</property>
                        <text id="4562">
                            <property name="fontSize">9pt</property>
                            <property name="color">#000000</property>
                            <property name="textAlign">left</property>
                            <property name="dataSet">TranslateDS</property>
                            <list-property name="paramBindings">
                                <structure>
                                    <property name="paramName">param_1</property>
                                    <simple-property-list name="expression">
                                        <value type="javascript">row["unit_code"]</value>
                                    </simple-property-list>
                                </structure>
                            </list-property>
                            <list-property name="boundDataColumns">
                                <structure>
                                    <property name="name">message_key</property>
                                    <text-property name="displayName">message_key</text-property>
                                    <expression name="expression" type="javascript">dataSetRow["message_key"]</expression>
                                    <property name="dataType">string</property>
                                </structure>
                                <structure>
                                    <property name="name">translation</property>
                                    <text-property name="displayName">translation</text-property>
                                    <expression name="expression" type="javascript">dataSetRow["translation"]</expression>
                                    <property name="dataType">string</property>
                                </structure>
                            </list-property>
                            <property name="contentType">html</property>
                            <text-property name="content"><![CDATA[<VALUE-OF>if(row["translation"] != null) {row["translation"]} else {row["unit_code"]}</VALUE-OF>]]></text-property>
                        </text>
                    </cell>
                    <cell id="4495">
                        <property name="borderBottomColor">#606062</property>
                        <property name="borderBottomStyle">solid</property>
                        <property name="borderBottomWidth">thin</property>
                        <property name="borderLeftColor">#606062</property>
                        <property name="borderLeftStyle">solid</property>
                        <property name="borderLeftWidth">thin</property>
                        <property name="borderRightColor">#606062</property>
                        <property name="borderRightStyle">solid</property>
                        <property name="borderRightWidth">thin</property>
                        <property name="borderTopColor">#606062</property>
                        <property name="borderTopStyle">solid</property>
                        <property name="borderTopWidth">thin</property>
                        <property name="verticalAlign">middle</property>
                        <text id="4564">
                            <property name="fontSize">9pt</property>
                            <property name="color">#000000</property>
                            <property name="marginTop">1pt</property>
                            <property name="marginRight">2pt</property>
                            <property name="textAlign">right</property>
                            <property name="contentType">html</property>
                            <text-property name="content"><![CDATA[<VALUE-OF format="###,##0.00">row["current_qty"] * row["sale_price"]</VALUE-OF> <VALUE-OF format="^">"  "</VALUE-OF> <VALUE-OF>row["currency_code"]</VALUE-OF>]]></text-property>
                        </text>
                        <text id="4563">
                            <property name="fontSize">7pt</property>
                            <property name="fontStyle">italic</property>
                            <property name="color">#000000</property>
                            <property name="marginRight">2pt</property>
                            <property name="textAlign">right</property>
                            <property name="dataSet">TranslateDS</property>
                            <list-property name="paramBindings">
                                <structure>
                                    <property name="paramName">param_1</property>
                                    <simple-property-list name="expression">
                                        <value type="javascript">'StockLocation.unitValue'</value>
                                    </simple-property-list>
                                </structure>
                            </list-property>
                            <list-property name="boundDataColumns">
                                <structure>
                                    <property name="name">key</property>
                                    <text-property name="displayName">key</text-property>
                                    <expression name="expression" type="javascript">dataSetRow["message_key"]</expression>
                                    <property name="dataType">string</property>
                                </structure>
                                <structure>
                                    <property name="name">translation</property>
                                    <text-property name="displayName">translation</text-property>
                                    <expression name="expression" type="javascript">dataSetRow["translation"]</expression>
                                    <property name="dataType">string</property>
                                </structure>
                            </list-property>
                            <property name="contentType">html</property>
                            <text-property name="content"><![CDATA[<VALUE-OF>row["translation"]</VALUE-OF> : <VALUE-OF format="###,##0.00">row._outer["sale_price"]</VALUE-OF>]]></text-property>
                        </text>
                    </cell>
                    <cell id="4554">
                        <property name="borderBottomColor">#606062</property>
                        <property name="borderBottomStyle">solid</property>
                        <property name="borderBottomWidth">thin</property>
                        <property name="borderLeftColor">#606062</property>
                        <property name="borderLeftStyle">solid</property>
                        <property name="borderLeftWidth">thin</property>
                        <property name="borderRightColor">#606062</property>
                        <property name="borderRightStyle">solid</property>
                        <property name="borderRightWidth">thin</property>
                        <property name="borderTopColor">#606062</property>
                        <property name="borderTopStyle">solid</property>
                        <property name="borderTopWidth">thin</property>
                        <property name="verticalAlign">middle</property>
                        <text id="4566">
                            <property name="fontSize">9pt</property>
                            <property name="color">#000000</property>
                            <property name="marginTop">1pt</property>
                            <property name="marginRight">2pt</property>
                            <property name="textAlign">right</property>
                            <property name="contentType">html</property>
                            <text-property name="content"><![CDATA[<VALUE-OF format="###,##0.00">row["current_qty"] * row["cost_price"]</VALUE-OF> <VALUE-OF format="^">"  "</VALUE-OF> <VALUE-OF>row["currency_code"]</VALUE-OF>]]></text-property>
                        </text>
                        <text id="4565">
                            <property name="fontSize">7pt</property>
                            <property name="fontStyle">italic</property>
                            <property name="color">#000000</property>
                            <property name="marginRight">2pt</property>
                            <property name="textAlign">right</property>
                            <property name="dataSet">TranslateDS</property>
                            <list-property name="paramBindings">
                                <structure>
                                    <property name="paramName">param_1</property>
                                    <simple-property-list name="expression">
                                        <value type="javascript">'StockLocation.unitValue'</value>
                                    </simple-property-list>
                                </structure>
                            </list-property>
                            <list-property name="boundDataColumns">
                                <structure>
                                    <property name="name">key</property>
                                    <text-property name="displayName">key</text-property>
                                    <expression name="expression" type="javascript">dataSetRow["message_key"]</expression>
                                    <property name="dataType">string</property>
                                </structure>
                                <structure>
                                    <property name="name">translation</property>
                                    <text-property name="displayName">translation</text-property>
                                    <expression name="expression" type="javascript">dataSetRow["translation"]</expression>
                                    <property name="dataType">string</property>
                                </structure>
                            </list-property>
                            <property name="contentType">html</property>
                            <text-property name="content"><![CDATA[<VALUE-OF>row["translation"]</VALUE-OF> : <VALUE-OF format="###,##0.00">row._outer["cost_price"]</VALUE-OF>]]></text-property>
                        </text>
                    </cell>
                    <cell id="4635">
                        <property name="borderBottomColor">#606062</property>
                        <property name="borderBottomStyle">solid</property>
                        <property name="borderBottomWidth">thin</property>
                        <property name="borderLeftColor">#606062</property>
                        <property name="borderLeftStyle">solid</property>
                        <property name="borderLeftWidth">thin</property>
                        <property name="borderRightColor">#606062</property>
                        <property name="borderRightStyle">solid</property>
                        <property name="borderRightWidth">thin</property>
                        <property name="borderTopColor">#606062</property>
                        <property name="borderTopStyle">solid</property>
                        <property name="borderTopWidth">thin</property>
                        <property name="verticalAlign">middle</property>
                        <text id="4641">
                            <property name="fontSize">9pt</property>
                            <property name="color">#000000</property>
                            <property name="marginTop">1pt</property>
                            <property name="marginRight">2pt</property>
                            <property name="textAlign">right</property>
                            <property name="contentType">html</property>
                            <text-property name="content"><![CDATA[<VALUE-OF format="###,##0.00">row["current_qty"] * row["wap"]</VALUE-OF> <VALUE-OF format="^">"  "</VALUE-OF> <VALUE-OF>row["currency_code"]</VALUE-OF>]]></text-property>
                        </text>
                        <text id="4642">
                            <property name="fontSize">7pt</property>
                            <property name="fontStyle">italic</property>
                            <property name="color">#000000</property>
                            <property name="marginRight">2pt</property>
                            <property name="textAlign">right</property>
                            <property name="dataSet">TranslateDS</property>
                            <list-property name="paramBindings">
                                <structure>
                                    <property name="paramName">param_1</property>
                                    <simple-property-list name="expression">
                                        <value type="javascript">'StockLocation.unitValue'</value>
                                    </simple-property-list>
                                </structure>
                            </list-property>
                            <list-property name="boundDataColumns">
                                <structure>
                                    <property name="name">key</property>
                                    <text-property name="displayName">key</text-property>
                                    <expression name="expression" type="javascript">dataSetRow["message_key"]</expression>
                                    <property name="dataType">string</property>
                                </structure>
                                <structure>
                                    <property name="name">translation</property>
                                    <text-property name="displayName">translation</text-property>
                                    <expression name="expression" type="javascript">dataSetRow["translation"]</expression>
                                    <property name="dataType">string</property>
                                </structure>
                            </list-property>
                            <property name="contentType">html</property>
                            <text-property name="content"><![CDATA[<VALUE-OF>row["translation"]</VALUE-OF> : <VALUE-OF format="###,##0.00">row._outer["wap"]</VALUE-OF>]]></text-property>
                        </text>
                    </cell>
                </row>
            </detail>
            <footer>
                <row id="4497">
                    <cell id="4498"/>
                    <cell id="4499"/>
                    <cell id="4500"/>
                    <cell id="4548"/>
                    <cell id="4501"/>
                    <cell id="4556"/>
                    <cell id="4638"/>
                </row>
            </footer>
        </table>
    </body>
</report>
