Nested group in bip add-on for MSWord

Carlos Carvalho

Summary

Nested group in bip add-on for MSWord

Content

Hello everyone,

I am trying to create a report template.

I want to group the table according to operator and then by discountgroup:

and it creates the table and the groupings:

, but when i run the sample it gives error:

ConfFile: C:\Users\Administrator\AppData\Local\Oracle\BIPublisher\TemplateBuilderforWord\config\xdo.cfgFont Dir: C:\Program Files (x86)\Oracle32\BI Publisher\BI Publisher Desktop\Template Builder for Word\fontsOut File: C:\Users\Administrator\AppData\Local\Oracle\BIPublisher\TemplateBuilderforWord\tmp\tmp\91510749707236out.pdfRun XDO StartTemplate: C:\Users\Administrator\AppData\Local\Oracle\BIPublisher\TemplateBuilderforWord\tmp\tmp\tmp.rtfRTFProcessor setLocale: en-usFOProcessor setData: \\conceptsoftware.eu\Home\ccarvalho\OracleBIP\ReportsQuerys\DiscountReason\DiscountReasonDataModel_.xmlFOProcessor setLocale: en-usoracle.xdo.XDOException: org.xml.sax.SAXException: Error in expression: './/current-group()'.oracle.xdo11g.xpath.XPathException: Error in expression: './/current-group()'.at oracle.xdo.template.fo.util.FOUtility.generateFO(FOUtility.java:1300)at oracle.xdo.template.fo.util.FOUtility.generateFO(FOUtility.java:308)at oracle.xdo.template.FOProcessor.createFO(FOProcessor.java:2094)at oracle.xdo.template.FOProcessor.generate(FOProcessor.java:1201)at RTF2PDF2.runRTFto(RTF2PDF2.java:484)at RTF2PDF2.runXDO(RTF2PDF2.java:343)at RTF2PDF2.main(RTF2PDF2.java:235)Caused by: org.xml.sax.SAXException: Error in expression: './/current-group()'.oracle.xdo11g.xpath.XPathException: Error in expression: './/current-group()'.at oracle.xdo11g.xslt.XSLProcessor.reportException(XSLProcessor.java:965)at oracle.xdo11g.xslt.XSLProcessor.newXSLStylesheet(XSLProcessor.java:725)at oracle.xdo11g.parser.v2.XSLProcessor.newXSLStylesheet(XSLProcessor.java:391)at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)at java.lang.reflect.Method.invoke(Unknown Source)at oracle.xdo.common.xml.XSLT10gR1.invokeNewXSLStylesheet(XSLT10gR1.java:946)at oracle.xdo.common.xml.XSLT10gR1.transform(XSLT10gR1.java:683)at oracle.xdo.common.xml.XSLT10gR1.transform(XSLT10gR1.java:377)at oracle.xdo.common.xml.XSLTWrapper.transform(XSLTWrapper.java:238)at oracle.xdo.template.fo.util.FOUtility.generateFO(FOUtility.java:1276)... 6 more

If i remove the 'inner' group (discountReason):

it works well.

The query that originated the sample XML returns the expected result subset already ordered in sql developer:

So what is wrong?

Can someone help me please?

I am trying to achieve a result like:

So for each operator i will have x tables according to x discount reasons.

Thanks.

Carlos