使用参数创建Crystal Report [英] Create Crystal Report using parameters

问题描述

亲爱的所有人，

我想在两个日期之间的特定任务中创建一个Crystal Report。在这里，我将通过以上三点。但我不能在两个日期之间得到报告。这是我的代码供您检查。请帮我找一些需要改变的地方。我的代码生成所有日期的报告。

  private   void  button_Click（）
 {
 ReportDocument cryRpt =  new  ReportDocument（）; 
 cryRpt.Load（ @  Reports\DatewiseSupplierReport.rpt）; 
 frm_ReportForm _report =  new  frm_ReportForm（）; 
 TableLogOnInfos crtableLogoninfos =  new  TableLogOnInfos（）; 
 TableLogOnInfo crtableLogoninfo =  new  TableLogOnInfo（）; 
 ConnectionInfo crConnectionInfo =  new  ConnectionInfo（）; 
表格CrTables; 
 SqlConnection con =  new  SqlConnection（）; 
  string  [] conString = DBSettings.connectionStringValues（）; 
  string  connectionString =  string  .Format（ @   server = + conString [ 0 ] +  ; database = restaurant; uid = + conString [ 2 ] + < span class =code-string> ; pwd = + conString [ 3  ]）; 
 con.ConnectionString = connectionString; 
 con.Open（）; 
 crConnectionInfo.ServerName = conString [ 0 ]; 
 crConnectionInfo.DatabaseName =   restaurant; 
 crConnectionInfo.UserID = conString [ 2 ]; 
 crConnectionInfo.Password = conString [ 3 ]; 
 
 ParameterFieldDefinitions crParameterFieldDefinitions; 
 ParameterFieldDefinition crParameterFieldDefinition; 
 ParameterValues crParameterValues =  new  ParameterValues（）; 
 ParameterDiscreteValue crParameterDiscreteValue =  new  ParameterDiscreteValue（）; 
 
 crParameterDiscreteValue.Value = cmb_SupplierName.Text; 
 crParameterFieldDefinitions = cryRpt.DataDefinition.ParameterFields; 
 crParameterFieldDefinition = crParameterFieldDefinitions [  SupplierName]; 
 crParameterValues = crParameterFieldDefinition.CurrentValues; 
 
 crParameterValues.Clear（）; 
 crParameterValues.Add（crParameterDiscreteValue）; 
 crParameterFieldDefinition.ApplyCurrentValues（crParameterValues）; 
 
 crParameterDiscreteValue.Value = dateTimePicker1.Value.ToString（）; 
 crParameterFieldDefinitions = cryRpt.DataDefinition.ParameterFields; 
 crParameterFieldDefinition = crParameterFieldDefinitions [  fromDate]; 
 crParameterValues = crParameterFieldDefinition.CurrentValues; 
 
 crParameterValues.Clear（）; 
 crParameterValues.Add（crParameterDiscreteValue）; 
 crParameterFieldDefinition.ApplyCurrentValues（crParameterValues）; 
 
 crParameterDiscreteValue.Value = dateTimePicker2.Value.ToString（）; 
 crParameterFieldDefinitions = cryRpt.DataDefinition.ParameterFields; 
 crParameterFieldDefinition = crParameterFieldDefinitions [  toDate]; 
 crParameterValues = crParameterFieldDefinition.CurrentValues; 
 
 crParameterValues.Add（crParameterDiscreteValue）; 
 crParameterFieldDefinition.ApplyCurrentValues（crParameterValues）; 
 
 CrTables = cryRpt.Database.Tables; 
  foreach （CrystalDecisions.CrystalReports.Engine.Table CrTable  in  CrTables）
 { 
 crtableLogoninfo = CrTable.LogOnInfo; 
 crtableLogoninfo.ConnectionInfo = crConnectionInfo; 
 CrTable.ApplyLogOnInfo（crtableLogoninfo）; 
} 
 
 crystalReportViewer2.ReportSource = cryRpt; 
 crystalReportViewer2.Refresh（）; 
 
} 

在上面，我从combobox获得SupplierName（cmb_SupplierName）

我得到的两个日期是来自datetimepicker1和2.



预付谢谢



Dhinesh Kumar.V

解决方案

访问此链接



http://csharp.net-informations.com/crystal-reports/csharp-crystal-reports-dynamic-login.htm [ ^ ]

Dear All,
I want to create a Crystal Report in a particular task between two dates. Here I am passing all the above three. But I can''t get the report between two dates. Here is my code for you to check. Please help me find what needs to be changed. My code generates a report for all dates.

private void button_Click()
{
 ReportDocument cryRpt = new ReportDocument();
            cryRpt.Load(@"Reports\DatewiseSupplierReport.rpt");
            frm_ReportForm _report = new frm_ReportForm();
            TableLogOnInfos crtableLogoninfos = new TableLogOnInfos();
            TableLogOnInfo crtableLogoninfo = new TableLogOnInfo();
            ConnectionInfo crConnectionInfo = new ConnectionInfo();
            Tables CrTables;
            SqlConnection con = new SqlConnection();
            string[] conString = DBSettings.connectionStringValues();
            string connectionString = string.Format(@"server=" + conString[0] + ";database=restaurant;uid=" + conString[2] + ";pwd=" + conString[3]);
            con.ConnectionString = connectionString;
            con.Open();
            crConnectionInfo.ServerName = conString[0];
            crConnectionInfo.DatabaseName = "restaurant";
            crConnectionInfo.UserID = conString[2];
            crConnectionInfo.Password = conString[3];

            ParameterFieldDefinitions crParameterFieldDefinitions;
            ParameterFieldDefinition crParameterFieldDefinition;
            ParameterValues crParameterValues = new ParameterValues();
            ParameterDiscreteValue crParameterDiscreteValue = new ParameterDiscreteValue();
            
            crParameterDiscreteValue.Value = cmb_SupplierName.Text;
            crParameterFieldDefinitions = cryRpt.DataDefinition.ParameterFields;
            crParameterFieldDefinition = crParameterFieldDefinitions["SupplierName"];
            crParameterValues = crParameterFieldDefinition.CurrentValues;

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

            crParameterDiscreteValue.Value = dateTimePicker1.Value.ToString();
            crParameterFieldDefinitions = cryRpt.DataDefinition.ParameterFields;
            crParameterFieldDefinition = crParameterFieldDefinitions["fromDate"];
            crParameterValues = crParameterFieldDefinition.CurrentValues;

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

            crParameterDiscreteValue.Value = dateTimePicker2.Value.ToString();
            crParameterFieldDefinitions = cryRpt.DataDefinition.ParameterFields;
            crParameterFieldDefinition = crParameterFieldDefinitions["toDate"];
            crParameterValues = crParameterFieldDefinition.CurrentValues;

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

            CrTables = cryRpt.Database.Tables;
            foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables)
            {
                crtableLogoninfo = CrTable.LogOnInfo;
                crtableLogoninfo.ConnectionInfo = crConnectionInfo;
                CrTable.ApplyLogOnInfo(crtableLogoninfo);
            }

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

}

In the above, I get SupplierName from combobox(cmb_SupplierName)
The two dates I get are from datetimepicker1 and 2.

Thanks in Advance

Dhinesh Kumar.V

解决方案

visit this link

http://csharp.net-informations.com/crystal-reports/csharp-crystal-reports-dynamic-login.htm[^]

这篇关于使用参数创建Crystal Report的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！