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]

When you click on the "+" sign to open a new tab, nothing happens. Same thing when you select "file" and "new tab" or press ctrl+T. I have rolled back this version of firefox three days in a row and it keeps updating to this [More]
Is it possible to use service composer in CE 7.2 to join the 2 or more webservices? can any one have documents for this case?Yes, i have different services like ws1 and ws2 give me data like below , and need to join or merge them. few fieds may be sa [More]
I am using a Macbook Air, running 10.9.4. Every-time I click on anything on Safari or any other browser, it brings a pop up to another website (advert). I have enabled pop up blocker but has made no difference. It does not happened on any other Mac. [More]
hi, I want to export photo slideshow in hd. I had exported into quicktime h.264 hd but it doesnt support to my Samsung Led tv. When i exported to mp4 h.264 photo quality gets ruined, everthing looks pixel. I am using following setting: h.264 full hd [More]
From a forms web app I need to get some client machine and do file uploads. There is great sample code for doing this. I tried using the GetClientInfo sample and it works fine in Forms Builder and it works fine with JInitiator. But I need it to work [More]
I'm experiencing strange behavior with my MacBookPro. I use .mac mail on three machines. They all sync-up beautifully. Occasionally however, a message on the MBP switches identity. That is, in the list pane, it says it's a message from person-X, yet [More]
I have copied a table from a web page that has a PDF button, but how do I paste that into Adobe Reader?I do not quite understand the "table with a PDF button"; but if this is a linked or embedded PDF file, just download the file and open it with [More]
Recently purchased a Dell Precision T5600 workstation - Win7 64bit, 32 GB of RAM, Quadro 4000 (driver ver. 307.45).  CS6 Production Premium. Hitting the space bar nor hitting the play button on the program or source monitor will play a video or audio [More]
Hi, I have a blackberry curve 8520 and I received a text message from my mate the other day, went to click back off it and return to the main screen but it had frozen waited 20 mins and it was still stuck so i battery pulled. upon putting the battery [More]
Hi, is there a trx for opening multiple storage locations for the same material <b>instead of setting "Create Storage Location Automatically"</b> in SPRO? Best regardsU can extend a material to number of storage location by using tco [More]