VB.Net使用Crystal Reports生成开票报告差异客户端 [英] VB.Net Generate Billing Reports Difference Clients Using Crystal Reports

问题描述

我现在已经解决了这个问题。如何通过单击按钮为不同客户生成开票报告。请帮忙并告诉我。在此先感谢。



我有一个现有的代码，但它所能做的就是逐个生成账单报告。这是代码：

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()

推荐答案

我在这里看不到任何问题。要为多个客户端打印帐单，您只需要将报告与客户端数据数据绑定（如客户端表中的数据）。查看这些

发票/结算申请 [ ^ ]

水晶报告 - 收据收据 [ ^ ]

I don't see any problem here. To print bill for multiple clients, you just need to bind the reports with number of clients data(Like data from Clients Table). Check these
Invoice/Billing Application[^]
Crystal Reports - for Bill Receipts[^]

这篇关于VB.Net使用Crystal Reports生成开票报告差异客户端的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！