how to pass parameters from vb.net form to a crystal report sql query

[tutu]

hi all,
i want to pass a bill no and client name from a vb.net form to a crystal report sql querry and generate report based on that bill no.please help

 

[DavidT_macktool]

Create string parameters in the report named "BillNo" & "ClientName"
Use the parameters to build your record selection formula.

Whe you want to call the report, you pass the variables like this:

Dim tBillNumber as String = Textbox1.text  
Dim tClientName as String = Textbox2.text     
Dim rpt As New CrystalReport2
rpt.SetParameterValue("BillNo", tBillNumber)
rpt.SetParameterValue("ClientName", tClientName)

Names and types must match, ie.. strings to strings.
If the bill number is an integer change both the report parameter and the form variable.