protected void Page_Load(object sender, EventArgs e) { Dashboard dashboard = new Dashboard(); dashboard.LoadFromXml(HostingEnvironment.MapPath(@"~/App_Data/Dashboard.xml")); PivotDashboardItem pivot1 = (PivotDashboardItem)dashboard.Items[0]; DashboardOlapDataSource olapDataSource = (DashboardOlapDataSource)dashboard.DataSources[0]; string fieldYearName = "[Date].[Calendar].[Calendar Year]"; string year2001 = "[Date].[Calendar].[Calendar Year].&[2001]"; string year2002 = "[Date].[Calendar].[Calendar Year].&[2002]"; string fieldCountryName = "[Customer].[Country].[Country]"; string countryCanada = "[Customer].[Country].&[Canada]"; DynamicListLookUpSettings settings = new DynamicListLookUpSettings(); settings.DataSource = olapDataSource; settings.ValueMember = fieldCountryName; DashboardParameter parameter1 = new DashboardParameter("Parameter1", typeof(string), countryCanada, "Category", true, settings); dashboard.Parameters.Add(parameter1); CriteriaOperator filterCriteria = GroupOperator.And( new BinaryOperator(new OperandProperty(fieldCountryName), new OperandParameter(parameter1.Name), BinaryOperatorType.Equal), new NotOperator(new InOperator(new OperandProperty(fieldYearName), new ConstantValue[] { new ConstantValue(year2001), new ConstantValue(year2002) }))); pivot1.FilterString = filterCriteria.ToString(); ASPxDashboard1.OpenDashboard(dashboard.SaveToXDocument()); }
protected void ASPxDashboard1_Load(object sender, EventArgs e) { return; /*********************** config this ****************************************/ Dashboard dashboard = new Dashboard(); dashboard.LoadFromXDocument(System.Xml.Linq.XDocument.Load( Server.MapPath("~/App_Data/Dashboards/Terminales_Ventas.xml"))); //Change Dashboard Data // default values // dashboard.Parameters["Ano"].Value = DateTime.Now.Year; // dashboard.Parameters["Mes"].Value = DateTime.Now.Month; // option 1: change query in xml // option 2: change query in data provider // >>> set dashboard source // https://documentation.devexpress.com/Dashboard/117050/Examples/Web-Dashboard-Examples/How-to-Connect-the-Web-Dashboard-to-an-SQL-Database ASPxDashboard1.OpenDashboard(dashboard.SaveToXDocument()); // <<< set dashboard source }