1.How to generate report in PDF directly instead of from HTML to PDF in BI Publisher from Browser?
Hi All,
One solution has been found to generate the report
directly in PDF format instead of generating the from html to PDF.
Steps
to follow are below.
A.Open
the file “_report.xdo” which will
be located in the <Report_Name>.xdo folder
EX:
DetailedCustomerReportAdhoc.xdo
In file search for “label” in that line change the
below attributes.
1.From outputFormat="html,pdf,rtf,xlsx,pptx"
to outputFormat="pdf"
2.From defaultFormat="html"
to defaultFormat="pdf"
For Ex:
Change
From below line
<template label="test1"
url="DetailedCustomerReportAdhoc1.rtf" type="rtf" outputFormat="html,pdf,rtf,xlsx,pptx"
defaultFormat="html" locale="en_US" disableMasterTemplate="true"
active="true" viewOnline="true"/>
To
<template label="test1"
url="DetailedCustomerReportAdhoc1.rtf" type="rtf" outputFormat="pdf"
defaultFormat="pdf" locale="en_US"
disableMasterTemplate="true" active="true"
viewOnline="true"/>
B.After
changing the file Go to catalog select the required report
and click on edit as shown below
C.After
that click on save button and click View Report as shown below
If
still the report is getting viewed directly in HTML. Check the _report.xdo file
where the Step 1 done changes are there are not.
If
not please follow once again the steps mentioned above.
2.Useful Links for BIP
http://bipublisher.blogspot.in/2012/02/bi-publisher-xdotop-msword-debugging.html
2. How to Set up the Debug On for BIPUBLISHER?
Steps to Turn ON Logging for BI Publisher for Reports debugging
1.Create a folder xdolog and place it under
<Middleware_Home>/user_projects/domains/bifoundation_domain/config/bipublisher
This has to be used in LogDir parameter in step 2.
Note: The above mentioned path is optional .You can create it anywhere
2.Create a file named xdodebug.cfg and place it under
<Middleware_Home>/Oracle_BI1/jdk/jre/lib/
3.Add below listed lines in xdodebug.cfg file
Under Windows
LogLevel=STATEMENT
LogDir=c:\<Middleware_Home>\user_projects\domains\bifoundation_domain\config\bipublisher\xdolog
Under Unix:
LogLevel=STATEMENT
LogDir=<Middleware_Home>/user_projects/domains/bifoundation_domain/config/bipublisher/xdolog
4.Retest the issue
5.Check the files created in the specified LogDir (xdolog) directory.Here you can see XDO.log
6.Remove xdodebug.cfg when finished replicating the issue.
The logging is specifically useful for troubleshooting the Template(RTF/PDF) or Data File(XML file) specific issues. The generated XML file is the actual data file which is run from the MS Word Design Helper Preview mode to narrow down the issue.
3.How to create dynamic query execution in BI Publisher?
In the XDM we have so many DATASETS. Based on some parameters we can have conditional query preparation and execution.
SYNTAX:
create sql dataset with following query
$if{ (:PARAM == VALUE) }$
select 'ravi' as X from dual
$elsif{(:PARAM == VALUE1 )}$
select 'kale' as Z from dual
$else{
select 'TEJ' as Y from dual
}$
$endif$
POINTS TO REMEBER:
1. At least One if and one else is mandatory
2.We should not use the double quotes(") or single quotes ('), if the VALUE is string or character.
EX: a. ravi --> Correct
b. 'ravi' --> Not Correct
c. "ravi" --> Not Correct
EXPLANATION:
While the XDM is exectuing when the above code encounters then the when the inputted parameter is equal value i.e, when the condition satisfies then only the corresponding query executes. Not all the queries executes.
4.How to show Images in generated PDF using RTF Template?
We have 4 solutions. Those solution are available in My Google Drive (BI Publisher/dynamicImages.zip)
