How to create a new report ?

オフライン

Hi, I would like to create a new report.

For some reason my xsl documents makes blank rows ..

***********Here is my report Query :
<Item type="HG_Product_Model" action="get" >
<related_id>
<Item type="Part" id="{@id}" action="get" select="item_number,state,name"/>
</related_id>
<source_id>
<Item type="Initiative" action="get" select="title,_forcast_date_initiative,_yearly_impact_machine"/>
</source_id>
</Item>


*********Here is my Stylesheet:
<xsl:stylesheet version="1.0" xmlns:xsl="">www.w3.org/.../Transform">
<xsl:template match="/">
<html>
<style type="text/css" userData="Global">
.cellSolid {
border-top:1px #000000 solid;
border-right:1px #000000 solid;
border-bottom:1px #000000 solid;
border-left:1px #000000 solid;
}
.cellSolidTopRight {
border-top:1px #000000 solid;
border-right:1px #000000 solid;
}
.cellSolidTopLeft {
border-top:1px #000000 solid;
border-left:1px #000000 solid;
}
.cellSolidRightBottom {
border-right:1px #000000 solid;
border-bottom:1px #000000 solid;
}
.cellSolidBottomLeft {
border-bottom:1px #000000 solid;
border-left:1px #000000 solid;
}
.cellSolidTop {
border-top:1px #000000 solid;
}
.cellSolidRight {
border-right:1px #000000 solid;
}
.cellSolidBottom {
border-bottom:1px #000000 solid;
}
.cellSolidLeft {
border-left:1px #000000 solid;
}
.cellDashed {
border-top:1px #666666 dashed;
border-right:1px #666666 dashed;
border-bottom:1px #666666 dashed;
border-left:1px #666666 dashed;
}
.cellDashedTopRight {
border-top:1px #666666 dashed;
border-right:1px #666666 dashed;
}
.cellDashedTopLeft {
border-top:1px #666666 dashed;
border-left:1px #666666 dashed;
}
.cellDashedBottomRight {
border-bottom:1px #666666 dashed;
border-right:1px #666666 dashed;
}
.cellDashedBottomLeft {
border-bottom:1px #666666 dashed;
border-left:1px #666666 dashed;
}
.cellDashedTop {
border-top:1px #666666 dashed;
}
.cellDashedRight {
border-right:1px #666666 dashed;
}
.cellDashedBottom {
border-bottom:1px #666666 dashed;
}
.cellDashedLeft {
border-left:1px #666666 dashed;
}
.cellHeader {
background-color:#CCCCCC;
border-top:1px #000000 solid;
border-right:1px #000000 solid;
border-bottom:1px #000000 solid;
padding:2px;
text-align:center;
text-transform:capitalize;
text-align:center;
font-family:helvetica;
font-weight:bold;
font-size:8pt;
}
.cellHeaderVertBT {
background-color:#CCCCCC;
border-top:1px #000000 solid;
border-right:1px #000000 solid;
border-bottom:1px #000000 solid;
border-left:1px #000000 solid;
padding:2px;
writing-mode:tb-rl;filter: flipv fliph;
text-align:center;
text-transform:capitalize;
text-align:center;
font-family:helvetica;
font-weight:bold;
font-size:8pt;
}
.cellHeaderVertTB {
background-color:#CCCCCC;
border-top:1px #000000 solid;
border-right:1px #000000 solid;
border-bottom:1px #000000 solid;
border-left:1px #000000 solid;
padding:2px;
writing-mode:tb-rl;filter: flipv flipv;
text-align:center;
text-transform:capitalize;
text-align:center;
font-family:helvetica;
font-weight:bold;
font-size:8pt;
}
</style>
<body>
<h2>test</h2>
<table border="1">
<tr bgcolor="#9acd32">
<th>Title</th>
<th>Forcasted Application Date</th>
<th>Yearly Cost Impact</th>
</tr>
<xsl:for-each select="//Result/Item/source_id/*">
<tr>
<td>
<xsl:value-of select="//Result/Item/source_id/title"/>
</td>
<td>
<xsl:value-of select="//Result/Item/source_id/_forcast_date_initiative"/>
</td>
<td>
<xsl:value-of select="//Result/Item/source_id/_yearly_impact_machine"/>
</td>
</tr>
</xsl:for-each>
</table>
</body>
</html>
</xsl:template>
</xsl:stylesheet>


***********Here is the XML file:
<SOAP-ENV:Envelope
xmlns:SOAP-ENV="">schemas.xmlsoap.org/.../">
<SOAP-ENV:Body>
<Result>
<Item type="HG_Product_Model" typeId="B8DDCEDE1A3548A6A0EB0CF456A1DAA7" id="483FC81CD5754975A73F9757E5450797">
<behavior>float</behavior>
<config_id keyed_name="483FC81CD5754975A73F9757E5450797" type="HG_Product_Model">483FC81CD5754975A73F9757E5450797</config_id>
<created_by_id keyed_name="Moustapha MAHAMAT" type="User">544824346E2248A58AA334BA64F3B104</created_by_id>
<created_on>2019-11-04T12:59:51</created_on>
<generation>1</generation>
<id keyed_name="483FC81CD5754975A73F9757E5450797" type="HG_Product_Model">483FC81CD5754975A73F9757E5450797</id>
<is_current>1</is_current>
<is_released>0</is_released>
<keyed_name>483FC81CD5754975A73F9757E5450797</keyed_name>
<major_rev>A</major_rev>
<managed_by_id keyed_name="david BRENEUR" type="Identity">548D178F638D4170B5565E8F25DA36C3</managed_by_id>
<modified_by_id keyed_name="Moustapha MAHAMAT" type="User">544824346E2248A58AA334BA64F3B104</modified_by_id>
<modified_on>2019-11-04T12:59:51</modified_on>
<new_version>1</new_version>
<not_lockable>0</not_lockable>
<permission_id keyed_name="New ECR" type="Permission">1DAC88DF968B4451B877A2E7D9703163</permission_id>
<related_id keyed_name="4000900490 HS 4388 RT" type="Part">
<Item type="Part" typeId="4F1AC04A2B484F3ABA4E20DB63808A88" id="E5C5FA7397A24DB3BA7E21B89F023B8A">
<id keyed_name="4000900490 HS 4388 RT" type="Part">E5C5FA7397A24DB3BA7E21B89F023B8A</id>
<name xml:lang="fr">H15 SX</name>
<state>Preliminary</state>
<item_number>4000900490</item_number>
<xp-zzmodel>ZZMODELE200</xp-zzmodel>
<itemtype>4F1AC04A2B484F3ABA4E20DB63808A88</itemtype>
<_traceability>Non Tracé en Production</_traceability>
</Item>
</related_id>
<sort_order>128</sort_order>
<source_id keyed_name="INI-100028" type="Initiative">
<Item type="Initiative" typeId="2D4799413792453DA08C1EDE6AA22A76" id="DD52E067C8CD4500AAF971EE47FBF4C8">
<_forcast_date_initiative>2019-11-14T23:00:00</_forcast_date_initiative>
<_yearly_impact_machine>0</_yearly_impact_machine>
<id keyed_name="INI-100028" type="Initiative">DD52E067C8CD4500AAF971EE47FBF4C8</id>
<title>test initiative </title>
<itemtype>2D4799413792453DA08C1EDE6AA22A76</itemtype>
</Item>
</source_id>
</Item>
<Item type="HG_Product_Model" typeId="B8DDCEDE1A3548A6A0EB0CF456A1DAA7" id="9CDBB74985E141C9ADD2F8B99D6A93E7">
<behavior>float</behavior>
<config_id keyed_name="9CDBB74985E141C9ADD2F8B99D6A93E7" type="HG_Product_Model">9CDBB74985E141C9ADD2F8B99D6A93E7</config_id>
<created_by_id keyed_name="Moustapha MAHAMAT" type="User">544824346E2248A58AA334BA64F3B104</created_by_id>
<created_on>2019-11-04T12:58:48</created_on>
<generation>1</generation>
<id keyed_name="9CDBB74985E141C9ADD2F8B99D6A93E7" type="HG_Product_Model">9CDBB74985E141C9ADD2F8B99D6A93E7</id>
<is_current>1</is_current>
<is_released>0</is_released>
<keyed_name>9CDBB74985E141C9ADD2F8B99D6A93E7</keyed_name>
<major_rev>A</major_rev>
<modified_by_id keyed_name="Moustapha MAHAMAT" type="User">544824346E2248A58AA334BA64F3B104</modified_by_id>
<modified_on>2019-11-04T12:58:48</modified_on>
<new_version>1</new_version>
<not_lockable>0</not_lockable>
<permission_id keyed_name="New ECR" type="Permission">1DAC88DF968B4451B877A2E7D9703163</permission_id>
<related_id keyed_name="4000900490 HS 4388 RT" type="Part">
<Item type="Part" typeId="4F1AC04A2B484F3ABA4E20DB63808A88" id="E5C5FA7397A24DB3BA7E21B89F023B8A">
<id keyed_name="4000900490 HS 4388 RT" type="Part">E5C5FA7397A24DB3BA7E21B89F023B8A</id>
<name xml:lang="fr">H15 SX</name>
<state>Preliminary</state>
<item_number>4000900490</item_number>
<xp-zzmodel>ZZMODELE200</xp-zzmodel>
<itemtype>4F1AC04A2B484F3ABA4E20DB63808A88</itemtype>
<_traceability>Non Tracé en Production</_traceability>
</Item>
</related_id>
<sort_order>384</sort_order>
<source_id keyed_name="INI-100027" type="Initiative">
<Item type="Initiative" typeId="2D4799413792453DA08C1EDE6AA22A76" id="FE073AC2D1FB47C78F0DF033DAE6B5FE">
<_forcast_date_initiative is_null="1" />
<_yearly_impact_machine>500</_yearly_impact_machine>
<id keyed_name="INI-100027" type="Initiative">FE073AC2D1FB47C78F0DF033DAE6B5FE</id>
<title>test date</title>
<itemtype>2D4799413792453DA08C1EDE6AA22A76</itemtype>
</Item>
</source_id>
</Item>
</Result>
</SOAP-ENV:Body>
</SOAP-ENV:Envelope>

Thank you