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.

1. Click Create SQL Report.

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

2. Select a location for your SQL report and click Next.

   The SQL Report Wizard - 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 Report - Data access information window opens. In the Select database engine area, select a database from the drop-down list.
5. In the Select the connection area, choose a connection from the drop-down list generated from the engine you selected.
6. Click Next. The SQL Report 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 Report 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 Report Wizard - Summary of SQL options window opens. Review your options and click Next, which opens the Report 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 report.

    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.

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

    The InfoAssist canvas opens. You can now add data to your report and format the data using the tabs on the ribbon.