How to pass parameter value to CR SQL Command

vijaykumartaduri · October 10th, 2005, 04:38 AM

I have created reports using crystalreport9.0 and PULL method.

ex: "SELECT * FROM XYZ"

And also created parameter field for this above query like

{Command.ID}={?ID}.

While i accessing this above report, first it loading all the data into memory after that only it is filltering data using above parametervalue.

Pls let me tell how can i pass value into query at firat time itself.

Thankx

richierup · May 30th, 2006, 07:42 AM

hi vijay,
if you have given the above condition in record selection of the CR,than the CR fetches record by record and when the condition is true,it collects in the memory and finally displays it in the front end.hope you got where to giv the filter condition

thanx

rupi

Thamil · August 24th, 2006, 10:27 AM

Hi,
I am New to ASP. Need your help please.
I am working with Oracle Database and ASP.

I am having problem to pass value from dropdown list to another ASP to SQL statement. Below are codes:

[u]First Page code:</u>
<html>
<head>
<title>test</title>
</head>
<body>
<form name="test" action="patients.asp" method="POST">
Select Ward:
<select name="wardlist">
<option value="Arnwood">Arnwood</option>
<option value="Beacon">Beacon</option>
</select>
<input type="submit" value="Submit">
<input type="Reset" name="Reset">
</form>
</body>
</html

[u]Main Page:</u>

<%
    Dim paraval
    paraval = Request.Form("wardlist")

    Set conn = Server.CreateObject("ADODB.Connection")
    conn.open "PIMSP_MHLD","REPORT","REPORT"
    Set Session("PIMSP_MHLD_conn") = conn

    Set rs = Server.CreateObject("ADODB.Recordset")
    rs.Open sql, conn,3,3

sql="SELECT spont.shortname..... WHERE spont.shortname = & paraval &"
%>
....
....

Thanks in Advance

Thamil

veluworld · July 31st, 2007, 12:13 AM

Quote:

quote:Originally posted by Thamil
Hi,
I am New to ASP. Need your help please.
I am working with Oracle Database and ASP.

I am having problem to pass value from dropdown list to another ASP to SQL statement. Below are codes:

[u]First Page code:</u>
<html>
<head>
<title>test</title>
</head>
<body>
<form name="test" action="patients.asp" method="POST">
Select Ward:
<select name="wardlist">
<option value="Arnwood">Arnwood</option>
<option value="Beacon">Beacon</option>
</select>
<input type="submit" value="Submit">
<input type="Reset" name="Reset">
</form>
</body>
</html

[u]Main Page:</u>

<%
    Dim paraval
    paraval = Request.Form("wardlist")

    Set conn = Server.CreateObject("ADODB.Connection")
    conn.open "PIMSP_MHLD","REPORT","REPORT"
    Set Session("PIMSP_MHLD_conn") = conn

    Set rs = Server.CreateObject("ADODB.Recordset")

sql="SELECT spont.shortname..... WHERE spont.shortname = & paraval &"
    rs.Open sql, conn,3,3

%>
....
....

Thanks in Advance

Thamil

sql="SELECT spont.shortname... WHERE spont.shortname = '"&paraval &"'"
rs.Open sql, conn,3,3

U missed Quotes & Wrong placed rs.open