Misc Oracle Reports Information.

Various values of the horizontal of vertical sizing property. 

The various values are :

Contract : Contract means the vertical size of the object decreases, if the formatted objects or data within it are short enough, but it cannot increase to a height greater than that shown in the editor. Note : Truncation of data may occur. (You can think of this option as meaning “only contract, do not expand.”) 

Expand : Expand means the vertical size of the object increases, if the formatted objects or data within it are tall enough, but it cannot decrease to a height less than that shown in the editor. (You can think of this option as meaning “only expand, do not contract.”) 

Fixed : Fixed means the height of the object is the same on each logical page, regardless of the size of the objects or data within it. Note : Truncation of data may occur. The height of the object is defined to be its height in the editor. 

Variable : Variable means the object may expand or contract vertically to accommodate the objects or data within it (with no extra space), which means the height shown in the editor has no effect on the object’s height at runtime. 

Display a message in reports. 

Using SRW.Message 

Various values of ‘Print Panel Order’ property of report. 

The various values are :

  • Across/Down : Across/Down means the physical pages of the report body will print left-to-right then top-to-bottom.
  • Down/Across : Down/Across means the physical pages of the report body will print top-to-bottom and then left-to-right.

‘Print Direction’ Property of Repeating frames. 

‘Print Direction’ Property specifies the direction in which successive instances of the repeating frame appear. 

Various values of the ‘Print Direction’ Property of Repeating frames ?

Following are the various values :

  • Across : Across means that each instance of the repeating frame subsequent to the first instance is printed to the right of the previous instance across the logical page.
  • Across/Down : Across/Down means that each instance of the repeating frame subsequent to the first instance is printed to the right of the previous instance until an entire instance cannot fit between the previous instance and the right margin of the logical page. At that time, Oracle Reports prints the instance below the left-most instance on the logical page, provided there is enough vertical space left on the logical page for the instance to print completely.
  • Down : Down means that each instance of the repeating frame subsequent to the first instance is printed below the previous instance down the logical page.
  • Down/Across : Down/Across means that each instance of the repeating frame subsequent to the first instance is printed below the previous instance until an entire instance cannot fit inside the bottom margin of the logical page. At that time, Oracle Reports prints the instance to the right of the topmost instance on the logical page, provided there is enough horizontal space left on the logical page for the instance to print completely.

‘Keep with Anchoring Object’ object property. 

‘Keep with Anchoring Object’ object property indicates whether to keep an object and the object to which it is anchored on the same logical page. Checking Keep with Anchoring Object means that if the object, its anchoring object, or both cannot fit on the logical page, they will be moved to the next logical page. 

‘Page Break Before’ object property. 

‘Page Break Before’ object property indicates that you want the object to be formatted on the page after the page on which it is initially triggered to print. Note that this does not necessarily mean that all the objects below the object with Page Break Before will move to the next page. 

‘Page Break After’ object property. 

‘Page Break After’ object property indicates that you want all children of the object to be moved to the next page. In other words, any object that is a child object of an anchor (implicit or explicit) to this object will be treated as if it has Page Break Before set. Note that this does not necessarily mean that all the objects below the object with Page Break After will move to the next page. 

‘Break Order’ property of columns. 

The ‘Break Order’ property is the order in which to display the column’s values. This property applies only to columns that identify distinct values of user-created groups (i.e., break groups). The order of column values in a default group is determined by the ORDER BY clause of the query. For column values in user-created groups, however, you must use Break Order to specify how to order the break column’s values.

 Various types of links. 

The Data Link tool draws a link between a parent group and a child query. Creating a link is a drag and drop operation. Clicking and dragging from one column to another creates a link between those two columns (column to column link). Clicking and dragging from one query to another creates all possible links between columns selected by the queries based on database constraints (query to query link). Clicking and dragging between two groups creates a group-to-group link (i.e., a link with no columns). 

Some of the procedures in the SRW package. 

* SRW.Message, SRW.User_Exit, SRW.Do_Sql, SRW.Run_Report 

Report layout regions.

 There are three report regions in the Layout editor : 

  •  header
  •  body/margin
  •  trailer

Brief Description of the various report layout regions. 

Header : The report header pages appear once at the beginning of each report on a set of separate pages. They can contain text, graphics, data, and computations. 

Body/Margin : The body/margin pages appear between the header and trailer pages, and are the bulk of the report. Each physical page in this section consists of a body and a margin. The body contains the majority of the report’s text, graphics, data, and computations.

         A top and bottom margin appear on each page, until all data within the body has been formatted. A margin may include text, graphics, page numbers, page totals, and grand totals. The default margin size is one half inch each for the top and bottom margins and zero for the left and right margins. 

Trailer : The report trailer pages appear once at the end of each report on a set of separate pages. They can contain text, graphics, data, and computations. 

More efficient : Maximum rows or Group Filter. 

Maximum Rows in the Query property sheet restricts the number of records fetched by the query. A group filter determines which records to include and which records to exclude. Since Maximum Rows actually restricts the amount of data retrieved, it is faster than a group filter in most cases. If you are using a Filter of Last or Conditional, Oracle Reports must retrieve all of the records in the group before applying the filter criteria. As a result, Maximum Rows or a Filter of First is faster.

 

Advertisements

About Oracle Technology Blogs
Oracle Application Development

One Response to Misc Oracle Reports Information.

  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: