Hi all,
i am developing datareports with data environment and backend as oracle 9i.
i have to use the query like

"select * from det where name in (parval)"

but im not able to pass multiple values to parval like parval=23,34,45 or parval='23','34','45'.it is not accepting.

but the same query runs well from oracle 9i sql prompt.

do anyone have an idea of how to pass multiple values to a datareport command parameter?

thanks in advance

Please post the actual VB statement that you are using, and the pertinent statements that set up the value(s).

i found a solution by passing the query from VB form instead of from data environment.thanks for ur reply