SQL Builder Wizard

The SQL Builder Wizard is one way to connect a report created in the Report Designer to a TMS database.  To access the SQL Builder Wizard, you have to be in the Report Designer.

1. In the left pane, click the Reports tab and select Add New Report.  

2. Click the Build connection string button.

3. Select or enter a server name.

4. Enable the Use a specific user name and password button.  Type in the default TMS user name and password: TMSREPORT and 4Rivers, respectively. The password is case-sensitive.
5. Check Allow saving password.

6. Select the database on the server.

7. Click the Test Connection button to test the connection to the TMS database.  A pop-up window opens stating: Test Connection succeeded.  Click OK.
8. Click OK again.
9. Make sure that the SQL Statement option button is selected. Click the Build SQL Statement button.
10. The SQL Builder Wizard window opens.  Click the button to connect to the TMS database.
11. In the Data Link Properties screen, click the Provider tab.  Verify that Microsoft OLE DB Provider for SQL Server is selected.
12. Select Views within that database.  We use the V views, not the VTBLs.
13. If you were building a work order report, you would select from vWorkOrders.  Drag and drop fields from the view into the right pane (selected column) of the SQL Builder Wizard.  
14. When you are finished, click OK.  You are returned to Step 1: Select the Data Source for the new report.  Notice that the SQL statement is built.

15. Once you've made your connections using the SQL Builder Wizard, click the Next button to continue with the Report Wizard.