Database Reference
In-Depth Information
Figure 12-11.
Player data
Creating Alternate Default Reports
Now that you have data in the data grids, you can create alternate default reports,
which you reference when creating sections. Data grids allow you to save reports just
like interactive reports do. Alternate default reports are saved data-grid reports that can
be displayed throughout your websheet application.
Note
Some of the reports that you'll create are date sensitive. Normally, you'd use
SYSDATE
as a reference point. Instead, you'll use a static date of 10-Jun-2010 to simu-
late a common
SYSDATE
. This ensures that you see the same data that is shown in this
book.
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
