Hi
Iam calling a crystal report which is a view based from a jsp page.
I am passing some parameters to the report through a selection formulae string. This selection formulae string goes and concate with the view.
but when i tried to send these parameters iam getting an problem. so please help me out in this. the following is how iam sending the parameters to the rpt file.
VR_LETTER is the view name in the database.
sfstr = sfstr + ' and {VR_LETTER.senduserid} is null';
sfstr = sfstr + ' and {VR_LETTER.sentdate} is null';
sfstr = sfstr + ' order by {VR_LETTER.gendate} ASC';
this.document.form0.SF.value=sfstr;
// here SF is hidden value on the jsp page.
this.document.form0.submit();
Iam calling a crystal report which is a view based from a jsp page.
I am passing some parameters to the report through a selection formulae string. This selection formulae string goes and concate with the view.
but when i tried to send these parameters iam getting an problem. so please help me out in this. the following is how iam sending the parameters to the rpt file.
VR_LETTER is the view name in the database.
sfstr = sfstr + ' and {VR_LETTER.senduserid} is null';
sfstr = sfstr + ' and {VR_LETTER.sentdate} is null';
sfstr = sfstr + ' order by {VR_LETTER.gendate} ASC';
this.document.form0.SF.value=sfstr;
// here SF is hidden value on the jsp page.
this.document.form0.submit();