You can open the Report Properties window for a tabular report by clicking the Properties button on the Report tab of the Report Designer window.
The Report Style tab for a tabular report is shown below.
|
|
Figure 162: Report Style Tab |
Use the Report Style tab to select the type of tabular reports and the output format, and decide whether to encrypt report links.
The report type buttons on the Report Style tab allow you to select the required type for your report. For examples and descriptions of each report type, see Choosing the Tabular Report Type on page 171.
Output formats vary depending on the type of report selected. The Report Style tab of the Properties window supports the following output formats:
HTML and CSV
HTML and Excel 97
HTML, CSV and Excel 97
HTML, Excel 97 and PDF
CSV files produce an output with the values separated by commas. You can change the delimiter using the CSV Delimiter option on the General tab.
Changing the report output to CSV allows you to import the data into other applications, such as spreadsheets.
PDF files can be viewed using the Adobe Acrobat Reader.
If you select one of the options including Excel 97, you can select the Show Excel in One Page checkbox to resize the page output to fit the default single page size in Microsoft Excel.
Row-based XML and column-based XML may be available for reports depending on your user settings. Row-based XML may also be available for crosstab reports. XML can be stored as data or transformed using an XML compiler.
Note:
XML output is not available in SQL mode. You can create a full-page export to Excel by choosing the HTML and Excel97 output, selecting the Show Excel in One Page checkbox, and clicking the link that appears on the HTML page.
The output formats available for drill-chart reports are explained below:
Both the top-level chart and lowest level report table are exported in HTML.
HTML, CSV and Excel 97
The top-level chart is still formatted in HTML, but the lowest level report table can be exported in HTML, CSV or Excel 97, depending on your selection.
The Unencrypted Links checkbox determines whether or not to encrypt the URL for your report outputs. If you wish to hide the exact URLs (page links or drill down links) from report viewers, leave this checkbox unselected and once a report is run from Report Designer, Netcool Reporter pages, or through a scheduled job, the report output will display encrypted link instead of the actual URL. On the contrary, if you would like to show exact URL in report outputs, select this checkbox.
Unencrypted report outputs can be sent as e-mail attachments to other people who can then view the reports inside or outside of Netcool Reporter.
The following report output types are supported by this feature:
The General tab for a tabular report is shown below.
|
|
Figure 163: Report Properties Window: General Tab |
The General tab of the Report Properties window is divided into the following sections.
You can enter a description for the tabular report in the Description: field.
The fields in the Show/Hide Attributes section are described in Table 37.
|
Checkbox |
Description |
|
Show Date |
When selected, the date and time you ran the report is displayed at the top of the report page. |
|
Show Report Border |
When selected, a raised border is displayed around the report tables. |
|
Show Page Number |
When selected, the page number is displayed for each page. This is only valid when you check the One page at a time checkbox in the Display Style section. |
|
Show Description |
When selected, your report is labelled with the text you type in the Description field. The description appears centered under your current report. |
|
Show Parameter |
When selected, the name of a parameter and its value is shown in the upper left corner of the displayed report. The displayed parameter has the form parametername = value. You can also show parameter values in report titles. For information on how to add parameters to a report title, see Adding a Report Title on page 161. |
|
Show Form/Label Header |
When selected, the header is shown. This option is only available for tabular reports using the Form or Label report types. |
The fields in the Miscellaneous Attributes section are described in Table 38.
|
Attribute |
Description |
|
Specifies a background HTML scheme for the report output. The template can be a custom template that includes company logos and header and footer information. The template file can also contain the HTML tags which specify a style or it can take the style from an external style sheet. Templates are very useful for quickly giving all your reports a standard look and feel. Templates can also be used for charts. To create a new template you must edit an HTML page and place it in the templates directory used by the Report Designer server. If new templates have been put into the templates directory, click the Refresh button to access the new templates. | |
|
Specifies how many rows of data are displayed in the detailed reports when running a drill-down or master detail style report. Setting this value is extremely useful if you are designing or testing reports against very large databases. You can also use the Max number of rows from DB in combination with an Order By clause to retrieve the most crucial values, for example, the top 10 sales figures for the last quarter. | |
|
Detail Style |
Select either HTML or CSV styles for the detail report, and the No Detail option. If you choose the CSV style, then the date column values always show up in the format day-month-year. Note that some spreadsheets may truncate date information. If you import a CSV file into a spreadsheet, double-check that the dates were imported correctly. |
|
Specifies the character or string of characters to use as delimiters (separator characters) in a CSV report. You may enter up to 7 characters. If you do not enter a value here, a comma is used. | |
|
Label Size |
Specifies the number of labels per row in label report style. |
|
Drill Chart Options: |
For a description of this attribute, see Advanced Drill Chart Options on page 256. |
|
Adjust Width |
Specifies how much of the screen width the report tables can take up. Selecting the checkbox stretches the tables so they occupy the whole width of the page. Deselecting the checkbox compresses the tables to take up as little horizontal space as possible. |
The attributes in the Display Style section are described in Table 39.
|
Attribute |
Description |
|
All on One HTML Page |
When selected, all the rows for the report appear on a single page. Because some web browsers have limits on how much data can be displayed in a single table, you may want to limit the size of the tables used on that page by entering values in the Maximum number of detail rows in each table field. You should not set this option to above 1000 unless you are sure your web browser supports very large tables. Display Style controls how much retrieved data is presented in the report. You can control the number of rows in each table of data retrieved and also the number of rows for each page retrieved from the database. This does not include Header, Footer or Summary level information as part of the count. |
|
One Page at a Time |
When selected, the Maximum number of detail rows per page field controls how many rows of data appear on each page. Setting the number higher increases the size of each page. Setting it lower increases the total number of pages. One page at a time is the default setting for displaying your report. |
The advanced drill chart options are used to customize the chart applet width and height in pixels, the appearance of the chart applet (either 2D or 3D), choose a background template file, set the measure format, and define the location of the chart title (either inside or outside the chart).
If you have selected the drill-down report type you can open the Drill Chart Options window on the General tab.
Click the Advanced Properties button to open the Drill Chart Options window, as shown below.
|
|
Figure 164: Drill Chart Options |
The options are described in the following table.
|
Table 40: Drill Chart Attributes |
|
Attribute |
Description |
|
Applet Width |
Specifies the width of the drill chart. The numbers are in pixels. |
|
Applet Height |
Specifies the height of the drill chart. The numbers are in pixels. |
|
PM Files |
Allows you to select from a list of templates that affect the legend position, menu color, text font and size, colors for the chart background, item colors, and pie chart colors. |
|
2D Chart Descriptor |
Specifies a descriptor file that allows you to define the appearance of the chart applet itself. A descriptor can be created by modifying the appearance of the chart while viewing the chart in runtime mode. |
|
Measure Format |
Specifies how the numbers are displayed in the measure. You may specify whole numbers, decimal values, or dollar values. |
|
Show report title inside applet |
When selected, the chart title is displayed inside the applet. The title appears under the top menu bar of the chart. When deselected, the title appears outside the chart applet within the browser window. |
|
Show total as default first level |
When selected, the summary (total) level is displayed as the first level that is shown in a drill chart. The summary level also becomes the top level. When deselected, the first level shown is one level down from the summary level. That level also becomes the top level. |
The Auto Format tab is used to select one of the predefined print formats for your tabular report. These formats are applied when you print the report or when you choose PDF as the output format.
Select a predefined format from the Formats list. A sample of the format you select is displayed in the Preview area. An example Auto Format tab is shown below.
|
|
Figure 165: Auto Format Tab |
Your report output is an HTML file. You can use the Advanced tab of the Properties window to customize the properties of your output, including the use of cascading style sheets.
The Advanced tab creates a document style sheet when you close the window. This style sheet cannot be accessed directly.
The Advanced tab, shown in the following figure, allows you to customize the look of your report. You have control over the color of headings, alternate rows, table margins, width, and color, and the look of individual columns. You can either customize each report or create style sheets based on your corporate style and import these into your reports.
|
|
Figure 166: Report Properties Window: Advanced Tab |
You can change the properties displayed by clicking the following radio buttons in the Format Category section:
Report
Table
Column
The table properties apply to all cells. The column properties apply to specific columns and override similar table properties. Each property type is described in the following sections. All color properties allow you to either choose from predefined colors or to create your own custom colors.
The following table describes the advanced report properties.
|
Table 41: Advanced Report Properties |
|
Property |
Values |
Description |
|
Title Color: |
Unlimited, dependent on your browser |
The color of the title. |
|
Header Color: |
Unlimited, dependent on your browser |
The color for all headers. |
|
Page Color: |
Unlimited, dependent on your browser |
The color of all rows. If the Alternate Page Color selected is different, this specifies the color of all odd numbered rows. |
|
Alternate Row Color: |
Unlimited, dependent on your browser |
The color of all even numbered rows. |
|
Master Color: |
Unlimited, dependent on your browser |
The color of the information appearing at the top-left of the report, such as the parameter value in parameterized reports and the value of the break-level report in break reports. |
|
Summary Color: |
Unlimited, dependent on your browser |
The color of the summary row, if your report has one. |
The following table describes the advanced table properties.
|
Table 42: Advanced Table Properties |
|
Property |
Selectable Values |
Description |
|
Table Width: |
75%, 100%, 150%, 200% |
Specifies the table width in pixels or as a percentage of the page width. |
|
Table Border: |
1, 2, 3, 4, 5 |
Specifies the thickness of the border. |
|
Table Alignment: |
None |
Disabled. |
|
Table Cell Spacing: |
1, 2, 5, 10, 20, 50 |
Specifies the table cell spacing in pixels. You can also type in a value. |
|
Table Cell Padding: |
1, 2, 5, 10, 20, 50 |
Specifies the table cell padding in pixels. Determines how much white space there is around the values in the table cell. |
|
Table Style Class: |
None |
Specifies the name of the table style class from your HTML style sheets. |
The following table describes the advanced column properties.
|
Table 43: Advanced Column Properties |
|
Property |
Selectable Values |
Description |
|
Header No Wrap |
TRUE, FALSE |
Specifies whether long header text wraps or gets truncated. |
|
Header Row Span |
None |
Disabled. |
|
Header Column Span |
None |
Disabled. |
|
Header Horizontal Alignment |
LEFT, CENTER, RIGHT |
Specifies where the header appears, horizontally. |
|
Header Vertical Alignment |
TOP, MIDDLE, BOTTOM |
Specifies where the header appears, vertically. |
|
Header Width |
1, 2,...,50 |
Specifies the header width in pixels. You can also type in a value to set the column width to a fixed value. |
|
Header Height |
1, 2, 5, 10, 20, 50 |
Specifies the header height in pixels. You can also type in a value. |
|
Header Font |
None |
Specifies whether a particular font can be displayed or not. Browser dependant. |
|
Header Font Size |
None |
Specifies whether a particular font size can be displayed or not. Browser dependant. |
|
Header Font Color |
None |
Selects the desired font color for displaying the header. |
|
Header Style Class |
None |
Specifies the name of the header style class from your HTML style sheet. |
|
Data No Wrap |
YES, NO |
Specifies whether the text in cells wraps or gets truncated. |
|
Data Row Span |
None |
Disabled. |
|
Data Column Span |
None |
Disabled. |
|
Data Horiz. Alignment |
LEFT, CENTER, RIGHT |
Specifies the horizontally alignment of the text in a cell. |
|
Data Vert. Alignment |
TOP, MIDDLE, BOTTOM |
Specifies the vertically alignment of the text in a cell. |
|
Data Width |
1, 2, 5, 10, 20, 50 |
Specifies the width of cell in either pixels or percentage of the entire browser window. |
|
Data Height |
1, 2, 5, 10, 20, 50 |
Specifies the height of cell in either pixels or percentage of the entire browser window. |
|
Data Font |
None |
Specifies whether a particular font is displayed or not. Browser dependant. |
|
Data Font Size |
None |
Specifies whether a particular font size is displayed or not. Browser dependant. |
|
Data Font Color |
None |
Specifies the color of the data. Choose from predefined colors, or create your own custom colors. Values are unlimited, dependent on your browser. |
|
Data Style Class |
None |
Specifies the Data Style Class name from your HTML Style Sheet. |
To select a color, click the drop-down button on the required field. The color palette popup window is displayed, as shown below.
|
|
Figure 167: Color Selection Popup in the Advanced Tab |
The color palette allows fine control of colors utilized by the report. These drop-down menus include color schemes for the title, header, page, alternate row, master, and summary color for the document. Click More... to open the Color Selector window.
The Color Selector window is shown below.
|
|
Figure 168: Color Selector Window |
The Color Selector window allows you to specify new colors to use in your reports. In addition to altering any of your default colors, you can define up to ten custom colors. The following table describes the operation of the Color Selector window features.
|
Table 44: Selecting Custom Colors |
|
Window Feature |
Operation |
|
Color Wheel |
Select a new color. Move the cursor over the desired color and click on it. The color appears in the New Color box. |
|
Color Bar |
Alters the darkness and lightness of the color in the New Color box. Drag the arrows along the bar to the left to darken the color, or to the right to lighten it. |
|
Edit Color |
Places the last default or custom color in the New Color box for editing. You can then alter the color's value using the color bar. |
|
Add Color |
Adds the color in the New Color box to your Custom Colors palette. |
|
Default Colors |
Reassigns the default colors to their original values. |
The Conditional Format tab is used to create special conditions when writing your report definition file. If the data in a cell matches the specified criteria, those cells appear with special formatting applied.
An example Conditional Format tab is shown below.
|
|
Figure 169: Conditional Format Tab |
A list of data columns in your report query is displayed in the Columns/Expressions: list. Any conditions that you have already created are displayed in the Conditions: list.
1. Highlight a column in the Columns/Expressions: list on the left and click the Add New Condition... button.
2. The Conditional Cell Format window is displayed, as shown below.
|
|
Figure 170: Conditional Cell Format Window |
The name of the column you highlighted appears within an IF clause.
3. Complete the IF clause by choosing the predicate of the clause. You can choose from a drop-down list of comparison operators.
4. Type the value that the data is to be compared to.
5. Complete the outcome within the then clause.
6. Select the background color of the cell.
The color options are available as either of two sets of colors: conditional colors or standard named colors. To toggle between the color types, refer to Appendix E of the Administration Guide.
7. Select the color of the text.
8. Select the font size of the text.
9. Enter an e-mail notification address if required, as described in the following sub-sections.
10. Enter a pager notification, if required, by clicking the Add button, as described in the following sub-sections.
11. Click OK to close the Conditional Cell Format window. You can create up to three conditions based on each column.
You can choose to type e-mail addresses of people who you want to alert if the specified condition is met in the report data. You can separate multiple e-mail addresses with commas. Click OK when you have finished defining a condition.
When the specified condition is met in the report, Netcool Reporter sends an e-mail to the specified user. The URL of the report is listed in the e-mail header.
You can create up to three conditions based on each column. However, the e-mail addresses typed when defining the last condition apply to all conditions on that column. You cannot send e-mails to different groups of e-mail addresses based on different conditions on a single column.
You can send a page to any person if a specified condition is met in the report data. Click the Add button to open the Add Page Alert window, as shown below.
|
|
Figure 171: Add Page Alert Window |
Type the domain name of the pager company in the Pager Domain area and the pager number in the Pager Number area. When typing the pager number, type the entire number without punctuation marks, for example, 18009999999.
You can enter multiple pager numbers by clicking the Add button more than once, but you must enter them one at a time. If the condition specified in the alert is met in the report, the numbers specified are paged. The page has Netcool Reporter in the From area, and the URL of the report page is in the title in the header area.