Hi, Since date is in DD-MMM-YYYY format so you can directly go with substr. If its in standard date format i.e. 2000-04-08T20:00:00 then we can go for format-date function <?xdofx:substr(P_START_DATE,1,Instr(P_START_DATE,'-',1)-1)?>

BI Publisher parser will not understand <br/> as a new line character . So better to handle this on Database. So while generating the data <TermsAndConditions> 1) Terms - 1<br/>2) Terms -2<br/></TermsAndConditions> please generate as <TermsAndConditions> 1) Terms - 1 2) Terms -2 </TermsAndConditions>

can you use without & (i.e. &P_COND_SOURCE_LOCATION_PARAM directly refer P_COND_SOURCE_LOCATION_PARAM)

May I know what is the date format used for start date parameter....if you can paste how its appearing in XML it will be great

Where these variable has been defined? Package body or spec..? Variable defined in package specification(public) can be directly used in your sql. For me looks like sql formation after laxical paramter bind is not correct, its forming some incorrect sql. e.g. Below is the report lexical paramteer…

If I understand you problem correctly...you are passing one Date as a parameter and from that date you are displaying the data two days back and two days in future. I mean if I pass date as 25-Sep-2017 what you are expecting in output?

you can user <?format-date:ParameterName;'day-dd';'Asia/India'?>

Yes...you can subscribe to any country and region. for the format 'day-dd' if date is 25-Sep-2017. it will return Monday-25. You may need to do substr to get Mon-25

ohh...then you can just add <?format-date:ParameterName;'dd';'Asia/India'?>

Could you please upload/send mail...the rtf and sample xml

your syntax is little bit not correct, BI tags should start with <? and these should not be nested tag like <? <?. Below is the one working for me <?if: sum(current-group()/BUDGET)=0?><? '-'?><?end if?>

Hi, In EBS under BI Publisher we have option to register the font that will reflect in pdf output. Not really sure if this is there in JDE. But just posted if it triggers some clue for you to check further.

Hi, BI Publisher Desktop comes under OTN License , you can go through below terms and condition. OTN Developer License Terms

I tried below it worked for me <?xdofx:Total_Extended_Price_WF_ID23 - Summary_Taxable_Amt_ID8?>

Hi, These columns will appear with blank value...add plsql code to these place holders and return false based on your logic so that it will not appear in XML.

In the after report trigger based on the parameter value you can assign those place holder column as blank. so that it will not generate.

If I under stand correctly you would like to subtract two XML tag Total_Extended_Price_WF_ID23 and Summary_Taxable_Amt_ID8 we can directly use subtract function like <?xdofx:2-3?> we only need the exact level of these two tags...for that we need to analyse your XML. Could you please upload your sample XML

May i know what is your requirement? The one which you posted is way of subtraction with some additional logic. there are some easiest way example <?xdofx:2-3?> you can use. Let us know what exactly you are looking?

Hi, if then else is not straight forward in BIP. if-else is xdofx expression in BIP so its uses is limited to some tag or hard coded value...you cannot write any complex expression inside this. This is if-else <?xdofx:if element_condition then result1 else result2 end if?> If its fulfill your requirement you can use it or…

Could you please elaborate more on your requirement "I am trying to export from XML Publisher to an excel spreadsheet with multiple sheets"? For R12.1.3 in excel...please apply the below patch after this patch you will be able to see Excel Template type in XML Publisher R12: How to add Microsoft Excel as Type to the Create…