Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to pass order by from jsp

Status
Not open for further replies.

madhav23

Programmer
Jun 5, 2003
7
0
0
US
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();



 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top