DBSkool Header Image Background

Category: Report_ExpressivePage 1 of 2

Reusable objects and code

1. Write Benefits of Reusable objects and code? • Increases productivity • Decreases maintenance • Increases modularity • Maintains standards • Improves application performance 2. What is property…

Building Reports: Efficiency Guidelines

1. What is Flexible Code? Flexible code is code that is reusable. It is often generic code that we can use in any form module in an application….

Maximizing Performance Using Oracle AS Reports Services

1. Write Commit Sequence of Events? • Validate the form • Process savepoint • Fire the Pre-Commit trigger • Validate the block • Perform the DML • Fire…

Extending Functionality Using the SRW Package

1. What is the navigational unit? The navigational unit is an invisible, internal object that determines the navigational state of a Form. It can be one of the…

Coding PL/SQL Triggers

1. Write the validation Levels. Forms perform a validation process at several levels to ensure that records and individual values follow appropriate rules. Forms validates at the following…

Enhancing Matrix Reports

1. What is Pre-Query Trigger? Pre-Query Trigger defined at block level or above. It fires once, before query is performed. We can use Pre-Query to: • Test the…

Creating and Using Report Parameters

1. What is user Parameter? A user Parameter is a data model object that we create to hold a value that users can change at run time. 2….

Web Reporting

1. Compare static & dynamic reports -Static describes something that is fixed and unchanging. A static report is one that displays the same data each time the report…

Specific Properties

1. What is repeating Frame? A repeating Frame is record-related, and its properties allow us to modify specific attributes associated to the display of the records. 2. Write…

Controlling the Paper Layout: Common Properties

1. Write the types of object elasticity(size). The four types of objects elasticity are- • Fixed • Expand • Contract • Variable 2. What is format trigger? A…