public void GenerateCharityReport(string sCharity) { string sql = "SELECT orphanexpense.id,orphanexpense.Amount,orphanexpense.Notes,orphanexpense.Added,orphanexpense.Charity,orphanexpense.ChildID,orphanexpense.Balance,sponsoredOrphan.Name " + " from orphanexpense inner join sponsoredorphan on sponsoredorphan.childid=orphanexpense.childid where sponsoredorphan.charity = '" + BMS.PurifySQL(sCharity, 50) + "' order by added"; string html = UICommon.GetCharityTableHTML(sql); var result = Pdf.From(html).Portrait().Content(); Response.Clear(); Response.ContentType = "application/pdf"; string accName = "Charity Report - " + sCharity + ".pdf"; Response.AddHeader("Content-Disposition", "attachment;filename=" + accName); Response.BinaryWrite(result); Response.Flush(); Response.End(); }