Using Report Models as Data Sources

To create a data source for a report model that has been published to a report server or SharePoint site integrated with a report server, set the data source type to Report Server Model and specify a connection string that includes the URL to the report server, and the folder location for the model. For examples, see Connecting to a Data Source (Reporting Services).

After you create the data source, create a dataset based on the report model data source. When you create the dataset query, the Report Model Query Designer opens. In this query designer, you can drag entities and fields from the model to the Data view in the query designer. After you finish building the query, the entities and fields become the dataset field collection in the Report Data pane. You can now organize and format the contents of your report just like any other full-featured Report Designer report. For example, you can create a report that contains conditional formatting, includes multiple datasets, and contains multiple data regions using different queries within a single report. For more information, see Report Model Query Designer User Interface or Working with Report Model Query Designer.

From Report Designer, you can create new reports from a report model or you can modify existing reports built using Report Builder 1.0 and saved as files to your computer. You can add these Report Builder reports to a Report Server project, and redefine the data sources for the report. For more information about creating reports based on models, see How to: Use a Report Model as a Data Source.

NoteNote

Some additions you make to a report in Report Designer are not supported in Report Builder 1.0. Report Builder 1.0 uses predefined templates and limited design elements. If you are editing a report built with Report Builder 1.0 and plan to continue to use Report Builder 1.0, be aware that not all report elements that you create with Report Designer are supported by Report Builder 1.0.

For more information about report models, see Designing and Implementing Report Models. For more information about ad hoc reports, see Designing and Implementing Reports Using Report Builder 1.0 on msdn.microsoft.com. For more information about report authoring features, see Comparing Report Authoring Environments.

Community Additions

Show: