问Crystal Reports上的多个记录

EN

  string sql = @"select    date=convert(varchar,date,103),name,particulars,debit,credit,narrat from ledger" +
            " where name between @name1 and @name2" +
            " and companyID=@companyID" +
            " Order by convert(datetime,date,103) asc";

        SqlCommand cmd = new SqlCommand(sql, con);
        cmd.Parameters.AddWithValue("name1", textBox1.Text);
        cmd.Parameters.AddWithValue("name2", textBox2.Text);
        cmd.Parameters.AddWithValue("companyID", label1.Text);
        SqlDataAdapter dap = new SqlDataAdapter();
        dap.SelectCommand = cmd;
        DataSet7 d7 = new DataSet7();
        dap.Fill(d7, "ledger");
        CrystalMultiLdgerReports cmr = new CrystalMultiLdgerReports();
        cmr.SetDataSource(d7.Tables[0]);
        crystalReportViewer1.ReportSource = cmr;