Database Reference
In-Depth Information
How to do it...
The steps involved in creating the drillthrough report can be grouped into the following two
tasks:
• Creating the incident drillthrough report
• Linking the main report and the drillthrough report
Creating the Incident Details drillthrough report
The Incident Details report will include detailed information about an incident, such as the
description, the assigned-to analyst, and the classification category. We will need to create
a parameter for the Incident Details report to pass the incident ID to the report. Perform the
following steps:
1. Start Report Builder.
2. Under
New Report
, select
Blank Report
.
3. Right-click on
Data Sources
, click on
Add Data Source…
, and enter
Ser-
viceManager
as the name.
4. Select
Use a shared connection or report model
and select the
ServiceManager
data source from the list of available data sources. If the data source is not dis-
played, click on
Browse…
and browse to the location where the data source is
stored in SQL Server Reporting Services.
5. Click on
Test Connection
and then click on
OK
twice.
6. Right-click on
Datasets
and click on
Add Dataset…
.
7. Enter
DSIncidentDetails
as the name and select the
Use a dataset embed-
ded in my report
option.
8. Select the
ServiceManager
data source, select
Text
query type, and type the fol-
lowing query. Then, click on
OK
:
SELECT
I.Id_9A505725_E2F2_447F_271B_9B9F4F0D190C AS [Id],
I.CreatedDate_6258638D_B885_AB3C_E316_D00782B8F688
AS [CreatedDate],
I.Title_9691DD10_7211_C835_E3E7_6B38AF8B8104 AS
[Title],
I.Description_59B77FD5_FE0E_D2B5_D541_0EBBD1EC9A2B
AS [Description],
TClassification.LTValue AS [Classification],
AFU.DisplayName AS [AffectedUser],