void InitializeDashboardItems()
{
IDashboardDataSource olapDataSource = dashboardDesigner1.Dashboard.DataSources[0];
// PivotDashboardItem pivot = new PivotDashboardItem();
/*pivot.DataSource = olapDataSource;
* pivot.Values.Add(new Measure("[Measures].[Sales Amount]"));
* pivot.Columns.Add(new Dimension("[Sales Channel].[Sales Channel].[Sales Channel]"));
* pivot.Rows.AddRange(
* new Dimension("[Sales Territory].[Sales Territory].[Group]", 1),
* new Dimension("[Sales Territory].[Sales Territory].[Country]", 1),
* new Dimension("[Sales Territory].[Sales Territory].[Region]", 1));
* pivot.AutoExpandRowGroups = true;*/
ChartDashboardItem chart = new ChartDashboardItem();
chart.DataSource = olapDataSource;
chart.Arguments.Add(new Dimension("[Sales Territory].[Sales Territory].[Country]"));
chart.Panes.Add(new ChartPane());
SimpleSeries salesAmountSeries = new SimpleSeries(SimpleSeriesType.Bar);
salesAmountSeries.Value = new Measure("[Measures].[Sales Amount]");
chart.Panes[0].Series.Add(salesAmountSeries);
dashboardDesigner1.Dashboard.Items.AddRange(chart);
}
private RangeFilterDashboardItem CreateRangeFilter(IDashboardDataSource dataSource)
{
RangeFilterDashboardItem rangeFilter = new RangeFilterDashboardItem();
rangeFilter.DataSource = dataSource;
SimpleSeries salesAmountSeries = new SimpleSeries(SimpleSeriesType.Area);
rangeFilter.Series.Add(salesAmountSeries);
salesAmountSeries.Value = new Measure("Extended Price");
rangeFilter.Argument = new Dimension("OrderDate");
rangeFilter.Argument.DateTimeGroupInterval = DateTimeGroupInterval.MonthYear;
rangeFilter.FilterString = "[OrderDate] > #2018-01-01#";
rangeFilter.DateTimePeriods.AddRange(
DateTimePeriod.CreateLastYear(),
DateTimePeriod.CreateNextMonths("Next 3 Months", 3),
new DateTimePeriod
{
Name = "Year To Date",
Start = new FlowDateTimePeriodLimit(DateTimeInterval.Year, 0),
End = new FlowDateTimePeriodLimit(DateTimeInterval.Day, 1)
},
new DateTimePeriod
{
Name = "Jul-18-2018 - Jan-18-2019",
Start = new FixedDateTimePeriodLimit(new DateTime(2018, 7, 18)),
End = new FixedDateTimePeriodLimit(new DateTime(2019, 1, 18))
}
);
rangeFilter.DefaultDateTimePeriodName = "Year To Date";
// The caption is initially hidden. Uncomment the line below to show the caption.
//rangeFilter.ShowCaption = true;
return(rangeFilter);
}
private ChartDashboardItem CreateChart(DashboardObjectDataSource dataSource)
{
// Creates a chart dashboard item and specifies its data source.
ChartDashboardItem chart = new ChartDashboardItem();
chart.DataSource = dataSource;
// Specifies the dimension used to provide data for arguments on a chart.
chart.Arguments.Add(new Dimension("Sales Person", DateTimeGroupInterval.Year));
// Specifies the dimension that provides data for chart series.
chart.SeriesDimensions.Add(new Dimension("OrderDate"));
// Adds a new chart pane to the chart's Panes collection.
chart.Panes.Add(new ChartPane());
// Creates a new series of the Bar type.
SimpleSeries salesAmountSeries = new SimpleSeries(SimpleSeriesType.Bar);
// Specifies the measure that provides data used to calculate
// the Y-coordinate of data points.
salesAmountSeries.Value = new Measure("Extended Price");
// Adds created series to the pane's Series collection to display within this pane.
chart.Panes[0].Series.Add(salesAmountSeries);
chart.Panes.Add(new ChartPane());
SimpleSeries taxesAmountSeries = new SimpleSeries(SimpleSeriesType.StackedBar);
taxesAmountSeries.Value = new Measure("Quantity");
chart.Panes[1].Series.Add(taxesAmountSeries);
return(chart);
}
private Dashboard CreateDashboard()
{
Dashboard dashBoard = new Dashboard();
IDashboardDataSource sqlDataSource = CreateSqlDataSource();
dashBoard.DataSources.Add(sqlDataSource);
ChartDashboardItem chart = new ChartDashboardItem();
chart.DataSource = sqlDataSource; chart.DataMember = "MyQuery";
chart.Arguments.Add(new Dimension("OrderDate", DateTimeGroupInterval.MonthYear));
chart.Panes.Add(new ChartPane());
SimpleSeries salesAmountSeries = new SimpleSeries(SimpleSeriesType.SplineArea);
salesAmountSeries.Value = new Measure("ExtendedPrice");
chart.Panes[0].Series.Add(salesAmountSeries);
GridDashboardItem grid = new GridDashboardItem();
grid.DataSource = sqlDataSource;
grid.DataMember = "MyQuery";
grid.Columns.Add(new GridDimensionColumn(new Dimension("SalesPerson")));
grid.Columns.Add(new GridMeasureColumn(new Measure("ExtendedPrice")));
dashBoard.Items.AddRange(chart, grid);
return(dashBoard);
}
public void InitializeDashboard()
{
Dashboard dashboard = new Dashboard();
DashboardEFDataSource efDataSource = new DashboardEFDataSource();
efDataSource.ConnectionParameters =
new EFConnectionParameters(typeof(OrdersContext));
dashboard.DataSources.Add(efDataSource);
PivotDashboardItem pivot = new PivotDashboardItem();
pivot.DataMember = "Orders";
pivot.DataSource = dashboard.DataSources[0];
pivot.Rows.AddRange(new Dimension("ShipCountry"), new Dimension("ShipCity"));
pivot.Columns.Add(new Dimension("OrderDate"));
pivot.Values.Add(new Measure("Freight"));
ChartDashboardItem chart = new ChartDashboardItem();
chart.DataSource = dashboard.DataSources[0];
chart.DataMember = "Orders";
chart.Arguments.Add(new Dimension("OrderDate", DateTimeGroupInterval.Year));
chart.Panes.Add(new ChartPane());
SimpleSeries freightSeries = new SimpleSeries(SimpleSeriesType.Bar);
freightSeries.Value = new Measure("Freight");
chart.Panes[0].Series.Add(freightSeries);
dashboard.Items.AddRange(pivot, chart);
dashboardViewer1.Dashboard = dashboard;
}
public void InitializeDashboard()
{
Dashboard dashboard = new Dashboard();
DashboardJsonDataSource jsonDataSource = CreateJsonDataSourceFromWeb();
//DashboardJsonDataSource jsonDataSource = CreateJsonDataSourceFromFile();
//DashboardJsonDataSource jsonDataSource = CreateJsonDataSourceFromString();
dashboard.DataSources.Add(jsonDataSource);
PivotDashboardItem pivot = new PivotDashboardItem();
pivot.DataSource = jsonDataSource;
pivot.Rows.Add(new Dimension("ContactTitle"));
pivot.Columns.Add(new Dimension("Country"));
pivot.Values.Add(new Measure("Id", SummaryType.Count));
ChartDashboardItem chart = new ChartDashboardItem();
chart.DataSource = jsonDataSource;
chart.Arguments.Add(new Dimension("Country"));
chart.Panes.Add(new ChartPane());
SimpleSeries theSeries = new SimpleSeries(SimpleSeriesType.Bar);
theSeries.Value = new Measure("Id", SummaryType.Count);
chart.Panes[0].Series.Add(theSeries);
dashboard.Items.AddRange(pivot, chart);
dashboard.RebuildLayout();
dashboard.LayoutRoot.Orientation = DashboardLayoutGroupOrientation.Vertical;
dashboardDesigner1.Dashboard = dashboard;
}
public void AddFormatRulesToBarSeries(ChartDashboardItem chart)
{
SimpleSeries series = chart.Panes[0].Series[0] as SimpleSeries;
ChartItemFormatRule gradientRule = new ChartItemFormatRule(series.Value, series);
FormatConditionRangeGradient condition = new FormatConditionRangeGradient(FormatConditionRangeGradientPredefinedType.RedBlue);
gradientRule.Condition = condition;
gradientRule.ShowInLegend = false;
chart.FormatRules.Add(gradientRule);
}
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);
}
private ChartDashboardItem CreateChart(DashboardExcelDataSource excelDataSource)
{
ChartDashboardItem chart = new ChartDashboardItem();
chart.Name = string.Empty;
chart.ShowCaption = false;
chart.DataSource = excelDataSource;
chart.Arguments.Add(new Dimension("OrderDate", DateTimeGroupInterval.DayMonthYear));
chart.Panes.Add(new ChartPane());
SimpleSeries salesAmountSeries = new SimpleSeries(SimpleSeriesType.Line);
salesAmountSeries.Value = new Measure("Extended Price");
chart.Panes[0].Series.Add(salesAmountSeries);
return(chart);
}
private RangeFilterDashboardItem CreateRangeFilter(IDashboardDataSource dataSource)
{
// Create a Range Filter dashboard item and specify its data source.
RangeFilterDashboardItem rangeFilter = new RangeFilterDashboardItem();
rangeFilter.DataSource = dataSource;
// Create a new series of the Area type and add this series to the Series collection to
// display it within the Range Filter.
SimpleSeries salesAmountSeries = new SimpleSeries(SimpleSeriesType.Area);
rangeFilter.Series.Add(salesAmountSeries);
// Specify a measure to provide data used to calculate the Y-coordinate of the data points.
salesAmountSeries.Value = new Measure("Extended Price");
// Specify a dimension to provide Range Filter argument values.
rangeFilter.Argument = new Dimension("OrderDate");
// Specify a group interval for argument values.
rangeFilter.Argument.DateTimeGroupInterval = DateTimeGroupInterval.MonthYear;
// Restrict the displayed data.
rangeFilter.FilterString = "[OrderDate] > #2018-01-01#";
// Add predefined ranges to the context menu.
// You can show the item caption and use the Select Date Time Periods drop-down button to apply predefined ranges.
rangeFilter.DateTimePeriods.AddRange(
DateTimePeriod.CreateLastYear(),
DateTimePeriod.CreateNextMonths("Next 3 Months", 3),
new DateTimePeriod
{
Name = "Year To Date",
Start = new FlowDateTimePeriodLimit(DateTimeInterval.Year, 0),
End = new FlowDateTimePeriodLimit(DateTimeInterval.Day, 1)
},
new DateTimePeriod
{
Name = "Jul-18-2018 - Jan-18-2019",
Start = new FixedDateTimePeriodLimit(new DateTime(2018, 7, 18)),
End = new FixedDateTimePeriodLimit(new DateTime(2019, 1, 18))
}
);
// Specify the period selected when the control is initialized.
rangeFilter.DefaultDateTimePeriodName = "Year To Date";
// The caption is initially hidden. Uncomment the line to show the caption.
//rangeFilter.ShowCaption = true;
return(rangeFilter);
}
public void AddFormatRulesToLineSeries(ChartDashboardItem chart)
{
SimpleSeries series = chart.Panes[0].Series[0] as SimpleSeries;
ChartItemFormatRule valueRule1 = new ChartItemFormatRule(series.Value, series);
FormatConditionValue valueCondition1 = new FormatConditionValue(DashboardFormatCondition.Greater, 3000);
valueCondition1.StyleSettings = new ColorStyleSettings(Color.Green);
valueRule1.Condition = valueCondition1;
valueRule1.ShowInLegend = true;
valueRule1.DisplayName = "UnitPrice is greater than $3K";
chart.FormatRules.Add(valueRule1);
ChartItemFormatRule valueRule2 = new ChartItemFormatRule(series.Value, series);
FormatConditionValue valueCondition2 = new FormatConditionValue(DashboardFormatCondition.Less, 3000);
valueCondition2.StyleSettings = new ColorStyleSettings(Color.Red);
valueRule2.Condition = valueCondition2;
valueRule2.ShowInLegend = true;
valueRule2.DisplayName = "UnitPrice is less than $3K";
chart.FormatRules.Add(valueRule2);
}
public void InitializeDashboard()
{
Dashboard dashboard = new Dashboard();
DashboardSqlDataSource sqliteDataSource = CreateSQLiteDataSource();
dashboard.DataSources.Add(sqliteDataSource);
DashboardExcelDataSource exceldataSource = CreateExcelDataSource();
dashboard.DataSources.Add(exceldataSource);
DashboardObjectDataSource objectDataSource = CreateObjectDataSource();
dashboard.DataSources.Add(objectDataSource);
DashboardFederationDataSource federatedDS = CreateFederatedDataSource(sqliteDataSource, exceldataSource, objectDataSource);
dashboard.DataSources.Add(federatedDS);
PivotDashboardItem pivot = new PivotDashboardItem();
pivot.DataMember = "FDS-Created-by-NodeBulder";
pivot.DataSource = federatedDS;
pivot.Rows.AddRange(new Dimension("CategoryName"), new Dimension("ProductName"));
pivot.Columns.Add(new Dimension("SalesPerson"));
pivot.Values.Add(new Measure("Extended Price"));
ChartDashboardItem chart = new ChartDashboardItem();
chart.DataSource = federatedDS;
chart.DataMember = "FDS-Created-by-NodeBulder";
chart.Arguments.Add(new Dimension("SalesPerson"));
chart.Panes.Add(new ChartPane());
SimpleSeries theSeries = new SimpleSeries(SimpleSeriesType.Bar);
theSeries.Value = new Measure("Score");
chart.Panes[0].Series.Add(theSeries);
dashboard.Items.AddRange(pivot, chart);
dashboard.RebuildLayout();
dashboard.LayoutRoot.Orientation = DashboardLayoutGroupOrientation.Vertical;
dashboardDesigner1.Dashboard = dashboard;
}
private static Dashboard CreateDashboard(DashboardSqlDataSource dataSource)
{
Dashboard dashboard1 = new Dashboard();
dashboard1.DataSources.Add(dataSource);
ComboBoxDashboardItem comboBox1 = new ComboBoxDashboardItem()
{
Name = "Browser",
DataSource = dataSource,
DataMember = "Statistics",
ComboBoxType = ComboBoxDashboardItemType.Checked
};
comboBox1.FilterDimensions.Add(new Dimension("Browser"));
ListBoxDashboardItem listBox1 = new ListBoxDashboardItem()
{
Name = "Browser Version",
DataSource = dataSource,
DataMember = "Statistics"
};
listBox1.FilterDimensions.Add(new Dimension("BrowserDetails"));
listBox1.InteractivityOptions.IgnoreMasterFilters = false;
TreeViewDashboardItem treeView1 = new TreeViewDashboardItem()
{
Name = "Date",
DataSource = dataSource,
DataMember = "Statistics",
AutoExpandNodes = true
};
treeView1.FilterDimensions.AddRange(new Dimension("Date", DateTimeGroupInterval.Year),
new Dimension("Date", DateTimeGroupInterval.Quarter));
DashboardItemGroup group1 = new DashboardItemGroup()
{
Name = "Filters"
};
group1.InteractivityOptions.IsMasterFilter = true;
dashboard1.Groups.Add(group1);
group1.AddRange(comboBox1, treeView1, listBox1);
ChartDashboardItem chart1 = new ChartDashboardItem()
{
Name = "Browser Statistics",
DataSource = dataSource,
DataMember = "Statistics",
};
chart1.Arguments.Add(new Dimension("Date", DateTimeGroupInterval.MonthYear));
chart1.SeriesDimensions.AddRange(new Dimension("Browser"), new Dimension("BrowserDetails"));
chart1.Panes.Add(new ChartPane());
SimpleSeries salesAmountSeries = new SimpleSeries(SimpleSeriesType.SplineArea);
salesAmountSeries.Value = new Measure("Count");
chart1.Panes[0].Series.Add(salesAmountSeries);
dashboard1.Items.Add(chart1);
return(dashboard1);
}
