Creating Freeform SQL reports and Query Builder reports from Excel files

The Freeform SQL reporting and Query Builder reporting features allow you to create reports using data from Excel files. The process involves the following steps:

• Step 1: Preparing the Excel File

• Step 2: Setting up the data source (ODBC)

• Step 3: Creating a database instance for the Excel file

After setting up the connection to the Excel file you can create either a Freeform SQL report or a Query Builder report, as described below:

• Step 4: Creating a Freeform SQL report from Excel files

• Step 4: Creating a Query Builder report from Excel files