| Choosing Multiple values on an "LOV" [message #82753] |
Mon, 30 June 2003 20:52  |
michelle
Messages: 19
Registered: August 1999
|
Junior Member |
|
|
I need to create a front end form for a report where the user can select several values from the list of items I give him, then I need to pass this to a report.
I am a forms newbie and if I can't use a wizard I start getting confused so can someone lead me in the right direction on how to do the form and the general tecnique?? I'll be OK once I get it into the report!
Thanks!
|
|
|
|
|
|
|
|
| Re: Choosing Multiple values on an [message #82766 is a reply to message #82761] |
Wed, 02 July 2003 04:46  |
SCP
Messages: 21
Registered: June 2003
|
Junior Member |
|
|
Place a text item and check box.Make it to display as multiple items.
Based on the date you chose,populate the item with values using query.Then check the check box for the required values to be passed as parameters.
|
|
|
|
| Re: Choosing Multiple values on an [message #82806 is a reply to message #82766] |
Mon, 07 July 2003 03:06 |
sujit
Messages: 94
Registered: April 2002
|
Member |
|
|
hi,
i think it needs to be done like this,,
1. Create anather query (say Q2) that fetches your desired column (say ename in emp) in the existing report.
2. create a record group Q2 in the parameter form with the same query used in Q2 of the report.
3. Add the selected rows (where checkbox is checked) to the record group.
4. pass the the record group as a DATA_PARAMETER to the report.
Hope this helps.
SUJIT
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
