Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Choose Multiple Values for a single parameter

Status
Not open for further replies.

NormaD

Technical User
Jun 14, 2006
5
US
I am still pretty new to using Oracle Reports and Forms. I need to allow the user the ability to choose multiple values for a single parameter, i.e. manufacturer along with a date range, etc. so far I have found no guidelines on how to do that. Is it possible? Are there some workarounds? Anything would be appreciated, some suggestions on where I might go to read up on this, on if someone has done this maybe a brief explanation.

thanks
 
Please clarify how multiple values for a single parameter relate to manufacturer along with a date range?
Why can't we have a separate parameter for manufacturer and two more parameters for start and end dates?
 
I would have a parameter for startdate, enddate and manufacturerID, but for manufacturerID there could be mutliple Id's/Names chosen, i.e. Campbells, Arbys, Black Angus, etc. In SQL I would use the In statement to pass those values.

Hope this is a little clearer
 
In the query this would look like
Code:
...
where manufacturer_id in ('A34','B45','C23')
...
You need to use lexical parameter in the report, so the SQL would look like
Code:
...
where manufacturer_id in ([b]&all_id[/b])
...
In the form you need to provide the ability of multiple selection and return the string 'A34','B45','C23' as value for the all_id parameter.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top