Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Comments
-
Use the expression which Rajesh123 gave (<?ABC?> should be defined as BI Publisher Field) Put in one column tag <?if:string-length(ABC) != '0 '?> <?ABC?> <?end if?> <?if:string-length(ABC) = '0 '?> <?DEF?> <?end if?>
-
Iam sure it should be possible using xml tags in bi publisher. But, why dont you try using formula field in RDF and get the value using SQL query. This is not linked to original query and will return value irrespective of query returning rows.
-
whatever columns you specify in your etext layout, only those appear. Please check some samples which are available in BI Publisher installed directory. i.e. for ex:- C:\Program Files (x86)\Oracle\BI Publisher\BI Publisher Desktop\Template Builder for Word\samples\eText templates
-
Although I haven't not tried, but checked this URL Vishal's blog: Coding different page layouts in a single rtf template and the importance of Contexts in BI Publisher Probably it may be helpful to you.
-
whatever columns you specify in your etext layout, only those appear. Please check some samples which are available in BI Publisher installed directory. i.e. for ex:- C:\Program Files (x86)\Oracle\BI Publisher\BI Publisher Desktop\Template Builder for Word\samples\eText templates
-
Try changing in backend using to_char for ex:- SELECT to_char(108767,'99999G990D00', 'NLS_NUMERIC_CHARACTERS = '',.''') FROM DUAL . In RTF template, documentation says you can use format-number with decimal-format, but i have not used it. for ex:- <xsl:decimal-format name="european" decimal-separator=','…
-
Please use <?xdofx:replace(Text_2_GV_ID2,chr(10),' ')?> in RTF, for replacing newline with space. But, now it removes even other newlines. Please alter accordingly.
-
Submit BI publisher report using pl/sql code using FND_REQUEST.SUBMIT_REQUEST call and call below code to call XML bursting FND_REQUEST.SUBMIT_REQUEST (application => 'XDO', program => 'XDOBURSTREP', description => NULL, start_time => NULL, sub_request => FALSE, argument1 => 'N', argument2 => TO_CHAR(l_req_id)); -- request…
-
use url:{concat('${OA_MEDIA}','/','logo.gif')}
-
You need to run from server and check It works for all of our reports.
-
I believe you are using eText sample template, refer to samples which will be available in BI Publisher installed directory for ex:- C:\Program Files (x86)\Oracle\BI Publisher\BI Publisher Desktop\Template Builder for Word\samples\eText templates\example1
-
Not sure if this could be solution but, I think you can go for temporary table (which gets populated from pl/sql package )which can be used in another query