filtering reports in a dataenvironment in VB6

[Ewasonyiro]

Hallo guys,
I'm still learning vB and would like to know how to filter report in a dataenvironment. For example I'm doing a water billing and would like to print an invoice for a customer and also a receipt.Another example would be to get all the customers with balances. Thanks in advance

[Hack]

Moved to Reporting

[kuldevbhasin]

hi...
this is what i have done and it works.....though there may b bettr way to do it...and am new to vb.net this code i have used for vb.net 2003


Private Sub btnPrint_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnPrint.Click
Dim crForm As New FrmReportViewer
Dim Fltr As String
Dim mRpt As New rptRecoverySheetSent

Try

Dim CRViewer As New CrystalDecisions.Windows.Forms.CrystalReportViewer

crForm.CrystalReportViewer3.ReportSource = mRpt

Fltr = "{RecoveryStatmentSent.BranchCode} = '" & txtBranchCode.Text & "'"

If txtSubBranchCode.Text = Nothing Then
Else
Fltr = Fltr & " AND {RecoveryStatmentSent.SubBranchCode} = '" & txtSubBranchCode.Text & "'"
End If
Fltr = Fltr & " AND Day({RecoveryStatmentSent.FromDate}) = " & Day(dtpkFromDate.Value)
Fltr = Fltr & " AND Month({RecoveryStatmentSent.FromDate}) = " & Month(dtpkFromDate.Value)
Fltr = Fltr & " AND Year({RecoveryStatmentSent.FromDate}) = " & Year(dtpkFromDate.Value)
crForm.CrystalReportViewer3.SelectionFormula = (Fltr)

crForm.Show()
Catch ex As Exception
MessageBox.Show(ex.Message)
End Try

End Sub