How to create a report with excel datasource

You can create a report in Bold Report Designer with Excel data source using the ODBC data source. You need to follow these steps to create the Excel data source:

Create a new Excel Data source in ODBC

1. Open the ODBC data source administrator and click Add to create a new data source as shown in the following image.

   

2. Select Driver do Microsoft Excel(*.xls) to create new Excel data source as shown in the following image.

   

3. Provide the data source name and workbook location and click OK button to add new Excel datasource as shown in the following image.

   

Create a report with Excel data source using ODBC

1. Open the Report Designer application.

2. Open the data source panel as shown like in the following image.

   

3. Click New Data.

4. Click ODBC connection as shown in the following image.

   

5. Provide the datasource connection information as shown in the following image.

   

6. Click Connect.

7. The Query designer will get opened where you need to provide the Query to select the data from Excel data source as shown in the following image.

   

8. Click Finish to add the ODBC data source with Excel as data to the report.