Learn How to use XLReport for Easy Real Time Excel Reporting
Connect to the most common databases like MS SQL Server, MS Access, MySQL, Oracle, Informix, DB2, Excel, text files and any other database that has an ODBC or OLEDB driver.
You can add as many Data Connections to each Project as you like.
To add a new Data Connection click "New Data Connection" on the XLReport menu.
You can also create a new Data Connection from within the Query Builder.
Select the Data Connection Type.
Example: Microsoft SQL Server.
Fill in all required connection settings and click "Ok" to setup the new connection.
Once you setup a new Data Connection it will be visible in the XLReport Project Explorer.
Note: When you create a new XLReport Query Object you'll also have access to this data connection.
To edit an existing Data Connection, select it from the Project Explorer, right click it and select "Edit Data Connection".
Sometimes you will require to refresh a Data Connection; for example if new data base objects - tables and views - were created or edited in the database.
To refresh a Data Connection, select it from the Project Explorer, right click it and select "Refresh Data Connection".
To delete an existing Data Connection, select it from the Project Explorer, right click it and select "Delete Data Connection".