Database Reference
In-Depth Information
13. In the
New Table or Matrix wizard
, select
Choose an existing dataset in this
report or a shared dataset
, select the
DSOpenIncidents
dataset, and then click
on
Next
.
14. Drag and drop all the fields from the
Available fields
list to the
Values
area and
then click on
Next
.
15. On the
Choose the layout
page, click on
Next
, select the desired style (for ex-
ample,
Ocean
), and then click on
Finish
.
16. Change the columns' width and font sizes so that the rendered report is displayed
properly. You can click on the
Run
button in the
Home
toolbar at any time to
render data. Click on
Design
in the
Run
toolbar to return to the
Design
mode.
17. Right-click on the footer area in the report and click on
Remove Page Footer
.
18. Right-click on the
Id
column, click on
Insert Column
, and then click on
Left
to
insert a new column, as shown in the following screenshot:
19. Type
Open Incidents
as the title of the new column. Expand the column so
that the text fits.
20. Select the new column title by clicking on the space next to the title text and press
the
Esc
key. Use the formatting tools to change the fill color to green, as shown in
the following screenshot: