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