Exporting Crystal Report

  protected void cmdGenerate_Click(object sender, EventArgs e)

        {

            ReportDocument repDoc = new ReportDocument();

            repDoc.Load(Server.MapPath("TicketReport.rpt")); // Your Cystal Report Name. If placed the Report in Project                                                                                 //Folders, You should specify as foldername/CrystalReportname

            

            TableLogOnInfo crtableLogoninfo = new TableLogOnInfo(); // Login Credentials for Report, if need

            ConnectionInfo crConnectionInfo = new ConnectionInfo();

            crConnectionInfo.ServerName = WebConfigurationManager.AppSettings["ServerName"];

            crConnectionInfo.DatabaseName = WebConfigurationManager.AppSettings["DatabaseName"];

            crConnectionInfo.UserID = WebConfigurationManager.AppSettings["UserID"];

            crConnectionInfo.Password = WebConfigurationManager.AppSettings["Password"];

            crtableLogoninfo = repDoc.Database.Tables[0].LogOnInfo;

            crtableLogoninfo.ConnectionInfo = crConnectionInfo;

            repDoc.Database.Tables[0].ApplyLogOnInfo(crtableLogoninfo);

            Response.Buffer = false;

            ParameterField ticketTransactionId = repDoc.ParameterFields[0];        // Passing Parameters to Report.

            ParameterDiscreteValue tickettranvalue = new ParameterDiscreteValue();

            tickettranvalue.Value ="Parameter"; //Value for parameter

            ticketTransactionId.CurrentValues.Add(tickettranvalue);

            ParameterField baseURLParameter = repDoc.ParameterFields[1];

            ParameterDiscreteValue baseURLParameterValue = new ParameterDiscreteValue();

            baseURLParameterValue.Value = "Parameter";

            baseURLParameter.CurrentValues.Add(baseURLParameterValue);

                

            repDoc.ExportToHttpResponse(ExportFormatType.PortableDocFormat, Response, true, "Ticket"); // filename in " "

        }