Topics: |
How to: |
You can use the following procedures to create a basic report.
After you have signed in to WebFOCUS Business User Edition, you can work with an existing Domain folder, or create a new Domain folder on the Home page to store your reports.
InfoAssist opens.
The data source that you selected appears in the Data pane.
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 view, 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:
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.
WebFOCUS | |
Feedback |