Pie chart

In the following exercise, we are going to look at how to build a pie chart. A pie chart is a very common report type used in business to display percentages. In this example, we will create a pie chart to show what percentage an employee contributed to the total amount of sales. This will give us a visual representation of who the top employees are in terms of sales.

1. 1. Create a new report titled Employee_Sales_Percentage.rptDesign.

2. 2. From the ClassicCarsLibrary.rptDesign library, add the dsClassicCars data source to the report.

3. 3. Create a new dataset called totalSales using the following query:

   select CLASSICMODELS.EMPLOYEES.EMPLOYEENUMBER,
   CLASSICMODELS.EMPLOYEES.LASTNAME || ', ' || CLASSICMODELS.EMPLOYEES.FIRSTNAME name,
   sum(CLASSICMODELS.ORDERDETAILS.PRICEEACH) sales
   from
   CLASSICMODELS.EMPLOYEES,
   CLASSICMODELS.ORDERS,
   CLASSICMODELS.ORDERDETAILS,
   CLASSICMODELS.CUSTOMERS
   where
   CLASSICMODELS.CUSTOMERS.SALESREPEMPLOYEENUMBER = CLASSICMODELS.EMPLOYEES.EMPLOYEENUMBER
   and CLASSICMODELS...