在下一页中传递cristal报告参数值 [英] Passing cristal report parameter value in next page

问题描述

我想在下一页的cristal报告中传递参数值。例如我想在bill参数中传递bill no 1，在下一个循环中传递no 2 .. bill no 1应该在第一页中显示no 2应该显示在下一页...请帮助我使用cristal report 10和vb.net 10

i want to pass parameter value in cristal report in next page.. For example i want to pass bill no 1 in bill parameter and in next loop bill no 2 .. bill no 1 should show in first page while bill no 2 should show in next page... Please help me iam using cristal report 10 and vb.net 10

推荐答案

private void ShowReport()
    {

        ReportViewer1.LocalReport.SetParameters(new ReportParameter("ReportParameter1", "Created BY :" + user.FIRSTNAME + user.LASTNAME));


        this.ReportViewer1.LocalReport.ReportEmbeddedResource = "Reports.Report.rdlc";
        ReportParameter rp = new ReportParameter("ReportParameter1", "Created By: " + user.FIRSTNAME +" "+ user.LASTNAME);
        ReportParameter rp1 = new ReportParameter("ReportParameter2", "Start Date: " + this.txtDateFrom.Text);
        ReportParameter rp2 = new ReportParameter("ReportParameter3", "End Date: " + this.txtDateTo.Text);
        ReportParameter rp4 = new ReportParameter("ReportParameter4", "DWCExchange Inc.");
        ReportParameter rp5 = new ReportParameter("ReportParameter5", "Total Count: ");

        this.ReportViewer1.LocalReport.SetParameters(new ReportParameter[] { rp, rp1, rp2, rp4, rp5 });
        txtDateFrom1 = txtDateFrom.Text;
        txtDateTo1 = txtDateTo.Text;
        Office1 = drpOffice.SelectedValue;
        ReportViewer1.LocalReport.DataSources.Clear();
        DataSet dsGetHearing = null;

        SqlConnection sqlCon = new SqlConnection();
        // sqlCon.ConnectionString =ConfigurationManager.ConnectionStrings["EDEXConnectionString"].ConnectionString;
        sqlCon.ConnectionString = Utils.getSystemParameter("dsn");

         dsGetHearing = new DataSet();

        SqlCommand cmd = new SqlCommand("SPGetPatientHearing", sqlCon);
        cmd.CommandType = CommandType.StoredProcedure;
        cmd.Parameters.AddWithValue("@Office", Office1);
        cmd.Parameters.AddWithValue("@FuturePrior", "");
        cmd.Parameters.AddWithValue("@Days", "");
        cmd.Parameters.AddWithValue("@FromDate", txtDateFrom1);
        cmd.Parameters.AddWithValue("@ToDate", txtDateTo1);
        cmd.Parameters.AddWithValue("@OutQuery", "");
        cmd.Parameters.AddWithValue("@IsExecute", 1);

        SqlDataAdapter data = new SqlDataAdapter(cmd);
        data.Fill(dsGetHearing);

        ReportDataSource reportDSPartiesList =
new ReportDataSource("DataSet1",
                     dsGetHearing.Tables[0]);
        ReportViewer1.LocalReport.DataSources.Add(reportDSPartiesList);

        ReportViewer1.LocalReport.Refresh();
    }

这篇关于在下一页中传递cristal报告参数值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！