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);
        }
Beispiel #2
0
        private void Form1_Load(object sender, EventArgs e)
        {
            // Create a dashboard and display it in the dashboard viewer.
            dashboardViewer1.Dashboard = new Dashboard();

            // Create a data source and add it to the dashboard data source collection.
            DashboardExcelDataSource dataSource = CreateExcelDataSource();

            dashboardViewer1.Dashboard.DataSources.Add(dataSource);

            // Create a Range Filter dashboard item with the specified data source
            // and add it to the Items collection to display within the dashboard.
            RangeFilterDashboardItem rangeFilter = CreateRangeFilter(dataSource);

            dashboardViewer1.Dashboard.Items.Add(rangeFilter);

            // Create a pivot and add it to the dashboard.
            PivotDashboardItem pivot = CreatePivot(dataSource);

            dashboardViewer1.Dashboard.Items.Add(pivot);

            // Create the dashboard layout.
            dashboardViewer1.Dashboard.RebuildLayout();
            dashboardViewer1.Dashboard.LayoutRoot.FindRecursive(rangeFilter).Weight = 20;
            dashboardViewer1.Dashboard.LayoutRoot.FindRecursive(pivot).Weight       = 80;
            dashboardViewer1.Dashboard.LayoutRoot.Orientation = DashboardLayoutGroupOrientation.Vertical;

            dashboardViewer1.ReloadData();
        }
Beispiel #3
0
        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);
        }
        private void Form1_Load(object sender, EventArgs e)
        {
            Dashboard dashboard = new Dashboard();

            DashboardExcelDataSource dataSource = CreateExcelDataSource();

            dashboard.DataSources.Add(dataSource);
            RangeFilterDashboardItem rangeFilter = CreateRangeFilter(dataSource);

            dashboard.Items.Add(rangeFilter);
            PivotDashboardItem pivot = CreatePivot(dataSource);

            dashboard.Items.Add(pivot);

            // Create the dashboard layout.
            dashboard.RebuildLayout();
            dashboard.LayoutRoot.FindRecursive(rangeFilter).Weight = 20;
            dashboard.LayoutRoot.FindRecursive(pivot).Weight       = 80;
            dashboard.LayoutRoot.Orientation = DashboardLayoutGroupOrientation.Vertical;

            dashboardViewer1.Dashboard = dashboard;
            dashboardViewer1.ReloadData();
        }
Beispiel #5
0
    /// <summary>
    /// Required method for Designer support - do not modify
    /// the contents of this method with the code editor.
    /// </summary>
    private void InitializeComponent()
    {
        string resourceFileName = "RequestDashboard.resx";

        DevExpress.DashboardCommon.ChartPane            chartPane1            = new DevExpress.DashboardCommon.ChartPane();
        DevExpress.DashboardCommon.ChartPane            chartPane2            = new DevExpress.DashboardCommon.ChartPane();
        DevExpress.DashboardCommon.ChartPane            chartPane3            = new DevExpress.DashboardCommon.ChartPane();
        DevExpress.DashboardCommon.DashboardLayoutGroup dashboardLayoutGroup1 = new DevExpress.DashboardCommon.DashboardLayoutGroup();
        DevExpress.DashboardCommon.DashboardLayoutGroup dashboardLayoutGroup2 = new DevExpress.DashboardCommon.DashboardLayoutGroup();
        DevExpress.DashboardCommon.DashboardLayoutItem  dashboardLayoutItem1  = new DevExpress.DashboardCommon.DashboardLayoutItem();
        DevExpress.DashboardCommon.DashboardLayoutItem  dashboardLayoutItem2  = new DevExpress.DashboardCommon.DashboardLayoutItem();
        DevExpress.DashboardCommon.DashboardLayoutGroup dashboardLayoutGroup3 = new DevExpress.DashboardCommon.DashboardLayoutGroup();
        DevExpress.DashboardCommon.DashboardLayoutItem  dashboardLayoutItem3  = new DevExpress.DashboardCommon.DashboardLayoutItem();
        DevExpress.DashboardCommon.DashboardLayoutItem  dashboardLayoutItem4  = new DevExpress.DashboardCommon.DashboardLayoutItem();
        DevExpress.DashboardCommon.DashboardLayoutItem  dashboardLayoutItem5  = new DevExpress.DashboardCommon.DashboardLayoutItem();
        this.chartDashboardItem1       = new DevExpress.DashboardCommon.ChartDashboardItem();
        this.chartDashboardItem2       = new DevExpress.DashboardCommon.ChartDashboardItem();
        this.pieDashboardItem1         = new DevExpress.DashboardCommon.PieDashboardItem();
        this.chartDashboardItem3       = new DevExpress.DashboardCommon.ChartDashboardItem();
        this.rangeFilterDashboardItem1 = new DevExpress.DashboardCommon.RangeFilterDashboardItem();
        ((System.ComponentModel.ISupportInitialize)(this.chartDashboardItem1)).BeginInit();
        ((System.ComponentModel.ISupportInitialize)(this.chartDashboardItem2)).BeginInit();
        ((System.ComponentModel.ISupportInitialize)(this.pieDashboardItem1)).BeginInit();
        ((System.ComponentModel.ISupportInitialize)(this.chartDashboardItem3)).BeginInit();
        ((System.ComponentModel.ISupportInitialize)(this.rangeFilterDashboardItem1)).BeginInit();
        ((System.ComponentModel.ISupportInitialize)(this)).BeginInit();
        //
        // chartDashboardItem1
        //
        this.chartDashboardItem1.AxisX.TitleVisible = false;
        this.chartDashboardItem1.ComponentName      = "chartDashboardItem1";
        this.chartDashboardItem1.DataItemRepository.Clear();
        this.chartDashboardItem1.InteractivityOptions.IgnoreMasterFilters = false;
        this.chartDashboardItem1.Name = "Chart 1";
        chartPane1.Name = "Pane 1";
        chartPane1.PrimaryAxisY.ShowGridLines   = true;
        chartPane1.PrimaryAxisY.TitleVisible    = true;
        chartPane1.SecondaryAxisY.ShowGridLines = false;
        chartPane1.SecondaryAxisY.TitleVisible  = true;
        this.chartDashboardItem1.Panes.AddRange(new DevExpress.DashboardCommon.ChartPane[] {
            chartPane1
        });
        this.chartDashboardItem1.ShowCaption = true;
        //
        // chartDashboardItem2
        //
        this.chartDashboardItem2.AxisX.TitleVisible = false;
        this.chartDashboardItem2.ComponentName      = "chartDashboardItem2";
        this.chartDashboardItem2.DataItemRepository.Clear();
        this.chartDashboardItem2.InteractivityOptions.IgnoreMasterFilters = false;
        this.chartDashboardItem2.Name = "Chart 2";
        chartPane2.Name = "Pane 1";
        chartPane2.PrimaryAxisY.ShowGridLines   = true;
        chartPane2.PrimaryAxisY.TitleVisible    = true;
        chartPane2.SecondaryAxisY.ShowGridLines = false;
        chartPane2.SecondaryAxisY.TitleVisible  = true;
        this.chartDashboardItem2.Panes.AddRange(new DevExpress.DashboardCommon.ChartPane[] {
            chartPane2
        });
        this.chartDashboardItem2.ShowCaption = true;
        //
        // pieDashboardItem1
        //
        this.pieDashboardItem1.ComponentName = "pieDashboardItem1";
        this.pieDashboardItem1.DataItemRepository.Clear();
        this.pieDashboardItem1.InteractivityOptions.IgnoreMasterFilters = false;
        this.pieDashboardItem1.Name        = "Pies 1";
        this.pieDashboardItem1.ShowCaption = true;
        //
        // chartDashboardItem3
        //
        this.chartDashboardItem3.AxisX.TitleVisible = false;
        this.chartDashboardItem3.ComponentName      = "chartDashboardItem3";
        this.chartDashboardItem3.DataItemRepository.Clear();
        this.chartDashboardItem3.InteractivityOptions.IgnoreMasterFilters = false;
        this.chartDashboardItem3.Name = "Chart 3";
        chartPane3.Name = "Pane 1";
        chartPane3.PrimaryAxisY.ShowGridLines   = true;
        chartPane3.PrimaryAxisY.TitleVisible    = true;
        chartPane3.SecondaryAxisY.ShowGridLines = false;
        chartPane3.SecondaryAxisY.TitleVisible  = true;
        this.chartDashboardItem3.Panes.AddRange(new DevExpress.DashboardCommon.ChartPane[] {
            chartPane3
        });
        this.chartDashboardItem3.ShowCaption = true;
        //
        // rangeFilterDashboardItem1
        //
        this.rangeFilterDashboardItem1.ComponentName = "rangeFilterDashboardItem1";
        this.rangeFilterDashboardItem1.DataItemRepository.Clear();
        this.rangeFilterDashboardItem1.InteractivityOptions.IgnoreMasterFilters = true;
        this.rangeFilterDashboardItem1.Name        = "Range Filter 1";
        this.rangeFilterDashboardItem1.ShowCaption = false;
        //
        // RequestDashboard
        //
        this.Items.AddRange(new DevExpress.DashboardCommon.DashboardItem[] {
            this.chartDashboardItem1,
            this.chartDashboardItem2,
            this.pieDashboardItem1,
            this.chartDashboardItem3,
            this.rangeFilterDashboardItem1
        });
        dashboardLayoutItem1.DashboardItem = this.chartDashboardItem1;
        dashboardLayoutItem1.Weight        = 42.533185840707965D;
        dashboardLayoutItem2.DashboardItem = this.chartDashboardItem2;
        dashboardLayoutItem2.Weight        = 57.466814159292035D;
        dashboardLayoutGroup2.ChildNodes.AddRange(new DevExpress.DashboardCommon.DashboardLayoutNode[] {
            dashboardLayoutItem1,
            dashboardLayoutItem2
        });
        dashboardLayoutGroup2.DashboardItem = null;
        dashboardLayoutGroup2.Weight        = 50.0503524672709D;
        dashboardLayoutItem3.DashboardItem  = this.pieDashboardItem1;
        dashboardLayoutItem3.Weight         = 27.876106194690266D;
        dashboardLayoutItem4.DashboardItem  = this.chartDashboardItem3;
        dashboardLayoutItem4.Weight         = 72.123893805309734D;
        dashboardLayoutGroup3.ChildNodes.AddRange(new DevExpress.DashboardCommon.DashboardLayoutNode[] {
            dashboardLayoutItem3,
            dashboardLayoutItem4
        });
        dashboardLayoutGroup3.DashboardItem = null;
        dashboardLayoutGroup3.Weight        = 24.974823766364551D;
        dashboardLayoutItem5.DashboardItem  = this.rangeFilterDashboardItem1;
        dashboardLayoutItem5.Weight         = 24.974823766364551D;
        dashboardLayoutGroup1.ChildNodes.AddRange(new DevExpress.DashboardCommon.DashboardLayoutNode[] {
            dashboardLayoutGroup2,
            dashboardLayoutGroup3,
            dashboardLayoutItem5
        });
        dashboardLayoutGroup1.DashboardItem = null;
        dashboardLayoutGroup1.Orientation   = DevExpress.DashboardCommon.DashboardLayoutGroupOrientation.Vertical;
        this.LayoutRoot = dashboardLayoutGroup1;
        this.Title.ImageDataSerializable = "";
        this.Title.Text = "Dashboard";
        ((System.ComponentModel.ISupportInitialize)(this.chartDashboardItem1)).EndInit();
        ((System.ComponentModel.ISupportInitialize)(this.chartDashboardItem2)).EndInit();
        ((System.ComponentModel.ISupportInitialize)(this.pieDashboardItem1)).EndInit();
        ((System.ComponentModel.ISupportInitialize)(this.chartDashboardItem3)).EndInit();
        ((System.ComponentModel.ISupportInitialize)(this.rangeFilterDashboardItem1)).EndInit();
        ((System.ComponentModel.ISupportInitialize)(this)).EndInit();
    }