x

1. Open a project.
2. Create a new procedure by doing one of the following:
   • Right-click the Procedures folder, select New, and click Procedure.

     or

   • Highlight the Procedures folder, select New from the File menu, and click Procedure.

   The Add Procedure dialog box opens.

   

   The 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.

3. 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 .fex.
4. In the Files of type drop-down list, accept the default, Procedure Files (*.fex).
5. In the Create with drop-down list, select the creation tool:
   • Procedure Viewer provides a graphical environment for the creation of a generic procedure. For information, see How to Create a Reporting Procedure Using the Procedure Window.
   • Report Painter provides a graphical environment for the creation of a report procedure. For information, see How to Create a Report Procedure With the Report Painter .
   • Composer enables you to design reports, and to coordinate and distribute layouts made up of multiple reports and graphs in a single file.

     For details, see the Creating Compound Reports With Document Composer manual.

   • Graph Assistant accesses the Graph Assistant, where you can transform almost any type of data into an effective graph that you can customize.

     For information, see the Creating Charts With Graph Tools manual.

   • 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 the Report Painter or the Graph Assistant. For information, see Using the SQL Report Wizard.
   • Text Editor provides a standard text editor, allowing you to create a procedure by entering commands. For information, see How to Create a Procedure With the Text Editor.

x

When 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.

x

1. Type a name for the new procedure in the File name field, then select Report Painter from the Create with drop-down list, and click Open. For details on the Add Procedure dialog box, see Add Procedure Dialog Box.

   The Open dialog box prompts you for the name of the Master File to use.

   

   The display box lists all the Master Files currently visible in the project path, or all the Master Files that have been added to the project path. Click the Displays all files in the project path button to toggle between the two displays.

2. Select a Master File from the display box to add it to the File name field.
3. In the Files of type drop-down list, accept the default, Master Files (*.mas).
4. Choose Open Report Painter and click Open to start the selected tool.

   You can now build the report procedure.

   See Creating Reports Overview or the Creating Reports With Report Painter manual for information.

x

1. In the Add Procedure dialog box, enter a name for the new procedure, then select Procedure Viewer, and click Open.

   The Procedure window opens.

   

   This 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.

   Components are stored in a file with the extension .FEX.

2. Click and hold a diamond object and select a component, such as Report or Graph or use the toolbar icons. For details on how to proceed, see Creating a Procedure Component.

Once you have created components, you can do the following with components.

• Move them before or after an existing component (drag/drop).
• Copy by pressing Ctrl 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.

x

1. In the Add Procedure dialog box, enter a name for the new procedure, select Text Editor, and click Open. The text editor opens.

   

2. Enter the syntax for your procedure.

   See the Creating Reports With WebFOCUS Language manual for details on WebFOCUS syntax.

3. Click 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.

x

The Add Procedure dialog box contains the following fields/options:

Look in

Is the name of the project.

Procedure List Box

Lists the procedures associated with the selected project.

File name

Is the name of the procedure.

Files of type

Is the type of file.

Create with

Is the creation tool to be used. The options are:

• Procedure Viewer
• Report Painter
• Composer
• SQL Report Wizard
• Graph Assistant
• Advance Graph Assistant
• Text Editor