private void DisplayReport(DataTable dt)
{
string periode = String.Format("{0}", tbTgl.DateValue.Value.ToString("dd-MMM-yyyy"));
double saldoRKBank = tbSaldoRKBank.GetDoubleValue;
double saldoBankRK = Convert.ToDouble(dt.Rows[0]["jml3"]);
double selisih = saldoRKBank - saldoBankRK;
List <ReportParameter> rptParams = new List <ReportParameter>();
rptParams.Add(new ReportParameter("periode", periode));
rptParams.Add(new ReportParameter("nama", _namaBank));
rptParams.Add(new ReportParameter("noAcc", _noAcc));
//call report viewer
frmReportViewer ifrmReport = new frmReportViewer("Kasir.Report.rptBankRekonsiliasi.rdlc", rptParams, dt, "dsBank_Data");
ifrmReport.ExportToExcel(ifrmReport.Name);
if (selisih != 0)
{
MessageBox.Show("Saldo RK Selisih " + selisih.ToString("#,###"));
}
else
{
MessageBox.Show("Saldo RK Sama");
}
}
private void RptMutasiKas(DataSet ds)
{
List <ReportParameter> rptParams = new List <ReportParameter>();
rptParams.Add(new ReportParameter("fromDate", String.Format("{0:dd-MMM-yyyy}", fromDate)));
rptParams.Add(new ReportParameter("toDate", String.Format("{0:dd-MMM-yyyy}", toDate)));
rptParams.Add(new ReportParameter("Kodecabang", GlobalVar.Gudang));
//call report viewer
List <DataTable> pTable = new List <DataTable>();
pTable.Add(ds.Tables[0]);
pTable.Add(ds.Tables[1]);
List <string> pDatasetName = new List <string>();
pDatasetName.Add("dsMutasiKas_Data");
pDatasetName.Add("dsMutasiKas_Data1");
frmReportViewer ifrmReport = new frmReportViewer("Kasir.Report.rptLaporanMutasiKas.rdlc", rptParams, pTable, pDatasetName);
ifrmReport.Text = "lap_mutasikas";
ifrmReport.ExportToExcel(ifrmReport.Name);
}
private void generateReportUpdateJS(DataTable dt)
{
try
{
string periode;
periode = GlobalVar.DateTimeOfServer.AddMonths(-7).AddDays(-(GlobalVar.DateTimeOfServer.AddMonths(-7).Day - 1)).Date.ToString("dd MMM yyyy")
+ " S/D " + GlobalVar.DateTimeOfServer.AddDays(-(GlobalVar.DateTimeOfServer.Day - 1)).AddDays(-1).Date.ToString("dd MMM yyyy");
List <ReportParameter> rptParams = new List <ReportParameter>();
rptParams.Add(new ReportParameter("Periode", periode));
rptParams.Add(new ReportParameter("Cabang", GlobalVar.Gudang));
rptParams.Add(new ReportParameter("UserID", SecurityManager.UserID));
rptParams.Add(new ReportParameter("TglProses", GlobalVar.DateTimeOfServer.Date.ToString("dd-MM-yyyy HH:mm:ss")));
//call report viewer
frmReportViewer ifrmReport = new frmReportViewer("Piutang.Report.rptPlafonBaru_UpdateJS.rdlc", rptParams, dt, "dsPlafonBaru_UpdateJSToko");
ifrmReport.ExportToExcel("LAPORAN PERHITUNGAN JS TOKO");
MessageBox.Show("File Excel JS Toko tersimpan di C:\\Temp\\LAPORAN PERHITUNGAN JS TOKO");
}
catch (System.Exception ex)
{
Error.LogError(ex);
}
finally
{
this.Cursor = Cursors.Default;
}
}
private void RptPertanggungJawaban(DataSet ds)
{
List <ReportParameter> rptParams = new List <ReportParameter>();
rptParams.Add(new ReportParameter("fromDate", String.Format("{0:dd-MMM-yyyy}", fromDate)));
rptParams.Add(new ReportParameter("toDate", String.Format("{0:dd-MMM-yyyy}", toDate)));
//call report viewer
List <DataTable> pTable = new List <DataTable>();
pTable.Add(ds.Tables[0].DefaultView.ToTable());
List <string> pDatasetName = new List <string>();
pDatasetName.Add("dsKasbon_Data");
if (rbModelS.Checked == true)
{
frmReportViewer ifrmReport = new frmReportViewer("Kasir.Report.rptPertanggungJawabanShort.rdlc", rptParams, pTable, pDatasetName);
ifrmReport.Text = "lap_pertanggungjawaban";
ifrmReport.ExportToExcel(ifrmReport.Name);
}
else
{
frmReportViewer ifrmReport = new frmReportViewer("Kasir.Report.rptPertanggungjawabanLong.rdlc", rptParams, pTable, pDatasetName);
ifrmReport.Text = "lap_pertanggungjawaban";
ifrmReport.ExportToExcel(ifrmReport.Name);
}
}
private void DisplayReportRefil(DataTable dt)
{
List <ReportParameter> rptParams = new List <ReportParameter>();
//rptParams.Add(new ReportParameter("tanggal", rangeDateBoxPenjualan.FromDate.Value.ToString()));
// rptParams.Add(new ReportParameter("UserID", SecurityManager.UserID));
//call report viewer
frmReportViewer ifrmReport = new frmReportViewer("Penjualan.RptLaporanRefilToko.rdlc", rptParams, dt, "dsLaporanRefilToko_Data");
//ifrmReport.Show();
ifrmReport.ExportToExcel("Register Penjualan Refill");
}
private void DisplayReportBGD(DataTable dt)
{
string endDate = String.Format("{0}", ((DateTime)dbPeriode.DateValue).ToString("dd-MMM-yyyy"));
List <ReportParameter> rptParams = new List <ReportParameter>();
rptParams.Add(new ReportParameter("endDate", endDate));
//call report viewer
frmReportViewer ifrmReport = new frmReportViewer("Kasir.Report.rptSaldoGiroDitangan.rdlc", rptParams, dt, "dsGiro_Data");
ifrmReport.ExportToExcel(ifrmReport.Name);
}
private void DisplayReport(DataTable dt)
{
//construct parameter
string periode;
periode = String.Format("{0} s/d {1}", ((DateTime)rdbTgl.FromDate).ToString("dd/MM/yyyy"), ((DateTime)rdbTgl.ToDate).ToString("dd/MM/yyyy"));
List <ReportParameter> rptParams = new List <ReportParameter>();
rptParams.Add(new ReportParameter("Periode", periode));
rptParams.Add(new ReportParameter("UserID", SecurityManager.UserID));
//call report viewer
frmReportViewer ifrmReport = new frmReportViewer("Laporan.Toko.rptRegisterPenjualan.rdlc", rptParams, dt, "dsNotaPenjualan_Data");
//ifrmReport.Show();
ifrmReport.ExportToExcel("Register Penjualan_Rekap");
}
private void DisplayReportBGD(DataTable dt)
{
string fromDate = String.Format("{0}", rangeDateBox1.FromDate.Value.ToString("dd-MMM-yyyy"));
string toDate = String.Format("{0}", rangeDateBox1.ToDate.Value.ToString("dd-MMM-yyyy"));
List <ReportParameter> rptParams = new List <ReportParameter>();
rptParams.Add(new ReportParameter("fromDate", fromDate));
rptParams.Add(new ReportParameter("toDate", toDate));
//call report viewer
frmReportViewer ifrmReport = new frmReportViewer("Kasir.Report.rptPenerimaanBlmIdentifikasi.rdlc", rptParams, dt, "dsPenerimaanBlmIden_Data");
ifrmReport.ExportToExcel(ifrmReport.Name);
}
private void DisplayReport(DataTable dt)
{
string TglOpname = String.Format("{0}", ((DateTime)dateTextBox1.DateValue).ToString("dd-MMM-yyyy"));
List <ReportParameter> rptParams = new List <ReportParameter>();
rptParams.Add(new ReportParameter("TglOpname", TglOpname));
//call report viewer
frmReportViewer ifrmReport = new frmReportViewer("Kasir.Report.rptKasOpname.rdlc", rptParams, dt, "dsKasOpname_Data");
ifrmReport.ExportToExcel(ifrmReport.Name);
}
private void DisplayReport(DataTable dt)
{
string fromDate = String.Format("{0}", rangeDateBox1.FromDate.Value.ToString("dd-MMM-yyyy"));
string toDate = String.Format("{0}", rangeDateBox1.ToDate.Value.ToString("dd-MMM-yyyy"));
List <ReportParameter> rptParams = new List <ReportParameter>();
rptParams.Add(new ReportParameter("fromDate", fromDate));
rptParams.Add(new ReportParameter("toDate", toDate));
//call report viewer
frmReportViewer ifrmReport = new frmReportViewer("Kasir.Report.RptLapPiutangKaryawan.rdlc", rptParams, dt, "dsPinjamanPegawai_Data");
ifrmReport.ExportToExcel(ifrmReport.Name);
}
private void DisplayReport(DataTable dt)
{
string periode = String.Format("{0}", tbPeriode.FromDate.Value.ToString("dd-MMM-yyyy")) + " S/D " + String.Format("{0}", tbPeriode.ToDate.Value.ToString("dd-MMM-yyyy"));
List <ReportParameter> rptParams = new List <ReportParameter>();
rptParams.Add(new ReportParameter("periode", periode));
rptParams.Add(new ReportParameter("nama", _namaBank));
rptParams.Add(new ReportParameter("noRek", _noRek));
rptParams.Add(new ReportParameter("jnsRek", _jnsRek));
rptParams.Add(new ReportParameter("saldoAwal", saldoAwal.ToString("#,###")));
rptParams.Add(new ReportParameter("saldoAkhir", saldoAkhir.ToString("#,###")));
rptParams.Add(new ReportParameter("mutasi", mutasi.ToString("#,###")));
//call report viewer
frmReportViewer ifrmReport = new frmReportViewer("Kasir.Report.rptBukuBank.rdlc", rptParams, dt, "dsBank_Data2");
ifrmReport.ExportToExcel(ifrmReport.Name);
}
private void DisplayReport(DataTable ds)
{
string _periode = DateTime.Parse(rangePeriode.FromDate.ToString()).ToString("dd-MMM-yyyy") + " s/d " + DateTime.Parse(rangePeriode.ToDate.ToString()).ToString("dd-MMM-yyyy");
string _type = "Tipe " + comboType.Text;
string _created = "Created by " + SecurityManager.UserID + " on " + DateTime.Now;
List <ReportParameter> rptParams = new List <ReportParameter>();
rptParams.Add(new ReportParameter("Periode", _periode));
rptParams.Add(new ReportParameter("Type", _type));
rptParams.Add(new ReportParameter("Created", _created));
string _dataset = "";
string _rdlc = "";
string _judul;
string _filename = "";
if (cboRekap.Checked)
{
_rdlc = "rptLaporanInsentifSalesRekap.rdlc";
_dataset = "dsInsentifSales_Rekap";
_judul = "RekapInsentifSalesman" + _periode;
_filename = "RekapInsentifSalesman" + DateTime.Now.ToString("yyyyMMdd");
}
else
{
_rdlc = "rptLaporanInsentifSalesDetail.rdlc";
_dataset = "dsInsentifSales_Detail";
_judul = "DetailInsentifSalesman" + _periode;
_filename = "DetailInsentifSalesman" + DateTime.Now.ToString("yyyyMMdd");
}
//call report viewer
frmReportViewer ifrmReport = new frmReportViewer("Penjualan." + _rdlc, rptParams, ds, _dataset);
ifrmReport.Text = _judul;
ifrmReport.ExportToExcel(_filename);
}
