Various Oracle Reports infomation.

Various page layout sections in Oracle Reports .

A report has three sections : 

  • the report header pages, 
  • report body/margin pages, 
  • and report trailer pages.

Various types of parameters. 

There are two types of parameters: 

  •  default (system parameters)
  •  user-created (bind and lexical parameters)

Reference parameters and columns in reports . 

There are two ways to reference a parameter in Oracle reports: 

* As bind references

* As lexical references 

Bind Referencing and Lexical Referencing. 

Bind Referencing : Bind references are used to replace a single value in SQL or PL/SQL, such as a character string, number, or date. Use bind reference when you want the parameter to substitute only one value at runtime. Specifically, bind references may be used to replace expressions in SELECT, WHERE, GROUP BY, ORDER BY, HAVING, CONNECT BY, and START WITH clauses of queries. 

Lexical Referencing : Lexical references are placeholders for text that you embed in a SELECT statement. Use Lexical reference when you want the parameter to substitute multiple values at runtime. You can use lexical references to replace the clauses appearing after SELECT, FROM, WHERE, GROUP BY, ORDER BY, HAVING, CONNECT BY, and START WITH. 

Types of Matrix report. 

 1. Single query 

 2. Multi query

 3. Nested Query 

 4. Matrix Break

 Widow lines ? 

Widow lines are the minimum number of lines of the boilerplate text or field that should appear on the logical page where the text starts to print. If the number of lines specified for this property cannot fit on the logical page, then all lines of the boilerplate are moved to the next page. 

Widow records.

Widow records are the minimum number of instances (records) that should appear on the logical page where the repeating frame starts to print. If the number of instances specified for this property cannot fit on the logical page where the repeating frame is initially triggered to print, then the repeating frame will start formatting on the next page. 

‘page protect’ property for objects.

Page protect property for an object indicates whether to try to keep the entire object and its contents on the same logical page. Checking Page Protect means that if the contents of the object cannot fit on the current logical page, the object and all of its contents will be moved to the next logical page. 

‘Print Condition Type’ property. 

‘Print Condition Type’ property specifies the frequency with which you want the object to appear in the report. The Print Condition Type options indicate the logical page(s) on which the object should be triggered to print with regard to the Print Condition Object.

 ‘Print Condition Object’ property . 

‘Print Condition Object’ property specifies the object on which to base the Print Condition Type of the current object. For example, if you specify a Print Condition Type of All and a Print Condition Object of Anchoring Object, the current object will be triggered to print on every logical page on which its anchoring object (parent object) appears.

 Various values of the ‘Print Condition Object’ property in Reports. 

The various values are : 

  • Anchoring Object : Anchoring Object is the parent object to which the current object is implicitly or explicitly anchored.
  • Enclosing Object : Enclosing Object is the object that encloses the current object.

Horizontal of Vertical sizing property of objects. 

Horizontal of vertical sizing property specifies how the horizontal or vertical size of the object may change at runtime to accommodate the objects or data within it.

Advertisements

About Oracle Technology Blogs
Oracle Application Development

One Response to Various Oracle Reports infomation.

  1. Pingback: Oracle Technology Blogs

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: