public byte[] PrintResultPDF(string userNo) { try { Config.WebMode = true; Report rep = new Report(); rep.Load(Server.MapPath("~/App_Data/rptResult.frx")); using (VShapeUpDataContext _context = new VShapeUpDataContext()) { var data = (from x in _context.V_ChallengeResult_Reports where x.UserNo == userNo select x).ToList().ToDataTable(); rep.RegisterData(data, "Report"); DataBand band = rep.FindObject("Data") as DataBand; band.DataSource = rep.GetDataSource("Report"); } if (rep.Report.Prepare()) { PDFExport pdfExport = new PDFExport(); pdfExport.ShowProgress = false; pdfExport.Compressed = true; pdfExport.AllowPrint = true; pdfExport.EmbeddingFonts = true; MemoryStream strm = new MemoryStream(); rep.Report.Export(pdfExport, strm); rep.Dispose(); pdfExport.Dispose(); strm.Position = 0; return(strm.ToArray()); //ImageExport export = new ImageExport(); //MemoryStream strm = new MemoryStream(); //rep.Report.Export(export, strm); //rep.Dispose(); //export.Dispose(); //strm.Position = 0; //return strm.ToArray(); } else { return(null); } } catch (Exception ex) { return(null); } }
private void Rapor(int id, string path, string xpath, string baslik) { WebReport rapor = new WebReport(); string str = "SELECT B.OlusturmaTarihi, kr.Adi,br.Adi,B.Konu,B.CevapTarihi,B.CevapMesaji, B.BasvuruYolu, B.Mesaj, B.Tur, B.EPosta, B.Gsm, B.TcId, B.Ip, B.GrupId, B.Durum, B.Ad, B.Soyad,gr.Adi " + " FROM bildirimler B" + " left join kurumlar kr on kr.id=B.KurumId" + " left join birimler br on br.id=B.BirimId" + " left join gruplar gr on gr.id=B.GrupId " + "where B.Id=" + id + ""; var con = new MySqlConnection(WebConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString); var cmd = new MySqlCommand(str, con); MySqlDataAdapter da = new MySqlDataAdapter(cmd); DataTable Tamami = new DataTable(); da.Fill(Tamami); rapor.RegisterData(Tamami, "rapor"); string pdfadi = "Bildirim_" + id; rapor.Report.Load(Server.MapPath(path)); rapor.Report.RegisterData(Tamami, "Tamami"); // rapor.Load("D:/Projeler/idari/cs/KarmedWeb/MerkeziGorusOneri/HastaneOneriWeb/Rapor/rapor.frx"); if (rapor.Report.Prepare()) { var pdfExport = new PDFExport { ShowProgress = false, Subject = "Subject", Title = "Rapor", Compressed = true, AllowPrint = true, EmbeddingFonts = true }; rapor.Report.Export(pdfExport, Server.MapPath(xpath + pdfadi)); pdfExport.Dispose(); string url = @"loadPencere('Rapor/Raporx/Downloader.aspx?dosya={0}','Rapor',1000,500);"; //wr.Report.Print(); X.ResourceManager.AddScript(string.Format(url, pdfadi)); //rapor.Show(); } }
public static void exportaRelPDF1(String nomeArquivo, String tituloPdf, Report relatorio) { try { relatorio.Prepare(); PDFExport pdfExport = new PDFExport(); relatorio.PrintSettings.ShowDialog = false; pdfExport.ShowProgress = false; // pdfExport.Subject = "NobreSistemas"; pdfExport.Title = tituloPdf; pdfExport.Compressed = true; pdfExport.AllowPrint = true; pdfExport.EmbeddingFonts = true; MemoryStream strm = new MemoryStream(); relatorio.Export(pdfExport, strm); SaveFileDialog salvarPDF = new SaveFileDialog(); salvarPDF.Filter = "Arquivos PDF|*.pdf"; salvarPDF.Title = "Salvar Arquivo em PDF"; salvarPDF.FileName = nomeArquivo;//Irá trazer o nome do arquivo preenchido salvarPDF.ShowDialog(); FileStream arquivoPDF = new FileStream(salvarPDF.FileName, FileMode.Create, FileAccess.Write); strm.WriteTo(arquivoPDF); Alert.informacao("Arquivo Salvo com Sucesso!"); arquivoPDF.Close(); relatorio.Dispose(); pdfExport.Dispose(); strm.Position = 0; } catch (Exception erro) { Alert.erro("Erro ao exportar arquivo PDF \n" + erro.Message); } }