One option is to create a report whose WHERE clause is a lexical parameter, such as
select <column list>
from customer c,
country t
where t.cntry_id = c.cntry_id
&lex_where
In a form, you'd need to - through several lists of values - create (concatenation) the rest of the report's WHERE clause. It would look likeand c.cust_nam = 'MIKE' and t.region = 'ADRIATIC'
lex_where := :form_where_clause;
Executing a report would, if you're lucky, display a desired result.
] 
Blog
Search
Help
Members
Register
Login
Home
