Database Reference
In-Depth Information
How to do it...
Some of the basic terms used in this topic that you need to be familiar with and their de-
scriptions are detailed in the following table:
Report
Builder in-
terface and
terms
Description
This is the location of the raw data for reports. The data source comprises of a server (for example, Windows Server), the data-
base, and the connection credentials.
Data source
Dataset
The dataset is created using a query to the data source. This is what the report uses as its source for the presentation of the data.
Report
Builder
This is the report authoring tool similar in layout to Microsoft Office applications.
Report
Manager
This is a component of SQL Server Reporting Services. You connect to the Report Manager website to administer and publish the
reports you create in the Report Builder application.
Report
types
You have multiple options for the type of reports you create, including tablix (table and matrix), chart, and maps.
Query
Designer
This is a graphical query builder interface included with Report Builder.
Report parts
You have the option to save and reuse parts of reports, such as the datasets. You save these artifacts as report parts. The saved re-
port parts become available to other report authors.
Built-in
fields
These are the preconfigured fields in Report Builder that are available to you to insert into your report visualization. Examples in-
clude execution time, report name, and report server URL.
You can define parameter names for your reports. These parameters provide the report consumer with the option to specify accep-
ted values for a report. An example is a report that requires a computer name. You define a parameter for the computer name, and
the consumer can change the value to tailor the report.
Parameters
You have the option to insert images into reports. These images can be imported into Report Builder and stored in the image sec-
tion.
Images
Report au-
thors
These are users designated as report creators. The users in this category use Report Builder to create reports.
