VB.Net Generate Billing Reports Difference Clients Using Crystal Reports

See more:

VB

CrystalReports

reporting

I'm now stuck up with this problem. How can I generate billing reports for different customers in one click of a button. Please help and advise me. Thanks in advance.

I have an existing code but all it can do is to generate billing report one by one. Here's the code:

Dim connection_string As String = "Data Source=.\sqlexpress;Initial Catalog=CreditAndCollection;Integrated Security=True"
    Dim Connection As New SqlConnection(connection_string)
    Connection.Open()
    Dim da As New SqlDataAdapter
    Dim command As New SqlCommand
    command.Connection = Connection
    command.CommandType = CommandType.StoredProcedure
    command.CommandText = "showBillingNum"
    Dim crBillingStatement As New crBillingStatement()
    crBillingStatement.SetParameterValue("@AccountNum", frmBillingStatement.txtAccountNo.Text)
    crBillingStatement.SetParameterValue("@DateFrom", frmBillingStatement.dpFrom.Text)
    crBillingStatement.SetParameterValue("@DateTo", frmBillingStatement.dpTo.Text)
    crvBillingStatement.ReportSource = crBillingStatement
    crvBillingStatement.Refresh()
    Connection.Close()