Databases Reference
In-Depth Information
Figure 5-20.
The calendar in action
How It Works
Calendar views are also similar to chart views in the sense that the SQL you specify has to adhere to a
specific format. In the calendar view case, the first field in the SQL query refers to the label that will be
displayed on the calendar while the second field in the query refers to the date field that is used to
populate your records on the calendar.
5-6. Visualizing Data on a Map
Problem
You have a database table containing the total sales data for a number of countries in Europe. Your boss
wants you to have that data populated on top of a map of Europe. You have less than a day to get it done
and you are not sure how to proceed.
