Learn How to use XLReport for Easy Real Time Excel Reporting

Data Connections

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.

New Data Connection

To add a new Data Connection click "New Data Connection" on the XLReport menu.

image1.gif

You can also create a new Data Connection from within the Query Builder.

image94.gif

Select the Data Connection Type.

image2.gif

Example: Microsoft SQL Server.

image5.gif

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.

Edit Data Connection

To edit an existing Data Connection, select it from the Project Explorer, right click it and select "Edit Data Connection".

image16.gif

 

Refresh 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".

image17.gif

Delete Data Connection

To delete an existing Data Connection, select it from the Project Explorer, right click it and select "Delete Data Connection".

image18.gif

Important! If you delete a Data Connection, then  all dependent Query Objects will also be deleted and placed into the Recycle Bin.