Amicuk Programming Answers

Error: If statement in RTF template in BI Buplisher

2015-10-11   Views:8


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

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_period=/asset/p_fiscal_period and q1_task_top="Opex"]/q1_cost_plan_ytd) ) div
*(sum(//g_data[fiscal_period=/asset/p_fiscal_period]/q2_op_plan_ytd) ) ?><?end if?>*
I wanted to apply if condition to the code after the " div " as if I get any value for q2_op_plan_ytd as zero the it should replace with 1.
Please help me on this

The replay answer
Solution found.

Go to See the other 2 answers

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]

Run time error while login to RTF Template

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

Hi, I am trying to create a sample report in BI Publisher. but while login into RTF Template I am getting below error. Please rectify this problem? Run time error '429' Active x component can't ceate object help me outRuntime Errors         DYNPRO_FI[More]

PO PDF errors when using custom RTF Template, but works with custom xsl

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

Hi, I have done following set up steps for PO PDF Setup / Organizations / Purchasing Options / Control TAB / set 'PO Output Format' = 'PDF' setup / purchasing / document types / select "Standard Purchase Order" / Set the Document Type Layout to[More]

Parse Error in XML Publisher .rtf template during "preview"

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

I've created a template based upon a working one with a few tweaks, but it does not work. It validates okay in XML PUblisher but the preview fails with this error: Caused by: oracle.xdo.parser.v2.XMLParseException: Attribute 'select' not found in 'xs[More]

BI pulisher errors out when I tried to load xml in rtf template.

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

Hello, Today I have installed bi publisher with .net framework.But when I tried to load the xml file after opening .rtf template it gives error "XSD parser returned an error" Please let me know what could be the issue. Thanks Ganesh ManeHello, -[More]

Images in RTF template giving errors

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

Hi, I am using "XML Publisher Template Builder for Word" ver 5.6 Build 45. My requirement says that i need to put all data values in a Rectangular BOX. I made the template and tested the same by using Priview option of Template Buider, and it lo[More]

XML Publisher errors with pdf template workd perfectly with rtf template

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

Hi there, I hope you are well. I am having a problem with pdf templates in XML publisher. I have a report which outputs XML, this works very well with an rtf template. However I am trying to create a pdf xml publisher template (using the concurrent p[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 While creating a new template or updating file with an existing templ

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

Hi, I am trying to create a new Tempalte using XML Publisher Administrator resp. I am getting the error pasted below: oracle.apps.fnd.framework.OAException: oracle.apps.xdo.XDOException: String index out of range: -2      at oracle.apps.fnd.framework[More]

As far as a little background, i have just finished two high definition projects in Premiere Elements, the last one being 73 projects combined into 6 blu rays.  It had completely filled up my 1TB hard drive, so i have purchased an additional 2TB inte [More]
I plugged my phone into my laptop this morning and it started doing an update. I walked away from my desk, came back and had an error message and a prompt saying my phone is in recovery mode and needs to be restored. But when I click "ok" to do [More]
Hi everyone, When I am doing MIGO ,In stock transfer order ,I am getting the following error, "Excise Invoice cannot be captured for RG1(Finished Goods) material". What should I do? Regards PrabudhHi Prabudh, Can you come again with more details [More]
I tried to download a driver from Panasonic for my camcorder.  It puts an Icon on my desktop that is called set-up1.exe.  when I try to open this I get an error message that says I don't have a program to open it.  any suggestions.  Also, I tried to [More]
How can I copy all the comments from my picture/s in fotostream to my picture/s in my library?Hi, first, you should prevent the iTunes library auto sync with iPhone: Launch iTunes > click Preferences... > click Devices. In the window, check the opti [More]
Okay, so I upgrade to IOS5. I get hoodwinked into creating a new apple ID, much to my dismay. After restarting my iPhone, I don't want the new ID, so I try to log into Apple ID with my previous ID, however it won't accept my password and makes me res [More]
Hello,   I am having a problem when I try to make an IOS ipad release build it never able to finish and fails due to compiler errors.   I am using window 7 and flash builder 4.7 and AIR sdk 3.5.   I have one actionscript mobile project linked to 5 li [More]
Hi Experts, For my query I saw a similar thread in sdn forum. the link is given below. /thread/382306 [original link is broken] I have unzipped the par file and inside this there is no other par file. So I have to import this par file only. Can anybo [More]
Just installed XP 64 bit from XP 32 because i finally got tired of windows only recognizing 2GB of RAM. I have just discovered the multi card reader no longer works (it worked just a few days ago with the 32 bit xp). i have tried uninstalling and rei [More]
hi i follow this sample ,but when i select my LOV am geting this error FacesCtrlListBinding> <getInputValue> ADFv: Could not find selected item matching value 100 of type: orac [More]