Databases Reference
In-Depth Information
The first alternate report highlights the games and practices for the next two weeks. To create this report, follow
these steps:
1.
Navigate to the
Schedule
data grid using the
Data Grid
tab.
2.
Click the
Actions
button, and select
Filter
.
3.
Select
Row
for
Filter Type
.
4.
Enter
Next Two Weeks
for
Name
.
5.
Enter the following for
Filter Expression
:
B >= to_date('10-jun-2010', 'dd-mon-yyyy')
and B < to_date('10-jun-2010', 'dd-mon-yyyy') + 14
6.
Click the
Apply
button.
7.
Using the
Action
➤
Format
option, order the
Date
column as ascending by clicking the
Date
column heading and choosing the
Ascending
sort icon.
8.
Hide the
Grizzlies
and
Opponents
columns because you don't have scores for future
games. To do this, choose the
Select Columns
option from the
Actions
menu.
9.
Choose
Actions
➤
Save Report
.
10.
Select
As Default Report Settings
in the
Save
select list.
11.
Select
Alternate
for
Default Report Type
, and enter
Next Two Weeks
for
Name
.
12.
Click
Apply
. The report should now look like Figure
12-12
.
Figure 12-12.
The next two weeks
Because you've already learned how to manipulate and create saved interactive reports, create the following
alternate default reports for the Schedule data grid:
•
Remaining Games
: This report lists all the games left in the season.
•
Remaining Practices
: This report lists all the practices left in the season.
•
Results
: This report lists all the games that have been completed along with the scores.