Database Reference
In-Depth Information
How to do it...
The following sections will show you how to configure the various steps to create the re-
port for this recipe.
Creating the data source and datasets
1. To create the data source and data sets, launch the Report Builder application using
the Report Manager website option by navigating to
http://<ServerName>/
Reports
(substitute the URL with your specific environment values) and click on
Report Builder
.
Tip
Run as Administrator for Report Builder
Note that you may have to run Internet Explorer as an administrator if the report
builder icon is not visible.
2. Close the
Getting Started
page. Ensure that the
Home
tab is selected. Under
Re-
port Data
, click on
New
and then select
Data Source
.
3. On the
General
tab, in the
Name:
field, type
SCCMDB
and ensure that
Use a share
connection or report model
is selected.
4. Select the shared data source you created in the previous recipe and click on
OK
.
5. Under
Report Data
, click on
New
and select
Dataset…
.
6. On the
Query
tab, in the
Name:
field, type
List_Collections
and select
Use
a dataset embedded in my report
.
7. Under
Data source:
select the
SCCMDB
data source you created.
8. In
Query type:
, ensure that
Text
is selected and type the
List_Collections
query
from the preparation table into the text box, as shown in the following screenshot: