in the Add help Text use this <?xdofx:TO_CHAR(fieldname, '9,999,999.99')?> or <?xdofx:TO_CHAR('9,999,999.99')?>; might help u

https://docs.oracle.com/cd/E23943_01/bi.1111/e22254/extend_func.htm#BIPRD3163

Have u tried to_char () in ur orginal query????

<?format-number(Line_number, '#,##0.00', 'myFMT')?>

post ur sample query which ur using and sample xml

Or u can format in sql data model by using https://docs.oracle.com/cd/A87860_01/doc/server.817/a85397/sql_elem.htm#34512

<span class="pln" style="font-style: inherit; font-weight: inherit; font-family: inherit; color: #303336;">TO_CHAR</span><span class="pun" style="font-style: inherit; font-weight: inherit; font-family: inherit; color: #303336;">(<span style="font-weight: bold; font-size: 12px; font-family: Arial, Tahoma, Verdana;…

Use it in ur sql query

try this <?format-number:fieldname;’999G999D99′?> https://docs.oracle.com/middleware/12211/bip/BIPRD/GUID-7BD3C665-851A-43FE-BA2D-7501390D95AC.htm#BIPRD2566

select to_char(to_date(floor(6978.09),'J'),'Jsp')||' and '|| to_char(to_date((6978.09-(floor(6978.09)))*100,'J'),'Jsp') from dual

I think this is what ur looking for https://blogs.oracle.com/xmlpublisher/wildcard-filtering-continued

Check if this comes any handy https://it.toolbox.com/question/issue-in-displaying-french-characters-in-xml-publisher-report-071609

<?xdofx:if column ='ES' then ’Spain’ else if column ='M' then ’Male’ end if?> U can try this but this is a condition formating

Thas good if u think u find a solution for this close the thread so that it will be useful for other when searching

Mark ur respective correct answer as correct

go to the original post not looking in to ur box. click on and then u can c options

I am sorry my bad I thought both are same.

did u Tried creating in a different browser

Y dont u create a subtemplate and call that sub template in rtf which might help.

Y don`t u add this logic in sql in data model that should work. else https://docs.oracle.com/middleware/12212/bip/BIPRD/GUID-04477E49-F671-4BF1-8353-06A7CDEAD2CC.htm#BIPRD2484