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

كيف اغير لون أي عنصر في التقرير بناءً على قيمته


zedan

Recommended Posts

  • بعد 7 شهور...

Setting Format Attributes:
The SRW.SET_<attributes> packaged procedures apply specified format attributes to the current layout object: frame, repeating frame, field, or boilerplate object.
Why Use a Format Attribute?
Some of the reasons that you would want to use format attributes are:
 To change the visual appearance of layout objects conditionally, depending on values in a repeating frame, or on run-time parameter values
 To switch to different printer trays as your report formats
 To place a logo or standard links in an HTML document
 To define a bookmark in an HTML or PDF document Coding a Format Attribute
You can code the packaged procedure in a function as a local or report-level program unit, or in a PL/SQL library. This is useful if you want a common format attribute in more than one object or more than one report. You can then call the function whenever required, from the format trigger of a specific object.
As an alternative to a PL/SQL library, in the Object Navigator you can drag and drop report-level program units between different reports. However, note that this creates a copy of the program unit in each report, rather than a reference to one piece of code.
Example:
Conditionally set the following attributes if salary equals 2000:
FUNCTION SAL_MASK RETURN BOOLEAN IS
BEGIN
IF :SALARY > 2000 THEN
SRW.SET_BACKGROUND_FILL_COLOR(‘darkyellow’);
SRW.SET_FILL_PATTERN(‘sandpaper’);
SRW.SET_FONT_STYLE(SRW.ITALIC_STYLE);
SRW.SET_FONT_FACE(‘helvetica’);
SRW.SET_FONT_WEIGHT(SRW.EXTRABOLD_WEIGHT);
SRW.SET_TEXT_COLOR(‘darkblue’);
END IF;
RETURN(TRUE);
END;

رابط هذا التعليق
شارك

  • بعد 2 شهور...

انضم إلى المناقشة

يمكنك المشاركة الآن والتسجيل لاحقاً. إذا كان لديك حساب, سجل دخولك الآن لتقوم بالمشاركة من خلال حسابك.

زائر
أضف رد على هذا الموضوع...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   تمت استعادة المحتوى السابق الخاص بك.   مسح المحرر

×   You cannot paste images directly. Upload or insert images from URL.

جاري التحميل
×
×
  • أضف...

برجاء الإنتباه

بإستخدامك للموقع فأنت تتعهد بالموافقة على هذه البنود: سياسة الخصوصية