Export to PDF in while loop in asp.net c#

See more:

ASP.NET

CrystalReports

Hi,

I want to export crystal report in PDF file format.

what i want is i want to create multiple pdf files in loop.

but i am getting error.

first report it creates properly but when in loop to other record it throwing error.

following is my code for that.

while (objReaderRegno.Read())
               {
                   regno = objReaderRegno[0].ToString();
                   staff_Cd = objReaderRegno[1].ToString();

                   ReportDocument rpt = new ReportDocument();
                   objclsReport = new clsReport();

                   int NewVal = Convert.ToInt16(regno);
                   string Path = Server.MapPath("Reports//form12ba_16_217_27a//rep_form12ba.rpt");
                   rpt.Load(Path);
                   rpt = objclsReport.SetReportConnection(rpt);
                   rpt.SetParameterValue("from_dt", "1/4/2009"); //Convert.ToDateTime(txtFromDate12BA.Text).ToString("dd/MMM/yyyy"));
                   rpt.SetParameterValue("p_reg_no", regno);
                   rpt.SetParameterValue("print_date", "1/4/2009"); //Convert.ToDateTime(txtPrintDate12BA.Text).ToString("dd/MMM/yyyy"));

                  // ScriptManager.RegisterClientScriptBlock(this.UpdatePanel1, this.UpdatePanel1.GetType(), "reportshow", "alert('" + regno + "');", true);

                   string FileName = @"d:\testfile\" + "12BA-" + fin_year_subtext + "-" + staff_Cd+".pdf";
                   //rpt.ExportToDisk(ExportFormatType.PortableDocFormat, FileName);
                   rpt.ExportToHttpResponse(ExportFormatType.PortableDocFormat, Response, false, FileName);
}

Erro:-

Invalid Argument provided.
Failed to retrieve data from the database.
Error in File rep_form12ba {62DD9BC1-B7D1-465B-B6DB-A1A091C9D236}.rpt:
Invalid argument for database.