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(); }