Topics: |
How to: |
You can use the following procedures to create a basic report in the WebFOCUS Home Page and InfoAssist.
After you have signed in to , you can work with an existing folder, or create a new folder in the WebFOCUS Home Page to store your reports.
A basic report is shown in the following image.
The InfoAssist splash screen opens.
The Open dialog box opens.
The data source that you selected appears in the Data pane of the Resources panel.
The InfoAssist splash screen opens.
The Open dialog box opens.
The data source that you selected appears in the Data pane of the Resources panel.
The data is presented as a report.
The following output types are available for reports:
Note: When you create a report in Document mode, you have access to Excel only.
When you create a report in Live Preview or Query Design view, you have access to the following Excel output types:
Note: Additional output types can be enabled in the Administration Console, including Excel Pivot.
How to: |
When working with data in a report, you can download it into Excel (CSV) format. This enables you to capture your data and work with it in an external program, such as Excel.
When you use the File option to create a HOLD file from your report the output file is placed on the WebFOCUS reporting server. For users who do not have access to their reporting server this approach allows the data to be delivered directly to their desktops.
Note: You can select the Excel (CSV) output format in User Preferences, if you want to make this output format the default for each time you enter InfoAssist.
How to: |
Procedure Settings, also known as SET commands, enable you to specify and control items for inclusion in a procedure. If you want to include a Procedure Setting in a procedure (.fex), select the relevant check box to include that setting in the procedure (.fex). Procedure Settings are available in Report, Chart, and Document mode.
You can access Procedure Settings from the Quick Access toolbar. When you click Procedure Settings, the Procedure Settings dialog box displays, allowing you to select the options to apply to your procedure, as shown in the following image.
Options include:
Note: You can use amper (&) variables in the Missing Data field to allow the entry of values at run-time. In general, valid values include any string or amper (&) variable, which will print automatically. You can use &xx to activate autoprompt. For example, you can use &NONE to specify a value at run-time. In Live Preview, this value is set to _FOC_NULL or as many characters that will fit in the width as defined by the existing values in a column. Global variables (&&x) should not be entered as they do not activate autoprompt. Mixing strings with amper (&) variable can result in Focus error messages. For example, &&&&N& or &nn&n&).
Note: In Report mode, all settings apply. In Chart mode, only Collation Sequence (COLLATION), Decimal Notation (CDN), and Empty Report (EMPTYREPORT) settings are applicable. In Document mode, Procedure Settings apply to the whole document. These settings are currently unavailable in Visualization mode.
Note: The highlighted area indicates the default ( . ) for missing values.
Note: By default, this is set to ( . ). However, common examples include N/A or NONE.
Note: The addition of a filter condition causes your report to have no records, and the default behavior (EMPTYREPORT=ON) displays the heading and column titles.
The following image shows an empty report.
Note: This option is selected, by default. Notice that Empty Report can be set to On or Off. When enabled and set to On, the shell of the report (headings and titles) will be displayed. If the setting is turned off, the environment default will be used.
When the Empty Report check box is cleared, no report is generated, as shown in the following image.
How to: |
In InfoAssist, you can create and store thumbnail images for use in the WebFOCUS Home Page. Thumbnail images allow you to see a snapshot of a report or chart without opening the file. In InfoAssist, you can create a thumbnail image by clicking on the Create Thumbnail icon, which is located on the Quick Access toolbar.
You can create thumbnail images when working in Report and Chart mode in InfoAssist. These images are smaller renditions (220x160px) of your actual report or chart as it displays in Live Preview. Once you create the thumbnail and save the report or chart, you can access the thumbnail image from the file list on the WebFOCUS Home Page, as shown in the following image.
Note: Thumbnail images are stored as part of the procedure when it is saved in the repository.
The Create Thumbnail dialog box displays, as shown in the following image.
WebFOCUS | |
Feedback |