Amicuk Programming Answers

And/or if statement in rtf templates.

2015-10-11   Views:12


Hi all, I'm using XML Publisher 4.5. I have created a word template file (rtf) for my reports. I need to be able to show some content in the template file by using and and/or if statement. fx. <?if:doc_type='STANDARD'?> OR <?if:doc_type='DEFAULT'

Hi all,
I'm using XML Publisher 4.5.
I have created a word template file (rtf) for my reports. I need to be able to show some content in the template file by using and and/or if statement.
fx. <?if:doc_type='STANDARD'?> OR <?if:doc_type='DEFAULT'?>
How can I do this?
In advance thank you.
Best regards

The replay answer
Hi D,
Thank you for your answer.
I have seriously thought about that solution; but I don't think it's a smart way to do it.
If i do it like that, i need to copy the whole table and paste it inside the if statements.
I have two xml elements that I need to make the decisions on. POH_PO_TYPE & CP_RELEASE_NUM.
CP_RELEASE_NUM can be: '' or N
THEN show table (which contains the whole PO).
It shall show the content of the PO in any of these cases.
BR Kenneth

Go to See the other 4 answers

How to round numbers in RTF templates?

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

Hello! I'm using BI Publisher for Word (Oracle BI Publisher Builder for Word to build a template to my BI Publisher report and I want to calculate this: avg(X)/(avg(Y)-avg(Z)/0.9) The result should be rounded to 3 places. I tried: <?(sum([More]

Relative path for images in RTF templates

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

Hi everybody! When I insert an image in a RTF template, I put its path into the web dialog, in order to see correctly the picture when I open the report from the xmlp server, in this way: url:{"http://servername/analytics/res/Images/image.bmp"}[More]

Resetting Header and Footer in RTF templates

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

Hi, I developed an RTF template (template 1). This template contains start:body and end body for printing the header and footer in all pages. After printing this template then i have to call another template(template 2) from this. I called the templa[More]

Error: If statement in RTF template in BI Buplisher

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

All, Can some help me to solve the below issue. Please find the code below one which is extracted from the water mark block in RTF template. <?if:(sum(//g_data[fiscal_period=/asset/p_fiscal_period]/q2_op_plan_ytd))>0?><?( sum(//g_data[fiscal_p[More]

Complex if statement in rtf template?

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

Hello, I want to build an if statement in rtf template, the idea is like: <?if:address!='' and phone!=''?> <?end if?> what's the correct way to do it if it is possible? Thanks in advance! Shichaostevencallan wrote: Conditional statements, in t[More]

How to call a rtf template from another rtf template by passing a value

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

Hi Gurus, Its about calling a rtf template from another rtf template by passing a value. My requirement is like: I got a quote report from Siebel, based on the product PartNumber I need to pull product description or literature from another database[More]

Print Quote the report is in PDF but need to be new RTF template

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

We have 11.5.10 apps, the Quote screen is an OAF screen. When clicking Print Quote the report is in PDF, They want to include a new RTF template for printing instead of PDF. The new RTF template is created. But what I do not know is how the quote scr[More]

Rtf template not showing as uploaded in concurrent program

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

Hello I have created xml data definition and uploaded a rtf template. Then linked it to my concurrent program. But when i ran the concurrent program successfully all i get is the xml output. Upon closer inspection it shows that no template is uploade[More]

How can we get Dynamic columns and data with RTF Templates in BI Publisher

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

How can we get Dynamic columns and data with RTf Templates. My requirement is : create table xxinv_item_pei_taginfo(item_id number, Organization_id number, item varchar2(4000), record_type varchar2(4000), record_value CLOB, State varchar2(4000)); ins[More]

Problem in RTF template

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

Hi all, I use Bi publisher version (11.1.6 ) First Question : What is the best template type for making operational reports not statistical report ( RTF template or PDF template or others ) ? -- Second Question : when i try to make report template us[More]

Graph in rtf template

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

Dear All I need to insert a graph in report through XML in RTF template. i am not able insert the multiple values in BI Publisher. when i try to insert the 2nd value it is getting replaced with the 1st value. Kindly assist me. Regards Shaizy Edited b[More]

My purchased itunes videos no longer play on my Windows 7 computers.  When I click on a movie, itunes shuts down with an error message.  Movies played fine until now.  Any ideas out there? jgard96Let's try the following user tip with that one: iTunes [More]
Hello Everyone! Working on APEX REST services, my query is in regard with the below link: In the above link, heading '5.5.2 Retrieving Data Based on a Parameter (employees/ [More]
Greetings again. I have a quick question about the limitations of Active Directory Enterprise Resource Pool Synchronization.  Specifically, what has your experience been with extremely large numbers of users (10k plus).  Is anyone aware of a practica [More]
Hi, I am trying to find the longest path for a particular BOM material. I am using the FM CS_BOM_EXPL_MAT_V2 to explode the BOM to get the materials (including children nodes etc.). I think, in this scenario, a recursive function would be the best wa [More]
For some reason, I've had a few problems with Firefox recently. The latest is that each time I try to load it, it crashes straight away, occasionally letting me send an error report, others not. It always comes up with an error that states: Firefox h [More]
Hi, I have created several unit tests on functions that are within packages. I wanted to export these from one unit test repository into another repository on a different database. The export and import work fine, but when running the tests on the im [More]
When the battery gets low on the mouse I turn it off, replace them but it doesn't reconnect. I use the MacBook Pro in clamshell mode with the LED Apple screen, so I open it up to use the trackpad... then I go into the Bluetooth settings and it says t [More]
After upgrading from Windows 8 Pro 64bit to Windows 8.1 Pro 64bit on my Sony Vaio Duoe 13, I could not find WPA security type while configuring Wireless network manually. (only WPA2 and 802.1X are available). I have done a lot of troubleshootings lik [More]
I have what appears to be a virus on my mac namely MAL/FAK AV-OQ I only discovered it after installing SOPHOS anti virus software. I cannot remove it automatically with this software it says it has to be done manually. Where do I start??? Help req'd [More]
We have 3 iPads on my iTunes account.  My son created a game center account as a minor and it did not require an email account. Now he cannot remember his password and he is locked out. I am unable to reset it because all he has is his nickname and n [More]