public static DashboardItem GenerateListBoxItem(IDashboardDataSource dataSource, string itemComponentName) { ListBoxDashboardItem listBoxItem = new ListBoxDashboardItem() { ComponentName = itemComponentName }; listBoxItem.Name = "Countries"; listBoxItem.DataSource = dataSource; listBoxItem.FilterDimensions.Add(new Dimension("Country")); listBoxItem.InteractivityOptions.IgnoreMasterFilters = false; return(listBoxItem); }
public Form1() { InitializeComponent(); Dashboard dashboard = new Dashboard(); XmlFileConnectionParameters xmlParams = new XmlFileConnectionParameters(); xmlParams.FileName = @"..\..\Data\DashboardProductDetails.xml"; DashboardSqlDataSource xmlDataSource = new DashboardSqlDataSource("Data Source 1", xmlParams); SelectQuery selectQuery = SelectQueryFluentBuilder .AddTable("Products") .SelectColumns("Id", "Name", "Description") .Build("Query 1"); xmlDataSource.Queries.Add(selectQuery); xmlDataSource.Fill(); dashboard.DataSources.Add(xmlDataSource); BoundImageDashboardItem boundImage = new BoundImageDashboardItem(); boundImage.DataSource = xmlDataSource; boundImage.DataMember = "Query 1"; boundImage.DataBindingMode = ImageDataBindingMode.Uri; boundImage.ImageDimension = new Dimension("Name"); boundImage.UriPattern = @"..\..\ProductDetailsImages\{0}.jpg"; boundImage.SizeMode = ImageSizeMode.Stretch; ListBoxDashboardItem comboBox = new ListBoxDashboardItem(); comboBox.ShowCaption = false; comboBox.DataSource = xmlDataSource; comboBox.DataMember = "Query 1"; comboBox.FilterDimensions.Add(new Dimension("Name")); comboBox.ListBoxType = ListBoxDashboardItemType.Radio; comboBox.ShowAllValue = false; dashboard.Items.AddRange(comboBox, boundImage); dashboardViewer1.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); }