如何在crystal报表中传递参数和Sql查询 [英] How to pass parameter and Sql query in crystal report

问题描述

我在Windows应用程序的Crystal报表中有参数和exec查询的问题。我可以显示参数值和sql查询值，但我的问题是我可以显示任何一个



如果我在水晶报表中显示参数值我无法显示sql查询值，类似参数值



这里我的代码是：

I have prob with parameter and exec query in Crystal report in windows application. i can display both parameter value and sql query value, but my prob is i can display either one

In case i display parameter value in crystal report i can't display sql query value, similarly parameter value

Here My Code IS:

DataTable dt3 = new DataTable();
            Qry1 = "select EmpCodeC, convert(varchar,dated,103) as dated from ShiftTable where dated between '01/Oct/2014' and '07/Oct/2014' and EmpCodeC='18'";
            dt3 = Dt_Args(Qry1);
            if (dt3.Rows.Count == 7)
            {
                for (int d = 0; d <= 6; d++)
                {
                    Drow["Day"] = dt3.Rows[d]["dated"].ToString();
                    dt4.Rows.Add(Drow);
                    Drow = dt4.NewRow();
                    RptDoc.Load(@"E:\Prasanna\WindowsApplication\Crytal_Rpt\Crytal_Rpt\CrystalReport1.rpt");
                    string strD = "col" + (d + 1).ToString();
                    var D = dt3.Rows[d]["dated"].ToString();
                    RptDoc.SetParameterValue("col" + (d + 1).ToString(), dt3.Rows[d]["dated"].ToString());
                    //crystalReportViewer1.ReportSource = RptDoc;
                }

                //crystalReportViewer1.ParameterFieldInfo = paramFields;
            }
            else
            {
                MessageBox.Show("Choose Date With 7 Days");
            }

            crystalReportViewer1.ParameterFieldInfo = paramFields;
            //crystalReportViewer1.ReportSource = RptDoc;
            SqlDataAdapter dscmd = new SqlDataAdapter("select EmpnameC from ShiftTable where empcodec='18' and dated = '01/Oct/2014'", cnn);
            DataSet ds = new DataSet();
            dscmd.Fill(ds);
            objRpt.SetDataSource(ds);
            crystalReportViewer1.ReportSource = RptDoc;
            //crystalReportViewer1.ReportSource = objRpt;
            crystalReportViewer1.Refresh();

推荐答案

将参数传递给Crystl Report的代码如下：

The code to pass parameter to Crystl Report is as follows:

private void button1_Click(object sender, EventArgs e)
 {
        ReportDocument cryRpt = new ReportDocument();
        cryRpt.Load("PUT CRYSTAL REPORT PATH HERE\CrystalReport1.rpt");

        ParameterFieldDefinitions crParameterFieldDefinitions ;
        ParameterFieldDefinition crParameterFieldDefinition ;
        ParameterValues crParameterValues = new ParameterValues();
        ParameterDiscreteValue crParameterDiscreteValue = new ParameterDiscreteValue();

        crParameterDiscreteValue.Value = textBox1.Text;
        crParameterFieldDefinitions = cryRpt.DataDefinition.ParameterFields;
        crParameterFieldDefinition = crParameterFieldDefinitions["Customername"];
        crParameterValues = crParameterFieldDefinition.CurrentValues;

        crParameterValues.Clear();
        crParameterValues.Add(crParameterDiscreteValue);
        crParameterFieldDefinition.ApplyCurrentValues(crParameterValues);

        crystalReportViewer1.ReportSource = cryRpt;
        crystalReportViewer1.Refresh(); 

    }

详细信息冷藏链接：

http://csharp.net-informations.com/crystal-reports/csharp-crystal- reports-string-parameter.htm [ ^ ]

这篇关于如何在crystal报表中传递参数和Sql查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！