Skip to main content

Bind a Report to JSON

This tutorial describes how to connect a report to a JSON endpoint.

Create a Data Model and Report

  1. Define data models that obtain the data from your data providers. For this tutorial, prepare a data model connected to a JSON endpoint.

  2. Open an existing report or create a new report as described in the Create and Customize Reports document to get started.

Bind the Report to Data

  1. Click the main menu button and select Add Data Source to create a new data source.

    report-server-menu-add-sql-data-source

  2. On the first page of the invoked Data Source Wizard, select a JSON data model and click Next to proceed.

  3. Select the JSON object’s element to use as the root and select data fields to include into the data source.

    Click Finish to complete the wizard.

View the Result

The Field List displays the data source hierarchy after you connect a report to data.

The created data source is assigned to the report’s Data Source property.