Has anyone executed a report through RLP that uses SQL pass thru to Oracle db?
I have a report that runs well (using autoprompts with parameter defaults), until I try to "create hyperlink" with a multiselect listbox. I can't get the "MultiSelect" attribute set to "OR", it populates with "None" and it is grayed out so it can't be modified.
I've gotten multiselects to work with FOCUS queries, but now I have to run some queries using SQL passthru. RLP doesn't pick up the &MYMULTISELECT.(OR(1,2)). syntax when its embedded in the SQL passthru.