Show query parameter in crystal report from vb.net

Question

I executed a query with parameters DtpFrom.Text & DtpTo.Text. I just need to display parameters on report in text object (FromDate & ToDate)

Dim rpt As New TrialBalance_ 'The report created.

    Try

        Dim comd As New OracleCommand("select Jv_acc_name, sum(debit) as debit, sum (CREDIT) as Credit from VOUCHER_DETAIL  GROUP BY jv_acc_name order by JV_ACC_NAME", sgcnn)

        comd.Parameters.Add("From", OracleDbType.Varchar2).Value = DtpFrom.Text
        comd.Parameters.Add("To", OracleDbType.Varchar2).Value = DtpTo.Text

        Dim da As New OracleDataAdapter(comd)

        Dim dt As New DataTable()
        da.Fill(dt)
        rpt.SetDataSource(dt)

        CrvTrialBalance.ReportSource = rpt
        rpt.Refresh()

    Catch ex As Exception

        MsgBox(ex.Message)

    End Try

Please tell me what I need to do for this ......

Answer 1

Create parameters DtpFrom, DtpTo in the Crystal Reports design.

Put them on the report where you want them to show up.

Pass the parameters via code:

  //supposing rpt is a ReportDocument
  rpt.SetParameterValue("DtpFrom", DtpFrom.Text);    
  rpt.SetParameterValue("DtpTo", DtpTo.Text);