private void ReportViewer1OnLoad(object sender, EventArgs eventArgs) { var ds = new DataSetLog(); var reportDataSource = new ReportDataSource(); ds.BeginInit(); reportDataSource.Name = "DataSetLog"; reportDataSource.Value = ds.LogExport; ReportViewer1.LocalReport.DataSources.Add(reportDataSource); ReportViewer1.LocalReport.ReportEmbeddedResource = "TemperatureRecorder.Report2.rdlc"; ReportViewer1.LocalReport.EnableExternalImages = true; ds.EndInit(); ds.LogExport.Clear(); ds.LogExport.AddLogExportRow(Export.ItemName, Export.StartDate, Export.EndDate, Export.Graph, Export.HashValue, Export.Min, Export.Max); var pageSettings = new PageSettings(); pageSettings.Margins.Top = 0; pageSettings.Margins.Bottom = 0; pageSettings.Margins.Left = 0; pageSettings.Margins.Right = 0; var pageSize = new PaperSize(); pageSize.RawKind = (int)PaperKind.A4; pageSettings.PaperSize = pageSize; pageSettings.Landscape = true; ReportViewer1.SetPageSettings(pageSettings); ReportViewer1.RefreshReport(); }
private void GenerateReport() { //dataTable ReportViewer1.Reset(); DataTable dt = GetData(); ReportDataSource dataSource = new ReportDataSource("DataSet1", dt); ReportViewer1.LocalReport.DataSources.Add(dataSource); ReportViewer1.LocalReport.ReportPath = "Laporan/InvRusak.rdlc"; PageSettings pg = new System.Drawing.Printing.PageSettings(); pg.Margins.Top = 0; pg.Margins.Bottom = 0; pg.Margins.Left = 0; pg.Margins.Right = 0; PrinterSettings ps = new System.Drawing.Printing.PrinterSettings(); ps.PrinterName = "Microsoft XPS Document Writer"; PaperSize size = new PaperSize(); size.RawKind = (int)PaperKind.A4; pg.PaperSize = size; pg.PrinterSettings = ps; ReportViewer1.SetPageSettings(pg); ReportViewer1.LocalReport.Refresh(); }
private void GenerateReport() { //dataTable string idPengajuan = Request.QueryString["IdPengajuan"]; ReportViewer1.Reset(); ReportViewer1.LocalReport.ReportPath = "Laporan/PengajuanInvDetail.rdlc"; PengajuanDomain peDomain = GeneratePengajuan(idPengajuan); ReportParameter[] parameters = new ReportParameter[5]; parameters[0] = new ReportParameter("IDPengajuan", peDomain.IDPengajuan); parameters[1] = new ReportParameter("TglPengajuan", peDomain.Tgl); // parameters[2] = new ReportParameter("Judul", peDomain.Hal); parameters[2] = new ReportParameter("Judul", peDomain.Judul); parameters[3] = new ReportParameter("Keterangan", peDomain.Keterangan); if (peDomain.Prioritas.Equals("3")) { parameters[4] = new ReportParameter("Prioritas", "Normal"); } else if (peDomain.Prioritas.Equals("2")) { parameters[4] = new ReportParameter("Prioritas", "Penting"); } else if (peDomain.Prioritas.Equals("1")) { parameters[4] = new ReportParameter("Prioritas", "Urgen"); } ReportViewer1.LocalReport.SetParameters(parameters); DataTable dt = GetData(peDomain.IDPengajuan); ReportDataSource dataSource = new ReportDataSource("DataSet1", dt); ReportViewer1.LocalReport.DataSources.Add(dataSource); ReportViewer1.ShowPrintButton = true; PageSettings pg = new System.Drawing.Printing.PageSettings(); pg.Margins.Top = 0; pg.Margins.Bottom = 0; pg.Margins.Left = 0; pg.Margins.Right = 0; PrinterSettings ps = new System.Drawing.Printing.PrinterSettings(); ps.PrinterName = "Microsoft XPS Document Writer"; PaperSize size = new PaperSize(); size.RawKind = (int)PaperKind.A4; pg.PaperSize = size; pg.PrinterSettings = ps; ReportViewer1.SetPageSettings(pg); ReportViewer1.LocalReport.Refresh(); }
private void GenerateReport() { //dataTable string idPengajuan = Request.QueryString["IdPembelian"]; ReportViewer1.Reset(); ReportViewer1.LocalReport.ReportPath = "Laporan/PembelianDetail.rdlc"; PembelianDomain peDomain = GeneratePembelian(idPengajuan); ReportParameter[] parameters = new ReportParameter[6]; parameters[0] = new ReportParameter("NoPembelian", peDomain.IDPembelian); parameters[1] = new ReportParameter("TglBeli", peDomain.Tgl); // parameters[2] = new ReportParameter("Judul", peDomain.Hal); parameters[2] = new ReportParameter("Keterangan", peDomain.Keterangan); parameters[3] = new ReportParameter("RefPengajuan", peDomain.RefPengajuan); parameters[4] = new ReportParameter("HargaTotal", peDomain.HargaTotal); parameters[5] = new ReportParameter("Status", peDomain.status); ReportViewer1.LocalReport.SetParameters(parameters); DataTable dt = GetData(peDomain.RefPengajuan); ReportDataSource dataSource = new ReportDataSource("DataSet1", dt); ReportViewer1.LocalReport.DataSources.Add(dataSource); ReportViewer1.ShowPrintButton = true; PageSettings pg = new System.Drawing.Printing.PageSettings(); pg.Margins.Top = 0; pg.Margins.Bottom = 0; pg.Margins.Left = 0; pg.Margins.Right = 0; PrinterSettings ps = new System.Drawing.Printing.PrinterSettings(); ps.PrinterName = "Microsoft XPS Document Writer"; PaperSize size = new PaperSize(); size.RawKind = (int)PaperKind.A4; pg.PaperSize = size; pg.PrinterSettings = ps; ReportViewer1.SetPageSettings(pg); ReportViewer1.LocalReport.Refresh(); }
private void GenerateReport() { //dataTable ReportViewer1.Reset(); ReportViewer1.LocalReport.ReportPath = "Laporan/ServiceKeluarDetail.rdlc"; ServiceKeluar peDomain = GenerateService(TbIDNoPengajuan.Text); ReportParameter[] parameters = new ReportParameter[6]; parameters[0] = new ReportParameter("IDService", peDomain.id); parameters[1] = new ReportParameter("JudulService", peDomain.Judul); parameters[2] = new ReportParameter("Status", peDomain.Status); parameters[3] = new ReportParameter("TglService", peDomain.TglService); parameters[4] = new ReportParameter("RefService", peDomain.RefService); parameters[5] = new ReportParameter("Keterangan", peDomain.Keterangan); ReportViewer1.LocalReport.SetParameters(parameters); DataTable dt = GetData(peDomain.RefService); ReportDataSource dataSource = new ReportDataSource("DataSet1", dt); ReportViewer1.LocalReport.DataSources.Add(dataSource); ReportViewer1.ShowPrintButton = true; PageSettings pg = new System.Drawing.Printing.PageSettings(); pg.Margins.Top = 0; pg.Margins.Bottom = 0; pg.Margins.Left = 0; pg.Margins.Right = 0; PrinterSettings ps = new System.Drawing.Printing.PrinterSettings(); ps.PrinterName = "Microsoft XPS Document Writer"; PaperSize size = new PaperSize(); size.RawKind = (int)PaperKind.A4; pg.PaperSize = size; pg.PrinterSettings = ps; ReportViewer1.SetPageSettings(pg); ReportViewer1.LocalReport.Refresh(); }
private void GenerateReport() { //dataTable ReportViewer1.Reset(); ReportViewer1.LocalReport.ReportPath = "Laporan/PengajuanInvDetail.rdlc"; PengajuanDomain peDomain = GeneratePengajuan(TbIDNoPengajuan.Text); ReportParameter[] parameters = new ReportParameter[6]; parameters[0] = new ReportParameter("No", peDomain.No); parameters[1] = new ReportParameter("TglPengajuan", peDomain.TglPengajuan); parameters[2] = new ReportParameter("Hal", peDomain.Hal); parameters[3] = new ReportParameter("Keterangan", peDomain.Keterangan); parameters[4] = new ReportParameter("Prioritas", peDomain.Prioritas); parameters[5] = new ReportParameter("Pengaju", peDomain.Pengaju); ReportViewer1.LocalReport.SetParameters(parameters); DataTable dt = GetData(peDomain.id); ReportDataSource dataSource = new ReportDataSource("DS_V_Pengajuan_report_detail", dt); ReportViewer1.LocalReport.DataSources.Add(dataSource); ReportViewer1.ShowPrintButton = true; PageSettings pg = new System.Drawing.Printing.PageSettings(); pg.Margins.Top = 0; pg.Margins.Bottom = 0; pg.Margins.Left = 0; pg.Margins.Right = 0; PrinterSettings ps = new System.Drawing.Printing.PrinterSettings(); ps.PrinterName = "Microsoft XPS Document Writer"; PaperSize size = new PaperSize(); size.RawKind = (int)PaperKind.A4; pg.PaperSize = size; pg.PrinterSettings = ps; ReportViewer1.SetPageSettings(pg); ReportViewer1.LocalReport.Refresh(); }
private void GenerateReport() { //dataTable ReportViewer1.Reset(); DataTable dt = GetData(); ReportDataSource dataSource = new ReportDataSource("DSet_V_Pengajuan_Report", dt); ReportViewer1.LocalReport.DataSources.Add(dataSource); ReportViewer1.LocalReport.ReportPath = "Laporan/PengajuanInv.rdlc"; ReportViewer1.ShowPrintButton = true; ReportParameter[] parameters = new ReportParameter[2]; parameters[0] = new ReportParameter("TglDari", TbTanggalDari.Text); parameters[1] = new ReportParameter("TglKe", TbTanggalKe.Text); ReportViewer1.LocalReport.SetParameters(parameters); PageSettings pg = new System.Drawing.Printing.PageSettings(); pg.Margins.Top = 0; pg.Margins.Bottom = 0; pg.Margins.Left = 0; pg.Margins.Right = 0; PrinterSettings ps = new System.Drawing.Printing.PrinterSettings(); ps.PrinterName = "Microsoft XPS Document Writer"; PaperSize size = new PaperSize(); size.RawKind = (int)PaperKind.A4; pg.PaperSize = size; pg.PrinterSettings = ps; ReportViewer1.SetPageSettings(pg); ReportViewer1.LocalReport.Refresh(); }
private void GenerateReport() { string id = Request.QueryString["IdPenugasan"]; //dataTable ReportViewer1.Reset(); DataTable dt = GetData(id); DataTable dt2 = GetDetail(id); DataTable dt3 = GetDetailLain(id); ReportDataSource dataSource = new ReportDataSource("DSPenugasan", dt); ReportDataSource dataSource2 = new ReportDataSource("DSPerbaikanDetail", dt2); ReportDataSource dataSource3 = new ReportDataSource("DSPenugasanLain", dt3); ReportViewer1.LocalReport.DataSources.Add(dataSource); ReportViewer1.LocalReport.DataSources.Add(dataSource2); ReportViewer1.LocalReport.DataSources.Add(dataSource3); ReportViewer1.LocalReport.ReportPath = "Laporan/PerbaikanBarang.rdlc"; PageSettings pg = new System.Drawing.Printing.PageSettings(); pg.Margins.Top = 0; pg.Margins.Bottom = 0; pg.Margins.Left = 0; pg.Margins.Right = 0; PrinterSettings ps = new System.Drawing.Printing.PrinterSettings(); ps.PrinterName = "Microsoft XPS Document Writer"; PaperSize size = new PaperSize(); size.RawKind = (int)PaperKind.A4; pg.PaperSize = size; pg.PrinterSettings = ps; ReportViewer1.SetPageSettings(pg); ReportViewer1.LocalReport.Refresh(); }
private void GenerateReport() { //dataTable ReportViewer1.Reset(); ReportViewer1.LocalReport.ReportPath = "Laporan/PenerimaanDetail.rdlc"; PenerimaanDomain peDomain = GeneratePenerimaan(TbID.Text); ReportParameter[] parameters = new ReportParameter[5]; parameters[0] = new ReportParameter("NoPenerimaan", peDomain.No); parameters[1] = new ReportParameter("TglPenerimaan", peDomain.TglPenerimaan); parameters[2] = new ReportParameter("Hal", peDomain.Hal); parameters[3] = new ReportParameter("Keterangan", peDomain.Keterangan); /* * if (peDomain.Tipe.Equals("1")) * { * parameters[4] = new ReportParameter("Tipe", "Dengan Pengajuan Barang"); * * } * else if (peDomain.Tipe.Equals("2")) * { * parameters[4] = new ReportParameter("Tipe", "Dengan Pengajuan Service"); * * } * else * { * parameters[5] = new ReportParameter("Tipe", "Tanpa Pengajuan"); * } * * SqlConnection conn = Common.getConnection(); * string query = ""; * SqlCommand cmd = new SqlCommand(); * cmd.Connection = conn; * cmd.CommandType = System.Data.CommandType.Text; * * * if (peDomain.Tipe.Equals("1")) * { * query = "select no_pengajuan from t_pengajuan_inventaris where id = " + peDomain.id + ""; * * } * else if (peDomain.Tipe.Equals("2")) * { * query = "select no_pengajuan from t_pengajuan_service where id = " + peDomain.id + ""; * * } * cmd.CommandText = query; * * conn.Open(); * try * { * SqlDataReader reader = cmd.ExecuteReader(); * reader.Read(); * string pengajuan = reader["no_pengajuan"].ToString().Trim(); * parameters[5] = new ReportParameter("RefPengajuan", pengajuan); * * } * catch * { * } * * conn.Close(); */ parameters[4] = new ReportParameter("RefPengajuan", peDomain.RefPengajuan); ReportViewer1.LocalReport.SetParameters(parameters); DataTable dt = GetData(peDomain); ReportDataSource dataSource = new ReportDataSource("DataSet1", dt); ReportViewer1.LocalReport.DataSources.Add(dataSource); ReportViewer1.ShowPrintButton = true; PageSettings pg = new System.Drawing.Printing.PageSettings(); pg.Margins.Top = 0; pg.Margins.Bottom = 0; pg.Margins.Left = 0; pg.Margins.Right = 0; PrinterSettings ps = new System.Drawing.Printing.PrinterSettings(); ps.PrinterName = "Microsoft XPS Document Writer"; PaperSize size = new PaperSize(); size.RawKind = (int)PaperKind.A4; pg.PaperSize = size; pg.PrinterSettings = ps; ReportViewer1.SetPageSettings(pg); System.Diagnostics.Debug.WriteLine("RPT " + ReportViewer1.Width); ReportViewer1.LocalReport.Refresh(); }
/// <summary> /// 打印 /// </summary> /// <param name="startIndex"></param> /// <returns></returns> private void Print() { try { var item = PrintData.Data[Index]; m_currentPageIndex = 0; m_streams = null; PageSettings ps = Config.GetPageSettings(); ReportViewer1.SetPageSettings(ps); ReportViewer1.LocalReport.ReportPath = Config.TemplateLocation(PrintData.PrintTemplate.FileName); ReportViewer1.LocalReport.DataSources.Clear(); ReportViewer1.LocalReport.DataSources.Add(new ReportDataSource(PrintData.PrintTemplate.DataSetName, item.ToDataTable())); var printParams = PrintData.PrintTemplate.PrintParams; if (printParams.Count > 0) { int j = 0; foreach (var parameter in ReportViewer1.LocalReport.GetParameters()) { var db_param = PrintData.PrintTemplate.PrintParams.Find(p => p.PrintParamName == parameter.Name); string fileName = $"{PrintData.PrintTemplate.PrintTemplateID}_{db_param.Value}{Index}{j++}"; switch (db_param.ParamType) { case ParamType.BarCode: //创建条形码文件 fileName += "1D"; string value = CanCreateCode(db_param, item, out bool isCreate); if (isCreate == false) { Message = $"值({value})不能生成条形码"; return; } PrintReport.CreateBarCode(value, fileName, Config.TempleAddress); break; case ParamType.QRCode: //创建二维码 fileName += "2D"; value = CanCreateCode(db_param, item, out isCreate); if (isCreate == false) { Message = $"值({value})不能生成条形码"; } PrintReport.CreateQRCode(value, fileName, Config.TempleAddress); break; case ParamType.Other: ReportViewer1.LocalReport.SetParameters(new ReportParameter (parameter.Name, Convert.ToString(item[db_param.Value]))); continue; case ParamType.SQL: value = "0"; if (item.ContainsKey(db_param.Value)) { value = Convert.ToString(item[db_param.Value]); } ReportViewer1.LocalReport.SetParameters(new ReportParameter (parameter.Name, value)); continue; } var file = Path.Combine(Config.TempleAddress, fileName + ".bmp"); ReportViewer1.LocalReport.SetParameters(new ReportParameter(parameter.Name, "file://" + file)); } ReportViewer1.SetDisplayMode(DisplayMode.PrintLayout); ReportViewer1.ZoomMode = ZoomMode.Percent; ReportViewer1.ZoomPercent = 100; } } catch (Exception ex) { Message = ex.Message; } }