Databases Reference
In-Depth Information
6.
In the first step of the wizard that pops up, choose the Chart item. Choose
Flash Chart in the next step, then Pie & Doughnut in the next, and finally 3D
Pie. Specify Employee Leave Frequency as the title of the region. In the next
step of the wizard, specify the same title for the Chart and choose Side from
Left for the animation style.
7.
When you get to the SQL Statement area, specify the SQL shown in Listing 5-8.
Listing 5-8.
Specifying the SQL for the Chart Region
SELECT '',EmpName,count(*) FROM Employees INNER JOIN EmpLeave ON
Employees.EmpID=EmpLeave.EmpID GROUP BY EmpName
8.
Complete the wizard to create the region. You should see your newly created
region, as shown in Figure 5-28.
Figure 5-28.
The newly created region
9.
Now you need to create another region. Right click on the Regions node and
choose Create again.
