public void PrintLPO(int id)
{
ReportViewer reportViewer = new ReportViewer();
reportViewer.ProcessingMode = ProcessingMode.Local;
reportViewer.SizeToReportContent = true;
reportViewer.Width = Unit.Percentage(900);
reportViewer.Height = Unit.Percentage(900);
var connectionString = ConfigurationManager.ConnectionStrings["AuthenticationDB"].ConnectionString;
BTCDataSet ds = new BTCDataSet();
Warning[] warnings;
string[] streamIds;
string mimeType = string.Empty;
string encoding = string.Empty;
string extension = string.Empty;
Byte[] bytes;
SqlConnection conx = new SqlConnection(connectionString);
SqlDataAdapter adp;
adp = new SqlDataAdapter("select * FROM LPODetails WHERE LPOID = " + id, conx);
ds = new BTCDataSet();
adp.Fill(ds, ds.LPODetails.TableName);
reportViewer.LocalReport.ReportPath = Path.Combine(@"C:\Users\kanniyappans\Documents\GitHub\BTC\Travel_Request_System\Travel_Request_System_EF\Reports\", "LPOReport.rdlc");
reportViewer.LocalReport.DataSources.Add(new ReportDataSource("detailsDataset", ds.Tables["LPODetails"]));
bytes = reportViewer.LocalReport.Render("PDF", null, out mimeType, out encoding, out extension, out streamIds, out warnings);
Response.Buffer = true;
Response.Clear();
Response.ContentType = mimeType;
Response.AddHeader("content-disposition", "attachment; filename= outputreport" + "." + extension);
Response.OutputStream.Write(bytes, 0, bytes.Length); // create the file
Response.Flush(); // send it to the client to download
Response.End();
}
private string ExportReportToPDF(int id)
{
ReportViewer reportViewer = new ReportViewer();
reportViewer.ProcessingMode = ProcessingMode.Local;
reportViewer.SizeToReportContent = true;
reportViewer.Width = Unit.Percentage(900);
reportViewer.Height = Unit.Percentage(900);
var connectionString = ConfigurationManager.ConnectionStrings["AuthenticationDB"].ConnectionString;
BTCDataSet ds = new BTCDataSet();
Warning[] warnings;
string[] streamIds;
string mimeType = string.Empty;
string encoding = string.Empty;
string extension = string.Empty;
Byte[] bytes;
SqlConnection conx = new SqlConnection(connectionString);
SqlDataAdapter adp;
adp = new SqlDataAdapter("select * FROM LPODetails WHERE LPOID = " + id, conx);
ds = new BTCDataSet();
adp.Fill(ds, ds.LPODetails.TableName);
reportViewer.LocalReport.ReportPath = Path.Combine(@"C:\Users\kanniyappans\Documents\GitHub\BTC\Travel_Request_System\Travel_Request_System_EF\Reports\", "LPOReport.rdlc");
reportViewer.LocalReport.DataSources.Add(new ReportDataSource("detailsDataset", ds.Tables["LPODetails"]));
bytes = reportViewer.LocalReport.Render("PDF", null, out mimeType, out encoding, out extension, out streamIds, out warnings);
string filename = Path.Combine(Path.GetTempPath(), "LPODetails.pdf");
using (var fs = new FileStream(filename, FileMode.Create))
{
fs.Write(bytes, 0, bytes.Length);
fs.Close();
}
return(filename);
}
