المساعد الشخصي الرقمي

مشاهدة النسخة كاملة : Report not load



C# Programming
11-03-2009, 03:01 AM
Hi all i have a code in to show Date to Date report.When i compile and run it, it cannt show any error but when it run in browser it takes too much time to load and no result is shown. I take this code from an article and i want to implement it. Plz help y it even show parameters and reports???


protected void btnShow_Click(object sender, System.EventArgs e)
{

ReportDocument cryRpt = new ReportDocument();
cryRpt.Load("CrystalReport3.rpt");

TableLogOnInfos crtableLogoninfos = new TableLogOnInfos();
TableLogOnInfo crtableLogoninfo = new TableLogOnInfo();
ConnectionInfo crConnectionInfo = new ConnectionInfo();
Tables CrTables;

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

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

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

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

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

crConnectionInfo.ServerName = "Server1";
crConnectionInfo.DatabaseName = "Coupon Management.mdf";
crConnectionInfo.UserID = "";
crConnectionInfo.Password = "";

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.*******Report();
}