<?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.4.2.v201410272105 Build &lt;4.4.2.v20150217-1805></property>
    <list-property name="propertyBindings">
        <structure>
            <property name="name">odaDriverClass</property>
            <property name="id">7</property>
            <expression name="value" type="javascript">params["DefaultDriver"].value</expression>
        </structure>
        <structure>
            <property name="name">odaURL</property>
            <property name="id">7</property>
            <expression name="value" type="javascript">params["DBName"].value</expression>
        </structure>
        <structure>
            <property name="name">odaUser</property>
            <property name="id">7</property>
            <expression name="value" type="javascript">params["UserName"].value</expression>
        </structure>
        <structure>
            <property name="name">odaPassword</property>
            <property name="id">7</property>
            <expression name="value" type="javascript">params["Password"].value</expression>
        </structure>
    </list-property>
    <property name="units">in</property>
    <property name="iconFile">/templates/blank_report.gif</property>
    <property name="bidiLayoutOrientation">ltr</property>
    <property name="imageDPI">96</property>
    <parameters>
        <scalar-parameter name="CertificateId" id="9">
            <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="EbicsUserId" id="153">
            <property name="valueType">static</property>
            <property name="isRequired">true</property>
            <property name="dataType">decimal</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="DBName" id="3673">
            <property name="hidden">true</property>
            <property name="valueType">static</property>
            <property name="dataType">string</property>
            <property name="distinct">true</property>
            <simple-property-list name="defaultValue">
                <value type="constant">jdbc:postgresql://localhost:5432/</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="UserName" id="3674">
            <property name="hidden">true</property>
            <property name="valueType">static</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="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="DefaultDriver" id="4003">
            <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>
    </parameters>
    <data-sources>
        <oda-data-source extensionID="org.eclipse.birt.report.data.oda.jdbc" name="Data Source" id="7">
            <list-property name="privateDriverProperties">
                <ex-property>
                    <name>metadataBidiFormatStr</name>
                    <value>ILYNN</value>
                </ex-property>
                <ex-property>
                    <name>disabledMetadataBidiFormatStr</name>
                </ex-property>
                <ex-property>
                    <name>contentBidiFormatStr</name>
                    <value>ILYNN</value>
                </ex-property>
                <ex-property>
                    <name>disabledContentBidiFormatStr</name>
                </ex-property>
            </list-property>
            <property name="odaDriverClass">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="EbicsCertificate" id="31">
            <list-property name="columnHints"/>
            <list-property name="filter">
                <structure>
                    <property name="operator">in</property>
                    <expression name="expr" type="javascript">row["certId"]</expression>
                    <simple-property-list name="value1">
                        <value>params["CertificateId"].value.split(',')</value>
                    </simple-property-list>
                </structure>
            </list-property>
            <list-property name="parameters">
                <structure>
                    <property name="name">param_1</property>
                    <property name="paramName">EbicsUserId</property>
                    <property name="nativeName"></property>
                    <property name="dataType">decimal</property>
                    <property name="nativeDataType">-5</property>
                    <property name="position">1</property>
                    <property name="isOptional">false</property>
                    <property name="isInput">true</property>
                    <property name="isOutput">false</property>
                </structure>
            </list-property>
            <structure name="cachedMetaData"/>
            <property name="dataSource">Data Source</property>
            <list-property name="resultSet"/>
            <xml-property name="queryText"><![CDATA[select
certificate.id as "certId",
case when certificate.type_select = 'signature' then 'EbicsCertificateReport.signatureTitle'
      when certificate.type_select = 'authentication' then 'EbicsCertificateReport.authenticationTitle'
      when certificate.type_select = 'encryption' then 'EbicsCertificateReport.encryptionTitle'
 end as title,
 case when certificate.type_select = 'signature' then 'EbicsCertificateReport.signature'
      when certificate.type_select = 'authentication' then 'EbicsCertificateReport.authentication'
      when certificate.type_select = 'encryption' then 'EbicsCertificateReport.encryption'
 end as certificate_title,
 case when certificate.type_select = 'signature' then 'A005'
      when certificate.type_select = 'authentication' then 'X002'
      when certificate.type_select = 'encryption' then 'E002'
 end as certificate_type,
 case when certificate.type_select = 'signature' then 'EbicsCertificateReport.signatureHash'
      when certificate.type_select = 'authentication' then 'EbicsCertificateReport.authenticationHash'
      when certificate.type_select = 'encryption' then 'EbicsCertificateReport.encryptionHash'
 end as certificate_hash,
 bank.host_id,
 bank.name as "bank_name",
 language.code as "bank_language",
 ebics_user.user_id,
 partner.partner_id,
 case when certificate.type_select = 'signature' then 'EbicsCertificateReport.signatureVersion'
      when certificate.type_select = 'authentication' then 'EbicsCertificateReport.authenticationVersion'
      when certificate.type_select = 'encryption' then 'EbicsCertificateReport.encryptionVersion'
 end as version,
 certificate.pem_string,
 certificate.sha2has,
 certificate.issuer,
 certificate.subject,
 certificate.private_key,
 certificate.init_letter_edition_date        
from bankpayment_ebics_certificate certificate
left join bankpayment_ebics_user ebics_user on (ebics_user.id = ?)
left join bankpayment_ebics_partner partner on (partner.id = ebics_user.ebics_partner)
left join bankpayment_ebics_bank bank on (bank.id = partner.ebics_bank)
left join base_language language on (language.id = bank.language)
order by certificate.type_select desc;]]></xml-property>
            <xml-property name="designerValues"><![CDATA[<?xml version="1.0" encoding="UTF-8"?>
<model:DesignValues xmlns:design="http://www.eclipse.org/datatools/connectivity/oda/design" xmlns:model="http://www.eclipse.org/birt/report/model/adapter/odaModel">
  <Version>2.0</Version>
  <DataSetParameters>
    <parameter>
      <design:ParameterDefinition>
        <design:inOutMode>In</design:inOutMode>
        <design:attributes>
          <design:identifier>
            <design:name></design:name>
            <design:position>1</design:position>
          </design:identifier>
          <design:nativeDataTypeCode>-5</design:nativeDataTypeCode>
          <design:precision>0</design:precision>
          <design:scale>0</design:scale>
          <design:nullability>Unknown</design:nullability>
        </design:attributes>
        <design:inputAttributes>
          <design:elementAttributes/>
        </design:inputAttributes>
      </design:ParameterDefinition>
    </parameter>
  </DataSetParameters>
</model:DesignValues>]]></xml-property>
        </oda-data-set>
        <oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" name="Translation" id="34">
            <list-property name="columnHints">
                <structure>
                    <property name="columnName">message_value</property>
                    <property name="analysis">dimension</property>
                    <text-property name="displayName">message_value</text-property>
                    <text-property name="heading">message_value</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="isInput">true</property>
                </structure>
                <structure>
                    <property name="name">param_2</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>
                </structure>
            </list-property>
            <structure name="cachedMetaData">
                <list-property name="resultSet">
                    <structure>
                        <property name="position">1</property>
                        <property name="name">message_value</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">message_value</property>
                    <property name="nativeName">message_value</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
            </list-property>
            <xml-property name="queryText"><![CDATA[select
	message_value 
from meta_translation 
where message_key = ? and 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>
  <design:ResultSets derivedMetaData="true">
    <design:resultSetDefinitions>
      <design:resultSetColumns>
        <design:resultColumnDefinitions>
          <design:attributes>
            <design:identifier>
              <design:name>message_value</design:name>
              <design:position>1</design:position>
            </design:identifier>
            <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
            <design:precision>2147483647</design:precision>
            <design:scale>0</design:scale>
            <design:nullability>Nullable</design:nullability>
            <design:uiHints>
              <design:displayName>message_value</design:displayName>
            </design:uiHints>
          </design:attributes>
          <design:usageHints>
            <design:label>message_value</design:label>
            <design:formattingHints>
              <design:displaySize>2147483647</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" 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-cell" 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="headerHeight">0.5in</property>
            <property name="footerHeight">0.5in</property>
        </simple-master-page>
    </page-setup>
    <body>
        <table id="145">
            <property name="dataSet">EbicsCertificate</property>
            <list-property name="boundDataColumns">
                <structure>
                    <property name="name">certId</property>
                    <text-property name="displayName">certId</text-property>
                    <expression name="expression" type="javascript">dataSetRow["certId"]</expression>
                    <property name="dataType">decimal</property>
                </structure>
                <structure>
                    <property name="name">title</property>
                    <text-property name="displayName">title</text-property>
                    <expression name="expression" type="javascript">dataSetRow["title"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">certificate_title</property>
                    <text-property name="displayName">certificate_title</text-property>
                    <expression name="expression" type="javascript">dataSetRow["certificate_title"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">certificate_type</property>
                    <text-property name="displayName">certificate_type</text-property>
                    <expression name="expression" type="javascript">dataSetRow["certificate_type"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">certificate_hash</property>
                    <text-property name="displayName">certificate_hash</text-property>
                    <expression name="expression" type="javascript">dataSetRow["certificate_hash"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">host_id</property>
                    <text-property name="displayName">host_id</text-property>
                    <expression name="expression" type="javascript">dataSetRow["host_id"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">bank_name</property>
                    <text-property name="displayName">bank_name</text-property>
                    <expression name="expression" type="javascript">dataSetRow["bank_name"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">bank_language</property>
                    <text-property name="displayName">bank_language</text-property>
                    <expression name="expression" type="javascript">dataSetRow["bank_language"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">user_id</property>
                    <text-property name="displayName">user_id</text-property>
                    <expression name="expression" type="javascript">dataSetRow["user_id"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">partner_id</property>
                    <text-property name="displayName">partner_id</text-property>
                    <expression name="expression" type="javascript">dataSetRow["partner_id"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">version</property>
                    <text-property name="displayName">version</text-property>
                    <expression name="expression" type="javascript">dataSetRow["version"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">pem_string</property>
                    <text-property name="displayName">pem_string</text-property>
                    <expression name="expression" type="javascript">dataSetRow["pem_string"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">sha2has</property>
                    <text-property name="displayName">sha2has</text-property>
                    <expression name="expression" type="javascript">dataSetRow["sha2has"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">issuer</property>
                    <text-property name="displayName">issuer</text-property>
                    <expression name="expression" type="javascript">dataSetRow["issuer"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">subject</property>
                    <text-property name="displayName">subject</text-property>
                    <expression name="expression" type="javascript">dataSetRow["subject"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">init_letter_edition_date</property>
                    <text-property name="displayName">init_letter_edition_date</text-property>
                    <expression name="expression" type="javascript">dataSetRow["init_letter_edition_date"]</expression>
                    <property name="dataType">date-time</property>
                </structure>
                <structure>
                    <property name="name">private_key</property>
                    <text-property name="displayName">private_key</text-property>
                    <expression name="expression" type="javascript">dataSetRow["private_key"]</expression>
                    <property name="dataType">decimal</property>
                </structure>
            </list-property>
            <column id="152"/>
            <detail>
                <row id="148">
                    <property name="height">100%</property>
                    <cell id="149">
                        <grid id="18">
                            <property name="pageBreakBefore">auto</property>
                            <property name="canShrink">true</property>
                            <property name="overflow">visible</property>
                            <property name="height">9.958333333333334in</property>
                            <property name="width">7.677083333333333in</property>
                            <structure name="toc"/>
                            <column id="19">
                                <property name="width">1.3333333333333333in</property>
                            </column>
                            <column id="114">
                                <property name="width">4.25in</property>
                            </column>
                            <column id="20">
                                <property name="width">2.09375in</property>
                            </column>
                            <row id="21">
                                <cell id="22"/>
                                <cell id="100"/>
                                <cell id="23"/>
                            </row>
                            <row id="24">
                                <property name="height">0.3645833333333333in</property>
                                <cell id="25">
                                    <property name="colSpan">3</property>
                                    <property name="rowSpan">1</property>
                                    <text id="33">
                                        <property name="fontSize">16pt</property>
                                        <property name="fontWeight">bold</property>
                                        <property name="textAlign">left</property>
                                        <property name="dataSet">Translation</property>
                                        <list-property name="paramBindings">
                                            <structure>
                                                <property name="paramName">param_1</property>
                                                <simple-property-list name="expression">
                                                    <value type="javascript">row["title"]</value>
                                                </simple-property-list>
                                            </structure>
                                            <structure>
                                                <property name="paramName">param_2</property>
                                                <simple-property-list name="expression">
                                                    <value type="javascript">row["bank_language"]</value>
                                                </simple-property-list>
                                            </structure>
                                        </list-property>
                                        <list-property name="boundDataColumns">
                                            <structure>
                                                <property name="name">message_value</property>
                                                <text-property name="displayName">message_value</text-property>
                                                <expression name="expression" type="javascript">dataSetRow["message_value"]</expression>
                                                <property name="dataType">string</property>
                                            </structure>
                                        </list-property>
                                        <property name="contentType">html</property>
                                        <text-property name="content"><![CDATA[<VALUE-OF>row["message_value"] == null ?  row._outer["title"]  :  row["message_value"]</VALUE-OF>]]></text-property>
                                    </text>
                                </cell>
                            </row>
                            <row id="36">
                                <property name="height">0.16666666666666666in</property>
                                <cell id="37"/>
                                <cell id="102"/>
                                <cell id="38"/>
                            </row>
                            <row id="27">
                                <property name="height">0.375in</property>
                                <cell id="28">
                                    <label id="35">
                                        <property name="fontSize">12pt</property>
                                        <property name="fontWeight">bold</property>
                                        <text-property name="text">Date :</text-property>
                                    </label>
                                </cell>
                                <cell id="103">
                                    <property name="colSpan">2</property>
                                    <property name="rowSpan">1</property>
                                    <text id="140">
                                        <property name="fontSize">12pt</property>
                                        <property name="contentType">html</property>
                                        <text-property name="content"><![CDATA[<VALUE-OF format="dd.MM.yyyy">row["init_letter_edition_date"]</VALUE-OF>]]></text-property>
                                    </text>
                                </cell>
                            </row>
                            <row id="39">
                                <property name="height">0.375in</property>
                                <cell id="40">
                                    <label id="54">
                                        <property name="fontSize">12pt</property>
                                        <property name="fontWeight">bold</property>
                                        <text-property name="text">Time :</text-property>
                                    </label>
                                </cell>
                                <cell id="104">
                                    <property name="colSpan">2</property>
                                    <property name="rowSpan">1</property>
                                    <text id="141">
                                        <property name="fontSize">12pt</property>
                                        <property name="contentType">html</property>
                                        <text-property name="content"><![CDATA[<VALUE-OF format="HH:mm:ss">row["init_letter_edition_date"]</VALUE-OF>]]></text-property>
                                    </text>
                                </cell>
                            </row>
                            <row id="42">
                                <property name="height">0.375in</property>
                                <cell id="43">
                                    <label id="55">
                                        <property name="fontSize">12pt</property>
                                        <property name="fontWeight">bold</property>
                                        <text-property name="text">Host Id :</text-property>
                                    </label>
                                </cell>
                                <cell id="105">
                                    <property name="colSpan">2</property>
                                    <property name="rowSpan">1</property>
                                    <data id="63">
                                        <property name="fontSize">12pt</property>
                                        <property name="resultSetColumn">host_id</property>
                                    </data>
                                </cell>
                            </row>
                            <row id="59">
                                <property name="height">0.375in</property>
                                <cell id="60">
                                    <text id="62">
                                        <property name="fontSize">12pt</property>
                                        <property name="fontWeight">bold</property>
                                        <property name="dataSet">Translation</property>
                                        <list-property name="paramBindings">
                                            <structure>
                                                <property name="paramName">param_1</property>
                                                <simple-property-list name="expression">
                                                    <value type="javascript">'EbicsCertificateReport.bank'</value>
                                                </simple-property-list>
                                            </structure>
                                            <structure>
                                                <property name="paramName">param_2</property>
                                                <simple-property-list name="expression">
                                                    <value type="javascript">row["bank_language"]</value>
                                                </simple-property-list>
                                            </structure>
                                        </list-property>
                                        <list-property name="boundDataColumns">
                                            <structure>
                                                <property name="name">message_value</property>
                                                <text-property name="displayName">message_value</text-property>
                                                <expression name="expression" type="javascript">dataSetRow["message_value"]</expression>
                                                <property name="dataType">string</property>
                                            </structure>
                                        </list-property>
                                        <property name="contentType">html</property>
                                        <text-property name="content"><![CDATA[<VALUE-OF>row["message_value"]</VALUE-OF> :]]></text-property>
                                    </text>
                                </cell>
                                <cell id="106">
                                    <property name="colSpan">2</property>
                                    <property name="rowSpan">1</property>
                                    <data id="64">
                                        <property name="fontSize">12pt</property>
                                        <property name="resultSetColumn">bank_name</property>
                                    </data>
                                </cell>
                            </row>
                            <row id="45">
                                <property name="height">0.375in</property>
                                <cell id="46">
                                    <label id="56">
                                        <property name="fontSize">12pt</property>
                                        <property name="fontWeight">bold</property>
                                        <text-property name="text">User-ID :</text-property>
                                    </label>
                                </cell>
                                <cell id="107">
                                    <property name="colSpan">2</property>
                                    <property name="rowSpan">1</property>
                                    <data id="65">
                                        <property name="fontSize">12pt</property>
                                        <property name="resultSetColumn">user_id</property>
                                    </data>
                                </cell>
                            </row>
                            <row id="48">
                                <property name="height">0.375in</property>
                                <cell id="49">
                                    <label id="57">
                                        <property name="fontSize">12pt</property>
                                        <property name="fontWeight">bold</property>
                                        <text-property name="text">Partner-ID :</text-property>
                                    </label>
                                </cell>
                                <cell id="108">
                                    <property name="colSpan">2</property>
                                    <property name="rowSpan">1</property>
                                    <data id="66">
                                        <property name="fontSize">12pt</property>
                                        <property name="resultSetColumn">partner_id</property>
                                    </data>
                                </cell>
                            </row>
                            <row id="51">
                                <property name="height">0.375in</property>
                                <cell id="52">
                                    <label id="58">
                                        <property name="fontSize">12pt</property>
                                        <property name="fontWeight">bold</property>
                                        <text-property name="text">Version :</text-property>
                                    </label>
                                </cell>
                                <cell id="109">
                                    <property name="colSpan">2</property>
                                    <property name="rowSpan">1</property>
                                    <text id="154">
                                        <property name="fontSize">12pt</property>
                                        <property name="dataSet">Translation</property>
                                        <list-property name="paramBindings">
                                            <structure>
                                                <property name="paramName">param_2</property>
                                                <simple-property-list name="expression">
                                                    <value type="javascript">row["bank_language"]</value>
                                                </simple-property-list>
                                            </structure>
                                            <structure>
                                                <property name="paramName">param_1</property>
                                                <simple-property-list name="expression">
                                                    <value type="javascript">row["version"]</value>
                                                </simple-property-list>
                                            </structure>
                                        </list-property>
                                        <list-property name="boundDataColumns">
                                            <structure>
                                                <property name="name">message_value</property>
                                                <text-property name="displayName">message_value</text-property>
                                                <expression name="expression" type="javascript">dataSetRow["message_value"]</expression>
                                                <property name="dataType">string</property>
                                            </structure>
                                        </list-property>
                                        <property name="contentType">html</property>
                                        <text-property name="content"><![CDATA[<VALUE-OF>row["message_value"]</VALUE-OF>]]></text-property>
                                    </text>
                                </cell>
                            </row>
                            <row id="68">
                                <property name="height">0.19791666666666666in</property>
                                <cell id="69"/>
                                <cell id="110"/>
                                <cell id="70"/>
                            </row>
                            <row id="71">
                                <property name="height">6in</property>
                                <cell id="72">
                                    <property name="colSpan">3</property>
                                    <property name="rowSpan">1</property>
                                    <property name="borderBottomStyle">solid</property>
                                    <property name="borderBottomWidth">thin</property>
                                    <property name="borderLeftStyle">solid</property>
                                    <property name="borderLeftWidth">thin</property>
                                    <property name="borderRightStyle">solid</property>
                                    <property name="borderRightWidth">thin</property>
                                    <property name="borderTopStyle">solid</property>
                                    <property name="borderTopWidth">thin</property>
                                    <grid id="115">
                                        <property name="overflow">visible</property>
                                        <property name="height">6.927083333333333in</property>
                                        <column id="116"/>
                                        <row id="117">
                                            <property name="height">0.3333333333333333in</property>
                                            <cell id="118">
                                                <text id="123">
                                                    <property name="fontSize">14pt</property>
                                                    <property name="fontWeight">bold</property>
                                                    <property name="dataSet">Translation</property>
                                                    <list-property name="paramBindings">
                                                        <structure>
                                                            <property name="paramName">param_1</property>
                                                            <simple-property-list name="expression">
                                                                <value type="javascript">row["certificate_title"]</value>
                                                            </simple-property-list>
                                                        </structure>
                                                        <structure>
                                                            <property name="paramName">param_2</property>
                                                            <simple-property-list name="expression">
                                                                <value type="javascript">row["bank_language"]</value>
                                                            </simple-property-list>
                                                        </structure>
                                                    </list-property>
                                                    <list-property name="boundDataColumns">
                                                        <structure>
                                                            <property name="name">message_value</property>
                                                            <text-property name="displayName">message_value</text-property>
                                                            <expression name="expression" type="javascript">dataSetRow["message_value"]</expression>
                                                            <property name="dataType">string</property>
                                                        </structure>
                                                    </list-property>
                                                    <property name="contentType">html</property>
                                                    <text-property name="content"><![CDATA[<VALUE-OF>row["message_value"] == null ? row._outer["certificate_title"]  : row["message_value"]</VALUE-OF>]]></text-property>
                                                </text>
                                            </cell>
                                        </row>
                                        <row id="119">
                                            <property name="height">0.3333333333333333in</property>
                                            <cell id="120">
                                                <text id="124">
                                                    <property name="fontSize">14pt</property>
                                                    <property name="fontWeight">bold</property>
                                                    <property name="contentType">html</property>
                                                    <text-property name="content"><![CDATA[Type : <VALUE-OF>row["certificate_type"]</VALUE-OF>]]></text-property>
                                                </text>
                                            </cell>
                                        </row>
                                        <row id="121">
                                            <property name="height">0.3541666666666667in</property>
                                            <cell id="122">
                                                <text id="125">
                                                    <property name="fontSize">12pt</property>
                                                    <property name="dataSet">Translation</property>
                                                    <list-property name="visibility">
                                                        <structure>
                                                            <property name="format">all</property>
                                                            <expression name="valueExpr" type="javascript">row._outer["private_key"] != null</expression>
                                                        </structure>
                                                    </list-property>
                                                    <list-property name="paramBindings">
                                                        <structure>
                                                            <property name="paramName">param_1</property>
                                                            <simple-property-list name="expression">
                                                                <value type="javascript">'EbicsCertificateReport.issuedTo'</value>
                                                            </simple-property-list>
                                                        </structure>
                                                        <structure>
                                                            <property name="paramName">param_2</property>
                                                            <simple-property-list name="expression">
                                                                <value type="javascript">row["bank_language"]</value>
                                                            </simple-property-list>
                                                        </structure>
                                                    </list-property>
                                                    <list-property name="boundDataColumns">
                                                        <structure>
                                                            <property name="name">message_value</property>
                                                            <text-property name="displayName">message_value</text-property>
                                                            <expression name="expression" type="javascript">dataSetRow["message_value"]</expression>
                                                            <property name="dataType">string</property>
                                                        </structure>
                                                    </list-property>
                                                    <property name="contentType">html</property>
                                                    <text-property name="content"><![CDATA[<B><VALUE-OF>row["message_value"] == null ? 'Certificate issued to' :  row["message_value"]</VALUE-OF> : </B> <VALUE-OF>row._outer["subject"] != null ? (row._outer["subject"].split(',')[row._outer["subject"].split(',').length-1]).split('=')[1] : ""</VALUE-OF>]]></text-property>
                                                </text>
                                            </cell>
                                        </row>
                                        <row id="126">
                                            <property name="height">0.3541666666666667in</property>
                                            <cell id="127">
                                                <text id="128">
                                                    <property name="fontSize">12pt</property>
                                                    <property name="dataSet">Translation</property>
                                                    <list-property name="visibility">
                                                        <structure>
                                                            <property name="format">all</property>
                                                            <expression name="valueExpr" type="javascript">row._outer["private_key"] != null</expression>
                                                        </structure>
                                                    </list-property>
                                                    <list-property name="paramBindings">
                                                        <structure>
                                                            <property name="paramName">param_1</property>
                                                            <simple-property-list name="expression">
                                                                <value type="javascript">'EbicsCertificateReport.issuedBy'</value>
                                                            </simple-property-list>
                                                        </structure>
                                                        <structure>
                                                            <property name="paramName">param_2</property>
                                                            <simple-property-list name="expression">
                                                                <value type="javascript">row["bank_language"]</value>
                                                            </simple-property-list>
                                                        </structure>
                                                    </list-property>
                                                    <list-property name="boundDataColumns">
                                                        <structure>
                                                            <property name="name">message_value</property>
                                                            <text-property name="displayName">message_value</text-property>
                                                            <expression name="expression" type="javascript">dataSetRow["message_value"]</expression>
                                                            <property name="dataType">string</property>
                                                        </structure>
                                                    </list-property>
                                                    <property name="contentType">html</property>
                                                    <text-property name="content"><![CDATA[<B><VALUE-OF>row["message_value"] == null ? 'Certificate issued by' :  row["message_value"]</VALUE-OF> : </B> <VALUE-OF>row._outer["issuer"] != null ? (row._outer["issuer"].split(',')[0]).split('=')[1] : ""</VALUE-OF>]]></text-property>
                                                </text>
                                            </cell>
                                        </row>
                                        <row id="129">
                                            <property name="canShrink">false</property>
                                            <property name="overflow">visible</property>
                                            <cell id="130">
                                                <property name="borderBottomStyle">none</property>
                                                <property name="borderLeftStyle">none</property>
                                                <property name="borderRightStyle">none</property>
                                                <property name="borderTopStyle">none</property>
                                                <property name="canShrink">false</property>
                                                <property name="overflow">auto</property>
                                                <data id="144">
                                                    <property name="overflow">auto</property>
                                                    <property name="resultSetColumn">pem_string</property>
                                                </data>
                                            </cell>
                                        </row>
                                        <row id="131">
                                            <property name="height">0.3541666666666667in</property>
                                            <cell id="132">
                                                <text id="136">
                                                    <property name="fontSize">12pt</property>
                                                    <property name="fontWeight">bold</property>
                                                    <property name="dataSet">Translation</property>
                                                    <list-property name="paramBindings">
                                                        <structure>
                                                            <property name="paramName">param_1</property>
                                                            <simple-property-list name="expression">
                                                                <value type="javascript">row["certificate_hash"]</value>
                                                            </simple-property-list>
                                                        </structure>
                                                        <structure>
                                                            <property name="paramName">param_2</property>
                                                            <simple-property-list name="expression">
                                                                <value type="javascript">row["bank_language"]</value>
                                                            </simple-property-list>
                                                        </structure>
                                                    </list-property>
                                                    <list-property name="boundDataColumns">
                                                        <structure>
                                                            <property name="name">message_value</property>
                                                            <text-property name="displayName">message_value</text-property>
                                                            <expression name="expression" type="javascript">dataSetRow["message_value"]</expression>
                                                            <property name="dataType">string</property>
                                                        </structure>
                                                    </list-property>
                                                    <property name="contentType">html</property>
                                                    <text-property name="content"><![CDATA[<VALUE-OF>row["message_value"] == null ? row._outer["certificate_hash"] : row["message_value"]</VALUE-OF> (SHA-256) :]]></text-property>
                                                </text>
                                            </cell>
                                        </row>
                                        <row id="142">
                                            <property name="height">0.0625in</property>
                                            <cell id="143"/>
                                        </row>
                                        <row id="134">
                                            <property name="height">1.6979166666666667in</property>
                                            <cell id="135">
                                                <data id="138">
                                                    <property name="fontSize">12pt</property>
                                                    <property name="resultSetColumn">sha2has</property>
                                                </data>
                                            </cell>
                                        </row>
                                    </grid>
                                </cell>
                            </row>
                            <row id="78">
                                <property name="height">0.21875in</property>
                                <cell id="79"/>
                                <cell id="112"/>
                                <cell id="80"/>
                            </row>
                            <row id="81">
                                <property name="height">0.375in</property>
                                <cell id="82">
                                    <label id="98">
                                        <property name="fontSize">12pt</property>
                                        <property name="fontWeight">bold</property>
                                        <text-property name="text">Date :</text-property>
                                    </label>
                                </cell>
                                <cell id="113"/>
                                <cell id="83">
                                    <label id="139">
                                        <property name="fontSize">12pt</property>
                                        <property name="fontWeight">bold</property>
                                        <text-property name="text">Signature :</text-property>
                                    </label>
                                </cell>
                            </row>
                        </grid>
                    </cell>
                </row>
            </detail>
        </table>
    </body>
</report>
