Hi All,

I am using the VB.net. Since the datareport designer is replaced by CR in .net, i have to use the CR for output. The following query which works perfect in datareport designer doesn't work in the CR.

parameters id int ;
select a.*, b.*
from a, b
where a.id = b.id and a.id = id

the error msg is " No value given for one or more required parameters"

Any idea what's wrong with the query above ? Thx.