private void reportViewer_Drillthrough(object sender, DrillthroughEventArgs e) { int CompanyId = int.Parse(Parameters.Find(p => p.Name == "CompanyId").Value); int AccountId = 0; DateTime FromDate = DateTime.Parse(Parameters.Find(p => p.Name == "FromDate").Value); DateTime ToDate = DateTime.Parse(Parameters.Find(p => p.Name == "ToDate").Value); ReportParameter[] reportParam = new ReportParameter[2]; EGeneralLedgerDetailsReportDS jDataSource = new EGeneralLedgerDetailsReportDS(); GeneralLedgerDetailsTableAdapter JournalAdapter = new GeneralLedgerDetailsTableAdapter(); ECompanyDS companyDataSource = new ECompanyDS(); tblCompaniesTableAdapter companyAdapter = new tblCompaniesTableAdapter(); if ((e.Report as LocalReport).GetParameters()["ReportType"].Values[0] == "Per Date") { FromDate = IDateHandler.Parse((e.Report as LocalReport).GetParameters()["FromDate"].Values[0]); ToDate = IDateHandler.Parse((e.Report as LocalReport).GetParameters()["ToDate"].Values[0]); } AccountId = int.Parse((e.Report as LocalReport).GetParameters()["AccountId"].Values[0]); JournalAdapter.Fill(jDataSource.GeneralLedgerDetails, CompanyId, FromDate, ToDate, AccountId); companyAdapter.Fill(companyDataSource.tblCompanies, CompanyId); reportParam[0] = new ReportParameter("FromDate", FromDate.ToString("MM'/'dd'/'yyyy"), false); reportParam[1] = new ReportParameter("ToDate", ToDate.ToString("MM'/'dd'/'yyyy"), false); (e.Report as LocalReport).SetParameters(reportParam); (e.Report as LocalReport).DataSources.Add(new ReportDataSource("GeneralLedgerDetails", jDataSource.Tables["GeneralLedgerDetails"])); (e.Report as LocalReport).DataSources.Add(new ReportDataSource("Company", companyDataSource.Tables["tblCompanies"])); }
protected void rv_Drillthrough(object sender, DrillthroughEventArgs e) { switch (e.ReportPath) { case "subreport1": ; break; case "ReportOrder": LocalReport report = (LocalReport)e.Report; IList <ReportParameter> list = report.OriginalParametersToDrillthrough; string strCaseId = list[0].Values[0].ToString(); InitDataBase(); cmd.CommandText = strOrderID + @" where ""CustomerID"" = '" + strCaseId + "'"; DataTable dtOrders = dc.GetDataSet(cmd, CommandType.Text, null).Tables[0]; report.DataSources.Add(new ReportDataSource("dtOrders", dtOrders)); break; case "subreport3": ; break; default: break; } }
private void reportViewer1_Drillthrough(object sender, DrillthroughEventArgs e) { this.reportViewer1.LocalReport.ReportEmbeddedResource = "SSS.Reports.Coordinator.StudentEngagement.ViewDisengagedStudentsReport.rdlc"; reportViewer1.LocalReport.DataSources.Clear(); ReportDataConnect(); this.reportViewer1.RefreshReport(); }
/// <summary> /// /// </summary> /// <param name="currentDrillthroughEventArgs"></param> private void OnReportDrilledThrough(DrillthroughEventArgs currentDrillthroughEventArgs) { if (ReportDrilledThrough != null) { ReportDrilledThrough(this, currentDrillthroughEventArgs); } }
/// <summary> /// Handles the ReportViewer.Drillthrough event. Add the data for the drillthrough report here. /// </summary> private void ReportViewer1_Drillthrough(object sender, DrillthroughEventArgs e) { LocalReport report = (LocalReport)e.Report; // Supply a DataTable corresponding to each drillthrough report dataset // The dataset name must match the name defined in the drillthrough report report.DataSources.Add(new ReportDataSource(report.GetDataSourceNames()[0], LoadOrderDetailsData())); }
public void OnDrillthrough(ReportViewer reportViewer, DrillthroughEventArgs e) { var report = (LocalReport)e.Report; var parameters = report.GetParameters(); var countryId = int.Parse(parameters["CountryId"].Values.First()); var cities = LocalData.GetCitiesByCountryId(countryId); report.DataSources.Add(new ReportDataSource("Cities", cities)); report.Refresh(); }
private void DrillthroughEventHandler(object sender, DrillthroughEventArgs e) { if (UseSSRSParams()) { return; } ReportStore store = GetStore(); try { e.Report.DisplayName = e.ReportPath; DrillThrough dt = new DrillThrough(); dt.ReportPath = Util.ResolveReference(e.ReportPath, ReportPath); if (e.Report.GetType() != typeof(ServerReport)) { LocalReport localReport = (LocalReport)e.Report; dt.ParamValues = localReport.OriginalParametersToDrillthrough; Report rep = new Report(Util.ResolveReference(e.ReportPath, ReportPath), store); e.Report.LoadReportDefinition(rep.Stream); rep.AddSubreports(localReport, rep.ReportPath); //Moify Data Source and Data Sets if needed rep.SetDataSources(localReport.DataSources, new List <ReportParameter>(localReport.OriginalParametersToDrillthrough)); localReport.SetParameters(localReport.OriginalParametersToDrillthrough); localReport.EnableExternalImages = true; localReport.EnableHyperlinks = true; localReport.Refresh(); } else { dt.ParamValues = Util.GetRuntimeParameters(e.Report.GetParameters()); } //Store params for client string script = @"document.getElementById('DrillThroughParams').value = '" + JsonConvert.SerializeObject(dt) + "';"; ScriptManager.RegisterStartupScript(this, this.GetType(), "open", script, true); } catch (Exception ex) { string err = ex.Message; if (ex.InnerException != null) { err = ex.InnerException.Message; } SetErrorText(err); } }
protected void OnViewerDrillthrough(object sender, DrillthroughEventArgs e) { //Event handler for drill through try { if (!e.Report.IsDrillthroughReport) { return; } //Determine which drillthrough report is requested LocalReport report = (LocalReport)e.Report; switch (e.ReportPath) { case "PacSun Delivery Carton Detail": case "PacSun Delivery OSD Detail": //Get drillthrough parameters string _start = "", _end = "", _terminal = "", _store = "", _manifest = ""; for (int i = 0; i < report.OriginalParametersToDrillthrough.Count; i++) { switch (report.OriginalParametersToDrillthrough[i].Name) { case "FromDate": _start = report.OriginalParametersToDrillthrough[i].Values[0]; break; case "ToDate": _end = report.OriginalParametersToDrillthrough[i].Values[0]; break; case "TerminalName": _terminal = report.OriginalParametersToDrillthrough[i].Values[0]; break; case "StoreNumber": _store = report.OriginalParametersToDrillthrough[i].Values[0]; break; case "ManifestNumber": _manifest = report.OriginalParametersToDrillthrough[i].Values[0]; break; } } //Set data source and parameters System.IO.Stream stream = Master.GetReportDefinition("/Tracking/" + e.ReportPath); report.LoadReportDefinition(stream); DataSet ds = (DataSet)Session["PacSunDS"]; report.DataSources.Clear(); report.DataSources.Add(new ReportDataSource(REPORT_DS, ds.Tables[TBL_REPORT])); ReportParameter start = new ReportParameter("FromDate", _start); ReportParameter end = new ReportParameter("ToDate", _end); ReportParameter terminal = new ReportParameter("TerminalName", _terminal); ReportParameter store = new ReportParameter("StoreNumber", _store); ReportParameter manifest = new ReportParameter("ManifestNumber", _manifest); e.Report.SetParameters(new ReportParameter[] { start, end, terminal, store, manifest }); e.Report.Refresh(); break; } } catch (Exception ex) { Master.ReportError(ex, 4); } }
private void ReportViewer1_Drillthrough(object sender, DrillthroughEventArgs e) { int userid = 0; LocalReport report = (LocalReport)e.Report; foreach (ReportParameter rp in ((LocalReport)e.Report).OriginalParametersToDrillthrough) { userid = Convert.ToInt32(rp.Values[0]); } //Binding the DataTable to the Child report dataset. //The name DataSet1 which can be located from, //Go to Design view of Child.rdlc, Click View menu -> Report Data //You'll see this name under DataSet2. report.DataSources.Add(new ReportDataSource("DataSet1", objEmpModelService.GetEmployeeInfo(userid))); }
private void visor_Drillthrough(object sender, DrillthroughEventArgs e) { LocalReport localReport = (LocalReport)e.Report; string fn = System.IO.Path.GetFileNameWithoutExtension(localReport.ReportPath); localReport.DataSources.Clear(); for (int j = 0; j <= this.ActDb.Tables.Count - 1; j++) { if (j == 0) { continue;//Saltar tabla con el nombre de las tablas que siempre debe de ser la primera en el conjunto de seleccion } DataTable table = this.ActDb.Tables[j]; localReport.DataSources.Add(new ReportDataSource(table.TableName, table)); } }
void rptViewer_Drillthrough(object sender, DrillthroughEventArgs e) { LocalReport localreport = (LocalReport)e.Report; IList<ReportParameter> list = localreport.OriginalParametersToDrillthrough; DispatchOrderId =Convert.ToInt32(list[0].Values[0]); var dtDetails = _dispatchOrderService.GetDispatchOrderDetailByDispatchOrderid(DispatchOrderId); localreport.EnableHyperlinks = true; ReportDataSource rds = new ReportDataSource("DispatchOrderDetail", dtDetails); // ReportDataSource rds1 = new ReportDataSource("dsCashCard", dt); localreport.DataSources.Clear(); localreport.DataSources.Add(rds); localreport.Refresh(); }
/// <summary> /// Handles drilldown report events /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void reportViewer1_Drillthrough(object sender, DrillthroughEventArgs e) { _localReport = (LocalReport)e.Report; OnReportDrilledThrough(e); byte[] rdlBytes = Encoding.UTF8.GetBytes(_reportInfo.ReportDefinition); System.IO.MemoryStream stream = new System.IO.MemoryStream(rdlBytes); _localReport.LoadReportDefinition(stream); RunReport(); if (!_bDisplayedError) { _localReport.Refresh(); } }
void rptViewer_Drillthrough(object sender, DrillthroughEventArgs e) { LocalReport localreport = (LocalReport)e.Report; IList <ReportParameter> list = localreport.OriginalParametersToDrillthrough; DispatchOrderId = Convert.ToInt32(list[0].Values[0]); var dtDetails = _dispatchOrderService.GetDispatchOrderDetailByDispatchOrderid(DispatchOrderId); localreport.EnableHyperlinks = true; ReportDataSource rds = new ReportDataSource("DispatchOrderDetail", dtDetails); // ReportDataSource rds1 = new ReportDataSource("dsCashCard", dt); localreport.DataSources.Clear(); localreport.DataSources.Add(rds); localreport.Refresh(); }
private void reportViewer_Drillthrough(object sender, DrillthroughEventArgs e) { int CompanyId = int.Parse(Parameters.Find(p => p.Name == "CompanyId").Value); DateTime FromDate = DateTime.Parse(Parameters.Find(p => p.Name == "FromDate").Value); DateTime ToDate = DateTime.Parse(Parameters.Find(p => p.Name == "ToDate").Value); if (e.ReportPath == "Income Statement Detail Chart") { ReportParameter[] reportParam = new ReportParameter[2]; EIncomeStatementChartReportDS isDataSource = new EIncomeStatementChartReportDS(); IncomeStatementDetailChartReportTableAdapter isDetailAdapter = new IncomeStatementDetailChartReportTableAdapter(); ECompanyDS companyDataSource = new ECompanyDS(); tblCompaniesTableAdapter companyAdapter = new tblCompaniesTableAdapter(); isDetailAdapter.Fill(isDataSource.IncomeStatementDetailChartReport, CompanyId, FromDate, ToDate); companyAdapter.Fill(companyDataSource.tblCompanies, CompanyId); reportParam[0] = new ReportParameter("FromDate", FromDate.ToString("MM'/'dd'/'yyyy"), false); reportParam[1] = new ReportParameter("ToDate", ToDate.ToString("MM'/'dd'/'yyyy"), false); (e.Report as LocalReport).SetParameters(reportParam); (e.Report as LocalReport).DataSources.Add(new ReportDataSource("IncomeStatementDetailChartReport", isDataSource.Tables["IncomeStatementDetailChartReport"])); (e.Report as LocalReport).DataSources.Add(new ReportDataSource("Company", companyDataSource.Tables["tblCompanies"])); } else if (e.ReportPath == "Balance Sheet Detail Chart") { ReportParameter[] reportParam = new ReportParameter[1]; EBalanceSheetChartReport bsDataSource = new EBalanceSheetChartReport(); BalanceSheetDetailChartReportTableAdapter bsDetailAdapter = new BalanceSheetDetailChartReportTableAdapter(); ECompanyDS companyDataSource = new ECompanyDS(); tblCompaniesTableAdapter companyAdapter = new tblCompaniesTableAdapter(); bsDetailAdapter.Fill(bsDataSource.BalanceSheetDetailChartReport, CompanyId, ToDate); companyAdapter.Fill(companyDataSource.tblCompanies, CompanyId); reportParam[0] = new ReportParameter("AsOfDate", ToDate.ToString("MM'/'dd'/'yyyy"), false); (e.Report as LocalReport).SetParameters(reportParam); (e.Report as LocalReport).DataSources.Add(new ReportDataSource("BalanceSheetDetailChartReport", bsDataSource.Tables["BalanceSheetDetailChartReport"])); (e.Report as LocalReport).DataSources.Add(new ReportDataSource("Company", companyDataSource.Tables["tblCompanies"])); } }
private void rptView_Drillthrough(object sender, DrillthroughEventArgs e) { try { LocalReport DetailReport = (LocalReport)e.Report; MICS.Reports.PurchasedProducts.SalesDetailDataTable r = new PurchasedProducts.SalesDetailDataTable(); MICS.Reports.PurchasedProductsTableAdapters.SalesDetailsTableAdapter ad = new MICS.Reports.PurchasedProductsTableAdapters.SalesDetailsTableAdapter(); ad.SetTimeOut = 120; ReportParameterInfoCollection p = DetailReport.GetParameters(); string name = p[0].Name; string ParamValue = p[0].Values[0]; ad.FillByWhere(this.PurchasedProducts.SalesDetail, ParamValue); DetailReport.DataSources.Add(new ReportDataSource("PurchasedProducts_SalesDetail", ad.GetData())); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
protected void ReportViewer1_Drillthrough(object sender, DrillthroughEventArgs e) { try { LocalReport lr = (LocalReport)e.Report; /* * this.ReportViewer1.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Local; * if (lr.ReportPath.Contains("DashboardDetails") == true) * { * ReportParameterInfoCollection pars = e.Report.GetParameters(); * bizReport biz = new bizReport(); * List<proc_rpt_DashboardDetailResult> rs = biz.GetDashboardDetailData( * DateTime.Parse(pars[0].Values[0]), * DateTime.Parse(pars[1].Values[0]), * pars[2].Values[0], * int.Parse(pars[4].Values[0]), * int.Parse(pars[3].Values[0]), * pars[5].Values[0], * pars[6].Values[0], * pars[7].Values[0] == "" ? null : pars[7].Values[0], * pars[8].Values[0] == "" ? null : pars[8].Values[0]); * this.ucMessanger1.ProcessMessages(biz.MSGS, true); * ReportDataSource myRDS = new ReportDataSource("proc_rpt_DashboardDetailResult", rs); * lr.DataSources.Clear(); * lr.DataSources.Add(myRDS); * lr.Refresh(); * this.ReportViewer1.Height = Unit.Point(800); * this.ReportViewer1.Visible = true; * * } */ } catch (Exception ex) { bizLog.InsertExceptionLog(ex); Response.Redirect("~/ErrorPage.aspx", false); } }
protected void rpViewer_Drillthrough(object sender, DrillthroughEventArgs e) { try { // Handle local drillthrough only if (e.Report is ServerReport) { return; } LocalReport localreport = (LocalReport)e.Report; RDLReportDocument drillReport = new RDLReportDocument(e.ReportPath); drillReport.ReportPathWithOutName = Report.ReportPathWithOutName; drillReport.Load(String.Format(@"{0}\{1}.{2}", Report.ReportPathWithOutName, e.ReportPath, "rdl")); drillReport.LoadSourceDataSet(localreport.OriginalParametersToDrillthrough); localreport.DataSources.Clear(); localreport.LoadReportDefinition(drillReport.GetCustomTextReader(drillReport.ReportPath)); localreport.DisplayName = drillReport.Name; SetDataSource(drillReport.dsSource, localreport); ReportParameter[] Parameters = new ReportParameter[drillReport.Parameters.Count]; int i = 0; foreach (RDLParameter rpParam in drillReport.Parameters) { Parameters[i] = new ReportParameter(); Parameters[i].Name = rpParam.Name; Parameters[i].Values.Add(rpParam.Value.ToString()); i++; } localreport.Refresh(); } catch (Exception ex) { this.ErrorMessage = (ExceptionHelper.getExceptionMessage(ex)); } }
/// <summary> /// Handles the Drillthrough event of the RptViewer control. /// </summary> /// <param name="sender">The source of the event.</param> /// <param name="e">The <see cref="Microsoft.Reporting.WebForms.DrillthroughEventArgs"/> instance containing the event data.</param> private void RptViewer_Drillthrough(object sender, DrillthroughEventArgs e) { LocalReport lr = (LocalReport)e.Report; string photo = lr.GetParameters()["Photo"].Values[0].ToString(); //2014.02.17 paulus: 直接用 Photo as image Uri //string imageFolder = VWGContext.Current.Config.GetDirectory("RTImages"); //string imagePath = Path.Combine(Path.Combine(imageFolder, "Product"), photo); string imagePath = photo; ViewImage viewImage = new ViewImage(); viewImage.ImageName = imagePath; viewImage.ShowDialog(); e.Cancel = true; //LocalReport lr = (LocalReport)e.Report; //lr.DataSources.Clear(); //lr.DataSources.Add(new ReportDataSource(reportDatasourceName, dataSource)); }
protected void RpViewerDrillthrough(object sender, DrillthroughEventArgs e) { try { if (e.Report is ServerReport) { return; } LocalReport localreport = (LocalReport)e.Report; RDLReportDocument drillReport = new RDLReportDocument(); drillReport.SetFields(User.Identity.GetUserId <int>().ToString(), _reportDocument.Name, _reportDocument.ReportPathWithOutName); drillReport.Load(string.Format(@"{0}\{1}.{2}", _reportDocument.ReportPathWithOutName, e.ReportPath, "rdl")); drillReport.LoadSourceDataSet(localreport.OriginalParametersToDrillthrough); localreport.DataSources.Clear(); localreport.LoadReportDefinition(drillReport.GetCustomTextReader(drillReport.ReportPath)); localreport.DisplayName = drillReport.Name; SetDataSource(drillReport.DsSource, localreport); ReportParameter[] Parameters = new ReportParameter[drillReport.Parameters.Count]; int i = 0; foreach (RDLParameter rpParam in drillReport.Parameters) { Parameters[i] = new ReportParameter(); Parameters[i].Name = rpParam.Name; Parameters[i].Values.Add(rpParam.Value.ToString()); i++; } localreport.Refresh(); } catch (Exception ex) { throw (ex); } }
void rptViewer_Drillthrough1(object sender, DrillthroughEventArgs e) { try { ReportParameterInfoCollection drillThroughValues = e.Report.GetParameters(); DispatchOrderId = Convert.ToInt32(drillThroughValues[0].Values[0]); var dtDetails = _dispatchOrderService.GetDispatchOrderDetailByDispatchOrderId(DispatchOrderId); LocalReport localreport = (LocalReport)e.Report; localreport.EnableHyperlinks = true; ReportDataSource rds = new ReportDataSource("DispatchOrderDetail", dtDetails); // ReportDataSource rds1 = new ReportDataSource("dsCashCard", dt); localreport.DataSources.Clear(); localreport.DataSources.Add(rds); localreport.Refresh(); } catch (Exception ex) { MessageBox.Show(ex.Message, "", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
void DrillthroughEventHandler(object sender, DrillthroughEventArgs e) { Guid hubid = Guid.Empty; var report = e.Report; using (var c = ObjectFactory.Container.GetNestedContainer()) { hubid = c.GetInstance<IConfigService>().Load().CostCentreId; } ReportParameter hubidparam = new ReportParameter("hubId", hubid.ToString(), false); // ReportParameter hubidparam = new ReportParameter("hubId", "E6834108-4BA7-4A1A-98CA-9DD4DF8D68E2", false); try { report.SetParameters(new ReportParameter[] { hubidparam }); } catch (Exception ex) { } report.Refresh(); }
protected void rvVenta_Drillthrough(object sender, DrillthroughEventArgs e) { Ventas loVentas = new Ventas(); try { #region Mostrar detalles string lsClaveCliente = ((LocalReport)e.Report).OriginalParametersToDrillthrough[0].Values[0]; string lsCliente = ((LocalReport)e.Report).OriginalParametersToDrillthrough[1].Values[0]; string lsComodines = RetornaCadComodines(); Reglas.Comun loComun = new Reglas.Comun(); if (e.ReportPath == Comun.Definiciones.TipoSubreporte.DiasConPedidosDetalle.Descripcion()) { ((LocalReport)e.Report).ReportPath = "Informes/Ventas/" + e.ReportPath + ".rdl"; ((LocalReport)e.Report).ReportEmbeddedResource = "Informes/Ventas/" + e.ReportPath + ".rdl"; ((LocalReport)e.Report).DisplayName = "Analisis_dias_con_Pedidos_Cte-" + lsClaveCliente + "_" + ddlSucursales.SelectedItem.Text.Split('(')[1].Split(')')[0]; ((LocalReport)e.Report).DataSources.Add(new ReportDataSource("dsImportePedidoDias", loVentas.ObtenerVentasPorDiasDetalle((Sesion)Session["Sesion"], lsClaveCliente, int.Parse(ddlSucursales.SelectedValue), DateTime.Parse(txtFechaInicio.Text), DateTime.Parse(txtFechaFin.Text), int.Parse(ddlVendedores.SelectedValue), lsComodines))); ((LocalReport)e.Report).DataSources.Add(new ReportDataSource("dsEncabezado", loComun.ObtenerEncabezado( "Sucursal: " + ddlSucursales.SelectedItem.Text + ", Cliente: " + lsCliente + ((int.Parse(ddlVendedores.SelectedValue) == 0) ? string.Empty : ", Vendedor: " + ddlVendedores.SelectedItem.Text + " "), (txtFechaInicio.Text) + " - " + txtFechaFin.Text) )); //((LocalReport)e.Report).SetParameters(parametros); ((LocalReport)e.Report).Refresh(); } else if (e.ReportPath == Comun.Definiciones.TipoSubreporte.FolioPedidosDias.Descripcion()) { string ldFecha = ((LocalReport)e.Report).OriginalParametersToDrillthrough[2].Values[0]; ((LocalReport)e.Report).ReportPath = "Informes/Ventas/" + e.ReportPath + ".rdl"; ((LocalReport)e.Report).ReportEmbeddedResource = "Informes/Ventas/" + e.ReportPath + ".rdl"; ((LocalReport)e.Report).DisplayName = "Analisis_Folio_Pedidos_Cte-" + lsClaveCliente + "_" + ddlSucursales.SelectedItem.Text.Split('(')[1].Split(')')[0]; ((LocalReport)e.Report).DataSources.Add(new ReportDataSource("dsImportePedidoDias", loVentas.ObtenerFolioPedidosDias((Sesion)Session["Sesion"], lsClaveCliente, int.Parse(ddlSucursales.SelectedValue), DateTime.Parse(ldFecha), int.Parse(ddlVendedores.SelectedValue), lsComodines))); ((LocalReport)e.Report).DataSources.Add(new ReportDataSource("dsEncabezado", loComun.ObtenerEncabezado( "Sucursal: " + ddlSucursales.SelectedItem.Text + ", Cliente: " + lsCliente + ((int.Parse(ddlVendedores.SelectedValue) == 0) ? string.Empty : ", Vendedor: " + ddlVendedores.SelectedItem.Text + " "), DateTime.Parse(ldFecha).ToString("dd/MM/yyyy")) )); ((LocalReport)e.Report).Refresh(); } else if (e.ReportPath == Comun.Definiciones.TipoSubreporte.ArticulosPedidosDias.Descripcion()) { string lsFolio = ((LocalReport)e.Report).OriginalParametersToDrillthrough[2].Values[0]; int lnNumero = int.Parse(((LocalReport)e.Report).OriginalParametersToDrillthrough[3].Values[0]); string ldFecha = ((LocalReport)e.Report).OriginalParametersToDrillthrough[4].Values[0]; ((LocalReport)e.Report).ReportPath = "Informes/Ventas/" + e.ReportPath + ".rdl"; ((LocalReport)e.Report).ReportEmbeddedResource = "Informes/Ventas/" + e.ReportPath + ".rdl"; ((LocalReport)e.Report).DisplayName = "Analisis_Articulos_Pedidos_Cte-" + lsClaveCliente + "_" + ddlSucursales.SelectedItem.Text.Split('(')[1].Split(')')[0]; ((LocalReport)e.Report).DataSources.Add(new ReportDataSource("dsImportePedidoDias", loVentas.ObtenerArticulosPedidosDias((Sesion)Session["Sesion"], lsClaveCliente, int.Parse(ddlSucursales.SelectedValue), DateTime.Parse(ldFecha), lsFolio, lnNumero, int.Parse(ddlVendedores.SelectedValue), lsComodines))); ((LocalReport)e.Report).DataSources.Add(new ReportDataSource("dsEncabezado", loComun.ObtenerEncabezado( "Sucursal: " + ddlSucursales.SelectedItem.Text + ", Cliente: " + lsCliente + ((int.Parse(ddlVendedores.SelectedValue) == 0) ? string.Empty : ", Vendedor: " + ddlVendedores.SelectedItem.Text + " "), DateTime.Parse(ldFecha).ToString("dd/MM/yyyy")) )); ((LocalReport)e.Report).Refresh(); } #endregion } catch (Exception ex) { Session["Excepcion"] = ex; Response.Redirect("~/Error.aspx", false); } }
protected void ReportViewer1_Drillthrough(object sender, DrillthroughEventArgs e) { this.div_1.Attributes.Add("style", "display:none"); }
/// <summary> /// Handles drilldown report events /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void reportViewer1_Drillthrough(object sender, DrillthroughEventArgs e) { _localReport = (LocalReport)e.Report; OnReportDrilledThrough(e); byte[] rdlBytes = Encoding.UTF8.GetBytes(_reportInfo.ReportDefinition); System.IO.MemoryStream stream = new System.IO.MemoryStream(rdlBytes); _localReport.LoadReportDefinition(stream); RunReport(); if (!_bDisplayedError) _localReport.Refresh(); }
/// <summary> /// 钻取报表事件 /// </summary> private void ReportOnDrillthrough(object sender, DrillthroughEventArgs eventArgs) { base.RaiseEvent(new RoutedEventArgs(_DrillthroughEvent, this)); }
private void reportViewer1_Drillthrough(object sender, DrillthroughEventArgs e) { try { LocalReport localReport = (LocalReport)e.Report; Console.WriteLine(localReport.OriginalParametersToDrillthrough[0].Values[0].ToString()); DataTable dt = DBAdo.DtFillSql(string.Format("SELECT EXCHANGEDATE 日期,c.cname 客户,TYPE 类型,cash 现汇,note 票据,mz 抹账, cash+note+mz 小计 FROM ACASH a,aclients c where 1=1 AND HDW ='{0}' and c.ccode =a.ccode ORDER BY EXCHANGEDATE", ClassCustom.codeSub(localReport.OriginalParametersToDrillthrough[0].Values[0].ToString()))); localReport.DataSources.Add(new ReportDataSource("Contract1DataSet_DataTable2", dt)); //ReportParameter rp1 = new ReportParameter("HDW", dt.Rows[0]["客户名"].ToString()); } catch (Exception ex) { MessageBox.Show(ex.ToString()); // MessageBox.Show(ex.Message); return; } }
private void reportViewer1_Drillthrough(object sender, DrillthroughEventArgs e) { var localReport = (LocalReport)e.Report; localReport.DataSources.Add(_reportViewer1.LocalReport.DataSources["DataSet1"]); }
protected void rpViewer_Drillthrough(object sender, DrillthroughEventArgs e) { try { // Handle local drillthrough only if (e.Report is ServerReport) return; LocalReport localreport = (LocalReport)e.Report; RDLReportDocument drillReport = new RDLReportDocument(e.ReportPath); drillReport.ReportPathWithOutName = Report.ReportPathWithOutName; drillReport.Load(String.Format(@"{0}\{1}.{2}", Report.ReportPathWithOutName, e.ReportPath, "rdl")); drillReport.LoadSourceDataSet(localreport.OriginalParametersToDrillthrough); localreport.DataSources.Clear(); localreport.LoadReportDefinition(drillReport.GetCustomTextReader(drillReport.ReportPath)); localreport.DisplayName = drillReport.Name; SetDataSource(drillReport.dsSource, localreport); ReportParameter[] Parameters = new ReportParameter[drillReport.Parameters.Count]; int i = 0; foreach (RDLParameter rpParam in drillReport.Parameters) { Parameters[i] = new ReportParameter(); Parameters[i].Name = rpParam.Name; Parameters[i].Values.Add(rpParam.Value.ToString()); i++; } localreport.Refresh(); } catch (Exception ex) { this.ErrorMessage = (ExceptionHelper.getExceptionMessage(ex)); } }
/* * protected void ReportViewer1_Drillthrough(object sender, DrillthroughEventArgs e) * { * try * { * ServerReport sr = (ServerReport)e.Report; * this.ReportViewer1.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Remote; * if (sr.ReportPath.Contains("DashboardDetails") == true) * { * * } * } * catch (Exception ex) * { * bizLog.InsertExceptionLog(ex); * Response.Redirect("~/ErrorPage.aspx", false); * } * } * */ protected void ReportViewer1_Drillthrough(object sender, DrillthroughEventArgs e) { try { SearchOptions so = this.ucSearchOptions1.GetSearchOptions(); if (so == null) { this.pnlResults_CollapsiblePanelExtender.ClientState = "true"; this.pnlResults_CollapsiblePanelExtender.Collapsed = true; return; } this.ReportViewer1.Reset(); this.ReportViewer1.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Remote; string ssrsURL = ConfigurationSettings.AppSettings["SSRS_URL"]; if (string.IsNullOrEmpty(ssrsURL)) { throw new Exception("Error: Please set the SSRS_URL in the AppSetting in web.config"); } this.ReportViewer1.ServerReport.ReportServerUrl = new Uri(ssrsURL); this.ReportViewer1.ServerReport.ReportPath = "/enGage/DashboardDetails"; using (Timeline.Capture("ServerReport.Refresh()", "Reports")) { this.ReportViewer1.ServerReport.Refresh(); } this.ReportViewer1.Height = Unit.Point(480); this.ReportViewer1.Visible = true; ReportParameter p11 = new ReportParameter("parDateFrom", so.DateFrom.ToString("dd MMM yyyy")); ReportParameter p12 = new ReportParameter("parDateTo", so.DateTo.ToString("dd MMM yyyy")); //ReportParameter p13 = new ReportParameter("parRegion", so.Region); //ReportParameter p14 = new ReportParameter("parBranch", so.Branch); ReportParameter p15 = new ReportParameter("parExecutive", so.Executive); ReportParameter p16 = new ReportParameter("parClassification", so.Classification.ToString()); ReportParameter p17 = new ReportParameter("parBusinessType", so.BusinessType.ToString()); ReportParameter p18 = new ReportParameter("parIndustries", so.Industries == null ? "" : so.Industries); ReportParameter p19 = new ReportParameter("parSources", so.Sources == null ? "" : so.Sources); string ExecutiveName = this.ucSearchOptions1.GetExecutiveName(so.Executive); string label = so.Executive != "(All)" ? ExecutiveName : so.Branch != "(All)" && so.Executive == "(All)" ? so.Region + " (" + so.Branch + ")" : so.Region != "(All)" && so.Branch == "(All)" ? so.Region : so.Region == "(All)" ? "OAMPS Insurance Brokers Ltd" : ""; ReportParameter p20 = new ReportParameter("parReportLabel", label); //ReportParameter p21 = new ReportParameter("parOpportunities", so.Opportunities); this.ReportViewer1.ServerReport.SetParameters(new ReportParameter[] { p11, p12, p15, p16, p17, p18, p19, p20 }); using (Timeline.Capture("ServerReport.Refresh()", "Reports")) { this.ReportViewer1.ServerReport.Refresh(); } this.ReportViewer1.Height = Unit.Point(480); this.ReportViewer1.Visible = true; this.pnlResults_CollapsiblePanelExtender.ClientState = "false"; this.pnlResults_CollapsiblePanelExtender.Collapsed = false; } catch (Exception ex) { bizLog.InsertExceptionLog(ex); Response.Redirect("~/ErrorPage.aspx", false); } }
protected void rvContent_Drillthrough(object sender, DrillthroughEventArgs e) { BindReport(e.ReportPath, e.Report as LocalReport); BindExportButtons(e.Report as LocalReport); }
protected void ReportViewer1_Drillthrough(object sender, DrillthroughEventArgs e) { }
protected void ReportViewer2_Drillthrough(object sender, DrillthroughEventArgs e) { Microsoft.Reporting.WebForms.ReportDataSource rdis = new Microsoft.Reporting.WebForms.ReportDataSource("dsDInventLog_sp_ReportDrugActivityLog"); //rds.Name = "table1"; int rdrugID=0, rfacID=0; String rdrugName="", rclinName="", rdType="S"; String date1="", date2=""; LocalReport report = (LocalReport)e.Report; //ReportViewer2.LocalReport.ReportPath = "Reports/RptSInventLog.rdlc"; IList<ReportParameter> list = report.OriginalParametersToDrillthrough; int i = 0; foreach (ReportParameter param in list) { switch (i) { case 0: rdrugID = Convert.ToInt32(param.Values[0].ToString()); break; case 1: rdrugName = param.Values[0].ToString(); break; case 2: rdType = param.Values[0].ToString(); break; case 3: rfacID = Convert.ToInt32(param.Values[0].ToString()); break; case 4: rclinName = param.Values[0].ToString(); break; case 5: date1 = param.Values[0].ToString(); break; case 6: date2 = param.Values[0].ToString(); break; } i++; } rdis.Value = GetInventData(rdrugID, rfacID, rdType, date1, date2); ReportParameter DrugID = new ReportParameter("DrugID", rdrugID.ToString()); ReportParameter DType = new ReportParameter("DName", rdrugName); ReportParameter DName = new ReportParameter("DType", rdType); ReportParameter FacID = new ReportParameter("FacID", rfacID.ToString()); ReportParameter CName = new ReportParameter("CName", rclinName); ReportParameter Date1 = new ReportParameter("FromDate", date1); ReportParameter Date2 = new ReportParameter("ToDate", date2); ReportParameter[] rp = new ReportParameter[] { DrugID, DType, FacID, Date1, Date2 }; report.SetParameters(rp); //ReportViewer2.LocalReport.SetParameters(rp); //ReportViewer2.LocalReport.SetParameters(new ReportParameter("Date2", "8/8/2009")); report.DataSources.Add(rdis); //report.LocalReport.DataSources.Clear(); //report.LocalReport.DataSources.Add(rds); //report.LocalReport.Refresh(); //ReportViewer2.DataBind(); }
private void reportViewer1_Drillthrough(object sender, DrillthroughEventArgs e) { try { LocalReport localReport = (LocalReport)e.Report; //if (this.reportViewer1.LocalReport.ReportEmbeddedResource == "contract.Reports.Report合同收付款明细表.rdlc") //{ // localReport.DataSources.Add(new ReportDataSource("Contract1DataSet_AFKXX", DBAdo.DtFillSql("SELECT * FROM AFKXX"))); // localReport.DataSources.Add(new ReportDataSource("Contract1DataSet_ASP", DBAdo.DtFillSql("SELECT * FROM ASP"))); //} //localReport.OriginalParametersToDrillthrough //Console.WriteLine(localReport.DisplayName); //Console.WriteLine(int.Parse(localReport.OriginalParametersToDrillthrough[0].Values[0].ToString())); switch (this.reportViewer1.LocalReport.ReportEmbeddedResource) { case "contract.Reports.Report合同收付款明细表.rdlc": if (int.Parse(localReport.OriginalParametersToDrillthrough[0].Values[0].ToString()) == 0) { DataTable dt = DBAdo.DtFillSql(string.Format("SELECT * FROM Vcx1 WHERE 合同号 ='{0}'", localReport.OriginalParametersToDrillthrough[1].Values[0].ToString())); localReport.DataSources.Add(new ReportDataSource("Contract1DataSet_ASP", DBAdo.DtFillSql("SELECT * FROM ASP"))); if (dt.Rows.Count > 0) { ReportParameter rp1 = new ReportParameter("hkh", dt.Rows[0]["客户名"].ToString()); ReportParameter rp2 = new ReportParameter("qdrq", dt.Rows[0]["QDRQ"].ToString()); ReportParameter rp3 = new ReportParameter("jhrq", dt.Rows[0]["交货日期"].ToString()); ReportParameter rp4 = new ReportParameter("hlx", dt.Rows[0]["hlx"].ToString()); ReportParameter rp5 = new ReportParameter("sp", dt.Rows[0]["商品"].ToString()); ReportParameter rp6 = new ReportParameter("rmb", dt.Rows[0]["金额"].ToString()); ReportParameter rp7 = new ReportParameter("fp", dt.Rows[0]["发票"].ToString()); localReport.SetParameters(new ReportParameter[] { rp1, rp2, rp3, rp4, rp5, rp6, rp7 }); DataTable _dtsp = DBAdo.DtFillSql(string.Format("SELECT HTH 合同号, YEAR(date) 年 ,month(date) 月,TYPE 类型, SUM(RMB) 金额 FROM AFKXX WHERE HTH ='{0}' GROUP BY HTH , YEAR(date) ,month(date) ,TYPE ", localReport.OriginalParametersToDrillthrough[1].Values[0].ToString())); for (int i = 0; i < 12; i++) { _dtsp.Rows.Add(new object[] { localReport.OriginalParametersToDrillthrough[1].Values[0].ToString() ,this.YEAR.Text,i+1, (dt.Rows[0]["hlx"].ToString().Substring(0,2)=="02"?"回款":"付款") ,0}); _dtsp.Rows.Add(new object[] { localReport.OriginalParametersToDrillthrough[1].Values[0].ToString() ,this.YEAR.Text,i+1, (dt.Rows[0]["hlx"].ToString().Substring(0,2)=="02"?"销项发票":"进项发票") ,0}); } localReport.DataSources.Add(new ReportDataSource("Contract1DataSet_SP", _dtsp)); } } break; case "contract.Reports.Report合同导航.rdlc": localReport.DataSources.Add(new ReportDataSource("Contract1DataSet_ASP", DBAdo.DtFillSql("SELECT * FROM ASP"))); break; case "contract.Reports.Report签订明细.rdlc": if (int.Parse(localReport.OriginalParametersToDrillthrough[0].Values[0].ToString()) == 0) { DataTable dt = DBAdo.DtFillSql(string.Format("SELECT * FROM Vcx1 WHERE 合同号 ='{0}'", localReport.OriginalParametersToDrillthrough[1].Values[0].ToString())); localReport.DataSources.Add(new ReportDataSource("Contract1DataSet_ASP", DBAdo.DtFillSql("SELECT * FROM ASP"))); if (dt.Rows.Count > 0) { ReportParameter rp1 = new ReportParameter("hkh", dt.Rows[0]["客户名"].ToString()); ReportParameter rp2 = new ReportParameter("qdrq", dt.Rows[0]["QDRQ"].ToString()); ReportParameter rp3 = new ReportParameter("jhrq", dt.Rows[0]["交货日期"].ToString()); ReportParameter rp4 = new ReportParameter("hlx", dt.Rows[0]["hlx"].ToString()); ReportParameter rp5 = new ReportParameter("sp", dt.Rows[0]["商品"].ToString()); ReportParameter rp6 = new ReportParameter("rmb", dt.Rows[0]["金额"].ToString()); ReportParameter rp7 = new ReportParameter("fp", dt.Rows[0]["发票"].ToString()); localReport.SetParameters(new ReportParameter[] { rp1, rp2, rp3, rp4, rp5, rp6, rp7 }); DataTable _dtsp = DBAdo.DtFillSql(string.Format("SELECT HTH 合同号, YEAR(date) 年 ,month(date) 月,TYPE 类型, SUM(RMB) 金额 FROM AFKXX WHERE HTH ='{0}' GROUP BY HTH , YEAR(date) ,month(date) ,TYPE ", localReport.OriginalParametersToDrillthrough[1].Values[0].ToString())); for (int i = 0; i < 12; i++) { _dtsp.Rows.Add(new object[] { localReport.OriginalParametersToDrillthrough[1].Values[0].ToString() ,this.YEAR.Text,i+1, (dt.Rows[0]["hlx"].ToString().Substring(0,2)=="02"?"回款":"付款") ,0}); _dtsp.Rows.Add(new object[] { localReport.OriginalParametersToDrillthrough[1].Values[0].ToString() ,this.YEAR.Text,i+1, (dt.Rows[0]["hlx"].ToString().Substring(0,2)=="02"?"销项发票":"进项发票") ,0}); } localReport.DataSources.Add(new ReportDataSource("Contract1DataSet_SP", _dtsp)); } } break; case "contract.Reports.Report合同汇总.rdlc": if (int.Parse(localReport.OriginalParametersToDrillthrough[0].Values[0].ToString()) == 0) { DataTable dt = DBAdo.DtFillSql(string.Format("SELECT * FROM Vcx1 WHERE 合同号 ='{0}'", localReport.OriginalParametersToDrillthrough[1].Values[0].ToString())); localReport.DataSources.Add(new ReportDataSource("Contract1DataSet_ASP", DBAdo.DtFillSql("SELECT * FROM ASP"))); if (dt.Rows.Count > 0) { ReportParameter rp1 = new ReportParameter("hkh", dt.Rows[0]["客户名"].ToString()); ReportParameter rp2 = new ReportParameter("qdrq", dt.Rows[0]["QDRQ"].ToString()); ReportParameter rp3 = new ReportParameter("jhrq", dt.Rows[0]["交货日期"].ToString()); ReportParameter rp4 = new ReportParameter("hlx", dt.Rows[0]["hlx"].ToString()); ReportParameter rp5 = new ReportParameter("sp", dt.Rows[0]["商品"].ToString()); ReportParameter rp6 = new ReportParameter("rmb", dt.Rows[0]["金额"].ToString()); ReportParameter rp7 = new ReportParameter("fp", dt.Rows[0]["发票"].ToString()); localReport.SetParameters(new ReportParameter[] { rp1, rp2, rp3, rp4, rp5, rp6, rp7 }); DataTable _dtsp = DBAdo.DtFillSql(string.Format("SELECT HTH 合同号, YEAR(date) 年 ,month(date) 月,TYPE 类型, SUM(RMB) 金额 FROM AFKXX WHERE HTH ='{0}' GROUP BY HTH , YEAR(date) ,month(date) ,TYPE ", localReport.OriginalParametersToDrillthrough[1].Values[0].ToString())); for (int i = 0; i < 12; i++) { _dtsp.Rows.Add(new object[] { localReport.OriginalParametersToDrillthrough[1].Values[0].ToString() ,this.YEAR.Text,i+1, (dt.Rows[0]["hlx"].ToString().Substring(0,2)=="02"?"回款":"付款") ,0}); _dtsp.Rows.Add(new object[] { localReport.OriginalParametersToDrillthrough[1].Values[0].ToString() ,this.YEAR.Text,i+1, (dt.Rows[0]["hlx"].ToString().Substring(0,2)=="02"?"销项发票":"进项发票") ,0}); } localReport.DataSources.Add(new ReportDataSource("Contract1DataSet_SP", _dtsp)); } } break; //Report合同汇总.rdlc default: break; } } catch (Exception ex) { MessageBox.Show(ex.ToString()); // MessageBox.Show(ex.Message); return; } }
/// <summary> /// Event handler for when a report is drilled in to from the MS Viewer inside the ReportView control. /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void wlbReportView1_ReportDrilledThrough(object sender, DrillthroughEventArgs e) { SynchTreeViewReportList(e.ReportPath.ToString()); }
void SalesDrillthroughEventHandler(object sender, DrillthroughEventArgs e) { var report = e.Report; string distributorID = _vm.DistributorID.ToString(); //string distributorID = "167480A6-DC20-44B9-A1B6-0B523914B5CE"; var param = new ReportParameter(); param = new ReportParameter("distributorID", distributorID, false); try { report.SetParameters(new ReportParameter[] { param }); } catch (Exception ex) { } report.Refresh(); }
protected void OnViewerDrillthrough(object sender, DrillthroughEventArgs e) { //Event handler for drill through if (!e.Report.IsDrillthroughReport) { return; } //Determine which drillthrough report is requested LocalReport report = (LocalReport)e.Report; switch (e.ReportPath) { case "PacSunDeliveryCartonDetail": { //Get drillthrough parameters string _start = "", _end = "", _terminal = "", _store = "", _manifest = ""; for (int i = 0; i < report.OriginalParametersToDrillthrough.Count; i++) { switch (report.OriginalParametersToDrillthrough[i].Name) { case "FromDate": _start = report.OriginalParametersToDrillthrough[i].Values[0]; break; case "ToDate": _end = report.OriginalParametersToDrillthrough[i].Values[0]; break; case "TerminalName": _terminal = report.OriginalParametersToDrillthrough[i].Values[0]; break; case "StoreNumber": _store = report.OriginalParametersToDrillthrough[i].Values[0]; break; case "ManifestNumber": _manifest = report.OriginalParametersToDrillthrough[i].Values[0]; break; } } //Set data source and parameters DataSet ds = (DataSet)Session["PacSunDS"]; report.DataSources.Clear(); report.DataSources.Add(new ReportDataSource("DetailDS", ds.Tables[mTBLName])); ReportParameter start = new ReportParameter("FromDate", _start); ReportParameter end = new ReportParameter("ToDate", _end); ReportParameter terminal = new ReportParameter("TerminalName", _terminal); ReportParameter store = new ReportParameter("StoreNumber", _store); ReportParameter manifest = new ReportParameter("ManifestNumber", _manifest); e.Report.SetParameters(new ReportParameter[] { start, end, terminal, store, manifest }); e.Report.Refresh(); } break; case "PacSunDeliveryOSDDetail": { //Get drillthrough parameters string _start = "", _end = "", _terminal = "", _store = "", _manifest = ""; for (int i = 0; i < report.OriginalParametersToDrillthrough.Count; i++) { switch (report.OriginalParametersToDrillthrough[i].Name) { case "FromDate": _start = report.OriginalParametersToDrillthrough[i].Values[0]; break; case "ToDate": _end = report.OriginalParametersToDrillthrough[i].Values[0]; break; case "TerminalName": _terminal = report.OriginalParametersToDrillthrough[i].Values[0]; break; case "StoreNumber": _store = report.OriginalParametersToDrillthrough[i].Values[0]; break; case "ManifestNumber": _manifest = report.OriginalParametersToDrillthrough[i].Values[0]; break; } } //Set data source and parameters DataSet ds = (DataSet)Session["PacSunDS"]; report.DataSources.Clear(); report.DataSources.Add(new ReportDataSource("DetailDS", ds.Tables[mTBLName])); ReportParameter start = new ReportParameter("FromDate", _start); ReportParameter end = new ReportParameter("ToDate", _end); ReportParameter terminal = new ReportParameter("TerminalName", _terminal); ReportParameter store = new ReportParameter("StoreNumber", _store); ReportParameter manifest = new ReportParameter("ManifestNumber", _manifest); e.Report.SetParameters(new ReportParameter[] { start, end, terminal, store, manifest }); e.Report.Refresh(); } break; } }
private void reportViewer1_Drillthrough(object sender, DrillthroughEventArgs e) { LocalReport lp = (LocalReport)e.Report; m_szTitle = lp.OriginalParametersToDrillthrough[0].Values[0].ToString(); if (m_szTitle == "个人日放映收入表") { lp.DataSources.Clear(); RefleshReportViewer("dailydatagroup", "DailyDataGroup", "WinFormUI.Reporting.Reports.GroupClassTicketSale.rdlc", lp); flamingoDataSetTableAdapters.dailydatagroupTableAdapter TableAdapter = new flamingoDataSetTableAdapters.dailydatagroupTableAdapter(); TableAdapter.FillPersonalDailyIncome(this.flamingoDataSet.dailydatagroup, startDate, endDate, halls, films, users); TableAdapter.ClearBeforeFill = true; this.reportViewer1.RefreshReport(); } else if (m_szTitle == "个人日售票成绩表") { lp.DataSources.Clear(); RefleshReportViewer("dailydatagroup", "DailyDataGroup", "WinFormUI.Reporting.Reports.GroupClassTicketSale.rdlc", lp); flamingoDataSetTableAdapters.dailydatagroupTableAdapter TableAdapter = new flamingoDataSetTableAdapters.dailydatagroupTableAdapter(); TableAdapter.FillPersonalDailySale(this.flamingoDataSet.dailydatagroup, startDate, endDate, halls, films, users); TableAdapter.ClearBeforeFill = true; this.reportViewer1.RefreshReport(); } else if (m_szTitle == "影院日放映收入表") { lp.DataSources.Clear(); RefleshReportViewer("dailydatagroup", "DailyDataGroup", "WinFormUI.Reporting.Reports.GroupClassTicketSale.rdlc", lp); flamingoDataSetTableAdapters.dailydatagroupTableAdapter TableAdapter = new flamingoDataSetTableAdapters.dailydatagroupTableAdapter(); TableAdapter.FillTheaterDailyIncome(this.flamingoDataSet.dailydatagroup, startDate, endDate, halls, films); TableAdapter.ClearBeforeFill = true; this.reportViewer1.RefreshReport(); } else if (m_szTitle == "影院日售票成绩表") { lp.DataSources.Clear(); RefleshReportViewer("dailydatagroup", "DailyDataGroup", "WinFormUI.Reporting.Reports.GroupClassTicketSale.rdlc", lp); flamingoDataSetTableAdapters.dailydatagroupTableAdapter TableAdapter = new flamingoDataSetTableAdapters.dailydatagroupTableAdapter(); TableAdapter.FillTheaterDailySale(this.flamingoDataSet.dailydatagroup, startDate, endDate, halls, films); TableAdapter.ClearBeforeFill = true; this.reportViewer1.RefreshReport(); } //if (lp.ReportEmbeddedResource == "PersonalDailyIncomeGroup.rdlc") //{ // lp.DataSources.Clear(); // RefleshReportViewer("dailydatagroup", "DailyDataGroup", "WinFormUI.Reporting.Reports.PersonalDailyIncomeGroup.rdlc", lp); // flamingoDataSetTableAdapters.dailydatagroupTableAdapter TableAdapter = new flamingoDataSetTableAdapters.dailydatagroupTableAdapter(); // TableAdapter.FillPersonalDailyIncome(this.flamingoDataSet.dailydatagroup, startDate, endDate, halls, films, users); // TableAdapter.ClearBeforeFill = true; // this.reportViewer1.RefreshReport(); //} //else if (lp.ReportEmbeddedResource == "PersonalDailySalesGroup.rdlc") //{ // lp.DataSources.Clear(); // RefleshReportViewer("dailydatagroup", "DailyDataGroup", "WinFormUI.Reporting.Reports.PersonalDailySalesGroup.rdlc", lp); // flamingoDataSetTableAdapters.dailydatagroupTableAdapter TableAdapter = new flamingoDataSetTableAdapters.dailydatagroupTableAdapter(); // TableAdapter.FillPersonalDailySale(this.flamingoDataSet.dailydatagroup, startDate, endDate, halls, films, users); // TableAdapter.ClearBeforeFill = true; // this.reportViewer1.RefreshReport(); //} }
protected void ReportViewer1_Drillthrough(object sender, DrillthroughEventArgs e) { try { Rpt_PatientStatistics.Visible = true; ReportParameterInfoCollection DrillThroughValues = e.Report.GetParameters(); string[] Params = new string[2]; int i = 0; foreach (ReportParameterInfo d in DrillThroughValues) { Params[i] = d.Values[0].ToString().Trim(); i += 1; } //ReportViewer reportviewer = new ReportViewer(); //reportviewer.ProcessingMode = ProcessingMode.Local; //// Add a handler for drillthrough. //reportviewer.Back += new // BackEventHandler(BackEventHandlerFunc); //reportviewer.ReportPath = HttpContext.Current.Server.MapPath("~/RDLCReports/Rpt_TotalPaitentCount.rdlc"); // btnImgprint.Visible = true; //reportviewer.LocalReport.ReportPath = HttpContext.Current.Server.MapPath("~/RDLCReports/Rpt_TotalPaitentCount.rdlc"); LocalReport localreport = (LocalReport)e.Report; DateTime FromDate = DateTime.Parse(txtFromDate.Text.Trim(), provider, System.Globalization.DateTimeStyles.NoCurrentDateDefault).Date; DateTime ToDate = DateTime.Parse(txtToDate.Text.Trim(), provider, System.Globalization.DateTimeStyles.NoCurrentDateDefault).Date; if (e.ReportPath.ToString() == "Rpt_AllAnimalTypeDtls") { Session["ATypeCd"] = "T"; DataTable dt = ObjIns.GetAtypeALL1BAL(Session["UniqueInstId"].ToString(), FromDate, ToDate, ConnKey); ReportDataSource datasource = new ReportDataSource("Ds_PatientDtls", dt); localreport.DataSources.Clear(); localreport.DataSources.Add(datasource); localreport.Refresh(); } else if (e.ReportPath.ToString() == "Rpt_AnimalTypeWiseDtls") { Session["AnimalTypeCode"] = Params[1]; Session["ATypeCd"] = "R"; Session["Status"] = Params[0]; DataTable dt = ObjIns.GetAtypeRptBAL(Session["UniqueInstId"].ToString(), Params[1], Params[0], FromDate, ToDate, ConnKey); // DataTable dt = ObjIns.GetAtypeRptBAL(Session["UniqueInstId"].ToString(), lblParam.Text, FromDate, ToDate); ReportDataSource datasource = new ReportDataSource("Ds_PatientDtls", dt); localreport.DataSources.Clear(); localreport.DataSources.Add(datasource); localreport.Refresh(); } //DataTable dt = ObjIns.GetAtypeALLBAL(Session["UniqueInstId"].ToString(), FromDate, ToDate); //Assign dataset to report datasource } catch (Exception ex) { Response.Redirect("~/Error.aspx"); } }
protected void OnViewerDrillthrough(object sender, DrillthroughEventArgs e) { //Event handler for drill through if (!e.Report.IsDrillthroughReport) { return; } //Determine which drillthrough report is requested LocalReport report = (LocalReport)e.Report; report.DisplayName = e.ReportPath; report.EnableExternalImages = true; switch (e.ReportPath) { case "Delivery Window Summary By Client With Early": { //Get drillthrough parameters string _agent = "", _start = "", _end = ""; for (int i = 0; i < report.OriginalParametersToDrillthrough.Count; i++) { switch (report.OriginalParametersToDrillthrough[i].Name) { case "StartDate": _start = report.OriginalParametersToDrillthrough[i].Values[0]; break; case "EndDate": _end = report.OriginalParametersToDrillthrough[i].Values[0]; break; case "AgentNumber": _agent = report.OriginalParametersToDrillthrough[i].Values[0]; break; } } //Set local report and data source System.IO.Stream stream = Master.GetReportDefinition("/Executive/" + e.ReportPath); report.LoadReportDefinition(stream); EnterpriseGateway enterprise = new EnterpriseGateway(); DataSet ds = enterprise.FillDataset("uspRptDeliveryWindowSummaryByClientWithEarly", "NewTable", new object[] { null, _agent, _start, _end }); report.DataSources.Clear(); report.DataSources.Add(new ReportDataSource("DeliveryWindowSumByClientWithEarlyDS", ds.Tables["NewTable"])); DataSet _ds = enterprise.FillDataset("uspRptAgentRead", "NewTable", new object[] { _agent }); report.DataSources.Add(new ReportDataSource("DataSet1", _ds.Tables["NewTable"])); ReportParameter client = new ReportParameter("ClientNumber"); ReportParameter agent = new ReportParameter("AgentNumber", _agent); ReportParameter start = new ReportParameter("StartDate", _start); ReportParameter end = new ReportParameter("EndDate", _end); report.SetParameters(new ReportParameter[] { client, agent, start, end }); report.Refresh(); } break; case "Delivery Window Summary By Agent With Early": { //Get drillthrough parameters string _client = "", _start = "", _end = ""; for (int i = 0; i < report.OriginalParametersToDrillthrough.Count; i++) { switch (report.OriginalParametersToDrillthrough[i].Name) { case "StartDate": _start = report.OriginalParametersToDrillthrough[i].Values[0]; break; case "EndDate": _end = report.OriginalParametersToDrillthrough[i].Values[0]; break; case "ClientNumber": _client = report.OriginalParametersToDrillthrough[i].Values[0]; break; } } //Set local report and data source System.IO.Stream stream = Master.GetReportDefinition("/Executive/" + e.ReportPath); report.LoadReportDefinition(stream); EnterpriseGateway enterprise = new EnterpriseGateway(); DataSet ds = enterprise.FillDataset("uspRptDeliveryWindowSummaryByAgentWithEarly", "NewTable", new object[] { _client, null, null, null, null, null, null, _start, _end }); report.DataSources.Clear(); report.DataSources.Add(new ReportDataSource("DeliveryWindowSummaryByAgentWithEarlyDS", ds.Tables["NewTable"])); DataSet _ds = enterprise.FillDataset("uspRptClientRead", "NewTable", new object[] { _client }); report.DataSources.Add(new ReportDataSource("DataSet1", _ds.Tables["NewTable"])); ReportParameter clientName = new ReportParameter("ClientName"); ReportParameter client = new ReportParameter("ClientNumber", _client); ReportParameter division = new ReportParameter("Division"); ReportParameter agentnumber = new ReportParameter("AgentParentNumber"); ReportParameter subagentnumber = new ReportParameter("AgentNumber"); ReportParameter region = new ReportParameter("Region"); ReportParameter district = new ReportParameter("District"); ReportParameter store = new ReportParameter("StoreNumber"); ReportParameter start = new ReportParameter("StartDate", _start); ReportParameter end = new ReportParameter("EndDate", _end); report.SetParameters(new ReportParameter[] { client, division, agentnumber, subagentnumber, region, district, store, start, end, clientName }); report.Refresh(); } break; } }
protected void rptvContainer_OnDrillthrough(object sender, DrillthroughEventArgs e) { }