please let us know the data source for your data model , is this sql Type or any other source , if it is sql query type then create logic directly in sql query and apply in template level , Thanks

Note: TBAddInSetup is for Microsoft Word and ETBAddInSetup is for Excel. run ETBAddInSetup , Important note: For MS Office 2013, you will need to install BI Publisher Desktop 12c. open excel , Got to file -> options >add -ins -? select disable items in MANAGE drop down and click go , if BIP add in is there ,then enable ,…

Try this <?for-each-group:PriceBookLinesVORow[contains(CategoryName,'/')];./CategoryName?>. also post what was your exact requirement ,we can able to simplify your layout , Thanks

please post how you are generating xml data ? are you using standalone BIP or from EBS environment ? also what about your source type ? Thanks

Last Page Only Content Note: This feature is supported for PDF and PPT output only. BI Publisher supports the Microsoft Word functionality to specify a different page layout for the first page, odd pages, and even pages. To implement these options, simply select Page Setup from the File menu, then select the Layout tab. BI…

Use <?xdoxslt:ora_format_date(CREATION_DT,'mm/d d/yyyy')?> or <?xdoxslt:format_date(&#129;Date Field,'dd/MM/yyyy','yyyy-MM-dd',$_XDOLOCALE,$_XDOTIMEZONE)?> or place date field in RTF template ,open form field then select desired format and apply changes, Thanks

follow this link Johny's Oracle Tips: BI Publisher: Format Date in XML/BI Publisher

Does report has any parameters , if yes then run report with limited number of parameter values and monitor the processing time , Also you mentioned that you have scheduled the report , your environment is 12c , so get the diagnostic file , to get this file ,schedule the report again and you will find diagnostic tab ,where…

Edit this problematic report --> Click on Properties tab ( on right hand side upper corner) --> Go to Formatting tab a) FO Processing Provide full screenshots showing setting up of properties of "FO Processing" b) EXCEL 2007 Output Provide full screenshots showing setting up of properties of "EXCEL 2007 Output…

Yes ,this is expected behavior with 50k records of output data ,but you can tune the report at two places 1. database level -------use MV'S or GTT etc 2. report level -------setting up report properties(FO processing --this is mainly responsible for processing report output from data to final output) , increase bip server…

You have to handle data model query to accept "all values" and "multiple values" , Also what is your source for bip data model ?

Try place immediate after end of @section group 1) <?if:position()=last()?> paste 3 pages you want to display <?end if?> 2) <?start@last-page:body?> <?end body?> Thanks

one option is possible, keep same table (copy) side by side , and place <?if:count(G_1[position() mod 2=1])!=0?> in front of group in first table , do same for second table but use <?if:count(G_1[position() mod 2=0])!=0? in second table. it will display all odd positions in one side of table and even positions in 2nd table…

Keep <?if:banker id = 123?> after group and <?end if ?> before ending group. If you have still problem ,Please upload xml and Layout

If you have product_number with hard coded value in corresponding group that you want to merge , then follow below link https://blogs.oracle.com/xmlpublisher/formatting-concatenated-datasources

You can hard code username and password in bip report URL, step1: first run bip report step2:copy the https url from the browser and add &NQuser=username&NQpassword=password to this url and hardcode username and password ,then you can run hard coded url from external application. Thanks

Reference Never name it.: Cross tab Summation in RTF

Hello , you want to remove complete row or display null values in place of 123 and 1234 ? Thanks

Upload your documents , Thanks

put this code inside form field 1) <xsl:if xdofo:ctx="cell" test="position()=1"></xsl:if><xsl:attribute xdofo:ctx="block" name="number-rows-spanned"><xsl:value-of select="last()"/></xsl:attribute> Or use below <?C_AWAY[not(.=preceding::C_AWAY)]?> ----where c_away is field name that needs to be suppressed.