We have a RTF template we converted to Excel because of another limitation/bug that is not fixed where RTF template viewed as Excel does not view correctly on the server. We can't add if logic around the Excel template like we can in the RTF to hide the headings and totals. I entered an Oracle SR and they confirmed this is a limitation and asked me to enter a enhancement request. Please vote for this to increase the capabilities when using Excel templates especially with the other limitations of RTF viewed as Excel and the bug is not fixed yet.
Limitation of RTF Viewed as Excel:
E1: XMLP: Creating Native ExcelOutputs from RTF Templates ( DocID 1519530.1 )
Bug16165408 GENERATE NATIVE EXCEL OUTPUTSUPPORTED IN EMBEDDED BIP .
Excel Template:
Added below and it helps with for-each not displaying blank rows.
XDO_GROUP_?XDOG1?<xsl:for-eachselect=".//On_Company_S13[Description___Company_ID2>' ']"></xsl:for-each>
XDO_GROUP_?XDOG2?<xsl:for-eachselect=".//On_Community_S4[CostCenterSubsequent_ID45>' ']"></xsl:for-each>
Issue: the headings and totals section still display since can't add conditional logic around them like we can in RTF templates.
Headings
For each Company Company Details Section end for-each
Totals
