Database Reference
In-Depth Information
26. Click on
Save
from the
File
menu (or press
Ctrl
+
S
), browse to a folder in SSRS
of your choice, and save the report with the name
Active Alerts
.
Creating the combined dashboard
Next, we will create a new report that includes data from the other two reports using Re-
port Builder. Perform the following steps:
1. Start Report Builder.
2. Under
New Report
, select
Blank Report
.
3. Click on the
Insert
tab and then on
Subreport
.
4. Draw a rectangle on the report body using the
Subreport
icon to hold the
Active
Alerts
subreport.
5. Right-click on
<Subreport>
and click on
Subreport Properties…
.
6. Change the name of the subreport to
SRActiveAlerts
.
7. Click on
Browse…
and browse to the
Active Alerts
report. Then, click on
OK
to
close the
Subreport Properties
window.
8. On the
Insert
toolbar, click on
Subreport
.
9. Draw a rectangle on the report body to the right-hand side of the first subreport to
hold the
Open Incidents
subreport.
10. Right-click on
<Subreport>
and click on
Subreport Properties…
.
11. Change the name of the subreport to
SROpenIncidents
.
12. Click on
Browse…
and browse to the
Open Incidents
report. Then, click on
OK
to close the
Subreport Properties
window.
13. In the
Design
area, replace the
Click to add title
with
Service Man-
agement Dashboard
. Change the font size of the text box to
22
and enable
bold font.