Create a classic or visual report
There are two types of reports:
You begin the process of creating either type of report with
the Report Wizard. The Report Wizard opens when you have query results
in the active window and you:
- Select Results--> Display Report from
the main menu.
- Select Results--> Display Report from
the Actions window.
Using the Report Wizard
You begin the process of creating a report with the Report
Wizard. The Report Wizard helps you find the dialogs you need to
create a new or open an existing report. The process flows as follows:
- You specify that you are creating a new report or opening an
existing report stored in a file or saved on the database server.
- If you are opening an existing report stored in a file or saved
on the database server, the dialogs that you need to open the existing
report are presented to you. Based on your input, the Report Wizard
opens the existing report.
- If you are creating a new report, then you specify whether you
will be creating a classic report or a visual report. Based on your
input, the Report Wizard opens the dialogs that you need to create
the report.
Table 103. Report Wizard
Field |
Description |
Report Wizard Type page |
- Select Create a new report to create a
new classic or visual report. The Report Wizard New Report page
opens.
- Select Use an existing report stored at a server to open
an existing report that has been saved at the database server. The
Report Wizard Open from Server page pens.
- Select Use an existing report stored at a file to open
an existing report that has been stored in a file. The Report Wizard
Open from file page opens.
|
Report Wizard New Report page |
- Select Create a visual report to create
a new visual report. Specify whether the new report will be generated
using the formatting that has been applied to the current query
results or very basic, default formatting. The report opens in
the Visual Report window.
- Select Create a classic report to create
aa new classic report. Specify whether the new report will be generated
using the formatting that has been applied to the current query
results or very basic, default formatting. The report opens.
|
Report Wizard Open from Server |
Specify the database server, the owner and the
name of the visual report or a form for a traditional report that
you want to open. You can use the List button
to search the database to see a list of the visual reports or forms
that are on the database server. |
Report Wizard Open from file |
Specify the Name of the
file or use the Browse button to search for
the file. |
Create a new classic or visual report
Follow these steps to create a new classic or visual report:
- Select Query--> Run to run a
query and obtain query results.
- Optional: Use the Query results Explorer
and the formatting options to format the query results in the active
window. When either the classic or visual report is created, the
formatting that is applied to the report is taken from the query
results or the default report specifications.
- Select Results--> Display Report from
either the main menu or a context menu.
The Report Wizard opens.
- Select Create a new report from the Report
Wizard Type page. Select Create a classic report or Create a visual report from
the Report Wizard New Report page.
- Since this is a new report, and there is no assigned form or
formatting instructions, you must specify how the report will be
generated. You can select Generated based on the current query to
generate the report based on the way the query results currently
are formatted or you can select Default to
generate the report based on a very basic set of default formatting
options. The report opens.
- When the report opens, you cannot edit the contents or the formatting
of the report. You can:
- Export the report
- Change the data source of the report
- Change the default report options.
- Print the report
- Save the report
