public static DashboardItem GenerateCardItem(IDashboardDataSource dataSource, string itemComponentName) { CardDashboardItem cardItem = new CardDashboardItem() { ComponentName = itemComponentName }; cardItem.SeriesDimensions.Add(new Dimension("Country")); cardItem.SparklineArgument = new Dimension("SalesDate", DateTimeGroupInterval.DayMonthYear); cardItem.DataSource = dataSource; cardItem.ShowCaption = false; Measure actualValue = new Measure("Sales"); actualValue.NumericFormat.FormatType = DataItemNumericFormatType.Currency; Measure targetValue = new Measure("SalesTarget"); targetValue.NumericFormat.FormatType = DataItemNumericFormatType.Currency; Card card = new Card(actualValue, targetValue); card.LayoutTemplate = new CardCompactLayoutTemplate(); cardItem.Cards.Add(card); return(cardItem); }
private Dashboard CreateDashboard() { Dashboard dBoard = new Dashboard(); OlapConnectionParameters olapParams = new OlapConnectionParameters(); olapParams.ConnectionString = @"provider=MSOLAP; data source=http://demos.devexpress.com/Services/OLAP/msmdpump.dll; initial catalog=Adventure Works DW Standard Edition; cube name=Adventure Works;"; DashboardOlapDataSource olapDataSource = new DashboardOlapDataSource(olapParams); dBoard.DataSources.Add(olapDataSource); CardDashboardItem cardItem = new CardDashboardItem(); cardItem.DataSource = olapDataSource; cardItem.SeriesDimensions.Add(new Dimension("[Sales Territory].[Sales Territory Country].[Sales Territory Country]")); cardItem.SparklineArgument = new Dimension("[Date].[Month of Year].[Month of Year]", DateTimeGroupInterval.MonthYear); Card card = new Card(); card.LayoutTemplate = new CardStretchedLayoutTemplate(); card.ActualValue = new Measure("[Measures].[Internet Sales Amount]"); card.TargetValue = new Measure("[Measures].[Sales Amount]"); cardItem.Cards.Add(card); ChartDashboardItem chartItem = new ChartDashboardItem(); chartItem.DataSource = olapDataSource; chartItem.Arguments.Add(new Dimension("[Sales Territory].[Sales Territory].[Country]")); chartItem.Panes.Add(new ChartPane()); SimpleSeries salesAmountSeries = new SimpleSeries(SimpleSeriesType.Bar); salesAmountSeries.Value = new Measure("[Measures].[Sales Amount]"); chartItem.Panes[0].Series.Add(salesAmountSeries); SimpleSeries salesInernetAmountSeries = new SimpleSeries(SimpleSeriesType.Bar); salesInernetAmountSeries.Value = new Measure("[Measures].[Internet Sales Amount]"); chartItem.Panes[0].Series.Add(salesInernetAmountSeries); dBoard.Items.AddRange(cardItem, chartItem); DashboardLayoutItem cardLayoutItem = new DashboardLayoutItem(cardItem); DashboardLayoutItem chartLayoutItem = new DashboardLayoutItem(chartItem); DashboardLayoutGroup rootGroup = new DashboardLayoutGroup(DashboardLayoutGroupOrientation.Vertical, 50D, cardLayoutItem, chartLayoutItem); dBoard.LayoutRoot = rootGroup; return(dBoard); }
public Form1() { InitializeComponent(); dashboardDesigner1.CreateRibbon(); Dashboard dashboard = new Dashboard(); DashboardObjectDataSource salesDataSource = CreateDataSource(); dashboard.DataSources.Add(salesDataSource); CardDashboardItem cardItem = new CardDashboardItem(); CreateCards(cardItem, salesDataSource); dashboard.Items.Add(cardItem); dashboardDesigner1.Dashboard = dashboard; }
public Form1() { InitializeComponent(); dashboardDesigner1.DataSourceOptions.ObjectDataSourceLoadingBehavior = DevExpress.DataAccess.DocumentLoadingBehavior.LoadAsIs; dashboardDesigner1.CreateRibbon(); Dashboard dashboard = new Dashboard(); DashboardObjectDataSource salesDataSource = CreateDataSource(); dashboard.DataSources.Add(salesDataSource); CardDashboardItem cardItem = new CardDashboardItem(); CreateCards(cardItem, salesDataSource); dashboard.Items.Add(cardItem); dashboardDesigner1.Dashboard = dashboard; }
private void CreateCards(CardDashboardItem cardItem, DashboardObjectDataSource salesDataSource) { cardItem.DataSource = salesDataSource; Card card = new Card(); card.ActualValue = new Measure("Sales", SummaryType.Sum); card.TargetValue = new Measure("SalesTarget", SummaryType.Sum); cardItem.SeriesDimensions.Add(new Dimension("State")); cardItem.SparklineArgument = new Dimension("CurrentDate", DateTimeGroupInterval.MonthYear); CardCustomLayoutTemplate customTemplate = new CardCustomLayoutTemplate(); CardRow row1 = new CardRow(); CardRowDataElement dimensionValue_row1 = new CardRowDataElement(CardRowDataElementType.DimensionValue, 0, CardHorizontalAlignment.Left, 14, System.Drawing.Color.DarkBlue); CardRowIndicatorElement deltaIndicator_row1 = new CardRowIndicatorElement(CardHorizontalAlignment.Right, 22); row1.Elements.AddRange(dimensionValue_row1, deltaIndicator_row1); CardRow row2 = new CardRow(); CardRowTextElement staticText_row2 = new CardRowTextElement("Sales: ", CardHorizontalAlignment.Left, 12, CardPredefinedColor.Neutral); CardRowDataElement salesValue_row2 = new CardRowDataElement(CardRowDataElementType.ActualValue, CardHorizontalAlignment.Left, 12, CardPredefinedColor.Main); row2.Elements.AddRange(staticText_row2, salesValue_row2); CardRow row3 = new CardRow(); CardRowTextElement staticText_row3 = new CardRowTextElement("Target: ", CardHorizontalAlignment.Left, 12, CardPredefinedColor.Neutral); CardRowDataElement salesValue_row3 = new CardRowDataElement(CardRowDataElementType.TargetValue, CardHorizontalAlignment.Left, 12, CardPredefinedColor.Main); row3.Indent = 30; row3.Elements.AddRange(staticText_row3, salesValue_row3); CardSparklineRow row4 = new CardSparklineRow(); row4.VerticalAlignment = CardVerticalAlignment.Bottom; customTemplate.Layout = new CardLayout(); customTemplate.Layout.Rows.AddRange(row1, row2, row3, row4); card.LayoutTemplate = customTemplate; cardItem.Cards.Add(card); }
public ViewerForm1() { InitializeComponent(); dashboardViewer.Dashboard = new Dashboard(); // Creates a data source and adds it to the dashboard data source collection. DashboardExcelDataSource excelDataSource = new DashboardExcelDataSource(); excelDataSource = CreateExcelDataSource(); dashboardViewer.Dashboard.DataSources.Add(excelDataSource); // Creates a card dashboard item with the specified data source // and adds it to the Items collection to display within the dashboard. CardDashboardItem cards = CreateCards(excelDataSource); dashboardViewer.Dashboard.Items.Add(cards); // Reloads data in the data sources. dashboardViewer.ReloadData(); }
private CardDashboardItem CreateCards(DashboardExcelDataSource dataSource) { // Creates a card dashboard item and specifies its data source. CardDashboardItem cards = new CardDashboardItem(); cards.DataSource = dataSource; // Creates the Card object with measures that provide data for calculating actual and target // values, and then adds this object to the Cards collection of the card dashboard item. Card card = new Card(); card.ActualValue = new Measure("RevenueQTD (Sum)"); card.TargetValue = new Measure("RevenueQTDTarget (Sum)"); cards.Cards.Add(card); // Specifies dimensions that provides data for a card dashboard item series. cards.SeriesDimensions.Add(new Dimension("Category")); cards.SeriesDimensions.Add(new Dimension("Product")); cards.InteractivityOptions.IsDrillDownEnabled = true; return(cards); }
Dashboard CreateDashboardWithCards() { Dashboard dashboard = new Dashboard(); dashboard.Title.Text = "Card Custom Template"; dashboard.CurrencyCultureName = "en-US"; DashboardObjectDataSource dataSource = new DashboardObjectDataSource(); dashboardViewer1.AsyncDataLoading += (s, ev) => { ev.Data = DataGenerator.GenerateTestData(); }; dashboard.DataSources.Add(dataSource); CardDashboardItem cardItem = new CardDashboardItem(); cardItem.SeriesDimensions.Add(new Dimension("Country")); cardItem.SparklineArgument = new Dimension("SalesDate", DateTimeGroupInterval.DayMonthYear); cardItem.DataSource = dataSource; cardItem.ShowCaption = false; dashboard.Items.Add(cardItem); Measure actualValue = new Measure("Sales"); actualValue.NumericFormat.FormatType = DataItemNumericFormatType.Currency; Measure targetValue = new Measure("SalesTarget"); targetValue.NumericFormat.FormatType = DataItemNumericFormatType.Currency; Card card = new Card(actualValue, targetValue) { LayoutTemplate = CreateCustomCardLayoutTemplate() }; cardItem.Cards.Add(card); return(dashboard); }