Chapter 3. Key
Report Services ships with the following tools
that support configuration, management, design,
development, processing, rendering, and delivery of
Reporting Services Configuration
Reporting Services Configuration Manager is a
tool used to deploy a local Reporting Services installation and
configure remote Reporting Services instances.
Report Manager is a web-based report access and
management tool used to administer a single report server instance.
Report Manager lets you view, search, and subscribe to reports;
manage the report server folder hierarchy; configure site
properties, security, and report execution properties; create
shared data sources; create report models; and launch Report
Report Designer is a report creation tool hosted
in Visual Studio. Report Designer supports designing and defining
tabular, matrix, chart, and freeform reports. Report Designer
for Data (query builder and expression
editor), Layout, and Preview that allow you to design a report
interactively and iteratively. Report Designer is accessed through
Business Intelligence Development Studio.
Report Model Designer
Report Model Designer is a report model creation
toola report model is the basis of an ad hoc report. Report Model
Designer is used to define, edit, and publish report models used by
Report Builder. Report Model Designer is accessed through Business
Intelligence Development Studio.
Report Builder is an end-
used to create tabular, matrix, and chart reports through a simple
drag-and-drop interface. Report Builder lets you select queries and
, filter, and explore data; define expressions,
calculations, and aggregates; define layout and format; and
preview, print, publish, and export reports.
Report Server is the primary component of
Reporting Services providing its report processing, rendering, and
A report is the result of the integration of
four separate definitions defined in order of dependency on each
other (i.e., order in which they are created). The definitions are
stored in files with the file extensions listed in parentheses
after the definitions that follow.
Data Source (.ds)
A data source contains information about how to
connect to a data sourcefor example, a database, flat file or XML
file. This includes authentication information, a data source
and a connection string. A data source can be used by a single
report and contained within that report or shared among multiple
reports and stored independently on a report server. A report can
access one or more report-specific and shared data sources. A
report model can reference only one data source and one data source
You create a data source using Report Designer,
Report Model Designer, or Report Manager.
Data Source View (.dsv)
A data source view is a description of the data
to which the data source refers including (in the case of a
relational database) the tables, fields, and relationships.
You create a data source view using Report
Designer, Report Model Designer, or Report Manager.
Report Model (.smdl)
A report model is a metadata description of data
providing a business abstraction of the underlying data and
relationships that exist within the data. A report model references
one data source (.ds) file and one data source view (.dsv)
A report model lets Report Builder users easily
explore and select data they are interested in from the underlying
data sourceReport Server then uses the report model to generate a
query to retrieve the data.
You create a report model using either Report
Model Designer or Report Manager.
A report definition completely describes the
data source connections, queries, expressions, parameters, images
and other design-time elements, properties, and layout used in a
report. A report definition is rendered to a
You create a report definition using either
Report Designer or Report Builder.
four sections of this book will examine
the tools and components.