Since your parameter report on the Hands-On 09 is very useful for your client organization, they ask you to create a list of values (LOV) for the parameter so they can only select from the list rather than trying to remember the company symbol.

Also add more parameter to pass such as the destination of printer, and so on.

You will learn how to: use parameter, modify parameter properties using property palette, use query builder, add more parameters to existing parameter Form.

Remove report number 8 from "Object Navigator."

Open report number 8 -- customers list.

Then save it as report number 9.

Double click on the "Layout Model" icon."

Click on the "Parameter Form" icon.

Click on the "Parameter Form Builder" icon.

Change the title.

Select the Destination type.

Notice that the “Symbol” binding variable has already been selected.

Then click "OK."

Open the “Symbol” property palette.

Type “ORCL” as its initial value.

Double click on the "list of values" property.

Checkmark the “Select Statement” radio button and go to “Query Builder.”

Include the "Stocks" table and close the window.

Select the symbol column and check the query.

Change the “ALL” to distinct.

Click "OK" and close the property window.

Close “Parameter Form Builder.”

Highlight the report and run it.

Open each list box.

Change the report parameter if needed.

Run the report.

Repeat this process for different companies.

--after two company.

At the end, highlight the report and save the changes.

Now, you should practice this over and over, until you become a master at it.

Good Luck!