private PembelianDomain GeneratePembelian(string noId) { SqlConnection conn = Common.getConnection(); string query = ""; SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; cmd.CommandType = System.Data.CommandType.Text; PembelianDomain pDomain = new PembelianDomain(); query = "select * from v_pembelian_report where id_pembelian ='" + noId + "' or no_pembelian ='" + noId + "'"; cmd.CommandText = query; conn.Open(); SqlDataReader reader = cmd.ExecuteReader(); reader.Read(); pDomain.IDPembelian = reader["id_pembelian"].ToString(); pDomain.NoPembelian = reader["no_pembelian"].ToString(); pDomain.Keterangan = reader["keterangan"].ToString(); // pDomain.Keterangan = reader["memo_kabag"].ToString(); pDomain.RefPengajuan = reader["id_pengajuan"].ToString(); pDomain.HargaTotal = reader["harga_total"].ToString(); pDomain.Tgl = reader["tanggal"].ToString(); pDomain.status = reader["status"].ToString(); conn.Close(); return(pDomain); }
// Create a local report for Report.rdlc, load the data, // export the report to an .emf file, and print it. private void RunPrint() { LocalReport report = new LocalReport(); report.ReportPath = "Laporan/PembelianDetail.rdlc"; PembelianDomain peDomain = GeneratePembelian(TbIDNoPembelian.Text); ReportParameter[] parameters = new ReportParameter[6]; parameters[0] = new ReportParameter("NoPembelian", peDomain.NoPembelian); 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); report.SetParameters(parameters); DataTable dt = GetData(peDomain.IDPengajuan); report.DataSources.Add(new ReportDataSource("DS_Pembelian_Detail", dt)); Export(report); Print(); }
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(); }