 |
|
Oracle Tips by Burleson |
Building
a Report Using the Report Wizard
The report wizard will help build a report very
quickly. In most cases, the initial report can be built in two to
three minutes. No joke! The more comfortable one gets with HTML DB,
the easier it will be to do the same.
Do not let the fact that a report can be built in
a matter of minutes fool you into thinking it is not valuable. After
the initial report is created, there are several customizations that
can be made to the report to provide additional features.
This section of the chapter is focused on
rebuilding the report part of the Conference RSVP report in the
application that was created earlier. This is page one of the
Conference RSVP application. Some of the columns will be formatted,
and in the following sections, a couple of features will be added.
This is a lengthy tutorial, but these exercises
will provide exposure to a few of the more esoteric features of HTML
DB. The skills learned here can be applied to other areas of HTML DB
development. It should be well worth the time.
Navigate to the Conference RSVP application by
clicking on the Application Builder icon and then by clicking on the
Conference RSVP link in the report of applications.
1.
Click on the Create Page button.
2.
Choose the Report option and click Next.
3.
Choose the SQL Reportoption
and click Next.
This is the most common way to create
reports for beginners. As new users get more comfortable with HTML
DB, they may choose either method, but I still prefer using the Wizard
Report wizard.
4.
On the Page Attributes page:
This is the text that will be displayed on
the caption bar of the browser. It is also displayed as the name when
viewing all pages in an application.
5.
On the Tab (optional) page:
6.
On the SQL Query page, enter the following in the text area and
click Next. Use file ch7_1.sql from code depot.
Notice there is no semi-colon on the end of the SQL
statement. This is because HTML DB appends more SQL on the end of
this statement if sorting in reports is allowed. Having the
semi-colon will produce a common error (ORA-00911: invalid
character) and can lead to more debugging.
7.
On the Report Attributes page:
-
Region Template: Reports Region.
-
Report Template: template: 2. Standard
-
Region Name: Conference – Confirmed Attendees
-
Maximum Rows per Page: 15
At this point, the number of rows that
will appear on each page can be changed. This is referred to as
paginationand is used to restrict
the number of rows displayed at a time. Later, a Select List will be
added to the application page to make this a user selectable option.
8.
On the Confirm page click Finish.
9.
When the success page displays, click on the Run Page icon.
At this point, the
report shown in Figure 7.1 will have been created. There is still
some customizing to do to add the Spread Sheet link, some buttons, the
search field, and number of rows to display.
The above book excerpt is from:
Easy HTML-DB
Oracle Application Express
Create Dynamic
Web Pages with OAE
ISBN 0-9761573-1-4
Michael Cunningham & Kent
Crotty
http://www.rampant-books.com/book_2005_2_html_db.htm
|
