Collapse

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.

    Custom attributes

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

    Custom attributes

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

    Custom attributes

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.

    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.