private void BindReport()
{
string title = "Laporan";
reportViewer1.Reset();
string namaTransaksi = string.Empty;
switch (listOfTransaction)
{
case ListOfTransaction.Purchase:
namaTransaksi = "Pembelian ";
break;
case ListOfTransaction.Sales:
namaTransaksi = "Penjualan ";
break;
case ListOfTransaction.ReturSales:
namaTransaksi = "Retur Penjualan ";
break;
case ListOfTransaction.ReturPurchase:
namaTransaksi = "Retur Pembelian ";
break;
case ListOfTransaction.Correction:
namaTransaksi = "Koreksi Stok ";
break;
case ListOfTransaction.Mutation:
namaTransaksi = "Mutasi Stok ";
break;
default:
break;
}
switch (listOfReports)
{
case ListOfReports.ReportSalesFactur:
reportViewer1.LocalReport.ReportEmbeddedResource = "Inventori.MotorKymco.Forms.Reports.ReportSalesFactur.rdlc";
if (DataId != null)
{
FillVTotalTransactionDataSource(Convert.ToDecimal(DataId));
}
title = "NOTA PENJUALAN";
break;
case ListOfReports.ReportLabaRugi:
reportViewer1.LocalReport.ReportEmbeddedResource = "Inventori.MotorKymco.Forms.Reports.ReportLabaRugi.rdlc";
//FillRekapSubAccDataSource(DataId.ToString());
FillVTotalTransactionDataSource(DateFrom, DateTo);
title = "Laporan Laba/Rugi";
break;
case ListOfReports.ReportTransactionByPIC:
reportViewer1.LocalReport.ReportEmbeddedResource = "Inventori.MotorKymco.Forms.Reports.ReportTransactionByPIC.rdlc";
FillVTotalTransactionDataSource(listOfTransaction.ToString(), DateFrom, DateTo, VTotalTransactionDetail.ColumnNames.TransactionBy, DataId.ToString());
title = "Laporan " + namaTransaksi;
break;
case ListOfReports.ReportTransactionByItem:
reportViewer1.LocalReport.ReportEmbeddedResource = "Inventori.MotorKymco.Forms.Reports.ReportTransactionByItem.rdlc";
FillVTotalTransactionDataSource(listOfTransaction.ToString(), DateFrom, DateTo);
title = "Laporan " + namaTransaksi;
break;
case ListOfReports.ReportTransactionInternalByItem:
reportViewer1.LocalReport.ReportEmbeddedResource = "Inventori.MotorKymco.Forms.Reports.ReportTransactionInternalByItem.rdlc";
FillVTotalTransactionDataSource(listOfTransaction.ToString(), DateFrom, DateTo);
title = "Laporan " + namaTransaksi;
break;
case ListOfReports.ReportPiHutangDue:
reportViewer1.LocalReport.ReportEmbeddedResource = "Inventori.MotorKymco.Forms.Reports.ReportPiHutangDue.rdlc";
FillTPihutang(PiHutangStatus.ToString());
title = "Laporan " + PiHutangStatus.ToString();
break;
case ListOfReports.ReportPajak:
reportViewer1.LocalReport.ReportEmbeddedResource = "Inventori.MotorKymco.Forms.Reports.ReportPajak.rdlc";
FillVTotalTransactionDataSource(listOfTransaction.ToString(), DateFrom, DateTo);
title = "Laporan Pajak";
break;
case ListOfReports.ReportStokItem:
reportViewer1.LocalReport.ReportEmbeddedResource = "Inventori.MotorKymco.Forms.Reports.ReportStokItem.rdlc";
FillVItemDetail();
title = "Laporan Stok Item";
break;
case ListOfReports.ReportStokCard:
reportViewer1.LocalReport.ReportEmbeddedResource = "Inventori.MotorKymco.Forms.Reports.ReportStokCard.rdlc";
FillVStokCard();
title = "Laporan Kartu Stok";
break;
case ListOfReports.ReportSPKFactur:
reportViewer1.LocalReport.ReportEmbeddedResource = "Inventori.MotorKymco.Forms.Reports.ReportSPKFactur.rdlc";
if (DataId != null)
{
FillVTotalTransactionServiceDataSource(Convert.ToDecimal(DataId));
}
title = "Surat Perintah Kerja";
break;
case ListOfReports.ReportHistoryServiceCustomer:
reportViewer1.LocalReport.ReportEmbeddedResource = "Inventori.MotorKymco.Forms.Reports.ReportHistoryServiceCustomer.rdlc";
FillVTotalTransactionServiceDataSourceByCustomer();
title = "Laporan Histori Service Pelanggan";
break;
case ListOfReports.ReportTransactionServiceByPIC:
reportViewer1.LocalReport.ReportEmbeddedResource = "Inventori.MotorKymco.Forms.Reports.ReportTransactionServiceByPIC.rdlc";
FillVTotalTransactionServiceDataSource(listOfTransaction.ToString(), DateFrom, DateTo, VTotalTransactionService.ColumnNames.TransactionBy, DataId.ToString());
title = "Laporan Service Bengkel Per Pelanggan";
break;
default:
break;
}
reportViewer1.LocalReport.SubreportProcessing += new SubreportProcessingEventHandler(LocalReport_SubreportProcessing);
this.Text = title;
this.TabText = title;
this.reportViewer1.RefreshReport();
}
private void BindReport()
{
string title = "Laporan";
reportViewer1.Reset();
string namaTransaksi = string.Empty;
switch (listOfTransaction)
{
case ListOfTransaction.Purchase:
namaTransaksi = "Pembelian ";
break;
case ListOfTransaction.Sales:
namaTransaksi = "Penjualan ";
break;
case ListOfTransaction.ReturSales:
namaTransaksi = "Retur Penjualan ";
break;
case ListOfTransaction.ReturPurchase:
namaTransaksi = "Retur Pembelian ";
break;
case ListOfTransaction.Correction:
namaTransaksi = "Koreksi Stok ";
break;
case ListOfTransaction.Mutation:
namaTransaksi = "Mutasi Stok ";
break;
default:
break;
}
switch (listOfReports)
{
case ListOfReports.ReportTransactionDetail:
reportViewer1.LocalReport.ReportEmbeddedResource = "Inventori.PointOfSales.Forms.Reports.ReportTransactionDetail.rdlc";
FillVTotalTransactionDataSource(Convert.ToDecimal(DataId));
title = "Laporan Detail Transaksi";
break;
case ListOfReports.ReportSalesFactur:
reportViewer1.LocalReport.ReportEmbeddedResource = "Inventori.PointOfSales.Forms.Reports.ReportSalesFactur.rdlc";
if (DataId != null)
{
FillVTotalTransactionDataSource(Convert.ToDecimal(DataId));
}
title = "NOTA PENJUALAN";
break;
case ListOfReports.ReportLabaRugi:
reportViewer1.LocalReport.ReportEmbeddedResource = "Inventori.PointOfSales.Forms.Reports.ReportLabaRugi.rdlc";
FillVRekapSubAccountDataSource(ListOfAccountPosition.RugiLaba.ToString(), DataId.ToString());
//FillVTotalTransactionDataSource(DateFrom, DateTo);
title = "Laporan Laba/Rugi";
//ReportParameter[] parameters = new ReportParameter[1];
//parameters[0] = new ReportParameter("Report_Parameter_Periode","Juli 2007");
//reportViewer1.LocalReport.SetParameters(parameters);
break;
case ListOfReports.ReportNeraca:
reportViewer1.LocalReport.ReportEmbeddedResource = "Inventori.PointOfSales.Forms.Reports.ReportNeraca.rdlc";
FillVRekapSubAccountDataSource(DataId.ToString());
title = "Laporan Neraca";
break;
case ListOfReports.ReportTransactionByPIC:
reportViewer1.LocalReport.ReportEmbeddedResource = "Inventori.PointOfSales.Forms.Reports.ReportTransactionByPIC.rdlc";
FillVTotalTransactionDataSource(listOfTransaction.ToString(), DateFrom, DateTo, VTotalTransactionDetail.ColumnNames.TransactionBy, DataId.ToString());
title = "Laporan " + namaTransaksi;
break;
case ListOfReports.ReportTransactionByItem:
reportViewer1.LocalReport.ReportEmbeddedResource = "Inventori.PointOfSales.Forms.Reports.ReportTransactionByItem.rdlc";
FillVTotalTransactionDataSource(listOfTransaction.ToString(), DateFrom, DateTo);
title = "Laporan " + namaTransaksi;
break;
case ListOfReports.ReportTransactionInternalByItem:
reportViewer1.LocalReport.ReportEmbeddedResource = "Inventori.PointOfSales.Forms.Reports.ReportTransactionInternalByItem.rdlc";
FillVTotalTransactionDataSource(listOfTransaction.ToString(), DateFrom, DateTo);
title = "Laporan " + namaTransaksi;
break;
case ListOfReports.ReportPiHutangDue:
reportViewer1.LocalReport.ReportEmbeddedResource = "Inventori.PointOfSales.Forms.Reports.ReportPiHutangDue.rdlc";
FillTPihutang(PiHutangStatus.ToString());
title = "Laporan " + PiHutangStatus.ToString();
break;
case ListOfReports.ReportPajak:
reportViewer1.LocalReport.ReportEmbeddedResource = "Inventori.PointOfSales.Forms.Reports.ReportPajak.rdlc";
FillVTotalTransactionDataSource(listOfTransaction.ToString(), DateFrom, DateTo);
title = "Laporan Pajak";
break;
case ListOfReports.ReportStokItem:
reportViewer1.LocalReport.ReportEmbeddedResource = "Inventori.PointOfSales.Forms.Reports.ReportStokItem.rdlc";
FillVItemDetail();
title = "Laporan Stok Barang";
break;
case ListOfReports.ReportCommission:
reportViewer1.LocalReport.ReportEmbeddedResource = "Inventori.PointOfSales.Forms.Reports.ReportCommission.rdlc";
FillTCommission(DateFrom, DateTo);
title = "Laporan Pembagian Tuslah";
break;
case ListOfReports.ReportPiHutangDetail:
reportViewer1.LocalReport.ReportEmbeddedResource = "Inventori.PointOfSales.Forms.Reports.ReportPiHutangDetail.rdlc";
FillTPihutang(PiHutangStatus.ToString(), DataId.ToString(), DateFrom, DateTo);
title = "Laporan Detail " + PiHutangStatus.ToString();
break;
case ListOfReports.ReportTJournal:
reportViewer1.LocalReport.ReportEmbeddedResource = "Inventori.PointOfSales.Forms.Reports.ReportTJournal.rdlc";
FillTJournal(DateFrom, DateTo, AppCode.GetKasAccountNo());
title = "Laporan Arus Kas";
break;
case ListOfReports.ReportStokCard:
reportViewer1.LocalReport.ReportEmbeddedResource = "Inventori.PointOfSales.Forms.Reports.ReportStokCard.rdlc";
FillVStokCard(DateFrom, DateTo);
title = "Laporan Kartu Stok";
break;
case ListOfReports.ReportJournal:
reportViewer1.LocalReport.ReportEmbeddedResource = "Inventori.PointOfSales.Forms.Reports.ReportJournal.rdlc";
FillTJournal(DateFrom, DateTo);
title = "Laporan Journal Umum";
break;
case ListOfReports.ReportChartSalesMonthly:
reportViewer1.LocalReport.ReportEmbeddedResource = "Inventori.PointOfSales.Forms.Reports.ReportChartSalesMonthly.rdlc";
FillVTotalTransactionDataSource(listOfTransaction.ToString(), DateFrom, DateTo, VTotalTransactionDetail.ColumnNames.TransactionBy, DataId.ToString());
title = "Laporan Rekap Penjualan Per Bulan";
break;
case ListOfReports.ReportDelivery:
reportViewer1.LocalReport.ReportEmbeddedResource = "Inventori.PointOfSales.Forms.Reports.ReportDelivery.rdlc";
FillVTotalDelivery(DateFrom, DateTo, DataId.ToString());
title = "Laporan Pengiriman Barang";
break;
case ListOfReports.ReportMCustomer:
reportViewer1.LocalReport.ReportEmbeddedResource = "Inventori.PointOfSales.Forms.Reports.ReportMCustomer.rdlc";
FillMaster(typeof(MCustomer));
title = "Daftar Pelanggan";
break;
case ListOfReports.ReportMSupplier:
reportViewer1.LocalReport.ReportEmbeddedResource = "Inventori.PointOfSales.Forms.Reports.ReportMSupplier.rdlc";
FillMaster(typeof(MSupplier));
title = "Daftar Supplier";
break;
case ListOfReports.ReportMEkspedission:
reportViewer1.LocalReport.ReportEmbeddedResource = "Inventori.PointOfSales.Forms.Reports.ReportMEkspedission.rdlc";
FillMaster(typeof(MEkspedission));
title = "Daftar Ekspedisi";
break;
default:
break;
}
reportViewer1.LocalReport.SubreportProcessing += new SubreportProcessingEventHandler(LocalReport_SubreportProcessing);
this.Text = title;
this.TabText = title;
this.reportViewer1.RefreshReport();
}
private void BindReport()
{
string title = "Laporan";
reportViewer1.Reset();
string namaTransaksi = string.Empty;
switch (listOfTransaction)
{
case ListOfTransaction.Purchase:
namaTransaksi = "Pembelian ";
break;
case ListOfTransaction.Sales:
namaTransaksi = "Penjualan Retail ";
break;
case ListOfTransaction.SalesVIP:
namaTransaksi = "Penjualan Grosir ";
break;
case ListOfTransaction.ReturSales:
namaTransaksi = "Retur Penjualan ";
break;
case ListOfTransaction.ReturPurchase:
namaTransaksi = "Retur Pembelian ";
break;
case ListOfTransaction.Correction:
namaTransaksi = "Koreksi Stok ";
break;
case ListOfTransaction.Mutation:
namaTransaksi = "Mutasi Stok ";
break;
default:
break;
}
switch (listOfReports)
{
case ListOfReports.ReportSalesFactur:
reportViewer1.LocalReport.ReportEmbeddedResource = "Inventori.GrosirMitra.Forms.Reports.ReportSalesFactur.rdlc";
if (DataId != null)
{
FillVTotalTransactionDataSource(Convert.ToDecimal(DataId));
}
title = "NOTA PENJUALAN";
break;
case ListOfReports.ReportLabaRugi:
reportViewer1.LocalReport.ReportEmbeddedResource = "Inventori.GrosirMitra.Forms.Reports.ReportLabaRugi.rdlc";
FillVTotalTransactionDataSource(DateFrom, DateTo);
title = "Laporan Laba/Rugi";
break;
case ListOfReports.ReportTransactionByPIC:
reportViewer1.LocalReport.ReportEmbeddedResource = "Inventori.GrosirMitra.Forms.Reports.ReportTransactionByPIC.rdlc";
FillVTotalTransactionDataSource(listOfTransaction.ToString(), DateFrom, DateTo, VTotalTransactionDetail.ColumnNames.TransactionBy, DataId.ToString());
title = "Laporan " + namaTransaksi;
break;
case ListOfReports.ReportTransactionByItem:
reportViewer1.LocalReport.ReportEmbeddedResource = "Inventori.GrosirMitra.Forms.Reports.ReportTransactionByItem.rdlc";
FillVTotalTransactionDataSource(listOfTransaction.ToString(), DateFrom, DateTo);
title = "Laporan " + namaTransaksi;
break;
case ListOfReports.ReportTransactionInternalByItem:
reportViewer1.LocalReport.ReportEmbeddedResource = "Inventori.GrosirMitra.Forms.Reports.ReportTransactionInternalByItem.rdlc";
FillVTotalTransactionDataSource(listOfTransaction.ToString(), DateFrom, DateTo);
title = "Laporan " + namaTransaksi;
break;
case ListOfReports.ReportPiHutangDue:
reportViewer1.LocalReport.ReportEmbeddedResource = "Inventori.GrosirMitra.Forms.Reports.ReportPiHutangDue.rdlc";
FillTPihutang(PiHutangStatus.ToString());
title = "Laporan " + PiHutangStatus.ToString();
break;
case ListOfReports.ReportPajak:
reportViewer1.LocalReport.ReportEmbeddedResource = "Inventori.GrosirMitra.Forms.Reports.ReportPajak.rdlc";
FillVTotalTransactionDataSource(listOfTransaction.ToString(), DateFrom, DateTo);
title = "Laporan Pajak";
break;
case ListOfReports.ReportStokItem:
reportViewer1.LocalReport.ReportEmbeddedResource = "Inventori.GrosirMitra.Forms.Reports.ReportStokItem.rdlc";
FillVItemDetail();
title = "Laporan Stok Barang";
break;
case ListOfReports.ReportStokCard:
reportViewer1.LocalReport.ReportEmbeddedResource = "Inventori.GrosirMitra.Forms.Reports.ReportStokCard.rdlc";
FillVStokCard(DateFrom, DateTo);
title = "Laporan Kartu Stok";
break;
case ListOfReports.ReportTransactionPerMonth:
reportViewer1.LocalReport.ReportEmbeddedResource = "Inventori.GrosirMitra.Forms.Reports.ReportTransactionPerMonth.rdlc";
FillVTotalTransactionDataSource(listOfTransaction.ToString(), DateFrom, DateTo);
title = "Rekap " + namaTransaksi + "Per Bulan";
break;
default:
break;
}
reportViewer1.LocalReport.SubreportProcessing += new SubreportProcessingEventHandler(LocalReport_SubreportProcessing);
this.Text = title;
this.TabText = title;
this.reportViewer1.RefreshReport();
}