إنتقال للمحتوى

  • تسجيل الدخول عبر الفيس بوك تسجيل الدخول عبر تويتر Log In with LinkedIn Log In with Google      تسجيل دخول    
  • إنشاء حساب

صورة
- - - - -

Break Line Between Variable In Report Function


1 رد (ردود) على هذا الموضوع

#1 khalid806

khalid806

    عضو

  • الأعضــاء
  • 3 مشاركة
  • الاسم الأول:khalid
  • اسم العائلة:alhosni
  • البـلـد: Country Flag
  • المنصب الحالي:Senior Application Administrator

تاريخ المشاركة 17 August 2011 - 11:13 AM

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

#2 Mahmoud Ahmed El-Sayed

Mahmoud Ahmed El-Sayed

    عضو نشط

  • الأعضــاء
  • 346 مشاركة
  • البـلـد: Country Flag
  • الاهتمامات:Database Design, Programming and Sports

تاريخ المشاركة 18 August 2011 - 04:57 PM

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


تم التعديل بواسطة mah6326955, 18 August 2011 - 04:58 PM.

Mahmoud Ahmed El-Sayed

Senior Oracle Forms & ADF developer @ MCIT

Dive in Oracle Blog