PDF and Java Reports

You can generate SQL reports in the Adobe Portable Document Format (PDF). This format specifies the output dimensions precisely, ensuring that any printed output matches what you see on your screen.

In order to view PDF reports, you must have a PDF viewer installed on your machine. You can download the Adobe Acrobat Reader program, from the Adobe web site, http://www.adobe.com/. If your PDF reader is configured as a web browser plugin, your web browser automatically displays PDF reports.

You can also generate an interactive Java report. This report format lets you adjust a number of formatting options, such as text font and size.

Formatting Java Reports

Java reports give you a great deal of control over how the output should be formatted. Once you have formatted a Java report to your satisfaction, you can generate a PDF version of the same report. The PDF version can be stored or printed.

Some of the formatting options apply to the entire report. Others apply only to a single field of the report. You must first select the field you want to format, then choose the format option.

Java reports have their own menu bar, displayed above the report’s control buttons. If you are viewing the report in a web browser, the browser has its own menu bar. In this section, menu is a reference to the Java report’s menu, unless specified otherwise.

File Commands

To save the current configuration of the report, select the menu option FileÆSave, or click the Save button. You can also save the report under a new name by selecting Save As….

To save a PDF version of the report, select the menu option FileÆExport to PDF, or click the PDF button.

To print the report directly, select the menu option FileÆPrint, or click the Print button.

Navigation Commands

You can jump to any place in the report using the scroll bar, or using the commands on the Java report’s Search menu. The commands are:

•   Go to page… displays the page of the report that you specify.

•   Go to row… displays the row that you specify.

Formatting and Editing Cells

To format text, click the text with the mouse. You have to format all of the text in a cell. Generally, each label, title, or number in the report is a separate cell. You can shift-click cells to select several at once. Any formatting commands apply to all of the selected cells.

You can also edit the contents of a cell by double-clicking it.

To make a change to a cell’s format, select it and click one of the format tools shown in Table 29.

Table 29: Format Tools

Button

Description

 

Make the contents of the selected cell bold.

 

Make the contents of the selected cell italic.

 

Underline the contents of the selected cell.

 

Align the selected cell’s contents with the cell’s left border.

 

Center the cell’s contents.

 

Align the selected cell’s contents with the cell’s right border.

Adding and Moving Items

You can add contents to Java reports using the commands from the Insert menu.

To insert an image, choose Image… from the Insert menu. You are shown a list of images available on your Netcool Reporter server.

To insert a text label, choose Label… from the Insert menu.

You can move any item in the report by entering freehand mode. To do this, click the Freehand button.

When you are in freehand mode, you can move cells and graphics by dragging them with the mouse. Click the Freehand button again to disable freehand mode when you are finished.