hello all

i have 1 table feld having no ,name

i have one textbox when i input name it should return me according to name (input) i gave

and in report i have Inserted both field (no ,name) while it is being asked while i added it from new Item



Problem is This code shows all record in table and i can not see any Parameter in with TICK sign even if i put it on as a new parameter in field Explorer.


Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
If Not IsPostBack Then

Dim crpt As New cr1 (crytal report object )

Dim cn As New SqlConnection("workstation id=JIG;packet size=4096;integrated security=SSPI;data source=jig;persist security info=False;initial catalog=xx")

Dim cmd As New SqlCommand("sp1", cn)

cmd.CommandType = CommandType.StoredProcedure

cmd.Parameters.Add("@p1", txt1.Text)

Dim da As New SqlDataAdapter(cmd)

da.Fill(ds)

crpt.SetDataSource(ds)

crw.ReportSource = crpt (crystal report viewer object)

End If



my Sp1 is

ALTER PROCEDURE

dbo.sp1
@p1 varchar


AS

select * from tbl Where name='@p1'

RETURN


pls help me ......

cmd.Parameters.Add("parm1",Sring) means u r adding a parameter to command not assiging a value to sp's parameter (or to cmd parameter)

use cmd.Parameters("parm1").value = textbox.value
or
use cmd.Parameters(0).vaue = textBox.value

to assign value to parameter.
i think i understood ur pronlem and this may be the solution to ur problem.
take care bye for now

no sir my prob is there !!! :(

hello sir i did u said but my AIM is :

1)to create a PARAM in Crystal reports
 (i did is successfully :))

2)pass the value from Textbox as Crystapl report PARAM to Stored procedure and retrieve the report on screen

i tried so many things i ams stucked at 2nd how to pass this values

well first check ur sp. wheather records are returned or not ...
second try to use Formula rather using Parameters in report ...
U can also use ReplaceSelectionFormula of report direct rather passing value to sp then execute it to generate report against each name criteria ...
i dont understand one thing why r u using report parameter to pass value to it mean while u r passing criteria to sp that will also return a single row or multiple row against name; providing from text field.
(this is what i understand ur problem & giving reponse)
take care