Use the Reporting Interface




Search Tips   |   Advanced Search


Describes the reporting interface for IBM® DB2® Web Query for System i™, which you can use to select a domain, use items (reports, graphs, URLs) in the Domain Tree, search domains, access reporting tools such as Power Painter, Report Assistant, and Graph Assistant, and much more.

When you enter the reporting interface you are automatically connected to IBM DB2 Web Query for System i.

From the reporting interface, you can:

The browser Back and Forward buttons cannot be used to navigate between pages in the interface, or from an interface page to a page viewed before connecting to the interface.


Parent topic:

IBM DB2 Web Query for System i Overview


Opening the Reporting Interface

Before you can access the IBM DB2 Web Query for System i environment, log on to the reporting interface.


Log On to the Reporting Interface

  1. From the Login page of the reporting interface, click Login or enter the following URL in your Web browser.



    Is the host name and optional port number (specified only if you are not using the default port number) where the application is deployed.

  2. Enter a valid i5 user ID and password.

  3. Click Submit. The reporting interface opens.


Recommended Browser Setup

The following browser setup is recommended for use with the interface:

For information on browser setting options, see the browser Help system.


Reporting Interface Layout

The reporting interface contains the following areas:

In the following image of the interface, the:


Selecting a Domain

All of the domains that a user is authorized to access are displayed in the Domain Tree. Depending on how your user profile is set up, you may not have access to all domains.

The icon located next to an item in the Domain Tree represents the type of item. In the following table, the first column lists the icon, and the second column describes what the icon represents.



- Domain Tree

Highest level of the report organization containing folders and reports you can access.

- Reports Folders

Location of created reports.

- Reports

Reports in a folder.

- Internet Links

Web pages and reports run from launch pages.


Using Domain Tree Items

A domain can contain reports, which are located in the Reports folders.

When you select an item from one of the Reports folders, a menu appears; it allows you to select one of the available options. The option(s) for Reports (identified by the Report icon) include Run, Power Painter, Report Assistant, Graph Assistant, Delete, and Properties.

When you use the Delete option to delete a report, the Domain Tree refreshes and collapses. If the report is the only item in the folder, the folder is also deleted when you delete the report. You also have the option of deleting a folder including all of its contents.


Loading Domain Tree Folders

When a user opens one of the default folders in the Domain Tree, a request is sent to retrieve subfolders directly under the top level folder. As each node of the tree is expanded, only that section of the tree is populated. This reduces the time needed to create the tree when a Domain is selected.

When reports from a folder are loaded into the Domain Tree, only a maximum of 25 report items are loaded each time. A link labeled View More is displayed in the tree to enable users to retrieve up to an additional 25 items.


Creating Reports

In addition, you can create new reports from scratch in the Reports folder. You can create your own reports using Report Assistant, Graph Assistant, or Power Painter (if you have the required privilege). Depending on which tool you use to create your report, you can edit your report using the same tool (Power Painter, Report Assistant, or Graph Assistant). You can change the name of your report from the Properties window.

You may not be able to create reports if you do not have the privileges to do so.


Create a Report in the Interface

  1. In the Domain Tree, expand the Reports folder.

  2. Right-click a subfolder and select Power Painter, Report Assistant, or Graph Assistant.

  3. Create and save your report. The report is saved in the Reports folder with the name you provide.


Text Editor

Administrators and Developers only can use the text editor to troubleshoot source code for reports in the reporting interface.

The following table describes all of the functions available in the text editor. The first column lists the buttons, and the second column lists the actions they produce.



- Save button

Saves the report. Only appears if the Text Editor is opened from the Reports subfolder.

- Save As button

Saves the report in the Reports folder with a name you specify.

- Run button

Runs the current report.

- Quit button

Exits the Editor window. If you made changes to the original report, a window prompts you to save or cancel the changes.

- Help button

Opens the online help.

- Cut, Copy and Paste buttons

Cut, copy, or paste, respectively, the highlighted text.

- Delete, Select All, Undo, and Redo buttons

Delete, select all, undo, and redo, respectively.

- Find and Replace button

Find and replace text.

- Go to line button

Enables you to go to a particular line number in the report.

- Uppercase button

Converts highlighted text to uppercase.

- Lowercase button

Converts highlighted text to lowercase.

- Text color button

Sets the text color in the editor.

- Background color button

Sets the background color of the editor.

The text color and background colors are for the current session only.

- Font drop-down menu

Enables you to change the font of the editor.

- Font size drop-down menu

Enables you to change the font size of the text in the editor.


Using Banner Hyperlinks

The hyperlinks in the banner provide a way to easily navigate the reporting interface: