Visual basic 6 with crystal report

[imagetvr]

I Wish to pass parameter in Crystal Report. I have Access data base one table named

student. I with to select range of data's from that table field named "rno"

i am using visual basic 6

I used following code to view crystal report
================================================
Set rs = New ADODB.Recordset
modConnection.opendb
rs.Open "select * from STUDENT_M order by rno", cn, adOpenStatic, adLockPessimistic
Report.Database.SetDataSource rs
Screen.MousePointer = vbHourglass
CRViewer1.ReportSource = Report
CRViewer1.ViewReport

Screen.MousePointer = vbDefault


==========================================
I am new to crystal report. please guide me how to use parameter in crystal report.


a.Senthil kumar.

[dglienna]

Something like this should work:

Set m_Application = New CRAXDRT.Application
Set m_Report = New CRAXDRT.Report
Set m_Report = m_Application.OpenReport(App.Path & "\ReportName.rpt", 1)   
    m_Report.EnableParameterPrompting = False
     
    Set m_Parameters = m_Report.ParameterFields
    
    For cnt = 1 To m_Parameters.Count
        Set m_Parameter = m_Parameters.item(cnt)
        If m_Parameter.name = "{?testcode}" Then
           m_Parameter.AddCurrentValue "12345"
        End If
    Next
    
    
    frmReportView.CRViewer1.ReportSource = m_Report
    frmReportView.CRViewer1.ViewReport
    
    frmReportView.Show