Printable View
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!
report.recordselection = " {NameOfTable.FieldName} => #" & UrStartDate & _
"# AND {NameOfTable.FieldName} <= #" & UrEndDate & "#"
are there controls i need to add in the vbform?
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!
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.
this is what i have so far
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.Code: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