Posted on: 1/25/2014 5:41:17 AM | Views : 550

Hi,
I want to know how can I send values to Parameter fields in my crystal report through my Windows .cs file.I am using C#.NET platform.Also I want to generate the Sum of a field of my table, AMount.SO I want to calculate the Total AMount.

//cn = new OleDbConnection("Data Source=ABPO222;Initial Catalog=arya_srushti;Integrated Security=True;Integrated Security=sspi;Provider=SQLOLEDB"); //cn.Open(); //da = new OleDbDataAdapter("select Shop_Name, Bill_No, Amount, Reason, date from Expences where date Between '" + check_expense.dt + "' and '" + check_expense.dt2 + "'", cn); //ds = new DataSet(); //da.Fill(ds); //myreport = new CrystalReport1(); //myreport.SetDataSource(ds); //crystalReportViewer1.Refresh(); //crystalReportViewer1.RefreshReport();
Random rnd = new Random();
CrystalReport11.SetParameterValue("?tin", rnd.Next(234117,999999)); ...

Go to the complete details ...