Answers were Sorted based on User's Feedback
Answer / malleswar
The trigger can be used to dynamically change the
formatting attributes of the object. Format triggers are
PL/SQL functions executed before the object is
formatted.The function must return a Boolean value (TRUE or
FALSE). Depending on whether the function returns TRUE or
FALSE, the current instance of the object is included or
excluded from the report output. You can access format
triggers from the Object Navigator, the Property Palette,
or the PL/SQL Editor.
|Is This Answer Correct ?||6 Yes||0 No|
Answer / samaresh
A format trigger can fire multiple times for a given
object, whenever Reports Builder attempts to format the
object. Consider the case where Reports Builder starts to
format the object at the bottom of a page. If the object
does not fit on the page, Reports Builder stops formatting
and reformats on the following page. In this case, the
format trigger will fire twice. It is therefore not
advisable to do any kind of "persistence" operation, such
as logging, in this trigger.
The Reports Builder SRW built-in package contains PL/SQL
procedures with which you can quickly change the format
attributes of an object.
These include procedures to:
change the border pattern and color of an object change the
interior pattern and color of an object change the font
size, style, weight, spacing, and justification of a field
or boilerplate text change the format mask of a field
access a field's value
|Is This Answer Correct ?||2 Yes||1 No|
Answer / ramesh babu v
It formats the data before displaying output data.It is the
pl/sql function and it returns the boolean
values(TRUE/FALSE).If return TRUE the layout displays.
|Is This Answer Correct ?||0 Yes||0 No|
in order to run utl_file package we need to give any specific path? if yes what is that?where u will run utl_package?
What do you understand by soa and what are the benefits of using this architecture?
in interface and conversion if 10 records are error out we can't load the records?if >10 we have to insert,if we not insert we need to gernerate error how u can achieve?
What is the link between AP and GL in oracle apps R/12?
WHAT IS THE USE OF SKIP WHERE U WILL GIVE?
What are different execution methods of executabls?
what is aim methodolozy
What and Who is the best Institute or Trainer for Oracle Apps Technical ?
While importing data into interface tables,if u got number of records are error(like more than 1000 records are error),how to imform user?
in sql *loder how to skip the middle records ex:from 10th to 20th records i want to skip?
in which tables the transaction details stored? at least two.
tell me the scenarios of the independent in reports