How to create a report with an Excel data source
To create a report from an Excel workbook in the Bold Reports® Standalone Report Designer, create an ODBC data source for the Excel file, then connect to it from the designer. The designer also has a built-in Excel data connector.
How do I create an ODBC data source for an Excel file?
-
Open the ODBC data source administrator and click Add to create a new data source as shown in the following image.

-
Select
Driver do Microsoft Excel(*.xls)to create new Excel data source as shown in the following image.
-
Provide the data source name and workbook location and click
OKbutton to add new Excel datasource as shown in the following image.
How do I connect a report to the Excel ODBC data source?
-
Open the Standalone Report Designer application.
-
Open the data source panel as shown like in the following image.

-
Click
New Data. -
Click
ODBCconnection as shown in the following image.
-
Provide the datasource connection information as shown in the following image.

-
Click
Connect. -
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.

-
Click
Finishto add the ODBC data source with Excel as data to the report.