Блог

Я передаю параметр в crystal reports, и когда я загружаю свой отчет, он заставляет меня снова ввести параметр.

Вопрос: Как мне остановить необходимость повторного ввода параметра?

Код:

 try  {  SqlConnection con = new SqlConnection();  SqlCommand cmd = new SqlCommand();  con.ConnectionString = "*********************";  cmd.Connection = con;   con.Open();    cmd.Connection = con;  cmd.CommandType = CommandType.StoredProcedure;  cmd.CommandText = "food_list";  SqlParameter startdate = new SqlParameter("@date", date);  cmd.Parameters.AddWithValue("@date", date);  SqlParameter lu = new SqlParameter("@lunch", lunchs);  cmd.Parameters.AddWithValue("@lunch", lunchs);  SqlDataAdapter dataadapter = new SqlDataAdapter();  dataadapter.SelectCommand = cmd;  DataSet ds = new DataSet();  dataadapter.Fill(ds);    ConnectionInfo connectionInfo = new ConnectionInfo();  ReportDocument RepDoc = new ReportDocument();  connectionInfo.ServerName = "Data Source = 1.1.1.1; Network Library = DBMSSOCN; Initial Catalog = test; User ID = test; Password = test";  connectionInfo.DatabaseName = "test";  string RepPath = Application.StartupPath   @"\CrystalReportview_food.rpt";  RepDoc.Load(RepPath);  RepDoc.SetDatabaseLogon("test", "test");  RepDoc.SetDataSource(ds);  crystalReportViewer1.ReportSource = RepDoc;   ParameterValues parameterValuesdate = new ParameterValues();  ParameterDiscreteValue parameterDiscreteValuedate = new  ParameterDiscreteValue();  parameterDiscreteValuedate.Value =date;  parameterValuesdate.Add(parameterDiscreteValuedate);  ParameterFieldDefinitions parameterFieldDefinitionsdate =  RepDoc.DataDefinition.ParameterFields;  ParameterFieldDefinition parameterFieldDefinitionedate =  parameterFieldDefinitionsdate["@date"];  parameterFieldDefinitionedate.ApplyCurrentValues(parameterValuesdate);   ParameterValues parameterValueslunch = new ParameterValues();  ParameterDiscreteValue parameterDiscreteValuelunch = new  ParameterDiscreteValue();  parameterDiscreteValuelunch.Value = lunchs;  parameterValueslunch.Add(parameterDiscreteValuelunch);  ParameterFieldDefinitions parameterFieldDefinitionslunch =  RepDoc.DataDefinition.ParameterFields;  ParameterFieldDefinition parameterFieldDefinitionelunch =  parameterFieldDefinitionslunch["@lunch"];  parameterFieldDefinitionelunch.ApplyCurrentValues(parameterValueslunch);   con.Close();  }  catch (Exception ex)  {  MessageBox.Show(ex.ToString());  } }