public Form1() { InitializeComponent(); Dashboard dashboard = new Dashboard(); dashboard.LoadFromXml(@"..\..\Data\Dashboard.xml"); DashboardSqlDataSource dataSource = (DashboardSqlDataSource)dashboard.DataSources[0]; GridDashboardItem grid = (GridDashboardItem)dashboard.Items[0]; // Create a new dashboard parameter. StaticListLookUpSettings settings = new StaticListLookUpSettings(); settings.Values = new string[] { "0.01", "0.05", "0.1" }; DashboardParameter discountValue = new DashboardParameter("discountValue", typeof(double), 0.05, "Select discount:", true, settings); dashboard.Parameters.Add(discountValue); // Create a new calculated field and pass the created dashboard parameter // to a calculated field expression. CalculatedField isGreater = new CalculatedField(); isGreater.DataMember = "SalesPerson"; isGreater.Name = "IsGreater"; isGreater.Expression = "ToStr(Iif(Avg([Discount]) >= [Parameters.discountValue], 'TRUE', 'FALSE'))"; dataSource.CalculatedFields.Add(isGreater); grid.Columns.Add(new GridMeasureColumn(new Measure("IsGreater"))); dashboardViewer1.Dashboard = dashboard; }
public Form1() { InitializeComponent(); Dashboard dashboard = new Dashboard(); dashboard.LoadFromXml(@"..\..\Data\Dashboard.xml"); // Creates a new dashboard parameter. StaticListLookUpSettings staticSettings = new StaticListLookUpSettings(); staticSettings.Values = new string[] { "1994", "1995", "1996" }; DashboardParameter yearParameter = new DashboardParameter("yearParameter", typeof(string), "1995", "Select year:", true, staticSettings); dashboard.Parameters.Add(yearParameter); DashboardSqlDataSource dataSource = (DashboardSqlDataSource)dashboard.DataSources[0]; CustomSqlQuery salesPersonQuery = (CustomSqlQuery)dataSource.Queries[0]; salesPersonQuery.Parameters.Add(new QueryParameter("startDate", typeof(Expression), new Expression("[Parameters.yearParameter] + '/01/01'"))); salesPersonQuery.Parameters.Add(new QueryParameter("endDate", typeof(Expression), new Expression("[Parameters.yearParameter] + '/12/31'"))); salesPersonQuery.Sql = "select * from SalesPerson where OrderDate between @startDate and @endDate"; dashboardViewer1.Dashboard = dashboard; }
private void btnKaydet_ItemClick(object sender, ItemClickEventArgs e) { DevExpress.DashboardCommon.Dashboard rep = new DevExpress.DashboardCommon.Dashboard(); int iEkleyenID = 0; iEkleyenID = Genel.AktifKullaniciID; DashboardParameter prmUser = new DashboardParameter(); prmUser.Name = "EkleyenID"; prmUser.Type = typeof(System.Int32); prmUser.Value = iEkleyenID; prmUser.Description = "EkleyenID"; prmUser.Visible = false; rep.Parameters.Add(prmUser); MemoryStream stream = new MemoryStream(); rep.SaveToXml(stream); stream.Position = 0; byte[] RaporData = Genel.StreamToByteArray(stream); var IslemEkle = data.IUD_Evraklar(1, -1, RaporData, txtAdi.Text, txtAdi.Text, -1, -1, true, false, -1, -1, true, Genel.AktifKullaniciID).ToList(); if (IslemEkle != null && IslemEkle.FirstOrDefault().ID > 0) { //Ayar.InfoMesajGoster(Genel.DilGetirMesaj(1017), Ayar.MesajTipi.Bilgi, this); } }
public Form1() { InitializeComponent(); Dashboard dashboard = new Dashboard(); dashboard.LoadFromXml(@"..\..\Data\Dashboard.xml"); dashboardViewer1.Dashboard = dashboard; GridDashboardItem grid = (GridDashboardItem)dashboard.Items["gridDashboardItem1"]; GridMeasureColumn extendedPrice = (GridMeasureColumn)grid.Columns[1]; extendedPrice.Measure.UniqueId = "extendedPrice"; DashboardParameter priceParameter = new DashboardParameter(); priceParameter.LookUpSettings = null; priceParameter.Name = "priceParameter"; priceParameter.Type = typeof(decimal); priceParameter.Value = 150000; priceParameter.Description = "Format values that are greater than"; dashboard.Parameters.Add(priceParameter); GridItemFormatRule greaterThanRule = new GridItemFormatRule(extendedPrice); FormatConditionExpression greaterThanCondition = new FormatConditionExpression(); greaterThanCondition.Expression = "extendedPrice > [Parameters.priceParameter]"; greaterThanCondition.StyleSettings = new AppearanceSettings(FormatConditionAppearanceType.PaleGreen); greaterThanRule.ApplyToRow = true; greaterThanRule.Condition = greaterThanCondition; grid.FormatRules.AddRange(greaterThanRule); }
static void AddParamterCopy(DashboardParameter originalParameter, DashboardMerger dashboardMerger, Action <DashboardParameter> addParameterDelegate) { DashboardParameter parameterCopy = (DashboardParameter)originalParameter.Clone(); DashboardParameterCollection toParameters = dashboardMerger.TargetDashboard.Parameters; if (toParameters.Any(p => p.Name == parameterCopy.Name)) { if (ResolveParameterNamesConflict(parameterCopy, originalParameter.Name, dashboardMerger)) { addParameterDelegate(parameterCopy); } } else { addParameterDelegate(parameterCopy); } }
private void AddParameter(Dashboard dashboard) { DashboardParameter myDashboardParameter = new DashboardParameter(); StaticListLookUpSettings staticListLookUpSettings1 = new StaticListLookUpSettings(); myDashboardParameter.AllowMultiselect = true; // Parameter values displayed in the look-up editor. staticListLookUpSettings1.Values = new string[] { "Alabama", "Ohio", "Utah" }; myDashboardParameter.LookUpSettings = staticListLookUpSettings1; myDashboardParameter.Name = "parameterState"; myDashboardParameter.Type = typeof(string); // Default parameter value. myDashboardParameter.Value = new List <string> { "Ohio", "Utah" }; dashboard.Parameters.Add(myDashboardParameter); }
public Form1() { InitializeComponent(); Dashboard dashboard = new Dashboard(); dashboard.LoadFromXml(@"..\..\Data\Dashboard.xml"); // Obtain dashboard items and specify identifiers for data items. GridDashboardItem grid = (GridDashboardItem)dashboard.Items[0]; PieDashboardItem pie = (PieDashboardItem)dashboard.Items[1]; ((GridDimensionColumn)grid.Columns[0]).Dimension.UniqueId = "categoryColumn"; pie.SeriesDimensions[0].UniqueId = "categorySeries"; // Obtain the dashboard data source used to provide parameter values. DashboardSqlDataSource parameterDataSource = (DashboardSqlDataSource)dashboard.DataSources[0]; // Create a new parameter that obtains its values from the Categories query. DynamicListLookUpSettings settings = new DynamicListLookUpSettings(); settings.DataSource = parameterDataSource; settings.DataMember = "Categories"; settings.ValueMember = "CategoryName"; DashboardParameter parameter = new DashboardParameter("categoryParameter", typeof(string), "Beverages", "Select categories:", true, settings); // Enable multi-selection for the created parameter. parameter.AllowMultiselect = true; // Add the created parameter to a collection of dashboard parameters. dashboard.Parameters.Add(parameter); // Include the created parameter in filter strings as an operand value. grid.FilterString = "categoryColumn in (?categoryParameter)"; pie.FilterString = "categorySeries in (?categoryParameter)"; dashboardViewer1.Dashboard = dashboard; }
public static void ApplyValue(this IModelDashboardDataSourceParameter parameter, DashboardParameter dashboardParameter) { if (parameter.IsCustomFunction) { if (dashboardParameter != null) { var criteriaOperator = CriteriaOperator.Parse("Field=" + parameter.ParameterValue); var customFunctionValueProcessor = new CustomFunctionValueProcessor(); customFunctionValueProcessor.Process(criteriaOperator); dashboardParameter.Value = ((OperandValue)((BinaryOperator)criteriaOperator).RightOperand).Value; } } else { var tryToChange = parameter.ParameterValue.TryToChange(dashboardParameter.Type, out var result); if (tryToChange) { dashboardParameter.Value = result; } } }
static bool ResolveParameterNamesConflict(DashboardParameter parameterCopy, string originalName, DashboardMerger dashboardMerger) { // Provide your parameter name confilict resolution logic here parameterCopy.Name = NamesGenerator.GenerateName("RenamedParameter", 1, dashboardMerger.TargetDashboard.Parameters.Select(p => p.Name)); IEnumerable <DataDashboardItem> dataDashboardItems = dashboardMerger.TargetDashboard.Items.Where(item => item is DataDashboardItem).Cast <DataDashboardItem>(); string originalNamePattern = String.Format("?{0}", originalName); string copyNamePattern = String.Format("?{0}", parameterCopy.Name); foreach (DataDashboardItem item in dataDashboardItems) { if (!String.IsNullOrEmpty(item.FilterString) && item.FilterString.Contains(originalNamePattern)) { item.FilterString = item.FilterString.Replace(originalNamePattern, copyNamePattern); } } foreach (IDashboardDataSource dataSource in dashboardMerger.TargetDashboard.DataSources) { UpdateDataSourceParametersNames(dataSource, originalNamePattern, copyNamePattern); } return(true); }
public Form1() { InitializeComponent(); dashboardDesigner1.CreateRibbon(); Dashboard dashboard = new Dashboard(); dashboard.LoadFromXml(@"..\..\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(); dashboardDesigner1.Dashboard = dashboard; }
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()); }
public static void ApplyValue(this IModelDashboardDataSourceParameter parameter, DashboardParameter dashboardParameter){ if (parameter.IsCustomFunction) { if (dashboardParameter!=null) { var criteriaOperator = CriteriaOperator.Parse("Field="+ parameter.ParameterValue); new CustomFunctionValueProcessor().Process(criteriaOperator); dashboardParameter.Value = ((OperandValue) ((BinaryOperator) criteriaOperator).RightOperand).Value; } } else { object result; var tryToChange = parameter.ParameterValue.TryToChange(dashboardParameter.Type, out result); if (tryToChange) dashboardParameter.Value = result; } }