Use Conditional formatting might solve ur issue

Shows u how to create and drill u report http://www.oracle.com/webfolder/technetwork/tutorials/obe/fmw/bi/biee/r1013/bipub/advance/advance.htm

IF u want to get the output u cant call the stored procedure with out parameter . U have to convert the procedure to function to get the output.

it is possible using Event Triggers. This feature is available from version 11.1.1.6. You can refer documentation here https://docs.oracle.com/cd/E23943_01/bi.1111/e22258/add_event_trig.htm#BIPDM331 Update: As per documentation only functions are allowed. "The BI Publisher data model supports before data and after data…

In addition to ​ where u select the parameter type menu at the bottom u have an option

click on the option multiple selection use comma or semi colon

is the same webservice data ur using or different

<?xml version="1.0" encoding="UTF-8"?> <DATA_DS> <G_1> <SYSDATE>2018-04-06T10:54:08.000-05:00</SYSDATE><FISICAL_PERIOD>APR-06</FISICAL_PERIOD> </G_1> </DATA_DS> If this one is upload in rtf and shown output in excel it shows me in all caps in .xlsx excel output

which excel version ur using..

excel 2013 is ur excel output is in .xsl or .xslx

https://docs.oracle.com/middleware/12211/bip/BIPRD/GUID-142C47DC-2B6F-4FB4-9512-4EA14467D9A0.htm#BIPRD3328

Try the excel report and let me what issue ur getting over der instead of excel2000

attach ur rtf template..

post ur sample xml and rtf template ur using can help u out.

Might be some help https://docs.oracle.com/middleware/12211/bip/BIPRD/GUID-7BD3C665-851A-43FE-BA2D-7501390D95AC.htm#BIPRD2568

This might be of some help https://apps2fusion.com/at/ps/262-xml-publisher-and-data-template-sql-query-to-develop-bi-publisher-reports

<?xdofx:if statement= XXX then 'mmm' else if statement= = 'YYY' then 'dddd' end if?>

well when I am trying the sample out put which was given shows me same in all the terminal..

it does not change..