EXCEL template

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 think I may have a similar issue. Did you ever find resolution?

Thanks,

Greg
 
Hi Pavel,

I had the same problem. Locally it works fine, but on server it makes some xml over 800MB and no xls file as output.
The only working solution I found is to hide all working sections and make new conditional group section which is not hidden. This new section is called only if the condition in working section is true, or when there is not "suppress section write" in working section. Working on E812. Petr
 
Back
Top