• Welcome to the upgraded JDELIST forum and thank you for your patience.
    Please restrict discussions and issues regarding the new forum software to the Off Topic forum. We will be monitoring that forum for issues.
    If you have trouble logging in, please reset your password using the forgotten password form: https://www.jdelist.com/community/index.php?lost-password/
    If you are unable to successfully reset your password, please contact us: Click here!
    We hope that you enjoy the upgraded forum.
  • Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

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.
 

xxpeta

Member
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
 
Top