Report Painter provides a variety of options that enable you to customize the display of columns in your reports.
By default, the column title is the field name or Title attribute in the Master File, if specified. To change the column title on the report:
The Title dialog box opens.
The new title appears over the field in the report.
Note: Click the Default button in the Title dialog box if you want to reinstate the default title of a field.
Title Window displays the default column title of the selected field. Highlight the text and type the new column title.
Reinstates the default title of a field.
or
Right-click and select Format from the context menu.
The Format dialog box opens. For details, see Format Dialog Box.
Note:
The Field Properties dialog box opens at the Style tab.
The Field Properties dialog box opens at the Style tab.
Repeat this process for other rows you want to assign colors to.
The Field Properties dialog box opens at the Style tab.
You can copy the background color characteristics from one column to another.
To copy all formatting characteristics (including font, grid, background color, and conditional styling) from one column to another, click the Match All Styles option on the Font toolbar.
You may customize the virtual screen size for the report.
Note: Adjusting the virtual screen size applies to the work area in the Report Painter window. The report output is not affected by these settings.
Note: The Virtual Screen Size option appears for HTML Web Document (HTML), HTML Table (HTMTABLE), Default, and User Styled report outputs.
You can align alphanumeric and numeric report columns with either the left or right column margin, or in the center by performing the following steps:
Tip: To restore the default column width, select Fixed Column Width from the Properties menu.
The Field Properties dialog box opens at the Style tab.
Note: For HTML-styled report formats, ensure that the Cascading Style Sheets options is selected on the Report Options Features tab.
The Field Properties dialog box opens at the Style tab.
To indicate that a field value has been truncated in the report browser, Report Painter places an exclamation point (!) after every alphanumeric and text field value and an asterisk (*) after every numeric field value.
Note: For HTML-styled report formats, ensure that the Cascading Style Sheets option is selected on the Report Options Features tab.
The Field Properties dialog box opens at the Style tab.
This is selected by default. Minimum width sets the width of the column according to the widest value or heading in the field.
Note: For HTML-styled report formats, ensure that the Cascading Style Sheets option is selected on the Report Options Features tab.
The Field Properties dialog box opens at the Style tab.
Maximum width sets the width according to the length defined in the field format.
Note: To apply this setting to HTML styled report formats, ensure that the Cascading Style Sheets option is selected on the Report Options Features tab.
To remove extra blank space between report columns, select Styling from the Report menu. Then select Minimum from the Report Layout Width drop-down list. This is the default setting.
Since this may change the width of the report at run time, the report may look different in the Report Painter window.
Note: For HTML-styled report formats, ensure that the Cascading Style Sheets option is selected on Report Options Features tab.
You can stack columns over one another by performing the following steps:
The Field Properties dialog box opens.
Note: OVER is not available for sort fields.
To make a column invisible, right-click the column in the Report Painter window and choose On from the Invisible context menu. The field is grayed out in the Report Painter window and will not be visible in the report output, but may still be used in the report (for instance, as part of a calculation).
To make a column visible, right-click the field in the Report Painter window and choose Off from the Invisible context menu. The grayed background is removed and the field is visible in the report output.
Click the Show/Hide invisible fields button on the General toolbar.
How to: Reference: |
You can have pop-up field descriptions display in an HTML report when the mouse pointer is positioned over column titles. Field description text displays in a pop-up box near the column title using the default font for the report. Pop-up text appears for report column titles including titles created with ACROSS phrases and stacked column titles created with OVER phrases.
The pop-up text displayed for a column title is defined by the Description attribute in the Master File for the corresponding field. If a column title has no Description entry in the Master File, then no pop-up box is generated when your mouse is positioned over the title.
The Report Options dialog box opens.
Note: Pop-up Field Descriptions are available for HTML Web Document (HTML), HTML Table (HTMTABLE), Default, and User styled report formats.
The following image shows part of the Report Options dialog box with the Pop-up Field Descriptions option enabled for this report.
Distributing an HTML report containing pop-up field descriptions with ReportCaster requires the use of JavaScript components located on the WebFOCUS Client. To access these components from a report distributed by ReportCaster, the scheduled procedure must contain the SET FOCHTMLURL command, which must be set to an absolute URL instead of the default value. For example,
SET FOCHTMLURL = http://hostname:port/ibi_html
where:
Is the host name and optional port number (specified only if you are not using the default port number) where the WebFOCUS web application is deployed.
Is the site-customized web server alias pointing to the WebFOCUS/ibi_html directory (where ibi_html is the default value)
For more information about coding reports for use with ReportCaster, see the Tips and Techniques for Coding a ReportCaster Report section in your ReportCaster manual.
WebFOCUS |