Report Model Connection (SSRS)
To include data from a report model, you must have a dataset that is based on a report model as a data source. Unlike other report data sources, there is no data extension for a report model. In Report Builder, you browse to and select the model directly from the report server. In Report Designer, you specify the URL to the report model.
Use the information in this topic to build a data source. For step-by-step instructions, see Add and Verify a Data Connection or Data Source (Report Builder and SSRS).
In This Article
Connection String
Credentials
Queries
Parameters
Remarks
How-To Topics
Related Sections
Connection String
You do not need a connection string to use a report model as a data source. To connect to a report model, browse to a report server or SharePoint site and select a published model. On a SharePoint site, the report model file name extension is .smdl.
For more connection string examples, see Data Connections, Data Sources, and Connection Strings in Report Builder.
.gif "Arrow icon used with Back to Top link")
Back to Top
Credentials
Credentials are required to run queries, to preview the report locally, and to preview the report from the report server.
After you publish your report, you may need to change the credentials for the data source so that when the report runs on the report server, the permissions to retrieve the data are valid.
For more information, see Specify Credentials in Report Builder.
Back to Top
Queries
Use the report model query designer to interactively specify entities, fields, and a filter for the query. The entities and fields from the model become the dataset field collection displayed in the Report Data pane. For more information, see Report Model Query Designer User Interface (Report Builder).
Back to Top
Parameters
To add a report parameter, create a filter with a prompt in the Report Model Query Designer. For more information, see Report Model Query Designer User Interface (Report Builder).
Report parameters are created with default property values that you might need to modify. By default, each report parameter is data type Text. If the underlying data is a different data type, you must change the parameter data type.
For more information, see Report Parameters (Report Builder and SSRS).
Back to Top
Remarks
Not all report delivery modes are supported by this data provider. Delivering reports through data-driven subscriptions is not supported for this data processing extension. For more information, see Use an External Data Source for Subscriber Data (Data-Driven Subscription).
Back to Top
How-To Topics
This section contains step-by-step instructions for working with data connections, data sources, and datasets.
Add and Verify a Data Connection or Data Source (Report Builder and SSRS)
Create a Shared Dataset or Embedded Dataset (Report Builder and SSRS)
Add a Filter to a Dataset (Report Builder and SSRS)
Back to Top
Related Sections
These sections of the documentation provide in-depth conceptual information about report data, as well as procedural information about how to define, customize, and use parts of a report that are related to data.
Add Data to a Report (Report Builder and SSRS)
Provides an overview of accessing data for your report.Data Connections, Data Sources, and Connection Strings in Report Builder
Provides information about data connections and data sources.Report Embedded Datasets and Shared Datasets (Report Builder and SSRS)
Provides information about embedded and shared datasets.Dataset Fields Collection (Report Builder and SSRS)
Provides information about the dataset field collection generated by the query.Data Sources Supported by Reporting Services (SSRS) in the Reporting Services documentation in SQL Server Books Online.
Provides in-depth information about platform and version support for each data extension.
Back to Top
See Also
Concepts
Finding, Viewing, and Managing Reports (Report Builder and SSRS )
Report Parameters (Report Builder and SSRS)