DB2 graphic QMF Version 8

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:

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:

  1. You specify that you are creating a new report or opening an existing report stored in a file or saved on the database server.
  2. 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.
  3. 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:

  1. Select Query--> Run to run a query and obtain query results.
  2. 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.
  3. Select Results--> Display Report from either the main menu or a context menu.

    The Report Wizard opens.

  4. 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.
  5. 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.
  6. When the report opens, you cannot edit the contents or the formatting of the report. You can:


Go to the previous page Go to the next page

Downloads | Library | Support | Support Policy | Terms of use | Feedback
Copyright IBM Corporation 1982,2004 Copyright IBM Corporation 1982, 2004
timestamp Last updated: March, 2004