crystal report para problme

[csvax]

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.

[Kunchesm]

how are you generating the crystal report??.. from crystal report designer only?? .. from where ru supplying the parameter value for 'Id'??

[csvax]

Kunchesm,

In .net, you can add a new item as crystal report which in this case, a file .rpt will be generated. Then, you can use the .rpt file as the resource of your CR viewer control in the print form. The para. info can be added into the viewer control by setting the "ParameterFieldInfo" property. As the object of ParameterField, there are two properties : value and name. Then name should be as same as the one defined in the .rpt file. BTW, i figure out my own question. Instead of putting the para in sql query, should use the "selection formula editor" in the rpt.