Sitemap

Amicuk Programming Answers

And/or if statement in rtf templates.

2015-10-11   Views:12

Advertisement

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
Kenneth

The replay answer
Advertisement
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.
POH_PO_TYPE can be: STANDARD, RELEASE or BLANKET.
CP_RELEASE_NUM can be: '' or N
If POH_PO_TYPE is RELEASE AND CP_RELEASE_NUM is not ''
OR POH_PO_TYPE is STANDARD
OR POH_PO_TYPE is BLANKET AND CP_RELEASE_NUM is ''
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 10.1.3.4.1) 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]

Hot
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: http://docs.oracle.com/cd/E37097_01/doc/doc.42/e35128/restful_svc.htm#autoId6 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]