Hi ive got crystal reports loading my data successfully from my database, what i wan to do now is to only select certain parts of that data by using the date entered into a text box as part of the selection forumla for the report.

Here is my code :
VB Code:
  1. Imports CrystalDecisions.CrystalReports.Engine

  2. Imports CrystalDecisions.Shared

  3.  
  4. Public Class Form1

  5.  
  6. Dim strdate As String

  7.  
  8.     Private Sub ConfigureCrystalReports() 'Config for Method

  9.  
  10.  
  11.         strdate = TextBox1.Text

  12.  
  13.         Dim mySelectFormula As String = "{Clinic.complete} <> 'yes' " _

  14.         & "AND {Clinic.Booked_date} = 'Strdate' "

  15.  
  16.         MyCrystalReportViewer.SelectionFormula = mySelectFormula

  17.  
  18.         MyCrystalReportViewer.ReportSource = "C:\Documents and Settings\willmg01\VB\ClinicReport\ClinicReport\clinicreport.rpt"

  19.  
  20.     End Sub

  21.  
  22.     Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load

  23.  
  24. End Sub

  25.  
  26.     Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click

  27.  
  28.         strdate = TextBox1.Text

  29.         ConfigureCrystalReports()      'Calls the Method

  30.  
  31.     End Sub

  32. End Class

Any ideas how i can pass the parameter into the method so i can use it in the selection formula?