public ActionResult PrintJob(int id)//ServiceEnquiryId is received here { ReportDocument rd = new ReportDocument(); rd.Load(Path.Combine(Server.MapPath("~/Reports"), "JobRepairOrderProject.rpt")); DataSet ds = new DataSet(); ds.Tables.Add("Head"); ds.Tables.Add("Items"); //-------HEAD ds.Tables["Head"].Columns.Add("ServiceEnquiryRefNo"); ds.Tables["Head"].Columns.Add("ServiceEnquiryDate"); ds.Tables["Head"].Columns.Add("CustomerName"); ds.Tables["Head"].Columns.Add("CDoorNo"); ds.Tables["Head"].Columns.Add("CStreet"); ds.Tables["Head"].Columns.Add("CPhone"); ds.Tables["Head"].Columns.Add("CZip"); ds.Tables["Head"].Columns.Add("CState"); ds.Tables["Head"].Columns.Add("CContactPerson"); //ds.Tables["Head"].Columns.Add("VehicleMake"); //ds.Tables["Head"].Columns.Add("VehicleRegNo"); //ds.Tables["Head"].Columns.Add("VehicleChassisNo"); //ds.Tables["Head"].Columns.Add("VehicleKm"); //ds.Tables["Head"].Columns.Add("BoxMake"); //ds.Tables["Head"].Columns.Add("BoxNo"); //ds.Tables["Head"].Columns.Add("BoxSize"); //ds.Tables["Head"].Columns.Add("FreezerMake"); //ds.Tables["Head"].Columns.Add("FreezerModel"); //ds.Tables["Head"].Columns.Add("FreezerSerialNo"); //ds.Tables["Head"].Columns.Add("FreezerHours"); //ds.Tables["Head"].Columns.Add("TailLiftMake"); //ds.Tables["Head"].Columns.Add("TailLiftModel"); //ds.Tables["Head"].Columns.Add("TailLiftSerialNo"); ds.Tables["Head"].Columns.Add("UnitDetails"); ds.Tables["Head"].Columns.Add("Complaints"); ds.Tables["Head"].Columns.Add("DoorNo"); ds.Tables["Head"].Columns.Add("Street"); ds.Tables["Head"].Columns.Add("State"); ds.Tables["Head"].Columns.Add("CountryName"); ds.Tables["Head"].Columns.Add("Zip"); ds.Tables["Head"].Columns.Add("Fax"); ds.Tables["Head"].Columns.Add("Email"); ds.Tables["Head"].Columns.Add("Phone"); ds.Tables["Head"].Columns.Add("ContactPerson"); ds.Tables["Head"].Columns.Add("OrganizationName"); ds.Tables["Head"].Columns.Add("Image1"); ds.Tables["Head"].Columns.Add("CreatedUser"); ds.Tables["Head"].Columns.Add("CreatedUsersig"); ds.Tables["Head"].Columns.Add("CreatedDes"); //-------DT ds.Tables["Items"].Columns.Add("Date"); ds.Tables["Items"].Columns.Add("Description"); ds.Tables["Items"].Columns.Add("TotalHours"); SaleOrderRepository repo = new SaleOrderRepository(); ServiceEnquiry se = new ServiceEnquiry(); var Head = repo.GetJobPrintHD(id, OrganizationId); DataRow dr = ds.Tables["Head"].NewRow(); dr["ServiceEnquiryRefNo"] = Head.ServiceEnquiryRefNo; dr["ServiceEnquiryDate"] = Head.ServiceEnquiryDate.ToString("dd-MMM-yyyy"); dr["CustomerName"] = Head.CustomerName; dr["CDoorNo"] = Head.CDoorNo; dr["CStreet"] = Head.CStreet; dr["CPhone"] = Head.CPhone; dr["CZip"] = Head.CZip; dr["CState"] = Head.CState; dr["CContactPerson"] = Head.CContactPerson; //dr["VehicleMake"] = Head.VehicleMake; //dr["VehicleRegNo"] = Head.VehicleRegNo; //dr["VehicleChassisNo"] = Head.VehicleChassisNo; //dr["VehicleKm"] = Head.VehicleKm; //dr["BoxMake"] = Head.BoxMake; //dr["BoxNo"] = Head.BoxNo; //dr["BoxSize"] = Head.BoxSize; //dr["FreezerMake"] = Head.FreezerMake; //dr["FreezerModel"] = Head.FreezerModel; //dr["FreezerSerialNo"] = Head.FreezerSerialNo; //dr["FreezerHours"] = Head.FreezerHours; //dr["TailLiftMake"] = Head.TailLiftMake; //dr["TailLiftModel"] = Head.TailLiftModel; //dr["TailLiftSerialNo"] = Head.TailLiftSerialNo; dr["UnitDetails"] = Head.UnitDetails; dr["Complaints"] = Head.Complaints; dr["DoorNo"] = Head.DoorNo; dr["Street"] = Head.Street; dr["State"] = Head.State; dr["CountryName"] = Head.CountryName; dr["Zip"] = Head.Zip; dr["Fax"] = Head.Fax; dr["Email"] = Head.Email; dr["Phone"] = Head.Phone; dr["ContactPerson"] = Head.ContactPerson; dr["OrganizationName"] = Head.OrganizationName; dr["Image1"] = Server.MapPath("~/App_images/") + Head.Image1; dr["CreatedUser"] = Head.CreatedUser; dr["CreatedUsersig"] = Server.MapPath("~/App_images/") + Head.CreatedUsersig; dr["CreatedDes"] = Head.CreatedDes; ds.Tables["Head"].Rows.Add(dr); ds.WriteXml(Path.Combine(Server.MapPath("~/XML"), "JobRepairOrderProject.xml"), XmlWriteMode.WriteSchema); rd.SetDataSource(ds); Response.Buffer = false; Response.ClearContent(); Response.ClearHeaders(); try { Stream stream = rd.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat); stream.Seek(0, SeekOrigin.Begin); return(File(stream, "application/pdf")); } catch (Exception ex) { throw; } }