Collapse

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?

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

    ODBC Data Source Administrator

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

    Microsoft Excel driver in the ODBC setup

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

    Excel workbook location in the ODBC setup

How do I connect a report to the Excel ODBC data source?

  1. Open the Standalone Report Designer application.

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

    Data Source Panel

  3. Click New Data.

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

    Data Source Select Panel

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

    ODBC datasource connection settings

  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.

    Query Designer

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