|
REPORTS BUILDER EXERCISES
Exercises for Reports Builder
Download
company.sql
from the lab web site and run the script to create all the tables. The figure
below shows the relational schema of these tables.
-
Create a report named
works to show
the hours that every employee is working for the projects. The report will
show the employees' first names and last names, and the number of hours that
they have been working for each project, and the project number. This report
must have a master-detail format, with the employees' names at the top level.
And you must show the total and average hours at the individual level as well
as the company level.
-
Add a parameter named P_NO and a list of values
for project name and number. So that when the user run your report, they can
choose from a list of projects to see the hours that employees are working for
the selected project.
|
