how to bind data in crystal report and export in pdf in asp.net web application

See more:

ASP.NET

C#5.0

CrystalReports

hii all.. i am getting data from sql server db in a crystal report viewer..i m using visual studio 2010 and sap crtstal report for vs 2010...

i am gettng the data perfectly but on click on next page the error occurred report source is not available.. if i want to export crystal report data in pdf without show crystal report on web page then no record is exported in pdf..

please help..

my source code is..


protected void Button1_Click(object sender, EventArgs e)
{


ParameterFields paramFields = new ParameterFields();
ParameterDiscreteValue paramDiscreteValue = new ParameterDiscreteValue();
ParameterDiscreteValue paramDiscreteValue1 = new ParameterDiscreteValue();
ParameterDiscreteValue paramDiscreteValue2 = new ParameterDiscreteValue();
ParameterDiscreteValue paramDiscreteValue3 = new ParameterDiscreteValue();

ParameterField paramField = new ParameterField();
ParameterField paramField1 = new ParameterField();
ParameterField paramField2 = new ParameterField();
ParameterField paramField3 = new ParameterField();



paramField1.Name = "@DistrictID";
paramDiscreteValue1.Value = ddlDistricNName.SelectedValue;
paramField1.CurrentValues.Add(paramDiscreteValue1);
paramFields.Add(paramField1);

paramField2.Name = "@BlockID";
paramDiscreteValue2.Value = ddlBlockName.SelectedValue;
paramField2.CurrentValues.Add(paramDiscreteValue2);
paramFields.Add(paramField2);


paramField3.Name = "@Village";
paramDiscreteValue3.Value = ddlVillage.SelectedValue;
paramField3.CurrentValues.Add(paramDiscreteValue3);
paramFields.Add(paramField3);

paramField.Name = "@Habitation";
paramDiscreteValue.Value = ddlHabitation.SelectedValue;
paramField.CurrentValues.Add(paramDiscreteValue);
paramFields.Add(paramField);


CrystalReportViewer1.ParameterFieldInfo = paramFields;


ReportDocument reportDocument = new ReportDocument();
reportDocument.Load(Server.MapPath("CrystalReport2.rpt"));

CrystalReportViewer1.ReportSource = reportDocument;
CrystalReportViewer1.RefreshReport();
reportDocument.SetDatabaseLogon("sa", "scjdata", "ANIL-PC", "abc");

ExportFormatType formatType = ExportFormatType.PortableDocFormat;
reportDocument.ExportToHttpResponse(formatType, Response, true, "Crystal");
Response.End();
}