I have this function in report builder with only one variable which is equl many variable and want to make line break between them in the report output same like this

-amount in words
-note to suplier
-price basis
-completion date
-payment terms
-note

this is my function

function CF_R_FOOTERFormula return Char is
FOOTER_REPORT VARCHAR2(5000) :=NULL;
begin
IF :LINE_TYPE='Service' THEN
FOOTER_REPORT :=(:CF_amount_in_words
||:CF_note_to_suplier
||'PRICE BASIS: '||:PRICE_BASIS
||'COMPLETION DATE :'||:CF_need_by_date
||'PAYMENT_TERMS'||:PAYMENT_TERMS
||'SUPPLIER_NOTE'||:SUPPLIER_NOTE
||'NOTE:'
||'1.Kindly acknowledge receipt of the Work order and arrange to complete the work as per the completion date.'
||'2.Please ensure that your account number and full banks details are clearly indicated in your invoice for easy TT');

END IF;
RETURN FOOTER_REPORT;
end;


please help me if there is any function to do break line

you can use in concatenation CHR(10) to do break line

FOOTER_REPORT := :cf_1 || CHR(10) || :CF_2;

the output will be like the below

CF_1 Value

CF_2 Value

note that ascii code of line break is 10

تم تعديل 18 أغسطس 201114 سنة بواسطة mah6326955