Working with Report Model Query Designer

New: 5 December 2005

In Microsoft SQL Server 2005 Reporting Services, you can author reports based on report models by using Report Builder or Report Designer. Report Builder is a tool used to create ad hoc reports based on report models and uses a subset of the report definition language (RDL) available in Reporting Services. Report Designer is an advanced report authoring tool that utilizes the full functionality of RDL, enabling you to create complex reports from a variety of data sources, including OLEDB, ODBC, and other data sources. When building a report model query in Report Designer, you use a tool available in Report Designer 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 similar to the one in Report Builder, 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 Designer report where you can organize and format the contents of your report just like any other 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. When you render the report, the query is translated on the fly.

Before attempting to access the Query Designer, you must successfully create a report model and deploy it to the report server. Query Designer can be accessed from the Report Designer Report Wizard or by clicking the Report Designer Data tab. When creating your data source, specify Report Model and then provide a valid connection string in the following format:

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

For example:

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

Community Additions