[RESOLVED] Two Dates Parameter

[Simply Me]

Hi! Im using CR9 and new to it. I have tried creating a report that will display client records. I want to generate a monthly reports so I need to use Start and End Date. My problem is, How do I let CR know that I just want to display records between the two dates? Is this done in CR alone or there is a code or controls needed in VB?

An example is highly appreciated and thank you very much in advance!

[joshthenewbie]

report.recordselection = " {NameOfTable.FieldName} => #" & UrStartDate & _
"# AND {NameOfTable.FieldName} <= #" & UrEndDate & "#"

[Simply Me]

are there controls i need to add in the vbform?

[Simply Me]

I have created a report which display the transactions by client just like in the attached file. But I want it to be dynamic. The user enters the start and end date (as well as the month and the year, if needed), after entering, the report should display the results.

An example program is highly appreciated. Thanks in advance!

[causeidm]

What code are you using to bring up the crystal report now?

I mean, basically all you have to do is either use an input box command and get the month then use that variable in the query or create a vb form that asks them for a date range and plug that into your query.

[Simply Me]

this is what i have so far

Option Explicit

Private Sub cmdClose_Click()
  Unload Me
End Sub 'cmdClose_Click

Private Sub Form_Load()
  Dim cReport As CRAXDRT.Report
  Dim cAppn As New CRAXDRT.Application
  
  Call openConnection
  
  Me.Left = LeftPos - 440
  Me.Top = TopPos - 1100

  Screen.MousePointer = vbHourglass
  Set cReport = cAppn.OpenReport(App.Path & "\SuppliesConsumptionReport.rpt")
  CRViewer91.ReportSource = cReport
  CRViewer91.ViewReport
  Screen.MousePointer = vbDefault
  
  Set cReport = Nothing
  Set Appn = Nothing
  
End Sub 'Form_Load

When i run the proj., it ask me to enter the value for the parameters month, year and dates. I have put two DTPicker in the VB form so thats instead of the prog will ask those mentioned, I want to pass the value of DTPicker as values of the parameters.