hello,

In my application i am using vb .net 2003 and oracle 10g database and crystal reports, in built in vb.net.
in my oracle 10g database i have one field "Rep_no" in one table. now my datbase is ready, now i want only that report which report no i entered in one textbox, i am passing that textbox's value as a parameter. my code is as below.... please guide me what i have to do? its not working properly.

Dim rptDocument As New CrystalDecisions.CrystalReports.Engine.ReportDocum ent
Dim strReportName As String
Public Shared strFrom As String
Public Shared strTo As String

Dim crParFieldDefinitions As ParameterFieldDefinitions
Dim crParFieldDefinition As ParameterFieldDefinition

Dim crParValues As New ParameterValues
Dim crParDiscreteValue As New ParameterDiscreteValue

-----------on load event of frmpreview---------

rptDocument.Load(strReportPath)
rptDocument.SetDataSource("select * from calibration")

crParFieldDefinitions = rptDocument.DataDefinition.ParameterFields
crParFieldDefinition = crParFieldDefinitions.Item("REP_NO")
crParValues = crParFieldDefinition.CurrentValues
crParDiscreteValue = New CrystalDecisions.Shared.ParameterDiscreteValue
crParDiscreteValue.Value = strFrom
crParValues.Add(crParDiscreteValue)
crParFieldDefinition.ApplyCurrentValues(crParValue s)
CrystalReportViewer2.ReportSource = rptDocument
-------------

I am getting error in crParFieldDefinition = crParFieldDefinitions.Item("REP_NO") ... so please guide me, "REP_NO" is my field name my database, what i have to pass in arguement.I can see all reports when i am clicking on report button in my application but I want to see only specifice report from 1 to 10 reports in my database.

Please guide me as soon as possible
Regards,
Renish

Hello

rptDocument.SetDataSource("select * from calibration where REP_NO = ?")

If only REP_NO is the field on the table.

OR ELSE

rd.SetParameterValue("@UserType", sUserType);

@UserType -> is the parameter of the procedure
sUserType -> is the variable which will be passed to the SP.
rd -> ReportDocument object.

Its always better to create SP with params and pass params at
the run time and get the data to the input

Hope this helps

With Regards,
Raghavendra Mudugal