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

    If you selected one of the JSON, XML, CSV, or Excel File data sources, the next screen of the report wizard allows you to configure the actual connection. The following sections describe the connection settings for each file type.

    Fixed and Dynamic Settings

    Connection settings can either be fixed or dynamic:

    To make a setting dynamic, click the Parameter... link near the setting name:

    General section of Configure JSON File Connection 

    This will open the Parameters dialog:

    Configure JSON File Connection Parameter 

    Here, you can re-use an existing parameter or create a new one by clicking the Add button. The following properties can be configured:

    Advantages of Dynamic Settings

    Dynamic settings offer flexibility, especially in environments where connection details might change or where different users require different settings. For example, you might want to use different files depending on the current logged-in user in your application.

    Configuring JSON File Connection 

    Configure JSON File Connection 

    General Settings

    Proceeding to Next Steps

    Once you have the file path configured, click Next > to proceed to the Configuring JSON Queries step of the report wizard.

    Configuring XML File Connection

    Configure XML File Connection

    Transformation Settings

    Proceeding to Next Steps

    Once you have the settings configured, click Next > to proceed to the Configuring XML Queries step of the report wizard.

    Configuring CSV File Connection

    Configure CSV File Connection

    General Settings

    • Delimited: Select this option if your CSV file uses delimiters (such as commas, tabs, or other characters) to separate fields.
    • Fixed: Choose this option if the fields in your file have a fixed width.

    Data Settings

    Delimiters

    • Column Delimiters: Check this box to merge consecutive column delimiters in the file, which is useful if there are empty fields.
    • Row Delimiters: Check this box to merge consecutive row delimiters in the file, which is helpful if there are empty rows or if rows are split across multiple lines.

    Proceeding to Next Steps

    Once you have configured all the settings, click Next > to proceed to the Configure CSV Data Fields step of the report wizard.

    Configuring Excel File Connection

    Configure Excel File Connection

    General Settings

    Proceeding to Next Steps

    Once you have the file path configured, click Next > to proceed to the Configure Excel Workbook Queries step of the report wizard.