I am not able to set up multiple selections in a drop list in the HTMLPAINTER. Any suggestions or known issues. Also assuming I am missing something after the user presses go, what can I expect to have returned to my fex? I have seen posts that talk about a WHERE clause and others that pass the count in the &VAR0 variable and then the data in the &varx variables.

Thanks for you help.

There should be a Multiple property of the drilldown (valid values: Not Set or Multiple).

As far as passing the parameter, it depends on your requirement. If you need to pass the whole list, you can write some jave script to parse it in the format so you can use it as an IN statement in your WHERE clause.

Hi Rick,

After you will have the the "multiple" property it is possible that it's still not working. To make it work go in the HTML code then find the "SELECT" row of your id and add << operation="OR" >> on the line (if the multiple apply with an "OR", you can also put an "AND").

See example below:

<SELECT id=STORE style="Z-INDEX: 88; LEFT: 40px; WIDTH: 60px; POSITION: absolute; TOP: 235px; HEIGHT: 70px" tabIndex=5 multiple size=3 name=STORE addalloption="0" accept="0" datatype="0" datafieldtype="INTIGER" sourcetype="typeMaster" requiredfield="1436578" newchainnumber="0" IBIMR_domain="financed/financed.htm" IBIMR_folder="#reportsj471g" labelid="text8" [b]operation="OR"[/b]> 

Hope that will complete dballest reply and make your multiple selection working.

This message has been edited. Last edited by: Kerry,

rick, we just discussed this very issue yesterday.
here's the thread.
All our existing code has to be rewritten.
its awful. the version 7 htmlpainter makes the narrow-minded and erroneous assumption that a launch page runs a single fex with a single filter.
So we wrote a chunk of code to unwind that, and put it back to the way it works for all our existing code. That code is in the thread i pointed you to. Take, tweak, improve, and report back on how you're doing.
-S.

If you've built the report in report painter in developer studio IBI now handles all that for you. No more dialogue manager to loop through and develop your where clause.

Take a look at the source code to see the combination of html javascript and xml that does it. Nice.

Larry, that's just it. it doesn't anymore.
it changed from separate variables to a single complex filter.

banging head on wall.
you've missed the point.

Thanks.
Report Painter is where I needed to create the multiple selection function not HTML Painter.
It then create a WHERE FIELD EQ 'A' OR 'B' OR etc. clause.