 |
|
Oracle Tips by Burleson |
Report
Attributes
Throughout the
exercises in this chapter, the Region Definition and Report Attributes
pages have been used several times. The Region Definition page was
described in an earlier chapter. This section will describe, in
detail, the regions and attributes on the Report Attributes page.
Column Attributes
This region represents the most common attributes
a developer would want to make changes to. To make addition changes
to a column click on  .
Headings Type
This will dictate the way the column headings are
displayed. The options are self-explanatory except for the PL/SQL
type. The PL/SQL option could be selected to dynamically have the
column headings generated at run time. A PL/SQL function could then
be provided that returns a colon delimited list of values to be
rendered as the column headings. A simple example for page 11 from
above would be:
return 'id:last:first:email:phone:rsvp:company:donation:pmt';
This is not used very often, but it could be used
in a multi-language implementation. One use for something like this
would be in a banking application. At one bank, the teller can hit a
button and the text on the screen switches to Spanish so the customer
can read the information on the screen. Using PL/SQL, the data could
be queried from a language translation table in the database and
return the colon delimited string. The return values would then be
used in the report headings.
Layout and Pagination
Report Template
Report templates control how the rows are
displayed in reports. Several templates are built-in and available
regardless of the theme used, and several templates are provided in
the themes.
Built in Report
Templates
Figure 7.14 shows the list of report templates.
Notice the prefixes in the list are default:, export:, and template:
2.
Table 7.1 below includes descriptions for the
types of report templates.
|
DEFAULT |
BUILT-IN TEMPLATES. |
|
Export |
The user is provided with a File Download
dialog box when this type of report is rendered. This type of
report makes it very easy to provide download capabilities. The
report can be developed using another template, then once it is
perfected, change it to export before deployment. If this type of
template is used, it is best not to have other page components;
just the report. |
|
Template: 2. |
This indicates the report template is
provided as a template in Theme 2. |
Table 7.1:
Report template prefixes
Pagination Scheme
The Pagination Scheme will select the look of the
pagination area on the report. Table 7.2 shows examples of the
selection:
|
PAGINATION SCHEME |
EXAMPLE |
|
Row Ranges 1-15 16-30 (with set pagination) |
|
|
Row Ranges 1-15 16-30 in select list (with
pagination) |
|
|
Row Ranges X to Y (no pagination) |
|
|
Row Ranges X to Y of Z (no pagination) |
|
|
Row Ranges X to Y of Z (with pagination) |
|
|
Search Engine 1,2,3,4 (set based pagination) |
|
|
Row Ranges X to Y (with next and previous
links) |
|
Table 7.2:
Pagination scheme examples
 |
For more details and scripts, see my new book "
Oracle
Tuning: The Definitive Reference", over 900 pages
of BC's favorite tuning tips & scripts.
You can buy it direct from the publisher for 30%-off and get
instant access to the code depot. |
|
