How to: Apply Master Filtering in DashboardViewer

• Mar 31, 2018
• 2 minutes to read

The following example demonstrates how to apply filtering for dashboard items that act as a master filter.

In this example, the DashboardViewer.SetMasterFilter method is used to select the required rows in the Grid dashboard item. To select the required range in the Range Filter dashboard item, the DashboardViewer.SetRange method is used.

Note

A complete sample project is available at https://github.com/DevExpress-Examples/how-to-apply-master-filtering-in-dashboardviewer-e5097.

Form1.cs

using System;
using System.Collections.Generic;
using System.Windows.Forms;
using System.Collections;
using DevExpress.DashboardCommon;

namespace Dashboard_SetMasterFilter {
    public partial class Form1 : Form {
        public Form1() {
            InitializeComponent();
            // Loads a dashboard from an XML file.
            dashboardViewer1.LoadDashboard(@"..\..\Data\Dashboard.xml");

            // Creates a list with values to be selected in the Grid dashboard item.
            List<object> rowValues1 = new List<object>();
            rowValues1.AddRange(new[] { "UK", "Anne Dodsworth" } );
            List<object> rowValues2 = new List<object>();
            rowValues2.AddRange(new[] { "USA", "Andrew Fuller" } );
            List<IList> selectedRows = new List<IList>( new[] {rowValues1, rowValues2} );

            // Creates a range with specified minimum and maximum values.
            DateTime minimumValue = new DateTime(1995, 3, 1);
            DateTime maximumValue = new DateTime(1995, 10, 1);
            RangeFilterSelection selectedRange = new RangeFilterSelection(minimumValue, maximumValue);

            // Selects specified values in the Grid dashboard item.
            dashboardViewer1.SetMasterFilter("gridDashboardItem1", selectedRows);
            // Selects a specified range in the Range Filter dashboard item.
            dashboardViewer1.SetRange("rangeFilterDashboardItem1", selectedRange);
        }
    }
}

Form1.vb

Imports Microsoft.VisualBasic
Imports System
Imports System.Collections.Generic
Imports System.Windows.Forms
Imports System.Collections
Imports DevExpress.DashboardCommon

Namespace Dashboard_SetMasterFilter
    Partial Public Class Form1
        Inherits Form
        Public Sub New()
            InitializeComponent()
            ' Loads a dashboard from an XML file.
            dashboardViewer1.LoadDashboard("..\..\Data\Dashboard.xml")

            ' Creates a list with values to be selected in the Grid dashboard item.
            Dim rowValues1 As New List(Of Object)()
            rowValues1.AddRange(New String() { "UK", "Anne Dodsworth" })
            Dim rowValues2 As New List(Of Object)()
            rowValues2.AddRange(New String() { "USA", "Andrew Fuller" })
            Dim selectedRows As New List(Of IList)(New IList() {rowValues1, rowValues2})


            ' Creates a range with specified minimum and maximum values.
            Dim minimumValue As New DateTime(1995, 3, 1)
            Dim maximumValue As New DateTime(1995, 10, 1)
            Dim selectedRange As New RangeFilterSelection(minimumValue, maximumValue)

            ' Selects specified values in the Grid dashboard item.
            dashboardViewer1.SetMasterFilter("gridDashboardItem1", selectedRows)
            ' Selects a specified range in the Range Filter dashboard item.
            dashboardViewer1.SetRange("rangeFilterDashboardItem1", selectedRange)
        End Sub
    End Class
End Namespace