private void FrmVisorReporte_Load(object sender, EventArgs e)
{
RptViewer.SetDisplayMode(DisplayMode.PrintLayout);
RptViewer.ZoomMode = ZoomMode.Percent;
RptViewer.ZoomPercent = 100;
try
{
RptViewer.ProcessingMode = ProcessingMode.Local;
RptViewer.LocalReport.ReportEmbeddedResource = $"SAP.Reportes.{_nombre}.rdlc";
foreach (var key in _dataSources.Keys)
{
RptViewer.LocalReport.DataSources.Add(new ReportDataSource(key, _dataSources[key]));
}
if (_parametros.Count > 0)
{
List <ReportParameter> parametros = new List <ReportParameter>();
foreach (var key in _parametros.Keys)
{
parametros.Add(new ReportParameter(key, _parametros[key].ToString()));
}
RptViewer.LocalReport.SetParameters(parametros);
}
RptViewer.RefreshReport();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message + " Error al crear Reporte", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public frmBalanceSheetPrint()
{
InitializeComponent();
RptViewer.SetDisplayMode(DisplayMode.PrintLayout);
LoadReport(Convert.ToDateTime(dtFrom), Convert.ToDateTime(dtTo));;
}
private void LoadBusAmount(string comapgny)
{
try
{
if (Connection.Instance.Con.State == ConnectionState.Closed)
{
Connection.Instance.Con.Open();
}
using (IDbCommand cmd = Connection.Instance.Con.CreateCommand())
{
cmd.CommandText = "SELECT bus.ref_compagnie, bus.numero, ref_bus, bus.etat as etat_bus, " +
"sum(montant - (commission + fraisTransact)) as montant from transaction " +
"inner join bus on transaction.ref_bus = bus.plaque where bus.ref_compagnie = '" + comapgny + "' group by ref_bus ";
using (MySqlDataAdapter adapter = new MySqlDataAdapter((MySqlCommand)cmd))
{
using (DataSet ds = new DataSet("DsBusAmount"))
{
adapter.Fill(ds, "DsBusAmount");
RptViewer.LocalReport.DataSources.Clear();
RptViewer.LocalReport.DataSources.Add(new Microsoft.Reporting.WinForms.ReportDataSource("DsBusAmount", ds.Tables[0]));
RptViewer.LocalReport.ReportEmbeddedResource = "EasyToGoCompany.Reports.RptBusAmount.rdlc";
RptViewer.PrinterSettings.DefaultPageSettings.Landscape = false;
RptViewer.RefreshReport();
}
}
}
}
catch (Exception ex)
{
MessageBox.Show(this, "Une erreur s'est produite lors du chargement du rapport. \n ERROR : " + ex.Message, "Erreur", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public frmSubsidaryAccountsPrint()
{
InitializeComponent();
RptViewer.SetDisplayMode(DisplayMode.PrintLayout);
LoadReport(Convert.ToDateTime(dtFrom), Convert.ToDateTime(dtTo));;
}
public void LoadReport(DateTime dtFrom, DateTime dtTo)
{
List <BLL.BalanceSheet> list = BLL.BalanceSheet.ToList(dtFrom, dtTo);
list = list.Select(x => new BLL.BalanceSheet()
{
Ledger = x.LedgerList.AccountName, CrAmt = x.CrAmt, DrAmt = x.DrAmt, CrAmtOP = x.CrAmtOP, DrAmtOP = x.DrAmtOP
}).ToList();
try
{
RptViewer.Reset();
ReportDataSource data = new ReportDataSource("BalanceSheet", list);
ReportDataSource data1 = new ReportDataSource("CompanyDetail", BLL.CompanyDetail.toList.Where(x => x.Id == BLL.UserAccount.User.UserType.Company.Id).ToList());
RptViewer.LocalReport.DataSources.Add(data);
RptViewer.LocalReport.DataSources.Add(data1);
RptViewer.LocalReport.ReportPath = @"Reports\rptBalancesheet.rdlc";
ReportParameter[] par = new ReportParameter[2];
par[0] = new ReportParameter("DateFrom", dtFrom.ToString());
par[1] = new ReportParameter("DateTo", dtTo.ToString());
RptViewer.LocalReport.SetParameters(par);
RptViewer.RefreshReport();
}
catch (Exception ex)
{
}
}
public void LoadReport(int LID, DateTime dtFrom, DateTime dtTo)
{
try
{
List <BLL.GeneralLedger> list = BLL.GeneralLedger.ToList((int)LID, dtFrom, dtTo);
list = list.Select(x => new BLL.GeneralLedger()
{
AccountName = x.Ledger.AccountName, Particular = x.Particular, CrAmt = x.CrAmt, DrAmt = x.DrAmt, BalAmt = x.BalAmt, EDate = x.EDate, EntryNo = x.EntryNo, EType = x.EType, Ledger = x.Ledger, RefNo = x.RefNo
}).ToList();
try
{
RptViewer.Reset();
ReportDataSource data = new ReportDataSource("GeneralLedger", list);
// ReportDataSource data1 = new ReportDataSource("CompanyDetail", BLL.CompanyDetail.toList.Where(x => x.Id == BLL.UserAccount.User.UserType.CompanyId).ToList());
RptViewer.LocalReport.DataSources.Add(data);
// RptViewer.LocalReport.DataSources.Add(data1);
RptViewer.LocalReport.ReportPath = @"Reports\rptGeneralLedger.rdlc";
ReportParameter[] par = new ReportParameter[2];
par[0] = new ReportParameter("DateFrom", dtFrom.ToString());
par[1] = new ReportParameter("DateTo", dtTo.ToString());
RptViewer.LocalReport.SetParameters(par);
RptViewer.RefreshReport();
}
catch (Exception ex)
{
}
}
catch (Exception ex)
{
}
}
private void getData()
{
RptViewer.Reset();
CommisionReceivableBo CommisionReceivableBo = new CommisionReceivableBo();
DataTable dt = CommisionReceivableBo.GetBranchBrokerage(product, productCategory, fromdate, todate, amcCode, schemeId, adviserId, issueid, CommissionType);
DataTable dt2 = CommisionReceivableBo.GetAssociateBrokerage(product, productCategory, fromdate, todate, amcCode, schemeId, adviserId, issueid, CommissionType);
DataTable dt3 = CommisionReceivableBo.GetProductApplicationWiseData(product, productCategory, fromdate, todate, amcCode, schemeId, adviserId, issueid, CommissionType);
DataTable dt4 = CommisionReceivableBo.GetAssocaiteApplicationWiseData(product, productCategory, fromdate, todate, amcCode, schemeId, adviserId, issueid, CommissionType);
ReportDataSource rds = new ReportDataSource("BranchDS_SPROC_GetBranchBrokerageReceivable", dt);
ReportDataSource rds2 = new ReportDataSource("ProductAssociateBrokarageReceived_SPROC_GetAssociateWiseBrokerageReceived", dt2);
ReportDataSource rds3 = new ReportDataSource("ProductBrokerageApplicationWise_SPROC_GetProductBrokerageApplicationWise", dt3);
ReportDataSource rds4 = new ReportDataSource("ProductAssociateBrokarageReceived_SPROC_GetBranchAssociateCommissionPayOuts", dt4);
RptViewer.LocalReport.DataSources.Add(rds);
RptViewer.LocalReport.DataSources.Add(rds2);
RptViewer.LocalReport.DataSources.Add(rds3);
RptViewer.LocalReport.DataSources.Add(rds4);
RptViewer.LocalReport.ReportPath = @"Reports\BrokerageMIS.rdlc";
ReportParameter[] RP = new ReportParameter[] {
new ReportParameter("Product", product),
new ReportParameter("Category", productCategory),
new ReportParameter("FromDate", fromdate),
new ReportParameter("ToDate", todate),
new ReportParameter("AMCCode", amcCode.ToString()),
new ReportParameter("IssueId", issueid.ToString()),
new ReportParameter("IsReceivable", IsReceivable),
new ReportParameter("CommissionType", CommissionType),
new ReportParameter("Channel", "true"),
};
RptViewer.LocalReport.SetParameters(RP);
RptViewer.LocalReport.Refresh();
}
public void LoadReport(DateTime dtFrom, DateTime dtTo)
{
try
{
List <BLL.GeneralLedger> list = BLL.GeneralLedger.Activity_ToList(dtFrom, dtTo);
list = list.Select(x => new BLL.GeneralLedger()
{
AccountName = x.Ledger.AccountName, SNo = x.SNo, Particular = x.Particular, CrAmt = x.CrAmt, DrAmt = x.DrAmt, BalAmt = x.BalAmt, EDate = x.EDate, EntryNo = x.EntryNo, EType = x.EType, Ledger = x.Ledger, RefNo = x.RefNo
}).ToList();
try
{
RptViewer.Reset();
ReportDataSource data = new ReportDataSource("ActivityReport", list);
RptViewer.LocalReport.DataSources.Add(data);
RptViewer.LocalReport.ReportPath = @"Reports\rptActivityReport.rdlc";
ReportParameter[] par = new ReportParameter[3];
par[0] = new ReportParameter("DateFrom", dtFrom.ToString());
par[1] = new ReportParameter("DateTo", dtTo.ToString());
par[2] = new ReportParameter("Fund", BLL.UserAccount.User.UserType.Company.CompanyName);
RptViewer.LocalReport.SetParameters(par);
RptViewer.RefreshReport();
}
catch (Exception ex)
{
}
}
catch (Exception ex)
{
}
}
public void LoadReport(DateTime dtFrom, DateTime dtTo)
{
List <BLL.SubsidaryAccounts> list = BLL.SubsidaryAccounts.ToList(dtFrom, dtTo);
list = list.Select(x => new BLL.SubsidaryAccounts()
{
AccountName = x.LedgerList.AccountName, CrAmt = x.CrAmt, DrAmt = x.DrAmt, CrAmtOP = x.CrAmtOP, DrAmtOP = x.DrAmtOP
}).ToList();
try
{
RptViewer.Reset();
ReportDataSource data = new ReportDataSource("SubsidaryAccounts", list);
ReportDataSource data1 = new ReportDataSource("FundMaster", BLL.FundMaster.toList.Where(x => x.Id == BLL.UserAccount.User.UserType.Fund.Id).ToList());
RptViewer.LocalReport.DataSources.Add(data);
RptViewer.LocalReport.DataSources.Add(data1);
RptViewer.LocalReport.ReportPath = @"Reports\rptSubsidaryAccount.rdlc";
ReportParameter[] par = new ReportParameter[3];
par[0] = new ReportParameter("DateFrom", dtFrom.ToString());
par[1] = new ReportParameter("DateTo", dtTo.ToString());
par[2] = new ReportParameter("Fund", BLL.UserAccount.User.UserType.Fund.FundName);
RptViewer.LocalReport.SetParameters(par);
RptViewer.RefreshReport();
}
catch (Exception ex)
{
}
}
private void ShowData()
{
Copyright = getVersion();
try {
//string str = ConfigurationManager.ConnectionStrings["ProTRAC_ConnectionString"].ConnectionString;
string str = Session[Session["TMLDealercode"] + "-TMLConString"].ToString();
SqlConnection con = new SqlConnection(str);
RptViewer.Reset();
//datasource
DataTable dt = getTable();
ReportDataSource rds = new ReportDataSource("DataSet1", dt);
RptViewer.LocalReport.DataSources.Add(rds);
//path
RptViewer.LocalReport.ReportPath = "TAT_BSRpt.rdlc";
//params
ReportParameter[] rptparams = new ReportParameter[4];
//{
rptparams[0] = new ReportParameter("FromDate", txtFrom.Text);
rptparams[1] = new ReportParameter("ToDate", TextTo.Text);
rptparams[2] = new ReportParameter("DealerDetails", DealerName);
rptparams[3] = new ReportParameter("Copyright", Copyright);
// };
RptViewer.LocalReport.SetParameters(rptparams);
//refresh
RptViewer.LocalReport.Refresh();
}
catch (Exception ex)
{
}
}
public void LoadReport(List <BLL.ReceiptAndPayment> list, DateTime dtFrom, DateTime dtTo, bool AccountHead)
{
try
{
RptViewer.Reset();
ReportDataSource data = new ReportDataSource("PaymentAndReceipt", list);
RptViewer.LocalReport.DataSources.Add(data);
if (AccountHead == true)
{
RptViewer.LocalReport.ReportPath = @"Reports\rptPaymentReceiptAccountHead.rdlc";
}
else
{
RptViewer.LocalReport.ReportPath = @"Reports\rptPaymentReceipt.rdlc";
}
ReportParameter[] par = new ReportParameter[4];
par[0] = new ReportParameter("DateFrom", dtFrom.ToString());
par[1] = new ReportParameter("DateTo", dtTo.ToString());
par[2] = new ReportParameter("Title", "Receipt And Payment Report");
par[3] = new ReportParameter("Fund", BLL.UserAccount.User.UserType.Fund.FundName);
RptViewer.LocalReport.SetParameters(par);
RptViewer.RefreshReport();
}
catch (Exception ex)
{
}
}
public void LoadReportBilan(DateTime begin, DateTime end)
{
try
{
if (ImplementConnection.Instance.Conn.State == System.Data.ConnectionState.Closed)
{
ImplementConnection.Instance.Conn.Open();
}
using (IDbCommand cmd = ImplementConnection.Instance.Conn.CreateCommand())
{
cmd.CommandText = "sp_bilan_operations";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(Parametres.Instance.AjouterParametre(cmd, "@date_debut", 30, DbType.DateTime, begin));
cmd.Parameters.Add(Parametres.Instance.AjouterParametre(cmd, "@date_fin", 30, DbType.DateTime, end));
adapter = new SqlDataAdapter((SqlCommand)cmd);
dataset = new DataSet();
adapter.Fill(dataset, "DataSetBilan");
RptViewer.LocalReport.DataSources.Clear();
RptViewer.LocalReport.DataSources.Add(new Microsoft.Reporting.WinForms.ReportDataSource("DataSetBilan", dataset.Tables[0]));
RptViewer.LocalReport.ReportEmbeddedResource = "GestionComptabiliteHP.Reports.RptBilan.rdlc";
RptViewer.RefreshReport();
}
}
catch (InvalidOperationException ex)
{
MessageBox.Show("Error when Selecting data, " + ex.Message, "Selecting data", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
catch (SqlException ex)
{
MessageBox.Show("Error when Selecting data, " + ex.Message, "Selecting data", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
catch (Exception ex)
{
MessageBox.Show("Error when Selecting data, " + ex.Message, "Selecting data", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
finally
{
if (ImplementConnection.Instance.Conn != null)
{
if (ImplementConnection.Instance.Conn.State == System.Data.ConnectionState.Open)
{
ImplementConnection.Instance.Conn.Close();
}
}
if (adapter != null)
{
adapter.Dispose();
}
if (dataset != null)
{
dataset.Dispose();
}
}
}
private void FrmShowTags_Load(object sender, EventArgs e)
{
var year = (Program.Year - 1980).ToString();
RptViewer.LocalReport.SetParameters(new ReportParameter("CapriconYear", year));
artShowItemBindingSource.DataSource = Items;
RptViewer.RefreshReport();
}
private void FrmSigninReport_Load(object sender, EventArgs e)
{
var year = (DateTime.Now.Year - 1980).ToString();
RptViewer.LocalReport.SetParameters(new ReportParameter("CapriconYear", year));
badgesBindingSource.DataSource = Items;
RptViewer.RefreshReport();
}
private void FrmArtistsWithWaivedFees_Load(object sender, EventArgs e)
{
var year = (Program.Year - 1980).ToString();
RptViewer.LocalReport.SetParameters(new ReportParameter("CapriconYear", year));
ArtistWithWaivedFeesBindingSource.DataSource = Items;
RptViewer.RefreshReport();
}
private void FrmShowTags_Load(object sender, EventArgs e)
{
var year = (Program.Year - 1980).ToString();
RptViewer.LocalReport.SetParameters(new ReportParameter("ArtistName", Artist.LegalName));
RptViewer.LocalReport.SetParameters(new ReportParameter("ArtistNumber", Artist.ArtistNumber.ToString()));
RptViewer.LocalReport.SetParameters(new ReportParameter("CapriconYear", year));
PrintShopItemBindingSource.DataSource = Items;
RptViewer.RefreshReport();
}
private void btnGenerate_Click(object sender, EventArgs e)
{
ItemsListSummaryRpt rpt = BuildReport();
string filename = string.Format("{0}\\Reports\\ItemsListSummary.htm", Application.StartupPath);
rpt.WriteHtmlReport(filename);
RptViewer.Navigate(filename);
}
private void FrmAuctionReport_Load(object sender, EventArgs e)
{
var year = (Program.Year - 1980).ToString();
RptViewer.LocalReport.SetParameters(new ReportParameter("CapriconYear", year));
var ds = new ReportDataSource("AuctionItem", Items);
RptViewer.LocalReport.DataSources.Clear();
RptViewer.LocalReport.DataSources.Add(ds);
RptViewer.RefreshReport();
}
private void FrmShowTags_Load(object sender, EventArgs e)
{
var year = (Program.Year - 1980).ToString();
RptViewer.LocalReport.SetParameters(new ReportParameter("CapriconYear", year));
var ds = new ReportDataSource("CheckoutItem", Items);
RptViewer.LocalReport.DataSources.Clear();
RptViewer.LocalReport.DataSources.Add(ds);
RptViewer.RefreshReport();
RptViewer.PrinterSettings.Copies = 2;
}
private void FrmShopReceipt_Load(object sender, EventArgs e)
{
RptViewer.RenderingComplete += RptViewer_RenderingComplete;
var year = (Program.Year - 1980).ToString();
RptViewer.LocalReport.SetParameters(new ReportParameter("Purchaser", Purchaser.Name));
RptViewer.LocalReport.SetParameters(new ReportParameter("CapriconYear", year));
RptViewer.LocalReport.SetParameters(new ReportParameter("PaymentSource", Source));
RptViewer.LocalReport.SetParameters(new ReportParameter("PaymentReference", Reference));
artShowItemBindingSource.DataSource = Items;
RptViewer.RefreshReport();
}
private void btnGenerate_Click(object sender, EventArgs e)
{
ItemRpt rpt = BuildReport();
string filename = string.Format("{0}{1}Reports{2}Purchases[Item].htm",
Application.StartupPath,
System.IO.Path.DirectorySeparatorChar,
System.IO.Path.DirectorySeparatorChar);
rpt.WriteHtmlReport(filename);
RptViewer.Navigate(filename);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
Usuarios usuario = new Usuarios();
RptViewer.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Local;
RptViewer.Reset();
RptViewer.LocalReport.ReportPath = Server.MapPath(@"~\Rpts\UsuarioReport.rdlc");
RptViewer.LocalReport.DataSources.Clear();
RptViewer.LocalReport.DataSources.Add(new ReportDataSource("Usuarios", usuario.Listado("*", "1=1", "")));
RptViewer.LocalReport.Refresh();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
ddlMinistry.Enabled = true;
PopulateMinistries();
if (Session["ministry_id"].ToInt32() > 0)
{
ddlMinistry.Enabled = false;
ddlMinistry.SelectedValue = Session["ministry_id"].ToString();
}
}
if (IsPostBack)
{
RptViewer.ReportSource = Session["ProblemReport"];
RptViewer.RefreshReport();
RptViewer.DataBind();
}
}
private void LoadReport(int index)
{
try
{
InitializeConnection();
using (cmd = con.CreateCommand())
{
cmd.CommandText = "SELECT designation,description,ref_compagnie,solde from compte";
using (MySqlDataAdapter adapter = new MySqlDataAdapter((MySqlCommand)cmd))
{
using (DataSet ds = new DataSet("DsFicheCompte"))
{
if (index == 1)
{
adapter.Fill(ds, "DsFicheCompte");
RptViewer.LocalReport.DataSources.Clear();
RptViewer.LocalReport.DataSources.Add(new Microsoft.Reporting.WinForms.ReportDataSource("DsFicheCompte", ds.Tables[0]));
RptViewer.LocalReport.ReportEmbeddedResource = "EasyToGoBq.Reports.RptFicheTransfert.rdlc";
RptViewer.PrinterSettings.DefaultPageSettings.Landscape = false;
RptViewer.RefreshReport();
}
else if (index == 2)
{
adapter.Fill(ds, "DsFicheCompte");
RptViewer.LocalReport.DataSources.Clear();
RptViewer.LocalReport.DataSources.Add(new Microsoft.Reporting.WinForms.ReportDataSource("DsFicheCompte", ds.Tables[0]));
RptViewer.LocalReport.ReportEmbeddedResource = "EasyToGoBq.Reports.RptFicheCompte.rdlc";
RptViewer.PrinterSettings.DefaultPageSettings.Landscape = false;
RptViewer.RefreshReport();
}
}
}
}
}
catch (Exception ex)
{
MessageBox.Show(this, "Une erreur s'est produite lors du chargement du rapport. \n ERROR : " + ex.Message, "Erreur", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
string strTicID = Convert.ToString(Request.QueryString["TicID"]);
string strDeptID = Convert.ToString(Request.QueryString["DeptID"]);
string strStatus = Convert.ToString(Request.QueryString["Status"]);
BusinessObjects bo = new BusinessObjects();
DataTable dt = bo.GetReportData(strTicID, strDeptID, strStatus);
dt.TableName = "TicketMasterTbl";
RptViewer.Reset();
RptViewer.LocalReport.DataSources.Clear();
ReportDataSource datasource = new ReportDataSource("DataSet1", dt);
RptViewer.ProcessingMode = ProcessingMode.Local;
RptViewer.LocalReport.ReportPath = Server.MapPath("~/Report/RptTic.rdlc");
RptViewer.LocalReport.DataSources.Add(datasource);
RptViewer.ZoomMode = ZoomMode.PageWidth;
//RptViewer.ReportRefresh();
}
}
private void LoadBusAmountHour(string comapgny, string date, string begin, string end)
{
date = Convert.ToDateTime(ConvertToOwerDateTimeFormat(date)).ToString("yyyy-MM-dd ");
begin = date + begin.Insert(begin.LastIndexOf(":"), ":00");
end = date + end.Insert(end.LastIndexOf(":"), ":00");
try
{
if (Connection.Instance.Con.State == ConnectionState.Closed)
{
Connection.Instance.Con.Open();
}
using (IDbCommand cmd = Connection.Instance.Con.CreateCommand())
{
cmd.CommandText = "SELECT bus.ref_compagnie, bus.numero, ref_bus, bus.etat as etat_bus, " +
"sum(montant - (commission + fraisTransact)) as montant from transaction " +
"inner join bus on transaction.ref_bus = bus.plaque where (bus.ref_compagnie = '" + comapgny + "') " +
" AND (dateTransact BETWEEN '" + begin + "' AND '" + end + "') group by ref_bus ";
using (MySqlDataAdapter adapter = new MySqlDataAdapter((MySqlCommand)cmd))
{
using (DataSet ds = new DataSet("DsBusAmountHour"))
{
adapter.Fill(ds, "DsBusAmountHour");
RptViewer.LocalReport.DataSources.Clear();
RptViewer.LocalReport.DataSources.Add(new Microsoft.Reporting.WinForms.ReportDataSource("DsBusAmountHour", ds.Tables[0]));
RptViewer.LocalReport.ReportEmbeddedResource = "EasyToGoCompany.Reports.RptBusAmountHour.rdlc";
RptViewer.PrinterSettings.DefaultPageSettings.Landscape = false;
RptViewer.RefreshReport();
}
}
}
}
catch (Exception ex)
{
MessageBox.Show(this, "Une erreur s'est produite lors du chargement du rapport. \n ERROR : " + ex.Message, "Erreur", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public void LoadReport(List <BLL.VoucherReport> list)
{
try
{
RptViewer.Reset();
ReportDataSource data = new ReportDataSource("VoucherReport", list);
RptViewer.LocalReport.DataSources.Add(data);
RptViewer.LocalReport.ReportPath = @"Reports\rptVoucherReport.rdlc";
ReportParameter[] par = new ReportParameter[3];
par[0] = new ReportParameter("DateFrom", dtFrom.ToString());
par[1] = new ReportParameter("DateTo", dtTo.ToString());
par[2] = new ReportParameter("Fund", BLL.UserAccount.User.UserType.Company.CompanyName);
RptViewer.LocalReport.SetParameters(par);
RptViewer.RefreshReport();
}
catch (Exception ex)
{
}
}
public void LoadReport(int?LID, DateTime dtFrom, DateTime dtTo, String EntryNo, String Payto, bool AccountHead)
{
try
{
List <BLL.ExpenseReport> list = new List <BLL.ExpenseReport>();
if (AccountHead == true)
{
list = BLL.ExpenseReport.ToList((int?)LID, dtFrom, dtTo, EntryNo, Payto, true);
}
else
{
list = BLL.ExpenseReport.ToList((int?)LID, dtFrom, dtTo, EntryNo, Payto, false);
}
try
{
RptViewer.Reset();
ReportDataSource data = new ReportDataSource("ExpenseReport", list);
ReportDataSource data1 = new ReportDataSource("FundMaster", BLL.FundMaster.toList.Where(x => x.Id == BLL.UserAccount.User.UserType.FundMasterId).ToList());
RptViewer.LocalReport.DataSources.Add(data);
RptViewer.LocalReport.DataSources.Add(data1);
RptViewer.LocalReport.ReportPath = @"Reports\rptExpenseReport.rdlc";
ReportParameter[] par = new ReportParameter[3];
par[0] = new ReportParameter("DateFrom", dtFrom.ToString());
par[1] = new ReportParameter("DateTo", dtTo.ToString());
par[2] = new ReportParameter("Fund", BLL.UserAccount.User.UserType.Fund.FundName.ToString());
RptViewer.LocalReport.SetParameters(par);
RptViewer.RefreshReport();
}
catch (Exception ex)
{
}
}
catch (Exception ex)
{
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
ddlMinistry.Enabled = true;
Session["rptProjectId"] = "0";
PopulateMinistries();
if (Session["ministry_id"].ToInt32() > 0)
{
ddlMinistry.Enabled = false;
ddlMinistry.SelectedValue = Session["ministry_id"].ToString();
PopulateBudgetHead();
}
}
if (IsPostBack)
{
/*RptViewer.ReportSource = Session["NatijaReport"];*/
RptViewer.ReportSource = Session["PratifalReport"];
RptViewer.RefreshReport();
RptViewer.DataBind();
}
}
private void ShowData()
{
string str = ConfigurationManager.ConnectionStrings["ProTRAC_ConnectionString"].ConnectionString;
SqlConnection con = new SqlConnection(str);
RptViewer.Reset();
//datasource
DataTable dt = getTable();
ReportDataSource rds = new ReportDataSource("DataSet1", dt);
RptViewer.LocalReport.DataSources.Add(rds);
//path
RptViewer.LocalReport.ReportPath = "Report_sample.rdlc";
//params
ReportParameter[] rptparams = new ReportParameter[]
{
new ReportParameter("Bodyshop", txtFrom.Text)
};
RptViewer.LocalReport.SetParameters(rptparams);
//refresh
RptViewer.LocalReport.Refresh();
}
