PavelK
Member
Hello, have somebody experience with Excel template?
I found difference with Local preview and server runnig functionality. Have somebody idea for workabroud?
My XML example:
- <LEVEL01>
<NODE02/>
<NODE02/>
- <NODE02>
<ELEMENT01>1</ELEMENT01>
<ELEMENT02>123456</ELEMENT02>
On sheet XDO_METADATA I create data Constraints
Data Constraints:
COLUMN A
------------
XDO_GROUP_?LISTNODE?
COLUMN B
------------
"<xsl:for-each-group select=""//NODE01[./ELEMENT01]"" group-by=""./ELEMENT02"">
<xsl:sort select=""./ELEMENT01"" order=""ascending"" data-type=""text""/>"
COLUMN C
------------
</xsl:for-each-group>
It working on local. Local BI publisher not printing empty lines in output excel.
But server print nothing.
I play with SKIPROW but without sucess.
I learn from:
[url="http://download.oracle.com/d...d/E21764_01/bi.1111/e13881/T527073T571887.htm [/url]
Thank you in advance for any idea.
I found difference with Local preview and server runnig functionality. Have somebody idea for workabroud?
My XML example:
- <LEVEL01>
<NODE02/>
<NODE02/>
- <NODE02>
<ELEMENT01>1</ELEMENT01>
<ELEMENT02>123456</ELEMENT02>
On sheet XDO_METADATA I create data Constraints
Data Constraints:
COLUMN A
------------
XDO_GROUP_?LISTNODE?
COLUMN B
------------
"<xsl:for-each-group select=""//NODE01[./ELEMENT01]"" group-by=""./ELEMENT02"">
<xsl:sort select=""./ELEMENT01"" order=""ascending"" data-type=""text""/>"
COLUMN C
------------
</xsl:for-each-group>
It working on local. Local BI publisher not printing empty lines in output excel.
But server print nothing.
I play with SKIPROW but without sucess.
I learn from:
[url="http://download.oracle.com/d...d/E21764_01/bi.1111/e13881/T527073T571887.htm [/url]
Thank you in advance for any idea.