Working with Report Model Query Designer

In Microsoft Reporting Services, you can author reports based on report models by using Report Builder or Report Designer. Report Designer is an advanced report authoring tool that uses the full functionality of RDL, enabling you to create complex reports from a variety of data sources, including relational and multidimensional databases, XML, and report models. Report Builder has all the functionality of Report Designer without requiring you to use Business Intelligence Development Studio. Report Builder is available as a standalone or ClickOnce application. When building a report model query in Report Designer or Report Builder, you use called Report Model Query Designer. 

With Report Model Query Designer, you can create queries based on models by dragging entities and fields to a design surface, resulting in a query composed of report model metadata. When you finish building the report model metadata for your query, it is incorporated into the RDL of your report where you can organize and format the contents just like any other 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. When you render the report, the query is translated on the fly.

Before you can use the Report Model Query Designer, you must successfully create a report model and deploy it to a report server or SharePoint. When creating your data source, specify Report Server Model and then provide a valid connection string.

Connecting to a Report Model

When using a report model located on a report server in native mode, use a connection string in the following format:

Server=http://<servername>/reportserver; datasource=/<modelpath>/<modelname>

For example:

Server=http://myreportservername/reportserver; datasource=/models/Adventure Works Model

When using a report model located on a report server in SharePoint integrated mode, you must specify the fully qualified URL to the model. Use a connection string in the following format:

Server=http://<servername>; datasource=http://<MySharePointSite>/<site>/<Document Library>/<MyFolder>/<modelname>

For example,

Server=http://myreportservername; datasource=http://TestSharePointSite/Site/Documents/Models/Adventure Works.smdl