Sitemap

Amicuk Programming Answers

Help with math / calculations in RTF templates

2015-10-11   Views:9

Advertisement

Greetings, I know that there are math capabilities in the templates... I've seen the code samples in the Core Components guide. What this doesn't tell you is WHERE these things would go in a template. And... that... is my question. We are just starti

Greetings,
I know that there are math capabilities in the templates... I've seen the code samples in the Core Components guide.
What this doesn't tell you is WHERE these things would go in a template. And... that... is my question.
We are just starting to use BIP in conjunction with JDE EnterpriseOne (8.12, tool set 8.97.12). For our first attempt we're creating our template over a new report.
I have a template where I sum two different repeating values (through the normal BI Properties) and place these values in two separate cells in a table. I want to sum the two of these together for a "grand" total.
I've seen the "examples" but they really aren't very helpful. The xsfo, etc. for doing addition is fine, but WHAT are the values to add and WHERE does the code go?
If anyone has done something like this or has experience using the embedded code I would appreciate hearing from you.
Thanks in advance

The replay answer
Advertisement
I see what you are saying about the spaces... but it made no difference... still got the error.
The XML file is too large and convoluted to be pasted here.
With reqards to the following snippet:
COLA = <?sum(current-group()/COLA)?>
COLB = <?sum(current-group()/COLB)?>
Summ== <?sum(current-group()/COLA) + sum(current-group()/COLB)?>
Where does THIS code go?
Here is the error detail:
ConfFile: C:\Program Files\Oracle\BI Publisher\BI Publisher Desktop\Template Builder for Word\config\xdoconfig.xml
Font Dir: C:\Program Files\Oracle\BI Publisher\BI Publisher Desktop\Template Builder for Word\fonts
Run XDO Start
Template: C:\Documents and Settings\jdenison\My Documents\BIP Templates\R5642001\R5642001_TEMPLsave.rtf
RTFProcessor setLocale: en-us
FOProcessor setData: C:\Documents and Settings\jdenison\My Documents\BIP Templates\R5642001\R5642001_RICE0001_D081029_T144059683.xml
FOProcessor setLocale: en-us
java.lang.reflect.InvocationTargetException
     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.apps.xdo.common.xml.XSLT10gR1.invokeProcessXSL(Unknown Source)
     at oracle.apps.xdo.common.xml.XSLT10gR1.transform(Unknown Source)
     at oracle.apps.xdo.common.xml.XSLT10gR1.transform(Unknown Source)
     at oracle.apps.xdo.common.xml.XSLTWrapper.transform(Unknown Source)
     at oracle.apps.xdo.template.fo.util.FOUtility.generateFO(Unknown Source)
     at oracle.apps.xdo.template.fo.util.FOUtility.generateFO(Unknown Source)
     at oracle.apps.xdo.template.FOProcessor.createFO(Unknown Source)
     at oracle.apps.xdo.template.FOProcessor.generate(Unknown Source)
     at RTF2PDF.runRTFto(RTF2PDF.java:629)
     at RTF2PDF.runXDO(RTF2PDF.java:439)
     at RTF2PDF.main(RTF2PDF.java:289)
Caused by: oracle.xdo.parser.v2.XPathException: Extension function error: Method not found 'sum'
     at oracle.xdo.parser.v2.XSLStylesheet.flushErrors(XSLStylesheet.java:1534)
     at oracle.xdo.parser.v2.XSLStylesheet.execute(XSLStylesheet.java:521)
     at oracle.xdo.parser.v2.XSLStylesheet.execute(XSLStylesheet.java:489)
     at oracle.xdo.parser.v2.XSLProcessor.processXSL(XSLProcessor.java:271)
     at oracle.xdo.parser.v2.XSLProcessor.processXSL(XSLProcessor.java:155)
     at oracle.xdo.parser.v2.XSLProcessor.processXSL(XSLProcessor.java:192)
     ... 15 more

Go to See the other 9 answers

Help with math / calculations in RTF templates

Category:DefaultRelease time:2015-10-11Views:130

Greetings, I know that there are math capabilities in the templates... I've seen the code samples in the Core Components guide. What this doesn't tell you is WHERE these things would go in a template. And... that... is my question. We are just starti[More]

Can we do Calculations in RTF Template

Category:DefaultRelease time:2015-10-11Views:130

Hi Friends Can we do calculations in RTF template with the fields existing in the XML code. Say there are 2 fields CF_TAX1 and CF_TAX2, can we do calculations with them to give output in a cell in a table in the RTF template for eg: (CF_TAX1)/(1+CF_T[More]

Calculations in RTF Template

Category:DefaultRelease time:2015-10-11Views:130

Hi All, I am new to BI Publisher and I am trying to create a template that will calculate growth for various fields. The data is split like (ignore # - using to show structure of XML): <YTDKPI> ###<YTDKPI_ROW> ######<FIELD 1>(Val)</FI[More]

Creating Calculations in RTF templates

Category:DefaultRelease time:2015-10-11Views:130

Is there any way of creating calculations or formula functions within rtf's?http://blogs.oracle.com/xmlpublisher/discuss/msgReader$75Read other 2 answers[More]

Calculation in rtf template

Category:DefaultRelease time:2015-10-11Views:130

I got error when I perform calculation in a field, the code is <?sum(current-group()/_IFNULL__BE_measures_._TOTAL_COST___0_) div sum(current-group()/_BE_measures_._GROSS_SALES_)?> It shows errors: Caused by: oracle.xdo.parser.v2.XPathException: An i[More]

How to select specific rows in rtf template for complex calculation

Category:DefaultRelease time:2015-10-11Views:130

Hi, I want custom calculation in my rtf template and for this i need to select specific cell's value OR specific row's value. Any one please suggest how can I get this. Below is the example i have plotted using excel. My target is to get field 8 and[More]

Creating Parameters in RTF Template for BI Publisher Report

Category:DefaultRelease time:2015-10-11Views:130

hi, I have created Parameters in my BI Publisher Report and in SQL query. But i need to create same parameters in RTF Template , so that when i publish this report in dashboard , parameters will be visible. Can you please tell me how to create Parame[More]

SUM Function in RTF Template

Category:DefaultRelease time:2015-10-11Views:130

Hi buddies, can we use functions like SUM,AVG etc. in the RTF Template. If possible please give adivce for the below scenario I have one column in the main body table "Extended Amount", I want to sum this field for the another column Total Exten[More]

SUM function with condition in RTF template

Category:DefaultRelease time:2015-10-11Views:130

Hi All, I have a problem in calculating the SUM in RTF template with condition, Here is the XML - <LIST_G_LINE_NOTES> - <G_LINE_NOTES> <LINE_TRX_ID>1567856</LINE_TRX_ID> <LINE_ID /> - <LIST_G_TRX_LINE> - <G_TRX_LINE&[More]

Multiply 2 variables in RTF templates

Category:DefaultRelease time:2015-10-11Views:130

Hi, I am trying to multiply a variable with a calculated field--> <?xdoxslt:get_variable($_XDOCTX,'baseline')*(xdoxslt:maximum(current-group/TRGT_RATIO))?> where "Baseline"=xdoxslt:div(sum(current-group()/NMRTR),sum(currnet-group()/DNMT[More]

Issue in grouping in RTF template

Category:DefaultRelease time:2015-10-11Views:130

HI ALL, I have a requirement as below. The report header part contains : Order number, Email_address, the report body part contains the details for each order like item number, item name Again the line section is based on the another group, so it sho[More]

Hot
Tenho um tipo de transporte que faze três paradas, da usina para um deposito(Deposito não emite nota fiscal), desse deposito vai para um segundo deposito(Que também não emite nota fiscal), saindo do segundo deposito o material é direcionado ao porto [More]
I am just starting off with Java Web Start and trying some simple tests. Let me preface the problem statement by saying that everything is on the same machine (my Win XP Pro desktop). Also, I have confirmed that the environment is set up correctly by [More]
Hi All, Earlier, I posted a similar question in the forum , but did not get appropriate response . Posting it again with some more information . We are not able to access Sharepoint public facing site on Mobile browsers like chrome, IE, Safari (Howev [More]
hi- i have a chat room based on multicast socket with a SWING GUI interface. i want group members to be able to establish a shared secret(bases on extended n-party diffie-hellman algorithm) to encrypt all messages exchanged . Re-keying happens upon m [More]
Hi, I'm using asa 5505 with 8.4(2) and have the following problem. I have 2 Networks. each Network has it's own externel Internet-Ip and also Mail-Server. Here is the example: Network1: 192.168.1.0/24 Mail-Server: 192.168.1.10 External: 1.1.1.1 Netwo [More]
Can I see how large the file will actually be in the Save for Web dialog --  so I can set the lossy and settings appropriately?  Why would the file double in size from what's indicated in the Save For Web dialog?  What can I do to see the correct siz [More]
Hi Experts, We are facing a problem during Batch Risk Analysis- Batch Risk Parameters- System- RP1 Options- User Role Profile, Critical Actions and Role/Profile Analysis Management reports User and Role permission Level risks analysis run fine, but a [More]
With ios 4 I used to be able to download large video files >1 gb (avi, wmv, etc) using Downloads app and then Open In AV Player app. Now it doesn't work. What's the deal Apple?Same problem here. And found several topics seen on other sites, like: htt [More]
I have had a talk21 email account for fifteen years or more.  For the first few years, it was a free service.  In 2004, it was changed so that you had to pay to be able to access your talk21 email via Outlook or other programs.  I signed up to this, [More]
Hi i have created a game where the user clicks on the screen and where ever the user clicks triangles appear. I have created an animation whereby after the user clicks, a set of colours, green, orange cyan and cycled through 1 by 1 in the triangle. T [More]