Selecting a Creation Tool
You can create a procedure with one of the following tools:
Procedure Viewer. Provides a graphical
environment for the creation of a generic procedure. This option
is the default.
Report Painter. Provides a graphical
environment for the creation of a report procedure.
Composer. Provides a graphical
environment for the creation of a compound report.
SQL Report Wizard. Assists
you with SQL passthru, which allows you to execute SQL code that
retrieves data from an RDBMS. You can
use the resulting extract file in Report Painter.
highly complex reports, charts, and documents with a powerful yet
simple to use interface.
Text Editor. Provides
administrators with a standard text editor, allowing you to create
a procedure by entering commands.
Define Function. Provides
a wizard for creating DEFINE functions.
Procedure: How to Select a Creation Tool
Open a project.
Create a new procedure by doing one
of the following:
the Procedures folder, select New, and click Procedure.
- Highlight the
Procedures folder, select New from the File
menu, and click Procedure.
Add Procedure dialog box opens, as shown in the following image.
display box lists all the procedures currently visible in the project
path, or all procedures that have been added to the project path
(QTY_ALL.fex in the sample dialog box). Click the Displays
all files in the project path button to
toggle between the two displays.
In the File name field, type a name
for the new procedure. Do not include any spaces in the name or
add an extension. Developer Studio automatically appends the extension
In the Files of type drop-down list,
accept the default, Procedure Files (*.fex).
In the Create
with drop-down list, select the creation tool:
Reference: WebFOCUS Logon Dialog Box
you access either the Projects folder or the WebFOCUS Environments
folder and you need to access a secure server, a logon box displays, prompting
you for an ID and password.
There is a check box option for
remembering the ID or password. By default, it is not checked. If
you check this box, your credentials will be stored and encrypted
in the wfscom.wfs file, the local configuration file that is used
to store information processed by the Developer Studio communication
layer. For details about the wfscom.wfs file, see Managing the WebFOCUS Environment in the Developing
Reporting Applications manual. If you decide to change the stored
credentials later, you can do so from the WebFOCUS Environments
Properties dialog box.
Procedure: How to Create a Report Procedure With Report Painter
folder that will contain the report procedure.
the folder where you want to create the report procedure.
Click New, and then click Procedure.
The New Procedure dialog box opens.
a name for the new procedure in the File name field, select Report
Painter from the Create with drop-down list, and click Create.
The WebFOCUS Table List dialog box opens and prompts you
to select a Master File, as shown in the following image.
display box lists all the Master Files currently visible in the
project path, or all the Master Files that have been added to the
a Master File.
Report Painter opens.
See the Creating Reports
With Report Painter manual for more information.
Procedure: How to Create a Reporting Procedure Using the Procedure Window
Add Procedure dialog box, enter a name for the new procedure, then
select Procedure Viewer, and click Open.
The Procedure window opens, as shown in the following
window contains a default Comment component with two diamond objects
on either side called component connectors. The Comment component
does not contain any executable commands. At this point, you have
created a procedure shell. You can now make this shell executable
by adding components, such as a report or graph.
are stored in a file with the extension .FEX.
a diamond object and select a component, such as Report or Graph
or use the toolbar buttons. For details on how to proceed, see Creating a Procedure Component.
have created components, you can do the following with components.
- Move them before
or after an existing component (drag and drop).
- Copy by pressing
the Ctrl key and dragging the selected object.
- Right-click on a
component provides a Context menu with the options to view as text
in a separate editor window by selecting Edit Text. You can perform
other operations, such as Run, Cut, Copy, Delete, and Open the tool
used to create the selected component.
Procedure: How to Create a Procedure With the Text Editor
Add Procedure dialog box, enter a name for the new procedure, select Text
Editor, and click Open. The text
editor opens, as shown in the following image.
the syntax for your procedure.
See the Creating Reports With WebFOCUS Language
manual for details on WebFOCUS syntax.
the Save button on the text editor toolbar when
you are done. See Editing Application Components as Text in Developer Studio, for details
on the text editor.
Reference: Add Procedure Dialog Box
Add Procedure dialog box contains the following fields and options:
Is the name of the project.
Procedure List Box
Lists the procedures associated with the selected project.
Is the name of the procedure.
Files of type
Is the type of file.
Is the creation tool to be used. The options are:
- Procedure Viewer
- Report Painter
- SQL Report
- Text Editor
- Define Function