Data Source

On this page you can choose a table from a database or an existing .SQL query file on which to base your report. After choosing the table or query, you can select the fields to include in the report.

The Web Reports Wizard can use data from a single table or from an SQL select statement that is stored in a .SQL file. On the Data Source page you can select a table or a SQL file. It is strongly advised that you use a database alias to access the data, however, a standard path is also supported.

After selecting a table or a SQL file, a list of fields will appear in the "Fields from file" list. Select the fields from this list that you want to appear on your report.

The Web Reports Wizard is designed to work with a single rowset. This rowset can be derived from an existing table or from a SQL file. If your report needs data from two or more table, you should create a SQL file and use that file as the Data Source. You can use the dBASE SQL designer or you can use another SQL designer. The dUFLP, for example, includes a SQL Wizard called CustomQuery.wfm. SQL Query Builder is another option.