Monday, 21 January 2019

How to display a Character like "&", "/" between Text in RTF Template

https://xmlpublishertemplate.blogspot.com/2019/01/how-to-display-character-like-between.html

You can write like below for PDF Output

select   distinct   substr( ' & '||trx_type.name,2)  TRX_TYPE_NAME
from 
ar_customers cust
 ,Ra_Cust_Trx_Line_Gl_Dist_All trx_gl,
 gl_code_combinations gcc,
ra_customer_trx_all trx_all,
       ra_cust_trx_types_all trx_type,  -- ,   -- 25 JUL 2011
   gl_code_combinations gcc2   
where
trx_all.org_id between nvl(:FR_ORG_ID,:P_ORG_ID) and nvl(:TO_ORG_ID,:P_ORG_ID)
and  trx_all.org_id  =  :P_ORG_ID
and trx_all.trx_date between  UPPER(nvl(:frdate,'01-JUL-94')) and  UPPER(nvl(:todate,Sysdate))
and gcc.CODE_COMBINATION_ID=trx_gl.CODE_COMBINATION_ID
and trx_gl.CUSTOMER_TRX_ID=trx_all.CUSTOMER_TRX_ID
and cust.CUSTOMER_ID=trx_all.BILL_TO_CUSTOMER_ID
and gcc.SEGMENT2 = nvl(:location,gcc.SEGMENT2)
and cust.CUSTOMER_name like nvl(:cust_name,cust.CUSTOMER_name)
and trx_type.name LIKE  NVL(:inv_Type,'%')
and  trx_all.cust_trx_type_id = trx_type.cust_trx_type_id
and  trunc(trx_gl.GL_DATE) <=  nvl(:p_term_due_date_to,trx_all.term_due_date)
and  trx_type.GL_ID_REC = gcc2.CODE_COMBINATION_ID
and  gcc2.SEGMENT4 = :ACCOUNT_GRP;


In RTF Template add in Text form Field Options

<?substring(TRX_TYPE_NAME,4)?> 


The Result will be like

ELT & TIU & LKK


No comments:

Post a Comment