How to: |
The Report Wizard allows you to create a new report procedure or SQL report procedure, and open an existing report.
To open the Report Wizard:
Note: If you choose to create a new report using the shortcut menu in the Environments Tree panel, you will skip the first screen of the Report Wizard. You will not have to specify whether you are creating a report or SQL report. You will instead be brought to the Select a Data Source screen, with the location for your report already selected.
The Report Wizard opens, as shown in the following image.
From the Report Wizard, you can open a recent procedure, search for an existing procedure, create a new report or SQL report procedure, and access documentation resources.
After you launch the Report Wizard, you can begin to create your report procedure.
Note: If you choose to create a new report using the shortcut menu in the Environments Tree panel, you will skip the first screen of the Report Wizard. You will not have to specify whether you are creating a report or SQL report. You will instead be brought to the Report Wizard - Select Procedure Location window, with the location for your report already selected.
The Report Wizard - Select Procedure Location window opens.
The Report Wizard - Select a master file window opens.
The Report canvas and the Procedure View panel open.
Tip: The Field and Appearance tabs appear when you select a data column on the Report canvas.
After you launch the Report Wizard, you can begin to create your SQL report procedure.
Note: If you choose to create a new SQL report using the shortcut menu in the Environments Tree panel, you will skip the first screen of the Report Wizard. You will not have to specify whether you are creating a report or SQL report. You will instead be brought to the Report Wizard - Choose location for the new SQL Report window, with the location for your report already selected.
The Report Wizard - Choose location for the new SQL Report window opens.
The SQL Report Wizard - Welcome window opens.
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.
Note: Typing a procedure name is not required to create a new report. 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.
The Report canvas and the Procedure View panel open. You can now add data to your report and format the data using the tabs on the ribbon.
After you launch the Report Wizard, you can begin to create your SQL report procedure.
Note: If you choose to create a new SQL report using the shortcut menu in the Environments Tree panel, you will skip the first screen of the Report Wizard. You will not have to specify whether you are creating a report or SQL report. You will instead be brought to the Report Wizard - Choose location for the new SQL Report window, with the location for your report already selected.
The Report Wizard - Choose location for the new SQL Report window opens.
The SQL Report Wizard - Welcome window opens.
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.
Note: Typing a procedure name is not required to create a new report. 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.
The Report canvas and the Procedure View panel open. You can now add data to your report and format the data using the tabs on the ribbon.
You can import commands from existing .sql files.
Note: If you choose to create a new SQL report using the shortcut menu in the Environments Tree panel, you will skip the first screen of the Report Wizard. You will not have to specify whether you are creating a report or SQL report. You will instead be brought to the Report Wizard - Choose location for the new SQL Report window, with the location for your report already selected.
The Report Wizard - Choose location for the new SQL Report window opens.
The SQL Report Wizard - Welcome window opens.
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.
Note: Typing a procedure name is not required to create a new report. 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.
The Report canvas and the Procedure View panel open. You can now add data to your report and format the data using the tabs on the ribbon.
WebFOCUS |