Database Reference
In-Depth Information
7. Click on
Next
, select the
Line
chart type, and then click on
Next
.
8. Drag
EventLevelTitle
from
Available fields
to the
Series
area.
9. Drag
MonthRaised
from
Available fields
to the
Categories
area.
10. Drag
EventCount
from
Available fields
to the
Values
area. Ensure that
Sum
is
selected as the aggregation.
11. Click on
Next
, choose the desired chart style, and then click on
Finish
.
12. Click on the
Click to add title
area and type
Event by Level by Time
.
The wizard will now close, and Report Builder displays the chart in your newly created
report. You can now modify the report and the chart as desired. You might want to change
the line color to a color that represents the event level, such as red for errors and yellow
for warnings. Perform the following steps:
1. Right-click the chart area. In Chart Data box on the right side of the chart area,
under
Values
, click the arrow next to
EventCount
, and select
Series Properties
.
2. Under
Fill
, in the
Pick color
area, click on the formula icon (
fx
) to add an expres-
sion to the
Color
property.
3. Add the following expression to the
Set expression for: Color
textbox and click
on
OK
twice:
=IIf(Fields!EventLevelTitle.Value="Error","Red",IIf(Fields!EventLevelTitle.Value="Warning","Yellow",IIf(Fields!EventLevelTitle.Value
="Information","Blue","Automatic")))
When you are done customizing your report, click on
Run
, as shown in the following
screenshot: