Home » Developer & Programmer » Forms » Choosing Multiple values on an "LOV"
Choosing Multiple values on an "LOV" [message #82753] Mon, 30 June 2003 20:52 Go to next message
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 "LOV" [message #82759 is a reply to message #82753] Tue, 01 July 2003 05:19 Go to previous messageGo to next message
Sun
Messages: 92
Registered: August 2002
Member
Instead of LOV, give check box. Using the values checked pass the parameter to report..
Re: Choosing Multiple values on an [message #82761 is a reply to message #82759] Tue, 01 July 2003 05:46 Go to previous messageGo to next message
michelle
Messages: 19
Registered: August 1999
Junior Member
Can you make a check box on the fly? I won't know the values until they put in some dates.

Thanks
Re: Choosing Multiple values on an [message #82766 is a reply to message #82761] Wed, 02 July 2003 04:46 Go to previous messageGo to next message
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 Go to previous message
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
Previous Topic: selecting folder alone using win_api or any other source
Next Topic: GO_ITEM Fails !!!
Goto Forum:
  


Current Time: Sat Mar 02 20:40:23 CST 2024