Could you see if above article help you...if not please let me know

or if you have latest BI Publisher installed it will support .xlsx also...please try both

Once you install BI Publisher Desktop it comes with sample template where you can find out all the basic examples and also it provide User guide for more details

Hi, You can design your rtf as below. Let me know if you face any issue

You are almost there...could you use below REPLACE(Payee/Name, '''', '')

I tried this...worked for me...could you please upload your rtf?

I think ​ specified same thing in the earlier post

Is this your Bursting program is taking time or its issue with all the Bursting across instance?

Do you have prod_seq column in table prod_det? If you have you can pass the prod_seq from the parent sql to child sql as below. This will restrict child sql to pick the value related to parent sql <dataQuery> <sqlStatement name="Q_MAST"><![CDATA[SELECT product_id, prod_seq, product_name FROM prod_mast WHERE…

Can you just copy paste your dataQuery only?

I think prod_mast_seq in prod_det contains the proj_seq of master table so you can do the below <dataQuery> <sqlStatement name="Q_MAST"><![CDATA[SELECT product_id, prod_seq, product_name FROM prod_mast WHERE product_id=:p_prod]]></sqlStatement> <sqlStatement name="Q_DET"><![CDATA[ SELECT…

There may be some hidden table layout or space that causing the issue....could you please upload your rtf and sample xml for further debugging?

Two changes require on the template, since you are calling two template using single rtf(one for Jul-17 and one for Jun-16) 1. Put the condition <?if:SIBA_CAL_RUN_ID='JUL-17'?> before the <?if:SIBA_CAL_RUN_ID!=''?>, this is because <?if:SIBA_CAL_RUN_ID!=''?> condition is always true in both the cases and because of this…

Please go a head to create new thread if its different from the current issue...you always welcome

What is your last update patch applied ? 1. Log into BIP Enterprise. 2. Select the 'View' menu in the toolbar of Internet Explorer. 3. Scroll down to the 'Source' option. 4. The entry for the version will look similar to the following: <meta name="Generator" content="Oracle BI Publisher 10.1.3.4.1 (build# 1267 on Wed Mar…

RTF you can write <?xdoxslt:sysdate(“DD-Mon-YYYY:HH:mm:ss”)?> etext : TO_CHAR(SYSDATE,'DD-MON-YYYY hh:mi:ss')

<xsl:value-of select="concat(string(format-number(sum (current-group()/PROPOSED1D) div 1000 , '###,###.000')),string('K'))"/> Could you try the above

What is the issue here? Above syntax is fine and it will show data in thousand separator e.g. 1,234,567,676

Hi, Its always preferable if you have number of columns more then go for Excel layout rather generating excel output from rtf 

can you try this dbms_xmlgen.convert('PROV</A',0)