Table of Contents

Bind a Report to JSON Data

This topic describes how to bind a report to JSON data.

Create JsonDataSource

  1. Create a new report.

  2. Click the report's smart tag. In the invoked actions list, expand the drop-down menu for the DataSource property and click Add New Data Source...

    This invokes the Data Source Wizard.

  3. Choose the JSON option and click Next.

    JSON-SelectJSONDataSource

    Note

    The Report Designer's Report Wizard provides the JSON option if the application has a reference to the open-source Newtonsoft.Json library for .NET Framework projects.

  4. The next wizard page allows you to specify a Web Service Endpoint, a filename, or a string with JSON data. In this example, the JSON data is obtained from a JSON sample data location.

    • Choose Web Service Endpoint and specify the endpoint data.

    • Choose JSON File and specify the JSON file location.

    • Choose JSON String and provide the JSON data string.

    If you choose the Web Service Endpoint option, you can configure a web service endpoint, URI path parameters, query parameters, and header parameters.

    4.1. Specify path parameters and query parameters.

    JSON-specify-request-parameters

    You can enable the new parameter's Expression property and use expressions to set path parameter and query parameter values.

    • Select Expression Editor from the Value property's drop-down list, specify the expression in the invoked Expression Editor, and click OK.

    JSON-specify-parameter-expression

    • Expressions can include report parameters. Select New Report Parameter from the Value property's drop-down list, configure the report parameter in the invoked Report Parameter dialog, and click OK.

    JSON-add-report-parameter

    Note

    The Data Source Wizard sends a request to the endpoint with the specified parameters to populate the data source and build the data source schema. Ensure that the parameters are always set to the values that the endpoint expects. Otherwise, the Data Source Wizard generates an error on the next steps.
    For instance, if a user specifies the name of a JSON file in a parameter, specify the default file name in order to avoid the File Not Found error.

    Path parameters and query parameters are included in endpoint requests in the same order as they are listed. Move a parameter up or down in the list to change its position in endpoint requests.

    The Resulting URI read-only field shows how the resulting JSON URI looks.

    JSON-resulting-uri

    Click Next to proceed to the Wizard's next page.

    4.2. Configure the Basic HTTP Authentication credentials and HTTP header parameters. Use the same steps as in P.4.1. above to configure a header parameter.

    JSON-header-parameters

    4.3. Choose whether to save the created connection string to the application's configuration file. If not, the connection parameters are saved to the report's definition.

    JSON-save-connection-string

    Tip

    If the path parameters, query parameters, and header parameters you specified do not contain sensitive data, you can save them along with the connection parameters. Otherwise, the path parameters, query parameters, and header parameters are used once to retrieve JSON data to an object in memory. This object is accessible until you close the Report Designer.

  5. On the next page, the wizard shows the structure of your JSON data. You can choose whether to include all records (root) or a subset of them to the datasource’s final set of records.

    Uncheck data fields that you do not want to include to your report.

    Assign a title to a field’s Field Display Name column if you want to use this title as a default field name.

    The JSON Data Source Wizard analyzes only the first 100 records to generate field types. If your JSON data contains more than 100 records, you can use all of them for type generation. For this, click the Analyze all records button.

After you finish the wizard, it creates the JsonDataSource component. This component retrieves the checked data fields that the selected JSON element includes. The Field List reflects the data source structure.

JSON-FieldList

Customize the JSON Data Source

Right-click the JsonDataSource component in the Field List or Report Explorer and choose Edit.... Specify another JSON data location and reconfigure data fields in the invoked wizard.

JSON-FieldList

Customize the JSON Data Source Schema

Right-click the JsonDataSource component in the Report Explorer and choose Edit Schema.... Reconfigure data fields in the invoked wizard page.

JSON-EditSchema

Edit this page