从报表中的两个表查询?mysql

在Crystal Report向导中，找到使用用户名和密码创建的odbc。

然后，您将看到一个命令文本，您可以在其中放置查询。

此代码为VB.NET

Private CRPT As New ReportDocument Private APPPATH As String Private PARAM As New ParameterFields Public PARAM_DESC As New ParameterDiscreteValue Private Sub Form1_Load(sender As System.Object, e As System.EventArgs) Handles MyBase.Load

    APPPATH = Application.StartupPath & "\REPORT\sample.rpt"
    CRPT.Load(APPPATH)
    Me.CrystalReportViewer1.ReportSource = CRPT

    PARAM = CRPT.ParameterFields

    PARAM_DESC.Value = Format(DatePicker1.Value, "yyyyMMdd")
    PARAM("DATEP").CurrentValues.Clear()
    PARAM("DATEP").CurrentValues.Add(PARAM_DESC)
    Me.CrystalReportViewer1.Refresh()
End Sub

此代码适用于C＃：

CRPT = new ReportDocument(); APPPATH = Environment.CurrentDirectory + "Sample.rpt"; CRPT.Load(APPPATH); Report_Viewer.Refresh(); CRPT.SetParameterValue("syear", Servercls.year);

        CRPT.SetParameterValue("smonth", Servercls.month);
        CRPT.SetParameterValue("sday", Servercls.day);
        CRPT.SetParameterValue("datevalue", Servercls.Datevalue);
        Report_Viewer.ReportSource = CRPT;

        sc.configureCrystalReport();
        Report_Viewer.Refresh();

您的Crystal Report参数名称必须与“隐藏代码”中的相同。来源：stack overflow