Home » Developer & Programmer » Reports & Discoverer » How to create a List box in Parameter form
How to create a List box in Parameter form [message #89853] Fri, 06 August 2004 03:22 Go to next message
Neeti
Messages: 7
Registered: November 2001
Junior Member
Hi,

 

  I have a simple requirement. I have a a parameter form in which i need to add a List box for dates, so that the user can select the date from that drop down box. My Question is how do we create a list box in the Parameter form and how do we populate it.

 

Thanks
Re: How to create a List box in Parameter form [message #89855 is a reply to message #89853] Fri, 06 August 2004 06:20 Go to previous message
Steve
Messages: 190
Registered: September 1999
Senior Member
Neeti -

To create a listbox in the parameter form:
1) Create your parameter form as you normally would
2) Double click on the parameter entry field in the parameter form to bring up the parameter's properties
3) Open the entry that reads "List of Values"
4) Here you have two options -
a) create a static list that you define yourself
b) write a select statement to populate the
listbox

From the way you describe your situation, I would assume you would write the select statement to populate the list, a la - SELECT date_field from table_name. Good luck!

Regards,
Steve
Previous Topic: can i create index on view
Next Topic: Conditional Formatting Question
Goto Forum:
  


Current Time: Mon Nov 25 17:54:08 CST 2024