کریستال ریپورت

[fakhravari]

با سلام
دوستان یه کدی پیدا کردم شاید بدرد دوستان خورد
private void Filter_Btn_Click(object sender, EventArgs e)
{
ReportDocument cryRpt = new ReportDocument();
TableLogOnInfos crtableLogoninfos = new TableLogOnInfos();
TableLogOnInfo crtableLogoninfo = new TableLogOnInfo();
ConnectionInfo crConnectionInfo = new ConnectionInfo();

cryRpt.Load("D:\\MY_THESIS\\WORKING FILES\\WindowsFormsApplication2\\WindowsFormsAppli cation2\\Reports\\Crystal Reports\\UsersReport.rpt");
crConnectionInfo.ServerName = "RITZEL-PC\\SQLEXPRESS";
crConnectionInfo.UserID = "NNIT-Admin";
crConnectionInfo.Password = "password";
crConnectionInfo.DatabaseName = "NNIT DB";

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

// Create parameter objects
ParameterFields myParams = new ParameterFields();

//PARAMETER NAME
ParameterField myParam = new ParameterField();
ParameterDiscreteValue myDiscreteValue = new ParameterDiscreteValue();
myParam.ParameterFieldName = "actualStart";

myDiscreteValue = new ParameterDiscreteValue();
myDiscreteValue.Value = FromCreated_DTime.Value.ToShortDateString();
myParam.CurrentValues.Add(myDiscreteValue);
myParams.Add(myParam);

crystalReportViewer1.ParameterFieldInfo = myParams;
crystalReportViewer1.ReportSource = cryRpt;
}