ActiveReports 19 .NET Edition
Report Authors / Report Wizard / Configuring Data Queries / Configuring File Queries / Configuring Excel File Queries
In This Topic
    Configuring Excel File Queries
    In This Topic

    General

    Once you have configured a valid Excel File data source, the Configure Excel Workbook Queries screen allows you to add one or more queries to the data contained in the file.

    Configure Excel Workbook Queries

    Adding and Removing Queries

    You can add and remove Queries by using the Add and Remove buttons below the list on the left side of the screen. At least one query is required to proceed to the next step.

    Configuring Queries

    Each query has a Name property, which serves as a unique identifier. By default, the first query is named DataSet1, but you can customize this by changing the name in the Name field at the top of the panel.

    In the main section, you can choose to retrieve data based on:

    For each query, there are several options you can use to refine how the data is read:

    These options give you the flexibility to filter the data as required before it is loaded into the report.

    Next steps

    After configuring your queries, click Finish >> to create a report with data binding configured, or click Next > to add a data display control.