These are used to determine the vertical and horizontal positioning of the child objects relatives
Showing posts with label D2k. Show all posts
Showing posts with label D2k. Show all posts
Anchor
Data link
Data links are used to establish parent-child relationship between Queries and Groups via column matches.
SRW Package
- These packages consist of PL/SQL functions, Procedures and exceptions.
- We can refer these Packages in our Reports or Library.
Action Triggers
Action triggers are PL/SQL functions. They are executed before an object being formatted.
Place Holder Column
It is used to hold the calculated value at a specific place rather than allowing it appearing in the actual row, when it has to appear.
Summary columns
Summary columns are computed their values by using built-in functions of Oracle Reports.
Formula columns
- Formula columns are computed their values by using PL/SQL expressions.
- They operate on multiple values per a record.
Report triggers
- BEFORE_PARAMETER_FORM
- AFTER_PARAMETER_FORM
- BEFORE_REPORT
- BETWEEN_PARAMETER
- AFTER_REPORT
Components of Report Builder
- Object Navigator
- Property palette
- Layout model editor
- Data model editor
- Parameter form editor
Alert
It is an object, used for decision making message.
It is three types..
- None
- Stop
- Caution
Query triggers
- Pre Query: It is fired once for all fetched records.
- Post Query: It is fired for each fetched records.
Firing triggers for form
Firing triggers for form…
- PRE_FORM
- PRE_BLOCK
- PRE_RECORD
- PRE_TEXT_ITEM
- WHEN_NEW_FORM_INSTANCT
- WHEN_NEW_BLOCK_INSTANCE
- WHEN_NEW_RECORD_INSTANCE
- WHEN_NEW_ITEM_INSTANCE
- POST_TEXT_ITEM
- POST_RECORD
- POST_BLOCK
- POST_FORM
NEW_FORM
- 'Calling (new) form' will be activated.
- 'Called (old) form' will be deactivated.
CALL_FORM
CALL_FORM is used to call one form to another form .
Here 'calling (old) form' will be deactivated. After exit from the form 'called form' control goes back to calling Form.
- CALL_FORM (form_name, display, switch_menu, parameter_list);
RUN_PRODUCT
We call a Form or Report or Graphics by using RUN_PRODUCT.
- RUN_PRODUCT (product name, 'path', Synch/Asynch, 'run_mode', parameters);
Record Group
Record Group is an object. It is a collection of records fetched based on a SELECT statement.
They are …
- Static
- Query based
- Non query based
List of Values
List of Values (LOV) is an object that opens up a separate window displacing the values from one or more tables
Subscribe to:
Posts
(
Atom
)
>
