Database Reference
In-Depth Information
Figure 6-36.
Joining the tables
10.
Validate that the
Join Conditions
are correct, and click
Apply Changes
.
11. Edit the report attributes again by right-clicking the
Tickets
region and se-
lecting
Edit Report Attributes
.
12. Enable sorting for the
Status
column by selecting the
Sort
check box, and
click
Apply Changes
.
13. Click the
+
symbol to the left to the
Report Columns
for the
Tickets
region
to expand that section of the tree. You can use your mouse to drag and drop
columns within the column list to reorder them. Reorder the columns so that
STATUS
is the second column in the list. Drag-and-drop changes are auto-
matically saved.
Run the application to see the changes to the Tickets report. You should see results
like those in
Figures 6-37
through
6-39
.
The Created On and Status values are now
more readable, and you can sort by column by double-clicking the column heading.