Troubles with xsl:for-each in XML Publisher reports with Excel template for OEBS 12.1.3
Hello.
We want create Excel reports in XML Publisher for OEBS 12.1.3 using "true" Excel Templates.
In metalink note id 1138602.1say:
--------------------------------------------------------------
For true Excel Template design (Creating Excel Templates) it is required to:
Uninstall the BI Publisher Desktop 10.1.3.2.1
Install Oracle BI Publisher Desktop 11.1.1.5.0 for Windows (download)
Use the Template Builder for Excel 11.1.1.5.0 for creating Excel templates
--------------------------------------------------------------
It is work, i can create Excel template with XML Publisher Desktop 11.1.1.5 and install it in to OEBS and receive Excel document with data. But it not work with all XSL features, for example with "xsl:for-each" not work.
For example, we created template with group (XDO_GROUP_?SORT? “<xsl:for-each select=".//G_1">” “</xsl:for-each>”) and calculated field (XDO_?TOTAL? “<?count(.//G_1)?>”), which returned count of rows in the group.
We want create Excel reports in XML Publisher for OEBS 12.1.3 using "true" Excel Templates.
In metalink note id 1138602.1say:
--------------------------------------------------------------
For true Excel Template design (Creating Excel Templates) it is required to:
Uninstall the BI Publisher Desktop 10.1.3.2.1
Install Oracle BI Publisher Desktop 11.1.1.5.0 for Windows (download)
Use the Template Builder for Excel 11.1.1.5.0 for creating Excel templates
--------------------------------------------------------------
It is work, i can create Excel template with XML Publisher Desktop 11.1.1.5 and install it in to OEBS and receive Excel document with data. But it not work with all XSL features, for example with "xsl:for-each" not work.
For example, we created template with group (XDO_GROUP_?SORT? “<xsl:for-each select=".//G_1">” “</xsl:for-each>”) and calculated field (XDO_?TOTAL? “<?count(.//G_1)?>”), which returned count of rows in the group.
0