Launching the Chart Wizard

How to:

The Chart Wizard allows you to create a new chart procedure or SQL chart procedure, and open an existing report.

To open the Chart Wizard:

The Chart Wizard opens, as shown in the following image.

Chart Wizard

From the Chart Wizard, you can open a recent procedure, search for an existing procedure, create a new chart or SQL chart procedure, and access documentation resources.


Top of page

x
Procedure: How to Create a Chart Using the Chart Wizard

After you launch the Chart Wizard, you can begin to create your chart procedure.

Note: If you choose to create a new chart using the shortcut menu in the Environments Tree panel, you will skip the first screen of the Chart Wizard. You will not have to specify whether you are creating a chart or SQL chart. You will instead be brought to the Chart Wizard - Choose location for the new chart window, with the location for your chart already selected.

  1. Click Create Chart.

    The Chart Wizard - Choose location for the new chart window opens

  2. Navigate to where you want to create the new chart and click Next.

    The Chart Wizard- Select a master file window opens.

  3. Choose an application folder in the app folder tree, and select a Master File. You can select the Use Qualified Path check box if you want to only display the data sources in the application folder.
  4. Click Finish.

    The Chart canvas opens.

  5. Double-click fields in the Data Panel to add them to the chart.

    You can use the features and functions on the ribbon that is located in the Chart canvas to format the chart.

  6. To save your chart, click the Save button on the App Studio Quick Access Toolbar, or select Save from the Application menu.
  7. To run your chart, click the Run button on the App Studio Quick Access Toolbar.

Top of page

x
Procedure: How to Create an SQL Chart From an External .sql File

After you launch the Chart Wizard, you can begin to create your SQL chart procedure.

Note: If you choose to create a new SQL chart using the shortcut menu in the Environments Tree panel, you will skip the first screen of the Chart Wizard. You will not have to specify whether you are creating a chart or SQL chart. You will instead be brought to the Chart Wizard - Choose location for the new chart window, with the location for your chart already selected.

  1. Select Create SQL Chart.

    The Chart Wizard - Choose location for the new chart window opens

  2. Navigate to where you want to create the new chart and click Next.

    The SQL Chart - Welcome window opens.

  3. Click the Included from an external ‘.sql’ file option. This enables you to browse and select external procedures that exist in the repository of the project.
  4. Click Next. The SQL Chart Wizard - Data access information window opens.
  5. In the Select database engine area, select a database from the drop-down list.
  6. In the Select connection area, choose a connection from the drop-down list generated from the engine you selected.
  7. Click Next. The SQL Chart Wizard - Include external SQL file window opens.
  8. Click Browse to select an external SQL file name or type the external SQL file name in the field.

    Optionally, you can run with limited records by clicking Run SQL. By default, the Run with limited records check box is selected so you can test your procedure with a read limit if the engine supports it. There is a field box next to the check box in which you can enter the number of records to be read. 100 is the default limit.

  9. Click Next. The SQL Chart Wizard - Summary of SQL options window opens. Review your options and click Next, which opens the Chart Wizard - SQL Data Source window.
  10. Navigate to where you want to create the new procedure.
  11. In the Enter a Procedure Name field, type a name for the SQL chart.

    Note: Typing a procedure name is not required to create a new chart. If you do not type a procedure name in the Enter a Procedure Name field, a default procedure name will be provided until you save the procedure.

  12. Click Select Styling if you want to edit the style sheet for the chart.
  13. Click Finish.

    The Chart canvas and the Procedure View panel open. You can now add data to your chart and format the data using the tabs in the ribbon.


Top of page

x
Procedure: How to Pass SQL Commands to the RDBMS Using SQL Passthru

After you launch the Chart Wizard, you can begin to create your SQL chart procedure.

Note: If you choose to create a new SQL chart using the shortcut menu in the Environments Tree panel, you will skip the first screen of the Chart Wizard. You will not have to specify whether you are creating a chart or SQL chart. You will instead be brought to the Chart Wizard - Choose location for the new SQL Chart window, with the location for your chart already selected.

  1. Click Create SQL Chart.

    The Chart Wizard - Choose location for the new SQL Chart window opens.

  2. Navigate to where you want to create the SQL chart and click Next.

    The SQL Chart Wizard - Welcome window opens.

  3. Click Type SQL statements in the chart request. This enables you to type SQL commands that will be passed on to the RDBMS with the SQL Passthru feature.
  4. Click Next. The SQL Chart Wizard - Data access information window opens.
  5. In the Select database engine area, select a database from the drop-down list.
  6. In the Select connection area, choose a connection from the drop-down list generated from the engine you selected.
  7. Click Next. The SQL Chart Wizard - Enter SQL statements window opens.
  8. In the field box, type the SQL statements you want to pass to the RDBMS.

    Optionally, you can run with limited records by clicking Run SQL. By default, the Run with limited records check box is selected so you can test your procedure with a read limit if the engine supports it. There is a field box next to the check box in which you can enter the number of records to be read. 100 is the default limit.

  9. Click Next. The SQL Chart Wizard - Summary of SQL options window opens. Review your options and click Next, which opens the Chart Wizard - SQL Data Source window.
  10. Navigate to where you want to create the new procedure.
  11. In the Enter a Procedure Name field, type a name for the SQL chart.

    Note: Typing a procedure name is not required to create a new chart. If you do not type a procedure name in the Enter a Procedure Name field, a default procedure name will be provided until you save the procedure.

  12. Click Select Styling if you want to edit the style sheet for the chart.
  13. Click Finish.

    The Chart canvas and the Procedure View panel open. You can now add data to your chart and format the data using the tabs in the ribbon.


Top of page

x
Procedure: How to Import SQL Commands From an Existing .sql File

You can import commands from existing .sql files.

Note: If you choose to create a new SQL chart using the shortcut menu in the Environments Tree panel, you will skip the first screen of the Chart Wizard. You will not have to specify whether you are creating a chart or SQL chart. You will instead be brought to the Chart Wizard - Choose location for the new chart window, with the location for your chart already selected.

  1. Open the Chart Wizard and click Create SQL Chart.

    The Chart Wizard - Choose location for the new chart window opens

  2. Navigate to where you want to create the new chart and click Next.

    The SQL Chart - Welcome window opens.

  3. Click Import from an existing ‘.sql’ file and click Next. This enables you to modify SQL code after importing it from an external file to the procedure being built. You can modify the request using bits of the code.
  4. The SQL Chart - Data access information window opens. In the Select database engine area, select a database from the drop-down list.
  5. In the Select connection area, choose a connection from the drop-down list generated from the engine you selected.
  6. Click Next. The SQL Chart Wizard - Import external SQL file window opens.
  7. Type the SQL file name that you want to import or click Browse to select it.

    Optionally, you can run with limited records by clicking Run SQL. By default, the Run with limited records check box is selected so you can test your procedure with a read limit if the engine supports it. There is a field box next to the check box in which you can enter the number of records to be read. 100 is the default limit. You can edit these options here or in the next step.

  8. Click Next. The SQL Chart Wizard - Enter SQL statements window opens.
  9. In the field box, type the SQL statements you want to pass to the RDBMS.
  10. Click Next. The SQL Chart Wizard - Summary of SQL options window opens. Review your options and click Next, which opens the Chart Wizard - SQL Data Source window.
  11. Navigate to where you want to create the new procedure.
  12. In the Enter a Procedure Name field, type a name for the SQL chart.

    Note: Typing a procedure name is not required to create a new chart. If you do not type a procedure name in the Enter a Procedure Name field, a default procedure name will be provided until you save the procedure.

  13. Click Select Styling if you want to edit the style sheet for the chart.
  14. Click Finish.

    The Chart canvas and the Procedure View panel open. You can now add data to your chart and format the data using the tabs in the ribbon.


WebFOCUS