PIVOT GRID Archives - icodebroker

[C#/WINFORM/DEVEXPRESS] PivotGridOptionsData 클래스 : CustomObjectConverter 속성을 사용해 객체 직렬화 커스텀 설정하기

■ PivotGridOptionsData 클래스의 CustomObjectConverter 속성을 사용해 객체 직렬화를 커스텀 설정하는 방법을 보여준다. ▶ CustomObjectConverter.cs


using System;

using DevExpress.Utils.Serializing.Helpers;

namespace TestProject
{
    /// <summary>
    /// 커스텀 객체 컨버터
    /// </summary>
    public class CustomObjectConverter : ICustomObjectConverter
    {
        //////////////////////////////////////////////////////////////////////////////////////////////////// Method
        ////////////////////////////////////////////////////////////////////////////////////////// Public

        #region 변환 가능 여부 구하기 - CanConvert(type)

        /// <summary>
        /// 변환 가능 여부 구하기
        /// </summary>
        /// <param name="type">타입</param>
        /// <returns>변환 가능 여부</returns>
        public bool CanConvert(Type type)
        {
            return type == typeof(Employee);
        }

        #endregion
        #region 문자열에서 객체 구하기 - FromString(type, source)

        /// <summary>
        /// 문자열에서 객체 구하기
        /// </summary>
        /// <param name="type">타입</param>
        /// <param name="source">소스</param>
        /// <returns>객체</returns>
        public object FromString(Type type, string source)
        {
            if(type != typeof(Employee))
            {
                return null;
            }

            string[] itemArray = source.Split('#');

            if(itemArray.Length >= 3)
            {
                return new Employee(itemArray[0], itemArray[1], int.Parse(itemArray[2]));
            }
            else if(itemArray.Length == 2)
            {
                return new Employee(itemArray[0], itemArray[1], 0);
            }
            else if(itemArray.Length == 1)
            {
                return new Employee(itemArray[0], string.Empty, 0);
            }
            else
            {
                return new Employee(string.Empty, string.Empty, 0);
            }
        }

        #endregion
        #region 문자열 구하기 - ToString(type, source)

        /// <summary>
        /// 문자열 구하기
        /// </summary>
        /// <param name="type">타입</param>
        /// <param name="source">소스</param>
        /// <returns>문자열</returns>
        public string ToString(Type type, object source)
        {
            if(type != typeof(Employee))
            {
                return string.Empty;
            }

            Employee employee = source as Employee;

            return employee.FirstName + '#' + employee.LastName + '#' + employee.Age;
        }

        #endregion
        #region 타입 구하기 - GetType(typeName)

        /// <summary>
        /// 타입 구하기
        /// </summary>
        /// <param name="typeName">타입명</param>
        /// <returns>타입</returns>
        public Type GetType(string typeName)
        {
            if(typeName != typeof(Employee).FullName)
            {
                return null;
            }

            return typeof(Employee);
        }

        #endregion
    }
}

100

101

102

103

104

105

106

using System;

using DevExpress.Utils.Serializing.Helpers;

namespace TestProject

{

/// <summary>

/// 커스텀 객체 컨버터

/// </summary>

public class CustomObjectConverter : ICustomObjectConverter

{

//////////////////////////////////////////////////////////////////////////////////////////////////// Method

////////////////////////////////////////////////////////////////////////////////////////// Public

#region 변환 가능 여부 구하기 - CanConvert(type)

/// <summary>

/// 변환 가능 여부 구하기

/// </summary>

/// <param name="type">타입</param>

/// <returns>변환 가능 여부</returns>

public bool CanConvert(Type type)

{

return type == typeof(Employee);

}

#endregion

#region 문자열에서 객체 구하기 - FromString(type, source)

/// <summary>

/// 문자열에서 객체 구하기

/// </summary>

/// <param name="type">타입</param>

/// <param name="source">소스</param>

/// <returns>객체</returns>

public object FromString(Type type, string source)

{

if(type != typeof(Employee))

{

return null;

}

string[] itemArray = source.Split('#');

if(itemArray.Length >= 3)

{

return new Employee(itemArray[0], itemArray[1], int.Parse(itemArray[2]));

}

else if(itemArray.Length == 2)

{

return new Employee(itemArray[0], itemArray[1], 0);

}

else if(itemArray.Length == 1)

{

return new Employee(itemArray[0], string.Empty, 0);

}

else

{

return new Employee(string.Empty, string.Empty, 0);

}

#endregion

#region 문자열 구하기 - ToString(type, source)

/// <summary>

/// 문자열 구하기

/// </summary>

/// <param name="type">타입</param>

/// <param name="source">소스</param>

/// <returns>문자열</returns>

public string ToString(Type type, object source)

{

if(type != typeof(Employee))

{

return string.Empty;

}

Employee employee = source as Employee;

return employee.FirstName + '#' + employee.LastName + '#' + employee.Age;

}

#endregion

#region 타입 구하기 - GetType(typeName)

/// <summary>

/// 타입 구하기

/// </summary>

/// <param name="typeName">타입명</param>

/// <returns>타입</returns>

public Type GetType(string typeName)

{

if(typeName != typeof(Employee).FullName)

{

return null;

}

return typeof(Employee);

}

#endregion

}

▶ MainForm.cs


using System;
using System.IO;

using DevExpress.XtraEditors;
using DevExpress.Data.PivotGrid;

namespace TestProject
{
    /// <summary>
    /// 메인 폼
    /// </summary>
    public partial class MainForm : XtraForm
    {
        //////////////////////////////////////////////////////////////////////////////////////////////////// Field
        ////////////////////////////////////////////////////////////////////////////////////////// Private

        #region Field

        /// <summary>
        /// 스트림
        /// </summary>
        private MemoryStream stream;

        #endregion

        //////////////////////////////////////////////////////////////////////////////////////////////////// Constructor
        ////////////////////////////////////////////////////////////////////////////////////////// Public

        #region 생성자 - MainForm()

        /// <summary>
        /// 생성자
        /// </summary>
        public MainForm()
        {
            InitializeComponent();

            this.pivotGridControl.DataSource = Employee.GetDataTable();

            this.pivotGridControl.OptionsData.CustomObjectConverter = new CustomObjectConverter();

            this.saveButton.Click += saveButton_Click;
            this.loadButton.Click += loadButton_Click;
        }

        #endregion

        //////////////////////////////////////////////////////////////////////////////////////////////////// Method
        ////////////////////////////////////////////////////////////////////////////////////////// Private

        #region Save 버튼 클릭시 처리하기 - saveButton_Click(sender, e)

        /// <summary>
        /// Save 버튼 클릭시 처리하기
        /// </summary>
        /// <param name="sender">이벤트 발생자</param>
        /// <param name="e">이벤트 인자</param>
        private void saveButton_Click(object sender, EventArgs e)
        {
            if(this.stream != null)
            {
                this.stream.Dispose();
            }

            this.stream = new MemoryStream();

            this.pivotGridControl.SavePivotGridToStream(stream);
        }

        #endregion
        #region Load 버튼 클릭시 처리하기 - loadButton_Click(sender, e)

        /// <summary>
        /// Load 버튼 클릭시 처리하기
        /// </summary>
        /// <param name="sender">이벤트 발생자</param>
        /// <param name="e">이벤트 인자</param>
        private void loadButton_Click(object sender, EventArgs e)
        {
            if(this.stream == null)
            {
                return;
            }

            PivotFileDataSource dataSource = new PivotFileDataSource(this.stream, new CustomObjectConverter());

            this.pivotGridControl.DataSource = dataSource;
        }

        #endregion
    }
}

using System;

using System.IO;

using DevExpress.XtraEditors;

using DevExpress.Data.PivotGrid;

namespace TestProject

{

/// <summary>

/// 메인 폼

/// </summary>

public partial class MainForm : XtraForm

{

//////////////////////////////////////////////////////////////////////////////////////////////////// Field

////////////////////////////////////////////////////////////////////////////////////////// Private

#region Field

/// <summary>

/// 스트림

/// </summary>

private MemoryStream stream;

#endregion

//////////////////////////////////////////////////////////////////////////////////////////////////// Constructor

////////////////////////////////////////////////////////////////////////////////////////// Public

#region 생성자 - MainForm()

/// <summary>

/// 생성자

/// </summary>

public MainForm()

{

InitializeComponent();

this.pivotGridControl.DataSource = Employee.GetDataTable();

this.pivotGridControl.OptionsData.CustomObjectConverter = new CustomObjectConverter();

this.saveButton.Click += saveButton_Click;

this.loadButton.Click += loadButton_Click;

}

#endregion

//////////////////////////////////////////////////////////////////////////////////////////////////// Method

////////////////////////////////////////////////////////////////////////////////////////// Private

#region Save 버튼 클릭시 처리하기 - saveButton_Click(sender, e)

/// <summary>

/// Save 버튼 클릭시 처리하기

/// </summary>

/// <param name="sender">이벤트 발생자</param>

/// <param name="e">이벤트 인자</param>

private void saveButton_Click(object sender, EventArgs e)

{

if(this.stream != null)

{

this.stream.Dispose();

}

this.stream = new MemoryStream();

this.pivotGridControl.SavePivotGridToStream(stream);

}

#endregion

#region Load 버튼 클릭시 처리하기 - loadButton_Click(sender, e)

/// <summary>

/// Load 버튼 클릭시 처리하기

/// </summary>

/// <param name="sender">이벤트 발생자</param>

/// <param name="e">이벤트 인자</param>

private void loadButton_Click(object sender, EventArgs e)

{

if(this.stream == null)

{

return;

}

PivotFileDataSource dataSource = new PivotFileDataSource(this.stream, new CustomObjectConverter());

this.pivotGridControl.DataSource = dataSource;

}

#endregion

}

TestProject.zip

[C#/WINFORM/DEVEXPRESS] PivotGridLocalizer 클래스 : Active 정적 속성을 사용해 불필요한 텍스트 숨기기

■ PivotGridLocalizer 클래스의 Active 정적 속성을 사용해 불필요한 텍스트를 숨기는 방법을 보여준다. ▶ CustomLocalizer.cs


using System;

using DevExpress.XtraPivotGrid.Localization;

namespace TestProject
{
    /// <summary>
    /// 커스텀 로컬라이저
    /// </summary>
    public class CustomLocalizer : PivotGridResLocalizer
    {
        //////////////////////////////////////////////////////////////////////////////////////////////////// Method
        ////////////////////////////////////////////////////////////////////////////////////////// Public

        #region 지역화 문자열 구하기 - GetLocalizedString(id)

        /// <summary>
        /// 지역화 문자열 구하기
        /// </summary>
        /// <param name="id">ID</param>
        /// <returns>지역화 문자열</returns>
        public override string GetLocalizedString(PivotGridStringId id)
        {
            if
            (
                id == PivotGridStringId.DataHeadersCustomization   ||
                id == PivotGridStringId.ColumnHeadersCustomization ||
                id == PivotGridStringId.FilterHeadersCustomization
            )
            {
                return String.Empty;
            }

            return base.GetLocalizedString(id);
        }

        #endregion
    }
}

using System;

using DevExpress.XtraPivotGrid.Localization;

namespace TestProject

{

/// <summary>

/// 커스텀 로컬라이저

/// </summary>

public class CustomLocalizer : PivotGridResLocalizer

{

//////////////////////////////////////////////////////////////////////////////////////////////////// Method

////////////////////////////////////////////////////////////////////////////////////////// Public

#region 지역화 문자열 구하기 - GetLocalizedString(id)

/// <summary>

/// 지역화 문자열 구하기

/// </summary>

/// <param name="id">ID</param>

/// <returns>지역화 문자열</returns>

public override string GetLocalizedString(PivotGridStringId id)

{

(

id == PivotGridStringId.DataHeadersCustomization ||

id == PivotGridStringId.ColumnHeadersCustomization ||

id == PivotGridStringId.FilterHeadersCustomization

)

{

return String.Empty;

}

return base.GetLocalizedString(id);

}

#endregion

}

▶ MainForm.cs


using System;
using System.Data;
using System.Drawing;

using DevExpress.XtraEditors;
using DevExpress.XtraPivotGrid;
using DevExpress.XtraPivotGrid.Localization;

namespace TestProject
{
    /// <summary>
    /// 메인 폼
    /// </summary>
    public partial class MainForm : XtraForm
    {
        //////////////////////////////////////////////////////////////////////////////////////////////////// Constructor
        ////////////////////////////////////////////////////////////////////////////////////////// Public

        #region 생성자 - MainForm()

        /// <summary>
        /// 생성자
        /// </summary>
        public MainForm()
        {
            PivotGridLocalizer.Active = new CustomLocalizer();

            InitializeComponent();

            Load += Form_Load;
        }

        #endregion

        //////////////////////////////////////////////////////////////////////////////////////////////////// Method
        ////////////////////////////////////////////////////////////////////////////////////////// Private
        //////////////////////////////////////////////////////////////////////////////// Event

        #region 폼 로드시 처리하기 - Form_Load(sender, e)

        /// <summary>
        /// 폼 로드시 처리하기
        /// </summary>
        /// <param name="sender">이벤트 발생자</param>
        /// <param name="e">이벤트 인자</param>
        private void Form_Load(object sender, EventArgs e)
        {
            this.pivotGridControl.BeginUpdate();

            this.pivotGridControl.DataSource = GetTable(20);

            this.pivotGridControl.Fields.Add("Type"   , PivotArea.RowArea);
            this.pivotGridControl.Fields.Add("Product", PivotArea.RowArea);

            PivotGridField yearField = new PivotGridField("Date", PivotArea.RowArea);

            yearField.Name          = "yearField";
            yearField.Caption       = yearField.Name;
            yearField.GroupInterval = PivotGroupInterval.DateYear;

            PivotGridField monthField = new PivotGridField("Date", PivotArea.RowArea);

            monthField.Name          = "monthField";
            monthField.Caption       = monthField.Name;
            monthField.GroupInterval = PivotGroupInterval.DateMonth;

            pivotGridControl.Fields.AddRange(new PivotGridField[] { yearField, monthField });

            pivotGridControl.Fields.Add("Flag", PivotArea.RowArea);

            this.pivotGridControl.CustomDrawFieldValue += pivotGridControl_CustomDrawFieldValue;

            this.pivotGridControl.Appearance.Lines.BackColor = Color.Transparent;

            this.pivotGridControl.EndUpdate();
        }

        #endregion
        #region 피벗 그리드 컨트롤 필드 값 커스텀 그리기 - pivotGridControl_CustomDrawFieldValue(sender, e)

        /// <summary>
        /// 피벗 그리드 컨트롤 필드 값 커스텀 그리기
        /// </summary>
        /// <param name="sender">이벤트 발생자</param>
        /// <param name="e">이벤트 인자</param>
        private void pivotGridControl_CustomDrawFieldValue(object sender, PivotCustomDrawFieldValueEventArgs e)
        {
            if(e.Area == PivotArea.ColumnArea)
            {
                e.Graphics.FillRectangle(Brushes.White, e.Bounds);

                e.Handled = true;
            }
        }

        #endregion

        //////////////////////////////////////////////////////////////////////////////// Function

        #region 테이블 구하기 - GetTable(rowCount)

        /// <summary>
        /// 테이블 구하기
        /// </summary>
        /// <param name="rowCount">행 수</param>
        /// <returns>테이블</returns>
        private DataTable GetTable(int rowCount)
        {
            DataTable table = new DataTable();

            table.Columns.Add("Type"   , typeof(string  ));
            table.Columns.Add("Product", typeof(string  ));
            table.Columns.Add("Date"   , typeof(DateTime));
            table.Columns.Add("Flag"   , typeof(bool    ));

            for(int i = 0; i < rowCount; i++)
            {
                for(int j = 0; j < rowCount; j++)
                {
                    table.Rows.Add
                    (
                        new object[]
                        {
                            string.Format("Type {0}", i % 5),
                            string.Format("Product {0}", i % 3),
                            DateTime.Now.AddYears(j % 7).AddMonths(j % 9), i % 2 == 0
                        }
                    );
                }
            }

            return table;
        }

        #endregion
    }
}

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

using System;

using System.Data;

using System.Drawing;

using DevExpress.XtraEditors;

using DevExpress.XtraPivotGrid;

using DevExpress.XtraPivotGrid.Localization;

namespace TestProject

{

/// <summary>

/// 메인 폼

/// </summary>

public partial class MainForm : XtraForm

{

//////////////////////////////////////////////////////////////////////////////////////////////////// Constructor

////////////////////////////////////////////////////////////////////////////////////////// Public

#region 생성자 - MainForm()

/// <summary>

/// 생성자

/// </summary>

public MainForm()

{

PivotGridLocalizer.Active = new CustomLocalizer();

InitializeComponent();

Load += Form_Load;

}

#endregion

//////////////////////////////////////////////////////////////////////////////////////////////////// Method

////////////////////////////////////////////////////////////////////////////////////////// Private

//////////////////////////////////////////////////////////////////////////////// Event

#region 폼 로드시 처리하기 - Form_Load(sender, e)

/// <summary>

/// 폼 로드시 처리하기

/// </summary>

/// <param name="sender">이벤트 발생자</param>

/// <param name="e">이벤트 인자</param>

private void Form_Load(object sender, EventArgs e)

{

this.pivotGridControl.BeginUpdate();

this.pivotGridControl.DataSource = GetTable(20);

this.pivotGridControl.Fields.Add("Type" , PivotArea.RowArea);

this.pivotGridControl.Fields.Add("Product", PivotArea.RowArea);

PivotGridField yearField = new PivotGridField("Date", PivotArea.RowArea);

yearField.Name = "yearField";

yearField.Caption = yearField.Name;

yearField.GroupInterval = PivotGroupInterval.DateYear;

PivotGridField monthField = new PivotGridField("Date", PivotArea.RowArea);

monthField.Name = "monthField";

monthField.Caption = monthField.Name;

monthField.GroupInterval = PivotGroupInterval.DateMonth;

pivotGridControl.Fields.AddRange(new PivotGridField[] { yearField, monthField });

pivotGridControl.Fields.Add("Flag", PivotArea.RowArea);

this.pivotGridControl.CustomDrawFieldValue += pivotGridControl_CustomDrawFieldValue;

this.pivotGridControl.Appearance.Lines.BackColor = Color.Transparent;

this.pivotGridControl.EndUpdate();

}

#endregion

#region 피벗 그리드 컨트롤 필드 값 커스텀 그리기 - pivotGridControl_CustomDrawFieldValue(sender, e)

/// <summary>

/// 피벗 그리드 컨트롤 필드 값 커스텀 그리기

/// </summary>

/// <param name="sender">이벤트 발생자</param>

/// <param name="e">이벤트 인자</param>

private void pivotGridControl_CustomDrawFieldValue(object sender, PivotCustomDrawFieldValueEventArgs e)

{

if(e.Area == PivotArea.ColumnArea)

{

e.Graphics.FillRectangle(Brushes.White, e.Bounds);

e.Handled = true;

}

#endregion

//////////////////////////////////////////////////////////////////////////////// Function

#region 테이블 구하기 - GetTable(rowCount)

/// <summary>

/// 테이블 구하기

/// </summary>

/// <param name="rowCount">행 수</param>

/// <returns>테이블</returns>

private DataTable GetTable(int rowCount)

{

DataTable table = new DataTable();

table.Columns.Add("Type" , typeof(string ));

table.Columns.Add("Product", typeof(string ));

table.Columns.Add("Date" , typeof(DateTime));

table.Columns.Add("Flag" , typeof(bool ));

for(int i = 0; i < rowCount; i++)

{

for(int j = 0; j < rowCount; j++)

{

table.Rows.Add

(

new object[]

{

string.Format("Type {0}", i % 5),

string.Format("Product {0}", i % 3),

DateTime.Now.AddYears(j % 7).AddMonths(j % 9), i % 2 == 0

}

);

}

return table;

}

#endregion

}

TestProject.zip

[C#/WINFORM/DEVEXPRESS] PivotGridControl 클래스 : FieldValueDisplayText 이벤트를 사용해 필드 값 디스플레이 텍스트 설정하기

■ PivotGridControl 클래스의 FieldValueDisplayText 이벤트를 사용해 필드 값 디스플레이 텍스트를 설정하는 방법을 보여준다. ▶ MainForm.cs


using System.Data.OleDb;

using DevExpress.Data.PivotGrid;
using DevExpress.XtraEditors;
using DevExpress.XtraPivotGrid;

namespace TestProject
{
    /// <summary>
    /// 메인 폼
    /// </summary>
    public partial class MainForm : XtraForm
    {
        //////////////////////////////////////////////////////////////////////////////////////////////////// Field
        ////////////////////////////////////////////////////////////////////////////////////////// Private

        #region Field

        /// <summary>
        /// 연결
        /// </summary>
        private OleDbConnection connection;

        #endregion

        //////////////////////////////////////////////////////////////////////////////////////////////////// Constructor
        ////////////////////////////////////////////////////////////////////////////////////////// Public

        #region 생성자 - MainForm()

        /// <summary>
        /// 생성자
        /// </summary>
        public MainForm()
        {
            InitializeComponent();

            this.connection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=nwind.mdb");

            this.pivotGridControl.OptionsView.RowTotalsLocation = PivotRowTotalsLocation.Tree;

            this.pivotGridControl.DataSource = Order.GetOrderList(this.connection);

            this.pivotGridControl.RetrieveFields();

            PivotGridField shipCountryField = this.pivotGridControl.Fields["ShipCountry"];

            shipCountryField.Area = PivotArea.RowArea;

            PivotGridField orderDateField = this.pivotGridControl.Fields["OrderDate"];

            orderDateField.Area          = PivotArea.ColumnArea;
            orderDateField.GroupInterval = PivotGroupInterval.DateYear;

            PivotGridField orderIDField = this.pivotGridControl.Fields["OrderID"];

            orderIDField.Area        = PivotArea.DataArea;
            orderIDField.SummaryType = PivotSummaryType.Count;

            this.pivotGridControl.BestFit();

            this.pivotGridControl.FieldValueDisplayText += pivotGridControl_FieldValueDisplayText;
        }

        #endregion

        //////////////////////////////////////////////////////////////////////////////////////////////////// Method
        ////////////////////////////////////////////////////////////////////////////////////////// Private

        #region 피벗 그리드 컨트롤 필드 값 디스플레이 텍스트 설정하기 - pivotGridControl_FieldValueDisplayText(sender, e)

        /// <summary>
        /// 피벗 그리드 컨트롤 필드 값 디스플레이 텍스트 설정하기
        /// </summary>
        /// <param name="sender">이벤트 발생자</param>
        /// <param name="e">이벤트 인자</param>
        private void pivotGridControl_FieldValueDisplayText(object sender, PivotFieldDisplayTextEventArgs e)
        {
            if(e.ValueType == PivotGridValueType.GrandTotal)
            {
                if(e.IsColumn)
                {
                    e.DisplayText = "소계";
                }
                else
                {
                    e.DisplayText = "총계";
                }
            }
        }

        #endregion
    }
}

using System.Data.OleDb;

using DevExpress.Data.PivotGrid;

using DevExpress.XtraEditors;

using DevExpress.XtraPivotGrid;

namespace TestProject

{

/// <summary>

/// 메인 폼

/// </summary>

public partial class MainForm : XtraForm

{

//////////////////////////////////////////////////////////////////////////////////////////////////// Field

////////////////////////////////////////////////////////////////////////////////////////// Private

#region Field

/// <summary>

/// 연결

/// </summary>

private OleDbConnection connection;

#endregion

//////////////////////////////////////////////////////////////////////////////////////////////////// Constructor

////////////////////////////////////////////////////////////////////////////////////////// Public

#region 생성자 - MainForm()

/// <summary>

/// 생성자

/// </summary>

public MainForm()

{

InitializeComponent();

this.connection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=nwind.mdb");

this.pivotGridControl.OptionsView.RowTotalsLocation = PivotRowTotalsLocation.Tree;

this.pivotGridControl.DataSource = Order.GetOrderList(this.connection);

this.pivotGridControl.RetrieveFields();

PivotGridField shipCountryField = this.pivotGridControl.Fields["ShipCountry"];

shipCountryField.Area = PivotArea.RowArea;

PivotGridField orderDateField = this.pivotGridControl.Fields["OrderDate"];

orderDateField.Area = PivotArea.ColumnArea;

orderDateField.GroupInterval = PivotGroupInterval.DateYear;

PivotGridField orderIDField = this.pivotGridControl.Fields["OrderID"];

orderIDField.Area = PivotArea.DataArea;

orderIDField.SummaryType = PivotSummaryType.Count;

this.pivotGridControl.BestFit();

this.pivotGridControl.FieldValueDisplayText += pivotGridControl_FieldValueDisplayText;

}

#endregion

//////////////////////////////////////////////////////////////////////////////////////////////////// Method

////////////////////////////////////////////////////////////////////////////////////////// Private

#region 피벗 그리드 컨트롤 필드 값 디스플레이 텍스트 설정하기 - pivotGridControl_FieldValueDisplayText(sender, e)

/// <summary>

/// 피벗 그리드 컨트롤 필드 값 디스플레이 텍스트 설정하기

/// </summary>

/// <param name="sender">이벤트 발생자</param>

/// <param name="e">이벤트 인자</param>

private void pivotGridControl_FieldValueDisplayText(object sender, PivotFieldDisplayTextEventArgs e)

{

if(e.ValueType == PivotGridValueType.GrandTotal)

{

if(e.IsColumn)

{

e.DisplayText = "소계";

}

else

{

e.DisplayText = "총계";

}

#endregion

}

TestProject.zip

[C#/WINFORM/DEVEXPRESS] PivotGridControl 클래스 : CustomCellDisplayText 이벤트를 사용해 셀 디스플레이 텍스트 커스텀 설정하기

■ PivotGridControl 클래스의 CustomCellDisplayText 이벤트를 사용해 셀 디스플레이 텍스트를 커스텀 설정하는 방법을 보여준다. ▶ MainForm.cs


using System;

using DevExpress.XtraEditors;
using DevExpress.XtraPivotGrid;

namespace TestProject
{
    /// <summary>
    /// 메인 폼
    /// </summary>
    public partial class MainForm : XtraForm
    {
        //////////////////////////////////////////////////////////////////////////////////////////////////// Constructor
        ////////////////////////////////////////////////////////////////////////////////////////// Public

        #region 생성자 - MainForm()

        /// <summary>
        /// 생성자
        /// </summary>
        public MainForm()
        {
            InitializeComponent();

            this.tableAdapter.Fill(this.nwindDataSet.SalesPerson);

            this.countryField.FilterValues.FilterType = PivotFilterType.Included;

            this.countryField.FilterValues.Add("UK");

            this.pivotGridControl.CustomCellDisplayText += pivotGridControl_CustomCellDisplayText;
        }

        #endregion

        //////////////////////////////////////////////////////////////////////////////////////////////////// Method
        ////////////////////////////////////////////////////////////////////////////////////////// Private

        #region 피벗 그리드 컨트롤 셀 디스플레이 텍스트 커스텀 설정하기 - pivotGridControl_CustomCellDisplayText(sender, e)

        /// <summary>
        /// 피벗 그리드 컨트롤 셀 디스플레이 텍스트 커스텀 설정하기
        /// </summary>
        /// <param name="sender">이벤트 발생자</param>
        /// <param name="e">이벤트 인자</param>
        private void pivotGridControl_CustomCellDisplayText(object sender, PivotCellDisplayTextEventArgs e)
        {
            if(e.RowValueType == PivotGridValueType.Total || e.ColumnValueType != PivotGridValueType.Total)
            {
                return;
            }

            if(Convert.ToSingle(e.Value) < 2000)
            {
                e.DisplayText = "Low";
            }
            else if(Convert.ToSingle(e.Value) > 6000)
            {
                e.DisplayText = "High";
            }
            else
            {
                e.DisplayText = "Middle";
            }
        }

        #endregion
    }
}

using System;

using DevExpress.XtraEditors;

using DevExpress.XtraPivotGrid;

namespace TestProject

{

/// <summary>

/// 메인 폼

/// </summary>

public partial class MainForm : XtraForm

{

//////////////////////////////////////////////////////////////////////////////////////////////////// Constructor

////////////////////////////////////////////////////////////////////////////////////////// Public

#region 생성자 - MainForm()

/// <summary>

/// 생성자

/// </summary>

public MainForm()

{

InitializeComponent();

this.tableAdapter.Fill(this.nwindDataSet.SalesPerson);

this.countryField.FilterValues.FilterType = PivotFilterType.Included;

this.countryField.FilterValues.Add("UK");

this.pivotGridControl.CustomCellDisplayText += pivotGridControl_CustomCellDisplayText;

}

#endregion

//////////////////////////////////////////////////////////////////////////////////////////////////// Method

////////////////////////////////////////////////////////////////////////////////////////// Private

#region 피벗 그리드 컨트롤 셀 디스플레이 텍스트 커스텀 설정하기 - pivotGridControl_CustomCellDisplayText(sender, e)

/// <summary>

/// 피벗 그리드 컨트롤 셀 디스플레이 텍스트 커스텀 설정하기

/// </summary>

/// <param name="sender">이벤트 발생자</param>

/// <param name="e">이벤트 인자</param>

private void pivotGridControl_CustomCellDisplayText(object sender, PivotCellDisplayTextEventArgs e)

{

if(e.RowValueType == PivotGridValueType.Total || e.ColumnValueType != PivotGridValueType.Total)

{

return;

}

if(Convert.ToSingle(e.Value) < 2000)

{

e.DisplayText = "Low";

}

else if(Convert.ToSingle(e.Value) > 6000)

{

e.DisplayText = "High";

}

else

{

e.DisplayText = "Middle";

}

#endregion

}

TestProject.zip

[C#/WINFORM/DEVEXPRESS] PivotGridControl 클래스 : CustomDrawFieldValue 이벤트를 사용해 필드 값 헤더 모양 변경하기

■ PivotGridControl 클래스의 CustomDrawFieldValue 이벤트를 사용해 필드 값 헤더 모양을 변경하는 방법을 보여준다. ▶ MainForm.cs


using System;
using System.Data;
using System.Drawing;

using DevExpress.XtraEditors;
using DevExpress.XtraPivotGrid;

namespace TestProject
{
    /// <summary>
    /// 메인 폼
    /// </summary>
    public partial class MainForm : XtraForm
    {
        //////////////////////////////////////////////////////////////////////////////////////////////////// Constructor
        ////////////////////////////////////////////////////////////////////////////////////////// Public

        #region 생성자 - MainForm()

        /// <summary>
        /// 생성자
        /// </summary>
        public MainForm()
        {
            InitializeComponent();

            this.pivotGridControl.OptionsView.RowTreeWidth = 150;

            DataTable table = this.dataSet.Tables["Data"];

            table.Rows.Add(new object[] { "UK"    , DateTime.Today.AddYears(-1)           , 4 , 5 });
            table.Rows.Add(new object[] { "UK"    , DateTime.Today.AddYears(-1).AddDays(1), 2 , 8 });
            table.Rows.Add(new object[] { "USA"   , DateTime.Today.AddYears(-1)           , 3 , 9 });
            table.Rows.Add(new object[] { "USA"   , DateTime.Today.AddDays(1).AddYears(-1), 1 , 5 });
            table.Rows.Add(new object[] { "France", DateTime.Today.AddYears(-1)           , 8 , 3 });
            table.Rows.Add(new object[] { "France", DateTime.Today.AddDays(1).AddYears(-1), 22    });
            table.Rows.Add(new object[] { "UK"    , DateTime.Today                        , 7 , 3 });
            table.Rows.Add(new object[] { "UK"    , DateTime.Today.AddDays(1)             , 4 , 1 });
            table.Rows.Add(new object[] { "USA"   , DateTime.Today                        , 12, 6 });
            table.Rows.Add(new object[] { "USA"   , DateTime.Today.AddDays(1)             , 14, 7 });
            table.Rows.Add(new object[] { "France", DateTime.Today                        , 11, 1 });
            table.Rows.Add(new object[] { "France", DateTime.Today.AddDays(1)             , 10, 3 });

            this.pivotGridControl.RefreshData();

            this.pivotGridControl.BestFitColumnArea();

            this.pivotGridControl.CustomDrawFieldValue += pivotGridControl_CustomDrawFieldValue;
        }

        #endregion

        //////////////////////////////////////////////////////////////////////////////////////////////////// Method
        ////////////////////////////////////////////////////////////////////////////////////////// Private

        #region 피벗 그리드 컨트롤 필드 값 커스텀 그리기 - pivotGridControl_CustomDrawFieldValue(sender, e)

        /// <summary>
        /// 피벗 그리드 컨트롤 필드 값 커스텀 그리기
        /// </summary>
        /// <param name="sender">이벤트 발생자</param>
        /// <param name="e">이벤트 인자</param>
        private void pivotGridControl_CustomDrawFieldValue(object sender, PivotCustomDrawFieldValueEventArgs e)
        {
            if(e.Area == PivotArea.ColumnArea)
            {
                e.Appearance.BackColor = Color.GreenYellow;
            }
            else if(e.Area == PivotArea.RowArea)
            {
                e.Painter.DrawObject(e.Info);

                e.Painter.DrawIndicator(e.Info);

                e.GraphicsCache.FillRectangle(e.GraphicsCache.GetSolidBrush(Color.FromArgb(50, 0, 0, 200)), e.Bounds);

                e.Handled = true;
            }
        }

        #endregion
    }
}

using System;

using System.Data;

using System.Drawing;

using DevExpress.XtraEditors;

using DevExpress.XtraPivotGrid;

namespace TestProject

{

/// <summary>

/// 메인 폼

/// </summary>

public partial class MainForm : XtraForm

{

//////////////////////////////////////////////////////////////////////////////////////////////////// Constructor

////////////////////////////////////////////////////////////////////////////////////////// Public

#region 생성자 - MainForm()

/// <summary>

/// 생성자

/// </summary>

public MainForm()

{

InitializeComponent();

this.pivotGridControl.OptionsView.RowTreeWidth = 150;

DataTable table = this.dataSet.Tables["Data"];

table.Rows.Add(new object[] { "UK" , DateTime.Today.AddYears(-1) , 4 , 5 });

table.Rows.Add(new object[] { "UK" , DateTime.Today.AddYears(-1).AddDays(1), 2 , 8 });

table.Rows.Add(new object[] { "USA" , DateTime.Today.AddYears(-1) , 3 , 9 });

table.Rows.Add(new object[] { "USA" , DateTime.Today.AddDays(1).AddYears(-1), 1 , 5 });

table.Rows.Add(new object[] { "France", DateTime.Today.AddYears(-1) , 8 , 3 });

table.Rows.Add(new object[] { "France", DateTime.Today.AddDays(1).AddYears(-1), 22 });

table.Rows.Add(new object[] { "UK" , DateTime.Today , 7 , 3 });

table.Rows.Add(new object[] { "UK" , DateTime.Today.AddDays(1) , 4 , 1 });

table.Rows.Add(new object[] { "USA" , DateTime.Today , 12, 6 });

table.Rows.Add(new object[] { "USA" , DateTime.Today.AddDays(1) , 14, 7 });

table.Rows.Add(new object[] { "France", DateTime.Today , 11, 1 });

table.Rows.Add(new object[] { "France", DateTime.Today.AddDays(1) , 10, 3 });

this.pivotGridControl.RefreshData();

this.pivotGridControl.BestFitColumnArea();

this.pivotGridControl.CustomDrawFieldValue += pivotGridControl_CustomDrawFieldValue;

}

#endregion

//////////////////////////////////////////////////////////////////////////////////////////////////// Method

////////////////////////////////////////////////////////////////////////////////////////// Private

#region 피벗 그리드 컨트롤 필드 값 커스텀 그리기 - pivotGridControl_CustomDrawFieldValue(sender, e)

/// <summary>

/// 피벗 그리드 컨트롤 필드 값 커스텀 그리기

/// </summary>

/// <param name="sender">이벤트 발생자</param>

/// <param name="e">이벤트 인자</param>

private void pivotGridControl_CustomDrawFieldValue(object sender, PivotCustomDrawFieldValueEventArgs e)

{

if(e.Area == PivotArea.ColumnArea)

{

e.Appearance.BackColor = Color.GreenYellow;

}

else if(e.Area == PivotArea.RowArea)

{

e.Painter.DrawObject(e.Info);

e.Painter.DrawIndicator(e.Info);

e.GraphicsCache.FillRectangle(e.GraphicsCache.GetSolidBrush(Color.FromArgb(50, 0, 0, 200)), e.Bounds);

e.Handled = true;

}

#endregion

}

TestProject.zip

[C#/WINFORM/DEVEXPRESS] PivotGridControl 클래스 : CustomAppearance 이벤트를 사용해 셀 모양 커스텀 설정하기

■ PivotGridControl 클래스의 CustomAppearance 이벤트를 사용해 셀 모양을 커스텀 설정하는 방법을 보여준다. ▶ MainForm.cs


using System.Data.OleDb;
using System.Drawing;

using DevExpress.Data.PivotGrid;
using DevExpress.XtraEditors;
using DevExpress.XtraPivotGrid;

namespace TestProject
{
    /// <summary>
    /// 메인 폼
    /// </summary>
    public partial class MainForm : XtraForm
    {
        //////////////////////////////////////////////////////////////////////////////////////////////////// Field
        ////////////////////////////////////////////////////////////////////////////////////////// Private

        #region Field

        /// <summary>
        /// 연결
        /// </summary>
        private OleDbConnection connection;

        #endregion

        //////////////////////////////////////////////////////////////////////////////////////////////////// Constructor
        ////////////////////////////////////////////////////////////////////////////////////////// Public

        #region 생성자 - MainForm()

        /// <summary>
        /// 생성자
        /// </summary>
        public MainForm()
        {
            InitializeComponent();

            this.connection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=nwind.mdb");

            this.pivotGridControl.OptionsView.RowTotalsLocation = PivotRowTotalsLocation.Tree;

            this.pivotGridControl.DataSource = Order.GetOrderList(this.connection);

            this.pivotGridControl.RetrieveFields();

            PivotGridField shipCountryField = this.pivotGridControl.Fields["ShipCountry"];

            shipCountryField.Area = PivotArea.RowArea;

            PivotGridField orderDateField = this.pivotGridControl.Fields["OrderDate"];

            orderDateField.Area          = PivotArea.ColumnArea;
            orderDateField.GroupInterval = PivotGroupInterval.DateYear;

            PivotGridField orderIDField = this.pivotGridControl.Fields["OrderID"];

            orderIDField.Area        = PivotArea.DataArea;
            orderIDField.SummaryType = PivotSummaryType.Count;

            this.pivotGridControl.BestFit();

            this.pivotGridControl.CustomAppearance += pivotGridControl_CustomAppearance;
        }

        #endregion

        //////////////////////////////////////////////////////////////////////////////////////////////////// Method
        ////////////////////////////////////////////////////////////////////////////////////////// Private

        #region 피벗 그리드 컨트롤 모양 커스텀 설정하기 - pivotGridControl_CustomAppearance(sender, e)

        /// <summary>
        /// 피벗 그리드 컨트롤 모양 커스텀 설정하기
        /// </summary>
        /// <param name="sender">이벤트 발생자</param>
        /// <param name="e">이벤트 인자</param>
        private void pivotGridControl_CustomAppearance(object sender, PivotCustomAppearanceEventArgs e)
        {
            PivotGridControl pivotGridControl = sender as PivotGridControl;

            PivotGridField orderIDField = pivotGridControl.Fields["OrderID"];

            if(e.DataField == orderIDField && e.ColumnValueType == PivotGridValueType.Value && e.RowValueType == PivotGridValueType.Value)
            {
                if(e.Value != null && (int)e.Value > 10)
                {
                    e.Appearance.BackColor = Color.Yellow;
                    e.Appearance.Font      = new Font(e.Appearance.Font, FontStyle.Bold);
                }
            }
        }

        #endregion
    }
}

using System.Data.OleDb;

using System.Drawing;

using DevExpress.Data.PivotGrid;

using DevExpress.XtraEditors;

using DevExpress.XtraPivotGrid;

namespace TestProject

{

/// <summary>

/// 메인 폼

/// </summary>

public partial class MainForm : XtraForm

{

//////////////////////////////////////////////////////////////////////////////////////////////////// Field

////////////////////////////////////////////////////////////////////////////////////////// Private

#region Field

/// <summary>

/// 연결

/// </summary>

private OleDbConnection connection;

#endregion

//////////////////////////////////////////////////////////////////////////////////////////////////// Constructor

////////////////////////////////////////////////////////////////////////////////////////// Public

#region 생성자 - MainForm()

/// <summary>

/// 생성자

/// </summary>

public MainForm()

{

InitializeComponent();

this.connection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=nwind.mdb");

this.pivotGridControl.OptionsView.RowTotalsLocation = PivotRowTotalsLocation.Tree;

this.pivotGridControl.DataSource = Order.GetOrderList(this.connection);

this.pivotGridControl.RetrieveFields();

PivotGridField shipCountryField = this.pivotGridControl.Fields["ShipCountry"];

shipCountryField.Area = PivotArea.RowArea;

PivotGridField orderDateField = this.pivotGridControl.Fields["OrderDate"];

orderDateField.Area = PivotArea.ColumnArea;

orderDateField.GroupInterval = PivotGroupInterval.DateYear;

PivotGridField orderIDField = this.pivotGridControl.Fields["OrderID"];

orderIDField.Area = PivotArea.DataArea;

orderIDField.SummaryType = PivotSummaryType.Count;

this.pivotGridControl.BestFit();

this.pivotGridControl.CustomAppearance += pivotGridControl_CustomAppearance;

}

#endregion

//////////////////////////////////////////////////////////////////////////////////////////////////// Method

////////////////////////////////////////////////////////////////////////////////////////// Private

#region 피벗 그리드 컨트롤 모양 커스텀 설정하기 - pivotGridControl_CustomAppearance(sender, e)

/// <summary>

/// 피벗 그리드 컨트롤 모양 커스텀 설정하기

/// </summary>

/// <param name="sender">이벤트 발생자</param>

/// <param name="e">이벤트 인자</param>

private void pivotGridControl_CustomAppearance(object sender, PivotCustomAppearanceEventArgs e)

{

PivotGridControl pivotGridControl = sender as PivotGridControl;

PivotGridField orderIDField = pivotGridControl.Fields["OrderID"];

if(e.DataField == orderIDField && e.ColumnValueType == PivotGridValueType.Value && e.RowValueType == PivotGridValueType.Value)

{

if(e.Value != null && (int)e.Value > 10)

{

e.Appearance.BackColor = Color.Yellow;

e.Appearance.Font = new Font(e.Appearance.Font, FontStyle.Bold);

}

#endregion

}

TestProject.zip

[C#/WINFORM/DEVEXPRESS] PivotGridCells 클래스 : CopySelectionToClipboard 메소드를 사용해 선택 영역 클립보드 복사하기

■ PivotGridCells 클래스의 CopySelectionToClipboard 메소드를 사용해 선택 영역 클립보드를 복사하는 방법을 보여준다. ▶ MainForm.cs


using System;
using System.Data.OleDb;

using DevExpress.Data.PivotGrid;
using DevExpress.XtraEditors;
using DevExpress.XtraPivotGrid;

namespace TestProject
{
    /// <summary>
    /// 메인 폼
    /// </summary>
    public partial class MainForm : XtraForm
    {
        //////////////////////////////////////////////////////////////////////////////////////////////////// Field
        ////////////////////////////////////////////////////////////////////////////////////////// Private

        #region Field

        /// <summary>
        /// 연결
        /// </summary>
        private OleDbConnection connection;

        #endregion

        //////////////////////////////////////////////////////////////////////////////////////////////////// Constructor
        ////////////////////////////////////////////////////////////////////////////////////////// Public

        #region 생성자 - MainForm()

        /// <summary>
        /// 생성자
        /// </summary>
        public MainForm()
        {
            InitializeComponent();

            this.connection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=nwind.mdb");

            this.pivotGridControl.OptionsView.RowTotalsLocation = PivotRowTotalsLocation.Tree;

            this.pivotGridControl.DataSource = Order.GetOrderList(this.connection);

            this.pivotGridControl.RetrieveFields();

            PivotGridField shipCountryField = this.pivotGridControl.Fields["ShipCountry"];

            shipCountryField.Area = PivotArea.RowArea;

            PivotGridField orderDateField = this.pivotGridControl.Fields["OrderDate"];

            orderDateField.Area          = PivotArea.ColumnArea;
            orderDateField.GroupInterval = PivotGroupInterval.DateYear;

            PivotGridField orderIDField = this.pivotGridControl.Fields["OrderID"];

            orderIDField.Area        = PivotArea.DataArea;
            orderIDField.SummaryType = PivotSummaryType.Count;

            this.pivotGridControl.BestFit();

            this.copyButton.Click += copyButton_Click;
        }

        #endregion

        //////////////////////////////////////////////////////////////////////////////////////////////////// Method
        ////////////////////////////////////////////////////////////////////////////////////////// Private

        #region Copy 버튼 클릭시 처리하기 - copyButton_Click(sender, e)

        /// <summary>
        /// Copy 버튼 클릭시 처리하기
        /// </summary>
        /// <param name="sender">이벤트 발생자</param>
        /// <param name="e">이벤트 인자</param>
        private void copyButton_Click(object sender, EventArgs e)
        {
            this.pivotGridControl.Cells.CopySelectionToClipboard();
        }

        #endregion
    }
}

using System;

using System.Data.OleDb;

using DevExpress.Data.PivotGrid;

using DevExpress.XtraEditors;

using DevExpress.XtraPivotGrid;

namespace TestProject

{

/// <summary>

/// 메인 폼

/// </summary>

public partial class MainForm : XtraForm

{

//////////////////////////////////////////////////////////////////////////////////////////////////// Field

////////////////////////////////////////////////////////////////////////////////////////// Private

#region Field

/// <summary>

/// 연결

/// </summary>

private OleDbConnection connection;

#endregion

//////////////////////////////////////////////////////////////////////////////////////////////////// Constructor

////////////////////////////////////////////////////////////////////////////////////////// Public

#region 생성자 - MainForm()

/// <summary>

/// 생성자

/// </summary>

public MainForm()

{

InitializeComponent();

this.connection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=nwind.mdb");

this.pivotGridControl.OptionsView.RowTotalsLocation = PivotRowTotalsLocation.Tree;

this.pivotGridControl.DataSource = Order.GetOrderList(this.connection);

this.pivotGridControl.RetrieveFields();

PivotGridField shipCountryField = this.pivotGridControl.Fields["ShipCountry"];

shipCountryField.Area = PivotArea.RowArea;

PivotGridField orderDateField = this.pivotGridControl.Fields["OrderDate"];

orderDateField.Area = PivotArea.ColumnArea;

orderDateField.GroupInterval = PivotGroupInterval.DateYear;

PivotGridField orderIDField = this.pivotGridControl.Fields["OrderID"];

orderIDField.Area = PivotArea.DataArea;

orderIDField.SummaryType = PivotSummaryType.Count;

this.pivotGridControl.BestFit();

this.copyButton.Click += copyButton_Click;

}

#endregion

//////////////////////////////////////////////////////////////////////////////////////////////////// Method

////////////////////////////////////////////////////////////////////////////////////////// Private

#region Copy 버튼 클릭시 처리하기 - copyButton_Click(sender, e)

/// <summary>

/// Copy 버튼 클릭시 처리하기

/// </summary>

/// <param name="sender">이벤트 발생자</param>

/// <param name="e">이벤트 인자</param>

private void copyButton_Click(object sender, EventArgs e)

{

this.pivotGridControl.Cells.CopySelectionToClipboard();

}

#endregion

}

TestProject.zip

[C#/WINFORM/DEVEXPRESS] PivotGridControl 클래스 : ShowPrintPreview 메소드를 사용해 인쇄 미리보기 대화 상자 표시하기

■ PivotGridControl 클래스의 ShowPrintPreview 메소드를 사용해 인쇄 미리보기 대화 상자를 표시하는 방법을 보여준다. ▶ MainForm.cs


using System.Data.OleDb;

using DevExpress.Data.PivotGrid;
using DevExpress.XtraEditors;
using DevExpress.XtraPivotGrid;

namespace TestProject
{
    /// <summary>
    /// 메인 폼
    /// </summary>
    public partial class MainForm : XtraForm
    {
        //////////////////////////////////////////////////////////////////////////////////////////////////// Field
        ////////////////////////////////////////////////////////////////////////////////////////// Private

        #region Field

        /// <summary>
        /// 연결
        /// </summary>
        private OleDbConnection connection;

        #endregion

        //////////////////////////////////////////////////////////////////////////////////////////////////// Constructor
        ////////////////////////////////////////////////////////////////////////////////////////// Public

        #region 생성자 - MainForm()

        /// <summary>
        /// 생성자
        /// </summary>
        public MainForm()
        {
            InitializeComponent();

            this.connection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=nwind.mdb");

            this.pivotGridControl.OptionsView.RowTotalsLocation = PivotRowTotalsLocation.Tree;

            this.pivotGridControl.DataSource = Order.GetOrderList(this.connection);

            this.pivotGridControl.RetrieveFields();

            PivotGridField shipCountryField = this.pivotGridControl.Fields["ShipCountry"];

            shipCountryField.Area = PivotArea.RowArea;

            PivotGridField orderDateField = this.pivotGridControl.Fields["OrderDate"];

            orderDateField.Area          = PivotArea.ColumnArea;
            orderDateField.GroupInterval = PivotGroupInterval.DateYear;

            PivotGridField orderIDField = this.pivotGridControl.Fields["OrderID"];

            orderIDField.Area        = PivotArea.DataArea;
            orderIDField.SummaryType = PivotSummaryType.Count;

            this.pivotGridControl.BestFit();

            if(!this.pivotGridControl.IsPrintingAvailable)
            {
                XtraMessageBox.Show(this, "Missing DevExpress.XtraPrinting library", "Error");

                return;
            }

            this.pivotGridControl.ShowPrintPreview();
        }

        #endregion
    }
}

using System.Data.OleDb;

using DevExpress.Data.PivotGrid;

using DevExpress.XtraEditors;

using DevExpress.XtraPivotGrid;

namespace TestProject

{

/// <summary>

/// 메인 폼

/// </summary>

public partial class MainForm : XtraForm

{

//////////////////////////////////////////////////////////////////////////////////////////////////// Field

////////////////////////////////////////////////////////////////////////////////////////// Private

#region Field

/// <summary>

/// 연결

/// </summary>

private OleDbConnection connection;

#endregion

//////////////////////////////////////////////////////////////////////////////////////////////////// Constructor

////////////////////////////////////////////////////////////////////////////////////////// Public

#region 생성자 - MainForm()

/// <summary>

/// 생성자

/// </summary>

public MainForm()

{

InitializeComponent();

this.connection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=nwind.mdb");

this.pivotGridControl.OptionsView.RowTotalsLocation = PivotRowTotalsLocation.Tree;

this.pivotGridControl.DataSource = Order.GetOrderList(this.connection);

this.pivotGridControl.RetrieveFields();

PivotGridField shipCountryField = this.pivotGridControl.Fields["ShipCountry"];

shipCountryField.Area = PivotArea.RowArea;

PivotGridField orderDateField = this.pivotGridControl.Fields["OrderDate"];

orderDateField.Area = PivotArea.ColumnArea;

orderDateField.GroupInterval = PivotGroupInterval.DateYear;

PivotGridField orderIDField = this.pivotGridControl.Fields["OrderID"];

orderIDField.Area = PivotArea.DataArea;

orderIDField.SummaryType = PivotSummaryType.Count;

this.pivotGridControl.BestFit();

if(!this.pivotGridControl.IsPrintingAvailable)

{

XtraMessageBox.Show(this, "Missing DevExpress.XtraPrinting library", "Error");

return;

}

this.pivotGridControl.ShowPrintPreview();

}

#endregion

}

TestProject.zip

[C#/WINFORM/DEVEXPRESS] PivotXlsxExportOptions 클래스 : CustomizeCell 이벤트를 사용해 내보내기 엑셀 문서에서 셀 커스텀 설정하기

■ PivotXlsxExportOptions 클래스의 CustomizeCell 이벤트를 사용해 내보내기 엑셀 문서에서 셀을 커스텀 설정하는 방법을 보여준다. ▶ MainForm.cs


using System;
using System.Drawing;

using DevExpress.XtraEditors;
using DevExpress.XtraPivotGrid;

namespace TestProject
{
    /// <summary>
    /// 메인 폼
    /// </summary>
    public partial class MainForm : XtraForm
    {
        //////////////////////////////////////////////////////////////////////////////////////////////////// Constructor
        ////////////////////////////////////////////////////////////////////////////////////////// Public

        #region 생성자 - MainForm()

        /// <summary>
        /// 생성자
        /// </summary>
        public MainForm()
        {
            InitializeComponent();

            this.tableAdapter.Fill(this.nwindDataSet.SalesPerson);

            Load += Form_Load;
        }

        #endregion

        //////////////////////////////////////////////////////////////////////////////////////////////////// Method
        ////////////////////////////////////////////////////////////////////////////////////////// Private

        #region 폼 로드시 처리하기 - Form_Load(sender, e)

        /// <summary>
        /// 폼 로드시 처리하기
        /// </summary>
        /// <param name="sender">이벤트 발생자</param>
        /// <param name="e">이벤트 인자</param>
        private void Form_Load(object sender, EventArgs e)
        {
            this.tableAdapter.Fill(this.nwindDataSet.SalesPerson);

            PivotXlsxExportOptions pivotXlsxExportOptions = new PivotXlsxExportOptions();

            pivotXlsxExportOptions.CustomizeCell +=  pivotXlsxExportOptions_CustomizeCell;

            this.pivotGridControl.ExportToXlsx("d:\\output.xlsx", pivotXlsxExportOptions);
        }

        #endregion
        #region 피벗 XLSX 내보내기 옵션 셀 커스텀 설정하기 - pivotXlsxExportOptions_CustomizeCell(e)

        /// <summary>
        /// 피벗 XLSX 내보내기 옵션 셀 커스텀 설정하기
        /// </summary>
        /// <param name="e">이벤트 인자</param>
        private void pivotXlsxExportOptions_CustomizeCell(CustomizePivotCellEventArgs e)
        {
            if(e.ExportArea == PivotExportArea.Data)
            {
                e.Formatting.BackColor   = Color.Azure;
                e.Formatting.Font.Italic = true;
            }

            e.Handled = true;
        }

        #endregion
    }
}

using System;

using System.Drawing;

using DevExpress.XtraEditors;

using DevExpress.XtraPivotGrid;

namespace TestProject

{

/// <summary>

/// 메인 폼

/// </summary>

public partial class MainForm : XtraForm

{

//////////////////////////////////////////////////////////////////////////////////////////////////// Constructor

////////////////////////////////////////////////////////////////////////////////////////// Public

#region 생성자 - MainForm()

/// <summary>

/// 생성자

/// </summary>

public MainForm()

{

InitializeComponent();

this.tableAdapter.Fill(this.nwindDataSet.SalesPerson);

Load += Form_Load;

}

#endregion

//////////////////////////////////////////////////////////////////////////////////////////////////// Method

////////////////////////////////////////////////////////////////////////////////////////// Private

#region 폼 로드시 처리하기 - Form_Load(sender, e)

/// <summary>

/// 폼 로드시 처리하기

/// </summary>

/// <param name="sender">이벤트 발생자</param>

/// <param name="e">이벤트 인자</param>

private void Form_Load(object sender, EventArgs e)

{

this.tableAdapter.Fill(this.nwindDataSet.SalesPerson);

PivotXlsxExportOptions pivotXlsxExportOptions = new PivotXlsxExportOptions();

pivotXlsxExportOptions.CustomizeCell += pivotXlsxExportOptions_CustomizeCell;

this.pivotGridControl.ExportToXlsx("d:\\output.xlsx", pivotXlsxExportOptions);

}

#endregion

#region 피벗 XLSX 내보내기 옵션 셀 커스텀 설정하기 - pivotXlsxExportOptions_CustomizeCell(e)

/// <summary>

/// 피벗 XLSX 내보내기 옵션 셀 커스텀 설정하기

/// </summary>

/// <param name="e">이벤트 인자</param>

private void pivotXlsxExportOptions_CustomizeCell(CustomizePivotCellEventArgs e)

{

if(e.ExportArea == PivotExportArea.Data)

{

e.Formatting.BackColor = Color.Azure;

e.Formatting.Font.Italic = true;

}

e.Handled = true;

}

#endregion

}

TestProject.zip

[C#/WINFORM/DEVEXPRESS] PivotGridControl 클래스 : ExportToXls 메소드를 사용해 엑셀 파일로 데이터 내보내기

■ PivotGridControl 클래스의 ExportToXls 메소드를 사용해 엑셀 파일로 데이터를 내보내는 방법을 보여준다. ▶ MainForm.cs


using System.Data.OleDb;

using DevExpress.Data.PivotGrid;
using DevExpress.XtraEditors;
using DevExpress.XtraPivotGrid;

namespace TestProject
{
    /// <summary>
    /// 메인 폼
    /// </summary>
    public partial class MainForm : XtraForm
    {
        //////////////////////////////////////////////////////////////////////////////////////////////////// Field
        ////////////////////////////////////////////////////////////////////////////////////////// Private

        #region Field

        /// <summary>
        /// 연결
        /// </summary>
        private OleDbConnection connection;

        #endregion

        //////////////////////////////////////////////////////////////////////////////////////////////////// Constructor
        ////////////////////////////////////////////////////////////////////////////////////////// Public

        #region 생성자 - MainForm()

        /// <summary>
        /// 생성자
        /// </summary>
        public MainForm()
        {
            InitializeComponent();

            this.connection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=nwind.mdb");

            this.pivotGridControl.OptionsView.RowTotalsLocation = PivotRowTotalsLocation.Tree;

            this.pivotGridControl.DataSource = Order.GetOrderList(this.connection);

            this.pivotGridControl.RetrieveFields();

            PivotGridField shipCountryField = this.pivotGridControl.Fields["ShipCountry"];

            shipCountryField.Area = PivotArea.RowArea;

            PivotGridField orderDateField = this.pivotGridControl.Fields["OrderDate"];

            orderDateField.Area          = PivotArea.ColumnArea;
            orderDateField.GroupInterval = PivotGroupInterval.DateYear;

            PivotGridField orderIDField = this.pivotGridControl.Fields["OrderID"];

            orderIDField.Area        = PivotArea.DataArea;
            orderIDField.SummaryType = PivotSummaryType.Count;

            this.pivotGridControl.BestFit();

            this.pivotGridControl.ExportToXls("d:\\output.xls");
        }

        #endregion
    }
}

using System.Data.OleDb;

using DevExpress.Data.PivotGrid;

using DevExpress.XtraEditors;

using DevExpress.XtraPivotGrid;

namespace TestProject

{

/// <summary>

/// 메인 폼

/// </summary>

public partial class MainForm : XtraForm

{

//////////////////////////////////////////////////////////////////////////////////////////////////// Field

////////////////////////////////////////////////////////////////////////////////////////// Private

#region Field

/// <summary>

/// 연결

/// </summary>

private OleDbConnection connection;

#endregion

//////////////////////////////////////////////////////////////////////////////////////////////////// Constructor

////////////////////////////////////////////////////////////////////////////////////////// Public

#region 생성자 - MainForm()

/// <summary>

/// 생성자

/// </summary>

public MainForm()

{

InitializeComponent();

this.connection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=nwind.mdb");

this.pivotGridControl.OptionsView.RowTotalsLocation = PivotRowTotalsLocation.Tree;

this.pivotGridControl.DataSource = Order.GetOrderList(this.connection);

this.pivotGridControl.RetrieveFields();

PivotGridField shipCountryField = this.pivotGridControl.Fields["ShipCountry"];

shipCountryField.Area = PivotArea.RowArea;

PivotGridField orderDateField = this.pivotGridControl.Fields["OrderDate"];

orderDateField.Area = PivotArea.ColumnArea;

orderDateField.GroupInterval = PivotGroupInterval.DateYear;

PivotGridField orderIDField = this.pivotGridControl.Fields["OrderID"];

orderIDField.Area = PivotArea.DataArea;

orderIDField.SummaryType = PivotSummaryType.Count;

this.pivotGridControl.BestFit();

this.pivotGridControl.ExportToXls("d:\\output.xls");

}

#endregion

}

TestProject.zip output.xls

[C#/WINFORM/DEVEXPRESS] PivotGridControl 클래스 : CustomChartDataSourceData 이벤트를 사용해 차트 데이터 소스 데이터 커스텀 설정하기

■ PivotGridControl 클래스의 CustomChartDataSourceData 이벤트를 사용해 차트 데이터의 소스 데이터를 커스텀 설정하는 방법을 보여준다. ▶ MainForm.cs


using System;
using System.Collections.Generic;

using DevExpress.XtraEditors;
using DevExpress.XtraPivotGrid;

namespace TestProject
{
    /// <summary>
    /// 메인 폼
    /// </summary>
    public partial class MainForm : XtraForm
    {
        //////////////////////////////////////////////////////////////////////////////////////////////////// Field
        ////////////////////////////////////////////////////////////////////////////////////////// Private

        #region Field

        /// <summary>
        /// 카테고리 딕셔너리
        /// </summary>
        private Dictionary<string, string> categoryDictionary;

        /// <summary>
        /// 제품 딕셔너리
        /// </summary>
        private Dictionary<string, string> productDictionary;

        #endregion

        //////////////////////////////////////////////////////////////////////////////////////////////////// Property
        ////////////////////////////////////////////////////////////////////////////////////////// Public

        #region 카테고리 딕셔너리 - CategoryDictionary

        /// <summary>
        /// 카테고리 딕셔너리
        /// </summary>
        private Dictionary<string, string> CategoryDictionary
        {
            get
            {
                if(this.categoryDictionary == null)
                {
                    this.categoryDictionary = new Dictionary<string, string>();
                }

                return this.categoryDictionary;
            }
        }

        #endregion
        #region 제품 딕셔너리 - ProductDictionary

        /// <summary>
        /// 제품 딕셔너리
        /// </summary>
        private Dictionary<string, string> ProductDictionary
        {
            get
            {
                if(this.productDictionary == null)
                {
                    this.productDictionary = new Dictionary<string, string>();
                }

                return this.productDictionary;
            }
        }

        #endregion

        //////////////////////////////////////////////////////////////////////////////////////////////////// Constructor
        ////////////////////////////////////////////////////////////////////////////////////////// Public

        #region 생성자 - MainForm()

        /// <summary>
        /// 생성자
        /// </summary>
        public MainForm()
        {
            InitializeComponent();

            Load                                            += Form_Load;
            this.pivotGridControl.CustomChartDataSourceData += pivotGridControl_CustomChartDataSourceData;
        }

        #endregion

        //////////////////////////////////////////////////////////////////////////////////////////////////// Method
        ////////////////////////////////////////////////////////////////////////////////////////// Private
        //////////////////////////////////////////////////////////////////////////////// Event

        #region 폼 로드시 처리하기 - Form_Load(sender, e)

        /// <summary>
        /// 폼 로드시 처리하기
        /// </summary>
        /// <param name="sender">이벤트 발생자</param>
        /// <param name="e">이벤트 인자</param>
        private void Form_Load(object sender, EventArgs e)
        {
            this.tableAdapter.Fill(this.nwindDataSet.ProductReports);

            this.pivotGridControl.OptionsChartDataSource.ProvideRowFieldValuesAsType    = typeof(string);
            this.pivotGridControl.OptionsChartDataSource.ProvideColumnFieldValuesAsType = typeof(string);
            this.pivotGridControl.OptionsChartDataSource.ProvideCellValuesAsType        = typeof(int);

            SetDictionary();

            this.chartControl.DataSource = this.pivotGridControl;

            this.categoryNameField.CollapseAll();

            this.categoryNameField.ExpandValue("Produce");
        }

        #endregion
        #region 피벗 그리드 컨트롤 차트 데이터 소스 데이터 커스텀 설정하기 - pivotGridControl_CustomChartDataSourceData(sender, e)

        /// <summary>
        /// 피벗 그리드 컨트롤 차트 데이터 소스 데이터 커스텀 설정하기
        /// </summary>
        /// <param name="sender">이벤트 발생자</param>
        /// <param name="e">이벤트 인자</param>
        private void pivotGridControl_CustomChartDataSourceData(object sender, PivotCustomChartDataSourceDataEventArgs e)
        {
            if(e.ItemType == PivotChartItemType.RowItem)
            {
                if(e.FieldValueInfo.Field == this.categoryNameField)
                {
                    e.Value = CategoryDictionary[e.FieldValueInfo.Value.ToString()];
                }
                else if(e.FieldValueInfo.Field == this.productNameField)
                {
                    string product  = ProductDictionary[e.FieldValueInfo.Value.ToString()];
                    string category = CategoryDictionary[e.FieldValueInfo.GetHigherLevelFieldValue(this.categoryNameField).ToString()];

                    e.Value = product + '[' + category + ']';
                }
            }

            if(e.ItemType == PivotChartItemType.ColumnItem)
            {
                if(e.FieldValueInfo.ValueType == PivotGridValueType.GrandTotal)
                {
                    e.Value = "Total Sales";
                }
            }

            if(e.ItemType == PivotChartItemType.CellItem)
            {
                e.Value = Math.Round(Convert.ToDecimal(e.CellInfo.Value), 0);
            }
        }

        #endregion

        //////////////////////////////////////////////////////////////////////////////// Function

        #region 딕셔너리 설정하기 - SetDictionary()

        /// <summary>
        /// 딕셔너리 설정하기
        /// </summary>
        private void SetDictionary()
        {
            int categoryCounter = 1;

            foreach(object value in this.categoryNameField.GetUniqueValues())
            {
                CategoryDictionary.Add(value.ToString(), "C" + categoryCounter++);
            }

            int productCounter = 1;

            foreach(object value in this.productNameField.GetUniqueValues())
            {
                ProductDictionary.Add(value.ToString(), "P" + productCounter++);
            }
        }

        #endregion
    }
}

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

147

148

149

150

151

152

153

154

155

156

157

158

159

160

161

162

163

164

165

166

167

168

169

170

171

172

173

174

175

176

177

178

179

180

181

182

183

184

185

186

187

188

using System;

using System.Collections.Generic;

using DevExpress.XtraEditors;

using DevExpress.XtraPivotGrid;

namespace TestProject

{

/// <summary>

/// 메인 폼

/// </summary>

public partial class MainForm : XtraForm

{

//////////////////////////////////////////////////////////////////////////////////////////////////// Field

////////////////////////////////////////////////////////////////////////////////////////// Private

#region Field

/// <summary>

/// 카테고리 딕셔너리

/// </summary>

private Dictionary<string, string> categoryDictionary;

/// <summary>

/// 제품 딕셔너리

/// </summary>

private Dictionary<string, string> productDictionary;

#endregion

//////////////////////////////////////////////////////////////////////////////////////////////////// Property

////////////////////////////////////////////////////////////////////////////////////////// Public

#region 카테고리 딕셔너리 - CategoryDictionary

/// <summary>

/// 카테고리 딕셔너리

/// </summary>

private Dictionary<string, string> CategoryDictionary

{

get

{

if(this.categoryDictionary == null)

{

this.categoryDictionary = new Dictionary<string, string>();

}

return this.categoryDictionary;

}

#endregion

#region 제품 딕셔너리 - ProductDictionary

/// <summary>

/// 제품 딕셔너리

/// </summary>

private Dictionary<string, string> ProductDictionary

{

get

{

if(this.productDictionary == null)

{

this.productDictionary = new Dictionary<string, string>();

}

return this.productDictionary;

}

#endregion

//////////////////////////////////////////////////////////////////////////////////////////////////// Constructor

////////////////////////////////////////////////////////////////////////////////////////// Public

#region 생성자 - MainForm()

/// <summary>

/// 생성자

/// </summary>

public MainForm()

{

InitializeComponent();

Load += Form_Load;

this.pivotGridControl.CustomChartDataSourceData += pivotGridControl_CustomChartDataSourceData;

}

#endregion

//////////////////////////////////////////////////////////////////////////////////////////////////// Method

////////////////////////////////////////////////////////////////////////////////////////// Private

//////////////////////////////////////////////////////////////////////////////// Event

#region 폼 로드시 처리하기 - Form_Load(sender, e)

/// <summary>

/// 폼 로드시 처리하기

/// </summary>

/// <param name="sender">이벤트 발생자</param>

/// <param name="e">이벤트 인자</param>

private void Form_Load(object sender, EventArgs e)

{

this.tableAdapter.Fill(this.nwindDataSet.ProductReports);

this.pivotGridControl.OptionsChartDataSource.ProvideRowFieldValuesAsType = typeof(string);

this.pivotGridControl.OptionsChartDataSource.ProvideColumnFieldValuesAsType = typeof(string);

this.pivotGridControl.OptionsChartDataSource.ProvideCellValuesAsType = typeof(int);

SetDictionary();

this.chartControl.DataSource = this.pivotGridControl;

this.categoryNameField.CollapseAll();

this.categoryNameField.ExpandValue("Produce");

}

#endregion

#region 피벗 그리드 컨트롤 차트 데이터 소스 데이터 커스텀 설정하기 - pivotGridControl_CustomChartDataSourceData(sender, e)

/// <summary>

/// 피벗 그리드 컨트롤 차트 데이터 소스 데이터 커스텀 설정하기

/// </summary>

/// <param name="sender">이벤트 발생자</param>

/// <param name="e">이벤트 인자</param>

private void pivotGridControl_CustomChartDataSourceData(object sender, PivotCustomChartDataSourceDataEventArgs e)

{

if(e.ItemType == PivotChartItemType.RowItem)

{

if(e.FieldValueInfo.Field == this.categoryNameField)

{

e.Value = CategoryDictionary[e.FieldValueInfo.Value.ToString()];

}

else if(e.FieldValueInfo.Field == this.productNameField)

{

string product = ProductDictionary[e.FieldValueInfo.Value.ToString()];

string category = CategoryDictionary[e.FieldValueInfo.GetHigherLevelFieldValue(this.categoryNameField).ToString()];

e.Value = product + '[' + category + ']';

}

if(e.ItemType == PivotChartItemType.ColumnItem)

{

if(e.FieldValueInfo.ValueType == PivotGridValueType.GrandTotal)

{

e.Value = "Total Sales";

}

if(e.ItemType == PivotChartItemType.CellItem)

{

e.Value = Math.Round(Convert.ToDecimal(e.CellInfo.Value), 0);

}

#endregion

//////////////////////////////////////////////////////////////////////////////// Function

#region 딕셔너리 설정하기 - SetDictionary()

/// <summary>

/// 딕셔너리 설정하기

/// </summary>

private void SetDictionary()

{

int categoryCounter = 1;

foreach(object value in this.categoryNameField.GetUniqueValues())

{

CategoryDictionary.Add(value.ToString(), "C" + categoryCounter++);

}

int productCounter = 1;

foreach(object value in this.productNameField.GetUniqueValues())

{

ProductDictionary.Add(value.ToString(), "P" + productCounter++);

}

#endregion

}

TestProject.zip

[C#/WINFORM/DEVEXPRESS] PivotGridControl 클래스 : 차트를 사용해 피벗 그리드 데이터 시각화하기

■ PivotGridControl 클래스에서 차트를 사용해 피벗 그리드 데이터를 시각화하는 방법을 보여준다. ▶ MainForm.cs


using System;

using DevExpress.XtraEditors;

namespace TestProject
{
    /// <summary>
    /// 메인 폼
    /// </summary>
    public partial class MainForm : XtraForm
    {
        //////////////////////////////////////////////////////////////////////////////////////////////////// Constructor
        ////////////////////////////////////////////////////////////////////////////////////////// Public

        #region 생성자 - MainForm()

        /// <summary>
        /// 생성자
        /// </summary>
        public MainForm()
        {
            InitializeComponent();

            Load += Form_Load;
        }

        #endregion

        //////////////////////////////////////////////////////////////////////////////////////////////////// Method
        ////////////////////////////////////////////////////////////////////////////////////////// Private

        #region 폼 로드시 처리하기 - Form_Load(sender, e)

        /// <summary>
        /// 폼 로드시 처리하기
        /// </summary>
        /// <param name="sender">이벤트 발생자</param>
        /// <param name="e">이벤트 인자</param>
        private void Form_Load(object sender, EventArgs e)
        {
            this.tableAdapter.Fill(this.nwindDataSet.SalesPerson);

            this.chartControl.DataSource = this.pivotGridControl;
        }

        #endregion
    }
}

using System;

using DevExpress.XtraEditors;

namespace TestProject

{

/// <summary>

/// 메인 폼

/// </summary>

public partial class MainForm : XtraForm

{

//////////////////////////////////////////////////////////////////////////////////////////////////// Constructor

////////////////////////////////////////////////////////////////////////////////////////// Public

#region 생성자 - MainForm()

/// <summary>

/// 생성자

/// </summary>

public MainForm()

{

InitializeComponent();

Load += Form_Load;

}

#endregion

//////////////////////////////////////////////////////////////////////////////////////////////////// Method

////////////////////////////////////////////////////////////////////////////////////////// Private

#region 폼 로드시 처리하기 - Form_Load(sender, e)

/// <summary>

/// 폼 로드시 처리하기

/// </summary>

/// <param name="sender">이벤트 발생자</param>

/// <param name="e">이벤트 인자</param>

private void Form_Load(object sender, EventArgs e)

{

this.tableAdapter.Fill(this.nwindDataSet.SalesPerson);

this.chartControl.DataSource = this.pivotGridControl;

}

#endregion

}

TestProject.zip

[C#/WINFORM/DEVEXPRESS] PivotGridControl 클래스 : CustomCellValue 이벤트를 사용해 총계 숨기기

■ PivotGridControl 클래스의 CustomCellValue 이벤트를 사용해 총계를 숨기는 방법을 보여준다. ▶ MainForm.cs


using System.ComponentModel;
using System.Linq;

using DevExpress.XtraEditors;
using DevExpress.XtraPivotGrid;

namespace TestProject
{
    /// <summary>
    /// 메인 폼
    /// </summary>
    public partial class MainForm : XtraForm
    {
        //////////////////////////////////////////////////////////////////////////////////////////////////// Constructor
        ////////////////////////////////////////////////////////////////////////////////////////// Public

        #region 생성자 - MainForm()

        /// <summary>
        /// 생성자
        /// </summary>
        public MainForm()
        {
            InitializeComponent();

            this.pivotGridControl.CustomCellValue += pivotGridControl_CustomCellValue;

            BindingList<PivotData> pivotDataList = new BindingList<PivotData>();

            for(int i = 0; i < 100; i++)
            {
                pivotDataList.Add
                (
                    new PivotData()
                    {
                        Group  = "Group " + i % 4,
                        Row    = "Row "   + i % 5,
                        Column = "Column" + i % 3,
                        Value  = i
                    }
                );
            }

            this.pivotGridControl.DataSource = pivotDataList;

            this.pivotGridControl.BestFitDataHeaders(true);
        }

        #endregion

        //////////////////////////////////////////////////////////////////////////////////////////////////// Method
        ////////////////////////////////////////////////////////////////////////////////////////// Private

        #region 피벗 그리드 컨트롤 셀 값 커스텀 설정하기 - pivotGridControl_CustomCellValue(sender, e)

        /// <summary>
        /// 피벗 그리드 컨트롤 셀 값 커스텀 설정하기
        /// </summary>
        /// <param name="sender">이벤트 발생자</param>
        /// <param name="e">이벤트 인자</param>
        private void pivotGridControl_CustomCellValue(object sender, PivotCellValueEventArgs e)
        {
            if(e.DataField == this.lowLevelValueField)
            {
                PivotGridField field = this.pivotGridControl.GetFieldsByArea(PivotArea.RowArea).Last();

                if
                (
                    e.RowValueType == PivotGridValueType.Total      ||
                    e.RowValueType == PivotGridValueType.GrandTotal ||
                    e.RowField     != field
                )
                {
                    e.Value = null;
                }
            }
        }

        #endregion
    }
}

using System.ComponentModel;

using System.Linq;

using DevExpress.XtraEditors;

using DevExpress.XtraPivotGrid;

namespace TestProject

{

/// <summary>

/// 메인 폼

/// </summary>

public partial class MainForm : XtraForm

{

//////////////////////////////////////////////////////////////////////////////////////////////////// Constructor

////////////////////////////////////////////////////////////////////////////////////////// Public

#region 생성자 - MainForm()

/// <summary>

/// 생성자

/// </summary>

public MainForm()

{

InitializeComponent();

this.pivotGridControl.CustomCellValue += pivotGridControl_CustomCellValue;

BindingList<PivotData> pivotDataList = new BindingList<PivotData>();

for(int i = 0; i < 100; i++)

{

pivotDataList.Add

(

new PivotData()

{

Group = "Group " + i % 4,

Row = "Row " + i % 5,

Column = "Column" + i % 3,

Value = i

}

);

}

this.pivotGridControl.DataSource = pivotDataList;

this.pivotGridControl.BestFitDataHeaders(true);

}

#endregion

//////////////////////////////////////////////////////////////////////////////////////////////////// Method

////////////////////////////////////////////////////////////////////////////////////////// Private

#region 피벗 그리드 컨트롤 셀 값 커스텀 설정하기 - pivotGridControl_CustomCellValue(sender, e)

/// <summary>

/// 피벗 그리드 컨트롤 셀 값 커스텀 설정하기

/// </summary>

/// <param name="sender">이벤트 발생자</param>

/// <param name="e">이벤트 인자</param>

private void pivotGridControl_CustomCellValue(object sender, PivotCellValueEventArgs e)

{

if(e.DataField == this.lowLevelValueField)

{

PivotGridField field = this.pivotGridControl.GetFieldsByArea(PivotArea.RowArea).Last();

(

e.RowValueType == PivotGridValueType.Total ||

e.RowValueType == PivotGridValueType.GrandTotal ||

e.RowField != field

)

{

e.Value = null;

}

#endregion

}

TestProject.zip

[C#/WINFORM/DEVEXPRESS] PivotGridControl 클래스 : ValueFormat/CellFormat 속성을 사용해 값 포맷하기

■ PivotGridControl 클래스의 ValueFormat/CellFormat 속성을 사용해 값을 포맷하는 방법을 보여준다. ▶ MainForm.cs


using System.Data.OleDb;

using DevExpress.Data.PivotGrid;
using DevExpress.Utils;
using DevExpress.XtraEditors;
using DevExpress.XtraPivotGrid;

namespace TestProject
{
    /// <summary>
    /// 메인 폼
    /// </summary>
    public partial class MainForm : XtraForm
    {
        //////////////////////////////////////////////////////////////////////////////////////////////////// Field
        ////////////////////////////////////////////////////////////////////////////////////////// Private

        #region Field

        /// <summary>
        /// 연결
        /// </summary>
        private OleDbConnection connection;

        #endregion

        //////////////////////////////////////////////////////////////////////////////////////////////////// Constructor
        ////////////////////////////////////////////////////////////////////////////////////////// Public

        #region 생성자 - MainForm()

        /// <summary>
        /// 생성자
        /// </summary>
        public MainForm()
        {
            InitializeComponent();

            this.connection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=nwind.mdb");

            this.pivotGridControl.OptionsView.RowTotalsLocation = PivotRowTotalsLocation.Tree;

            this.pivotGridControl.DataSource = Order.GetOrderList(this.connection);

            this.pivotGridControl.RetrieveFields();

            PivotGridField orderDateField   = this.pivotGridControl.Fields["OrderDate"  ];
            PivotGridField freightField     = this.pivotGridControl.Fields["Freight"    ];
            PivotGridField shipCountryField = this.pivotGridControl.Fields["ShipCountry"];
            PivotGridField shipCityField    = this.pivotGridControl.Fields["ShipCity"   ];

            shipCountryField.Area = PivotArea.RowArea;

            shipCityField.Area = PivotArea.RowArea;

            orderDateField.Area                                    = PivotArea.ColumnArea;
            orderDateField.GroupInterval                           = PivotGroupInterval.DateMonthYear;
            orderDateField.Appearance.Value.TextOptions.HAlignment = HorzAlignment.Center;
            orderDateField.ValueFormat.FormatType                  = FormatType.DateTime;
            orderDateField.ValueFormat.FormatString                = "yyyy-MM";

            freightField.Area                    = PivotArea.DataArea;
            freightField.SummaryType             = PivotSummaryType.Average;
            freightField.CellFormat.FormatType   = FormatType.Numeric;
            freightField.CellFormat.FormatString = "n2";
        }

        #endregion
    }
}

using System.Data.OleDb;

using DevExpress.Data.PivotGrid;

using DevExpress.Utils;

using DevExpress.XtraEditors;

using DevExpress.XtraPivotGrid;

namespace TestProject

{

/// <summary>

/// 메인 폼

/// </summary>

public partial class MainForm : XtraForm

{

//////////////////////////////////////////////////////////////////////////////////////////////////// Field

////////////////////////////////////////////////////////////////////////////////////////// Private

#region Field

/// <summary>

/// 연결

/// </summary>

private OleDbConnection connection;

#endregion

//////////////////////////////////////////////////////////////////////////////////////////////////// Constructor

////////////////////////////////////////////////////////////////////////////////////////// Public

#region 생성자 - MainForm()

/// <summary>

/// 생성자

/// </summary>

public MainForm()

{

InitializeComponent();

this.connection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=nwind.mdb");

this.pivotGridControl.OptionsView.RowTotalsLocation = PivotRowTotalsLocation.Tree;

this.pivotGridControl.DataSource = Order.GetOrderList(this.connection);

this.pivotGridControl.RetrieveFields();

PivotGridField orderDateField = this.pivotGridControl.Fields["OrderDate" ];

PivotGridField freightField = this.pivotGridControl.Fields["Freight" ];

PivotGridField shipCountryField = this.pivotGridControl.Fields["ShipCountry"];

PivotGridField shipCityField = this.pivotGridControl.Fields["ShipCity" ];

shipCountryField.Area = PivotArea.RowArea;

shipCityField.Area = PivotArea.RowArea;

orderDateField.Area = PivotArea.ColumnArea;

orderDateField.GroupInterval = PivotGroupInterval.DateMonthYear;

orderDateField.Appearance.Value.TextOptions.HAlignment = HorzAlignment.Center;

orderDateField.ValueFormat.FormatType = FormatType.DateTime;

orderDateField.ValueFormat.FormatString = "yyyy-MM";

freightField.Area = PivotArea.DataArea;

freightField.SummaryType = PivotSummaryType.Average;

freightField.CellFormat.FormatType = FormatType.Numeric;

freightField.CellFormat.FormatString = "n2";

}

#endregion

}

TestProject.zip

[C#/WINFORM/DEVEXPRESS] PivotGridControl 클래스 : SaveLayoutToStream/RestoreLayoutFromStream 메소드를 사용해 레이아웃 저장하기/복구하기

■ PivotGridControl 클래스의 SaveLayoutToStream/RestoreLayoutFromStream 메소드를 사용해 레이아웃을 저장하거나 복구하는 방법을 보여준다. ▶ MainForm.cs


using System;
using System.IO;

using DevExpress.Utils;
using DevExpress.XtraEditors;

namespace TestProject
{
    /// <summary>
    /// 메인 폼
    /// </summary>
    public partial class MainForm : XtraForm
    {
        //////////////////////////////////////////////////////////////////////////////////////////////////// Field
        ////////////////////////////////////////////////////////////////////////////////////////// Private

        #region Field

        /// <summary>
        /// 레이아웃 스트림
        /// </summary>
        private MemoryStream layoutStream = new MemoryStream();

        /// <summary>
        /// 접힌 상태 스트림
        /// </summary>
        private MemoryStream collapsedStateStream = new MemoryStream();

        #endregion

        //////////////////////////////////////////////////////////////////////////////////////////////////// Constructor
        ////////////////////////////////////////////////////////////////////////////////////////// Public

        #region 생성자 - MainForm()

        /// <summary>
        /// 생성자
        /// </summary>
        public MainForm()
        {
            InitializeComponent();

            this.clearButton.Enabled = false;

            Load                   += Form_Load;
            this.saveButton.Click  += saveButton_Click;
            this.loadButton.Click  += loadButton_Click;
            this.clearButton.Click += clearButton_Click;
        }

        #endregion

        //////////////////////////////////////////////////////////////////////////////////////////////////// Method
        ////////////////////////////////////////////////////////////////////////////////////////// Private

        #region 폼 로드시 처리하기 - Form_Load(sender, e)

        /// <summary>
        /// 폼 로드시 처리하기
        /// </summary>
        /// <param name="sender">이벤트 발생자</param>
        /// <param name="e">이벤트 인자</param>
        private void Form_Load(object sender, EventArgs e)
        {
            this.excelDataSource.FileName = "SalesPerson.xlsx";

            this.excelDataSource.Fill();

            this.pivotGridControl.DataSource = this.excelDataSource;
        }

        #endregion
        #region Save 버튼 클릭시 처리하기 - saveButton_Click(sender, e)

        /// <summary>
        /// Save 버튼 클릭시 처리하기
        /// </summary>
        /// <param name="sender">이벤트 발생자</param>
        /// <param name="e">이벤트 인자</param>
        private void saveButton_Click(object sender, EventArgs e)
        {
            if(this.pivotGridControl.Fields.Count > 0)
            {
                this.layoutStream.Dispose();

                this.layoutStream = new MemoryStream();

                this.pivotGridControl.SaveLayoutToStream(this.layoutStream, OptionsLayoutBase.FullLayout);

                this.collapsedStateStream.Dispose();

                this.collapsedStateStream = new MemoryStream();

                this.pivotGridControl.SaveCollapsedStateToStream(this.collapsedStateStream);

                this.clearButton.Enabled = true;
            }
        }

        #endregion
        #region Load 버튼 클릭시 처리하기 - loadButton_Click(sender, e)

        /// <summary>
        /// Load 버튼 클릭시 처리하기
        /// </summary>
        /// <param name="sender">이벤트 발생자</param>
        /// <param name="e">이벤트 인자</param>
        private void loadButton_Click(object sender, EventArgs e)
        {
            if(this.layoutStream.Length > 0 && this.collapsedStateStream.Length > 0)
            {
                this.layoutStream.Seek(0, SeekOrigin.Begin);

                this.pivotGridControl.RestoreLayoutFromStream(this.layoutStream, OptionsLayoutBase.FullLayout);

                this.collapsedStateStream.Seek(0, SeekOrigin.Begin);

                this.pivotGridControl.LoadCollapsedStateFromStream(this.collapsedStateStream);
            }
        }

        #endregion
        #region Clear 버튼 클릭시 처리하기 - clearButton_Click(sender, e)

        /// <summary>
        /// Clear 버튼 클릭시 처리하기
        /// </summary>
        /// <param name="sender">이벤트 발생자</param>
        /// <param name="e">이벤트 인자</param>
        private void clearButton_Click(object sender, EventArgs e)
        {
            if(this.layoutStream.Length > 0 && this.collapsedStateStream.Length > 0)
            {
                this.pivotGridControl.Fields.Clear();
            }
        }

        #endregion
    }
}

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

using System;

using System.IO;

using DevExpress.Utils;

using DevExpress.XtraEditors;

namespace TestProject

{

/// <summary>

/// 메인 폼

/// </summary>

public partial class MainForm : XtraForm

{

//////////////////////////////////////////////////////////////////////////////////////////////////// Field

////////////////////////////////////////////////////////////////////////////////////////// Private

#region Field

/// <summary>

/// 레이아웃 스트림

/// </summary>

private MemoryStream layoutStream = new MemoryStream();

/// <summary>

/// 접힌 상태 스트림

/// </summary>

private MemoryStream collapsedStateStream = new MemoryStream();

#endregion

//////////////////////////////////////////////////////////////////////////////////////////////////// Constructor

////////////////////////////////////////////////////////////////////////////////////////// Public

#region 생성자 - MainForm()

/// <summary>

/// 생성자

/// </summary>

public MainForm()

{

InitializeComponent();

this.clearButton.Enabled = false;

Load += Form_Load;

this.saveButton.Click += saveButton_Click;

this.loadButton.Click += loadButton_Click;

this.clearButton.Click += clearButton_Click;

}

#endregion

//////////////////////////////////////////////////////////////////////////////////////////////////// Method

////////////////////////////////////////////////////////////////////////////////////////// Private

#region 폼 로드시 처리하기 - Form_Load(sender, e)

/// <summary>

/// 폼 로드시 처리하기

/// </summary>

/// <param name="sender">이벤트 발생자</param>

/// <param name="e">이벤트 인자</param>

private void Form_Load(object sender, EventArgs e)

{

this.excelDataSource.FileName = "SalesPerson.xlsx";

this.excelDataSource.Fill();

this.pivotGridControl.DataSource = this.excelDataSource;

}

#endregion

#region Save 버튼 클릭시 처리하기 - saveButton_Click(sender, e)

/// <summary>

/// Save 버튼 클릭시 처리하기

/// </summary>

/// <param name="sender">이벤트 발생자</param>

/// <param name="e">이벤트 인자</param>

private void saveButton_Click(object sender, EventArgs e)

{

if(this.pivotGridControl.Fields.Count > 0)

{

this.layoutStream.Dispose();

this.layoutStream = new MemoryStream();

this.pivotGridControl.SaveLayoutToStream(this.layoutStream, OptionsLayoutBase.FullLayout);

this.collapsedStateStream.Dispose();

this.collapsedStateStream = new MemoryStream();

this.pivotGridControl.SaveCollapsedStateToStream(this.collapsedStateStream);

this.clearButton.Enabled = true;

}

#endregion

#region Load 버튼 클릭시 처리하기 - loadButton_Click(sender, e)

/// <summary>

/// Load 버튼 클릭시 처리하기

/// </summary>

/// <param name="sender">이벤트 발생자</param>

/// <param name="e">이벤트 인자</param>

private void loadButton_Click(object sender, EventArgs e)

{

if(this.layoutStream.Length > 0 && this.collapsedStateStream.Length > 0)

{

this.layoutStream.Seek(0, SeekOrigin.Begin);

this.pivotGridControl.RestoreLayoutFromStream(this.layoutStream, OptionsLayoutBase.FullLayout);

this.collapsedStateStream.Seek(0, SeekOrigin.Begin);

this.pivotGridControl.LoadCollapsedStateFromStream(this.collapsedStateStream);

}

#endregion

#region Clear 버튼 클릭시 처리하기 - clearButton_Click(sender, e)

/// <summary>

/// Clear 버튼 클릭시 처리하기

/// </summary>

/// <param name="sender">이벤트 발생자</param>

/// <param name="e">이벤트 인자</param>

private void clearButton_Click(object sender, EventArgs e)

{

if(this.layoutStream.Length > 0 && this.collapsedStateStream.Length > 0)

{

this.pivotGridControl.Fields.Clear();

}

#endregion

}

TestProject.zip

[C#/WINFORM/DEVEXPRESS] PivotGridControl 클래스 : CustomFieldValueCells 이벤트를 사용해 특정 행과 컬럼 숨기기

■ PivotGridControl 클래스의 CustomFieldValueCells 이벤트를 사용해 특정 행과 컬럼을 숨기는 방법을 보여준다. ▶ MainForm.cs


using System;
using System.Globalization;

using DevExpress.XtraEditors;
using DevExpress.XtraPivotGrid;

namespace TestProject
{
    /// <summary>
    /// 메인 폼
    /// </summary>
    public partial class MainForm : XtraForm
    {
        //////////////////////////////////////////////////////////////////////////////////////////////////// Constructor
        ////////////////////////////////////////////////////////////////////////////////////////// Public

        #region 생성자 - MainForm()

        /// <summary>
        /// 생성자
        /// </summary>
        public MainForm()
        {
            InitializeComponent();

            this.Load                                   += Form_Load;
            this.radioGroup.SelectedIndexChanged        += radioGroup_SelectedIndexChanged;
            this.pivotGridControl.CustomFieldValueCells += pivotGridControl_CustomFieldValueCells;
            this.pivotGridControl.FieldValueDisplayText += pivotGridControl_FieldValueDisplayText;
        }

        #endregion

        //////////////////////////////////////////////////////////////////////////////////////////////////// Method
        ////////////////////////////////////////////////////////////////////////////////////////// Private

        #region 폼 로드시 처리하기 - Form_Load(sender, e)

        /// <summary>
        /// 폼 로드시 처리하기
        /// </summary>
        /// <param name="sender">이벤트 발생자</param>
        /// <param name="e">이벤트 인자</param>
        private void Form_Load(object sender, EventArgs e)
        {
            ControlHelper.Initialize(this.pivotGridControl);

            this.pivotGridControl.DataSource = ControlHelper.GetDataTable();

            this.pivotGridControl.BestFit();
        }

        #endregion
        #region 라디오 그룹 선택 인덱스 변경시 처리하기 - radioGroup_SelectedIndexChanged(sender, e)

        /// <summary>
        /// 라디오 그룹 선택 인덱스 변경시 처리하기
        /// </summary>
        /// <param name="sender">이벤트 발생자</param>
        /// <param name="e">이벤트 인자</param>
        private void radioGroup_SelectedIndexChanged(object sender, EventArgs e)
        {
            this.pivotGridControl.LayoutChanged();
        }

        #endregion
        #region 피벗 그리드 컨트롤 필드 값 셀 커스텀 설정하기 - pivotGridControl_CustomFieldValueCells(sender, e)

        /// <summary>
        /// 피벗 그리드 컨트롤 필드 값 셀 커스텀 설정하기
        /// </summary>
        /// <param name="sender">이벤트 발생자</param>
        /// <param name="e">이벤트 인자</param>
        private void pivotGridControl_CustomFieldValueCells(object sender, PivotCustomFieldValueCellsEventArgs e)
        {
            PivotGridControl pivotGridControl = sender as PivotGridControl;

            if(pivotGridControl.DataSource == null)
            {
                return;
            }

            if(this.radioGroup.SelectedIndex == 0)
            {
                return;
            }

            for(int i = e.GetCellCount(false) - 1; i >= 0; i--)
            {
                FieldValueCell cell = e.GetCell(false, i);

                if(cell == null)
                {
                    continue;
                }

                if(object.Equals(cell.Value, "Employee B") && cell.ValueType != PivotGridValueType.Total)
                {
                    e.Remove(cell);
                }
            }
        }

        #endregion
        #region 피벗 그리드 컨트롤 필드 값 디스플레이 텍스트 설정하기 - pivotGridControl_FieldValueDisplayText(sender, e)

        /// <summary>
        /// 피벗 그리드 컨트롤 필드 값 디스플레이 텍스트 설정하기
        /// </summary>
        /// <param name="sender">이벤트 발생자</param>
        /// <param name="e">이벤트 인자</param>
        private void pivotGridControl_FieldValueDisplayText(object sender, PivotFieldDisplayTextEventArgs e)
        {
            PivotGridControl pivotGridControl = sender as PivotGridControl;

            if(e.Field == pivotGridControl.Fields[ControlHelper.Month])
            {
                e.DisplayText = CultureInfo.CurrentCulture.DateTimeFormat.GetMonthName((int)e.Value);
            }
        }

        #endregion
    }
}

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

using System;

using System.Globalization;

using DevExpress.XtraEditors;

using DevExpress.XtraPivotGrid;

namespace TestProject

{

/// <summary>

/// 메인 폼

/// </summary>

public partial class MainForm : XtraForm

{

//////////////////////////////////////////////////////////////////////////////////////////////////// Constructor

////////////////////////////////////////////////////////////////////////////////////////// Public

#region 생성자 - MainForm()

/// <summary>

/// 생성자

/// </summary>

public MainForm()

{

InitializeComponent();

this.Load += Form_Load;

this.radioGroup.SelectedIndexChanged += radioGroup_SelectedIndexChanged;

this.pivotGridControl.CustomFieldValueCells += pivotGridControl_CustomFieldValueCells;

this.pivotGridControl.FieldValueDisplayText += pivotGridControl_FieldValueDisplayText;

}

#endregion

//////////////////////////////////////////////////////////////////////////////////////////////////// Method

////////////////////////////////////////////////////////////////////////////////////////// Private

#region 폼 로드시 처리하기 - Form_Load(sender, e)

/// <summary>

/// 폼 로드시 처리하기

/// </summary>

/// <param name="sender">이벤트 발생자</param>

/// <param name="e">이벤트 인자</param>

private void Form_Load(object sender, EventArgs e)

{

ControlHelper.Initialize(this.pivotGridControl);

this.pivotGridControl.DataSource = ControlHelper.GetDataTable();

this.pivotGridControl.BestFit();

}

#endregion

#region 라디오 그룹 선택 인덱스 변경시 처리하기 - radioGroup_SelectedIndexChanged(sender, e)

/// <summary>

/// 라디오 그룹 선택 인덱스 변경시 처리하기

/// </summary>

/// <param name="sender">이벤트 발생자</param>

/// <param name="e">이벤트 인자</param>

private void radioGroup_SelectedIndexChanged(object sender, EventArgs e)

{

this.pivotGridControl.LayoutChanged();

}

#endregion

#region 피벗 그리드 컨트롤 필드 값 셀 커스텀 설정하기 - pivotGridControl_CustomFieldValueCells(sender, e)

/// <summary>

/// 피벗 그리드 컨트롤 필드 값 셀 커스텀 설정하기

/// </summary>

/// <param name="sender">이벤트 발생자</param>

/// <param name="e">이벤트 인자</param>

private void pivotGridControl_CustomFieldValueCells(object sender, PivotCustomFieldValueCellsEventArgs e)

{

PivotGridControl pivotGridControl = sender as PivotGridControl;

if(pivotGridControl.DataSource == null)

{

return;

}

if(this.radioGroup.SelectedIndex == 0)

{

return;

}

for(int i = e.GetCellCount(false) - 1; i >= 0; i--)

{

FieldValueCell cell = e.GetCell(false, i);

if(cell == null)

{

continue;

}

if(object.Equals(cell.Value, "Employee B") && cell.ValueType != PivotGridValueType.Total)

{

e.Remove(cell);

}

#endregion

#region 피벗 그리드 컨트롤 필드 값 디스플레이 텍스트 설정하기 - pivotGridControl_FieldValueDisplayText(sender, e)

/// <summary>

/// 피벗 그리드 컨트롤 필드 값 디스플레이 텍스트 설정하기

/// </summary>

/// <param name="sender">이벤트 발생자</param>

/// <param name="e">이벤트 인자</param>

private void pivotGridControl_FieldValueDisplayText(object sender, PivotFieldDisplayTextEventArgs e)

{

PivotGridControl pivotGridControl = sender as PivotGridControl;

if(e.Field == pivotGridControl.Fields[ControlHelper.Month])

{

e.DisplayText = CultureInfo.CurrentCulture.DateTimeFormat.GetMonthName((int)e.Value);

}

#endregion

}

TestProject.zip

[C#/WINFORM/DEVEXPRESS] PivotGridControl 클래스 : ShowingCustomizationForm 이벤트를 사용해 피벗 그리드 컨트롤 옆에 Customization 폼 표시하기

■ PivotGridControl 클래스의 ShowingCustomizationForm 이벤트를 사용해 피벗 그리드 컨트롤 옆에 Customization 폼을 표시하는 방법을 보여준다. ▶ MainForm.cs


using System;
using System.Windows.Forms;

using DevExpress.XtraEditors;
using DevExpress.XtraPivotGrid;
using DevExpress.XtraPivotGrid.Customization;

namespace TestProject
{
    /// <summary>
    /// 메인 폼
    /// </summary>
    public partial class MainForm : XtraForm
    {
        //////////////////////////////////////////////////////////////////////////////////////////////////// Constructor
        ////////////////////////////////////////////////////////////////////////////////////////// Public

        #region 생성자 - MainForm()

        /// <summary>
        /// 생성자
        /// </summary>
        public MainForm()
        {
            InitializeComponent();

            Load                                           += Form_Load;
            this.pivotGridControl.ShowingCustomizationForm += pivotGridControl_ShowingCustomizationForm;
        }

        #endregion

        //////////////////////////////////////////////////////////////////////////////////////////////////// Method
        ////////////////////////////////////////////////////////////////////////////////////////// Private

        #region 폼 로드시 처리하기 - Form_Load(sender, e)

        /// <summary>
        /// 폼 로드시 처리하기
        /// </summary>
        /// <param name="sender">이벤트 발생자</param>
        /// <param name="e">이벤트 인자</param>
        private void Form_Load(object sender, EventArgs e)
        {
            this.excelDataSource.FileName = "SalesPerson.xlsx";

            this.excelDataSource.Fill();

            this.pivotGridControl.OptionsCustomization.CustomizationFormStyle = CustomizationFormStyle.Excel2007;

            this.pivotGridControl.FieldsCustomization();
        }

        #endregion
        #region 피벗 그리드 컨트롤 Customization 폼 표시시 처리하기 - pivotGridControl_ShowingCustomizationForm(sender, e)

        /// <summary>
        /// 피벗 그리드 컨트롤 Customization 폼 표시시 처리하기
        /// </summary>
        /// <param name="sender">이벤트 발생자</param>
        /// <param name="e">이벤트 인자</param>
        private void pivotGridControl_ShowingCustomizationForm(object sender, CustomizationFormShowingEventArgs e)
        {
            e.ParentControl = this.splitContainerControl.Panel2;

            e.CustomizationForm.Dock = DockStyle.Fill;
        }

        #endregion
    }
}

using System;

using System.Windows.Forms;

using DevExpress.XtraEditors;

using DevExpress.XtraPivotGrid;

using DevExpress.XtraPivotGrid.Customization;

namespace TestProject

{

/// <summary>

/// 메인 폼

/// </summary>

public partial class MainForm : XtraForm

{

//////////////////////////////////////////////////////////////////////////////////////////////////// Constructor

////////////////////////////////////////////////////////////////////////////////////////// Public

#region 생성자 - MainForm()

/// <summary>

/// 생성자

/// </summary>

public MainForm()

{

InitializeComponent();

Load += Form_Load;

this.pivotGridControl.ShowingCustomizationForm += pivotGridControl_ShowingCustomizationForm;

}

#endregion

//////////////////////////////////////////////////////////////////////////////////////////////////// Method

////////////////////////////////////////////////////////////////////////////////////////// Private

#region 폼 로드시 처리하기 - Form_Load(sender, e)

/// <summary>

/// 폼 로드시 처리하기

/// </summary>

/// <param name="sender">이벤트 발생자</param>

/// <param name="e">이벤트 인자</param>

private void Form_Load(object sender, EventArgs e)

{

this.excelDataSource.FileName = "SalesPerson.xlsx";

this.excelDataSource.Fill();

this.pivotGridControl.OptionsCustomization.CustomizationFormStyle = CustomizationFormStyle.Excel2007;

this.pivotGridControl.FieldsCustomization();

}

#endregion

#region 피벗 그리드 컨트롤 Customization 폼 표시시 처리하기 - pivotGridControl_ShowingCustomizationForm(sender, e)

/// <summary>

/// 피벗 그리드 컨트롤 Customization 폼 표시시 처리하기

/// </summary>

/// <param name="sender">이벤트 발생자</param>

/// <param name="e">이벤트 인자</param>

private void pivotGridControl_ShowingCustomizationForm(object sender, CustomizationFormShowingEventArgs e)

{

e.ParentControl = this.splitContainerControl.Panel2;

e.CustomizationForm.Dock = DockStyle.Fill;

}

#endregion

}

TestProject.zip

[C#/WINFORM/DEVEXPRESS] PivotGridControl 클래스 : CustomFieldValueCells 이벤트를 사용해 필드 값 셀 분리하기

■ PivotGridControl 클래스의 CustomFieldValueCells 이벤트를 사용해 필드 값 셀을 분리하는 방법을 보여준다. ▶ MainForm.cs


using System;
using System.Collections.Generic;
using System.Globalization;

using DevExpress.XtraEditors;
using DevExpress.XtraPivotGrid;
using DevExpress.XtraPivotGrid.Data;

namespace TestProject
{
    /// <summary>
    /// 메인 폼
    /// </summary>
    public partial class MainForm : XtraForm
    {
        //////////////////////////////////////////////////////////////////////////////////////////////////// Constructor
        ////////////////////////////////////////////////////////////////////////////////////////// Public

        #region 생성자 - MainForm()

        /// <summary>
        /// 생성자
        /// </summary>
        public MainForm()
        {
            InitializeComponent();

            ControlHelper.Initialize(this.pivotGridControl);

            this.radioGroup.SelectedIndexChanged        += radioGroup_SelectedIndexChanged;
            this.pivotGridControl.CustomFieldValueCells += pivotGridControl_CustomFieldValueCells;
            this.pivotGridControl.FieldValueDisplayText += pivotGridControl_FieldValueDisplayText;

            this.pivotGridControl.DataSource = ControlHelper.GetDataTable();

            this.pivotGridControl.BestFit();
        }

        #endregion

        //////////////////////////////////////////////////////////////////////////////////////////////////// Method
        ////////////////////////////////////////////////////////////////////////////////////////// Private

        #region 라디오 그룹 선택 인덱스 변경시 처리하기 - radioGroup_SelectedIndexChanged(sender, e)

        /// <summary>
        /// 라디오 그룹 선택 인덱스 변경시 처리하기
        /// </summary>
        /// <param name="sender">이벤트 발생자</param>
        /// <param name="e">이벤트 인자</param>
        private void radioGroup_SelectedIndexChanged(object sender, EventArgs e)
        {
            this.pivotGridControl.LayoutChanged();
        }

        #endregion
        #region 피벗 그리드 컨트롤 필드 값 셀 커스텀 설정하기 - pivotGridControl_CustomFieldValueCells(sender, e)

        /// <summary>
        /// 피벗 그리드 컨트롤 필드 값 셀 커스텀 설정하기
        /// </summary>
        /// <param name="sender">이벤트 발생자</param>
        /// <param name="e">이벤트 인자</param>
        private void pivotGridControl_CustomFieldValueCells(object sender, PivotCustomFieldValueCellsEventArgs e)
        {
            PivotGridControl pivotGridControl = sender as PivotGridControl;

            if(pivotGridControl.DataSource == null)
            {
                return;
            }

            if(this.radioGroup.SelectedIndex == 0)
            {
                return;
            }

            Predicate<FieldValueCell> predicate = new Predicate<FieldValueCell>
            (
                delegate(FieldValueCell matchCell)
                {
                    return matchCell.ValueType == PivotGridValueType.GrandTotal && matchCell.Field == null;
                }
            );

            List<FieldValueSplitData> list = new List<FieldValueSplitData>(2);

            list.Add(new FieldValueSplitData("Price", 2));
            list.Add(new FieldValueSplitData("Count", 1));

            e.Split(true, predicate, list);
        }

        #endregion
        #region 피벗 그리드 컨트롤 필드 값 디스플레이 텍스트 설정하기 - pivotGridControl_FieldValueDisplayText(sender, e)

        /// <summary>
        /// 피벗 그리드 컨트롤 필드 값 디스플레이 텍스트 설정하기
        /// </summary>
        /// <param name="sender">이벤트 발생자</param>
        /// <param name="e">이벤트 인자</param>
        private void pivotGridControl_FieldValueDisplayText(object sender, PivotFieldDisplayTextEventArgs e)
        {
            PivotGridControl pivotGridControl = sender as PivotGridControl;

            if(e.Field == pivotGridControl.Fields[ControlHelper.Month])
            {
                e.DisplayText = CultureInfo.CurrentCulture.DateTimeFormat.GetMonthName((int)e.Value);
            }
        }

        #endregion
    }
}

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

using System;

using System.Collections.Generic;

using System.Globalization;

using DevExpress.XtraEditors;

using DevExpress.XtraPivotGrid;

using DevExpress.XtraPivotGrid.Data;

namespace TestProject

{

/// <summary>

/// 메인 폼

/// </summary>

public partial class MainForm : XtraForm

{

//////////////////////////////////////////////////////////////////////////////////////////////////// Constructor

////////////////////////////////////////////////////////////////////////////////////////// Public

#region 생성자 - MainForm()

/// <summary>

/// 생성자

/// </summary>

public MainForm()

{

InitializeComponent();

ControlHelper.Initialize(this.pivotGridControl);

this.radioGroup.SelectedIndexChanged += radioGroup_SelectedIndexChanged;

this.pivotGridControl.CustomFieldValueCells += pivotGridControl_CustomFieldValueCells;

this.pivotGridControl.FieldValueDisplayText += pivotGridControl_FieldValueDisplayText;

this.pivotGridControl.DataSource = ControlHelper.GetDataTable();

this.pivotGridControl.BestFit();

}

#endregion

//////////////////////////////////////////////////////////////////////////////////////////////////// Method

////////////////////////////////////////////////////////////////////////////////////////// Private

#region 라디오 그룹 선택 인덱스 변경시 처리하기 - radioGroup_SelectedIndexChanged(sender, e)

/// <summary>

/// 라디오 그룹 선택 인덱스 변경시 처리하기

/// </summary>

/// <param name="sender">이벤트 발생자</param>

/// <param name="e">이벤트 인자</param>

private void radioGroup_SelectedIndexChanged(object sender, EventArgs e)

{

this.pivotGridControl.LayoutChanged();

}

#endregion

#region 피벗 그리드 컨트롤 필드 값 셀 커스텀 설정하기 - pivotGridControl_CustomFieldValueCells(sender, e)

/// <summary>

/// 피벗 그리드 컨트롤 필드 값 셀 커스텀 설정하기

/// </summary>

/// <param name="sender">이벤트 발생자</param>

/// <param name="e">이벤트 인자</param>

private void pivotGridControl_CustomFieldValueCells(object sender, PivotCustomFieldValueCellsEventArgs e)

{

PivotGridControl pivotGridControl = sender as PivotGridControl;

if(pivotGridControl.DataSource == null)

{

return;

}

if(this.radioGroup.SelectedIndex == 0)

{

return;

}

Predicate<FieldValueCell> predicate = new Predicate<FieldValueCell>

(

delegate(FieldValueCell matchCell)

{

return matchCell.ValueType == PivotGridValueType.GrandTotal && matchCell.Field == null;

}

);

List<FieldValueSplitData> list = new List<FieldValueSplitData>(2);

list.Add(new FieldValueSplitData("Price", 2));

list.Add(new FieldValueSplitData("Count", 1));

e.Split(true, predicate, list);

}

#endregion

#region 피벗 그리드 컨트롤 필드 값 디스플레이 텍스트 설정하기 - pivotGridControl_FieldValueDisplayText(sender, e)

/// <summary>

/// 피벗 그리드 컨트롤 필드 값 디스플레이 텍스트 설정하기

/// </summary>

/// <param name="sender">이벤트 발생자</param>

/// <param name="e">이벤트 인자</param>

private void pivotGridControl_FieldValueDisplayText(object sender, PivotFieldDisplayTextEventArgs e)

{

PivotGridControl pivotGridControl = sender as PivotGridControl;

if(e.Field == pivotGridControl.Fields[ControlHelper.Month])

{

e.DisplayText = CultureInfo.CurrentCulture.DateTimeFormat.GetMonthName((int)e.Value);

}

#endregion

}

TestProject.zip

[C#/WINFORM/DEVEXPRESS] PivotGridControl 클래스 : EditValueChanged 이벤트를 사용해 셀 값 편집하기

■ PivotGridControl 클래스의 EditValueChanged 이벤트를 사용해 셀 값을 편집하는 방법을 보여준다. ▶ MainForm.cs


using System;

using DevExpress.XtraEditors;
using DevExpress.XtraPivotGrid;

namespace TestProject
{
    /// <summary>
    /// 메인 폼
    /// </summary>
    public partial class MainForm : XtraForm
    {
        //////////////////////////////////////////////////////////////////////////////////////////////////// Constructor
        ////////////////////////////////////////////////////////////////////////////////////////// Public

        #region 생성자 - MainForm()

        /// <summary>
        /// 생성자
        /// </summary>
        public MainForm()
        {
            InitializeComponent();

            this.pivotGridControl.EditValueChanged += pivotGridControl_EditValueChanged;
            this.pivotGridControl.CustomCellValue  += pivotGridControl_CustomCellValue;

            this.pivotGridControl.DataSource = DataHelper.GetOrderCollection();

            this.pivotGridControl.BestFit();
        }

        #endregion

        //////////////////////////////////////////////////////////////////////////////////////////////////// Method
        ////////////////////////////////////////////////////////////////////////////////////////// Private
        //////////////////////////////////////////////////////////////////////////////// Event

        #region 피벗 그리드 컨트롤 셀 값 커스텀 설정하기 - pivotGridControl_CustomCellValue(sender, e)

        /// <summary>
        /// 피벗 그리드 컨트롤 셀 값 커스텀 설정하기
        /// </summary>
        /// <param name="sender">이벤트 발생자</param>
        /// <param name="e">이벤트 인자</param>
        private void pivotGridControl_CustomCellValue(object sender, PivotCellValueEventArgs e)
        {
            if(e.DataField.Name == "fieldNeedVerification" && e.Value != null)
            {
                e.Value = (Convert.ToInt32(e.Value) > 0) ? true : false;
            }
        }

        #endregion
        #region 피벗 그리드 컨트롤 편집 값 변경시 처리하기 - pivotGridControl_EditValueChanged(sender, e)

        /// <summary>
        /// 피벗 그리드 컨트롤 편집 값 변경시 처리하기
        /// </summary>
        /// <param name="sender">이벤트 발생자</param>
        /// <param name="e">이벤트 인자</param>
        private void pivotGridControl_EditValueChanged(object sender, EditValueChangedEventArgs e)
        {
            ChangeCellValue(e, Convert.ToBoolean(e.Value), Convert.ToBoolean(e.Editor.EditValue));
        }

        #endregion

        //////////////////////////////////////////////////////////////////////////////// Function

        #region 셀 값 변경하기 - ChangeCellValue(e, currentValue, newValue)

        /// <summary>
        /// 셀 값 변경하기
        /// </summary>
        /// <param name="e">이벤트 인자</param>
        /// <param name="currentValue">현재 값</param>
        /// <param name="newValue">신규 값</param>
        private void ChangeCellValue(EditValueChangedEventArgs e, bool currentValue, bool newValue)
        {
            PivotDrillDownDataSource dataSource = e.CreateDrillDownDataSource();

            for(int i = 0; i < dataSource.RowCount; i++)
            {
                dataSource.SetValue(i, e.DataField, newValue);
            }
        }

        #endregion
    }
}

using System;

using DevExpress.XtraEditors;

using DevExpress.XtraPivotGrid;

namespace TestProject

{

/// <summary>

/// 메인 폼

/// </summary>

public partial class MainForm : XtraForm

{

//////////////////////////////////////////////////////////////////////////////////////////////////// Constructor

////////////////////////////////////////////////////////////////////////////////////////// Public

#region 생성자 - MainForm()

/// <summary>

/// 생성자

/// </summary>

public MainForm()

{

InitializeComponent();

this.pivotGridControl.EditValueChanged += pivotGridControl_EditValueChanged;

this.pivotGridControl.CustomCellValue += pivotGridControl_CustomCellValue;

this.pivotGridControl.DataSource = DataHelper.GetOrderCollection();

this.pivotGridControl.BestFit();

}

#endregion

//////////////////////////////////////////////////////////////////////////////////////////////////// Method

////////////////////////////////////////////////////////////////////////////////////////// Private

//////////////////////////////////////////////////////////////////////////////// Event

#region 피벗 그리드 컨트롤 셀 값 커스텀 설정하기 - pivotGridControl_CustomCellValue(sender, e)

/// <summary>

/// 피벗 그리드 컨트롤 셀 값 커스텀 설정하기

/// </summary>

/// <param name="sender">이벤트 발생자</param>

/// <param name="e">이벤트 인자</param>

private void pivotGridControl_CustomCellValue(object sender, PivotCellValueEventArgs e)

{

if(e.DataField.Name == "fieldNeedVerification" && e.Value != null)

{

e.Value = (Convert.ToInt32(e.Value) > 0) ? true : false;

}

#endregion

#region 피벗 그리드 컨트롤 편집 값 변경시 처리하기 - pivotGridControl_EditValueChanged(sender, e)

/// <summary>

/// 피벗 그리드 컨트롤 편집 값 변경시 처리하기

/// </summary>

/// <param name="sender">이벤트 발생자</param>

/// <param name="e">이벤트 인자</param>

private void pivotGridControl_EditValueChanged(object sender, EditValueChangedEventArgs e)

{

ChangeCellValue(e, Convert.ToBoolean(e.Value), Convert.ToBoolean(e.Editor.EditValue));

}

#endregion

//////////////////////////////////////////////////////////////////////////////// Function

#region 셀 값 변경하기 - ChangeCellValue(e, currentValue, newValue)

/// <summary>

/// 셀 값 변경하기

/// </summary>

/// <param name="e">이벤트 인자</param>

/// <param name="currentValue">현재 값</param>

/// <param name="newValue">신규 값</param>

private void ChangeCellValue(EditValueChangedEventArgs e, bool currentValue, bool newValue)

{

PivotDrillDownDataSource dataSource = e.CreateDrillDownDataSource();

for(int i = 0; i < dataSource.RowCount; i++)

{

dataSource.SetValue(i, e.DataField, newValue);

}

#endregion

}

※ Need Verifcation 항목을 수정해도 최초값으로 리셋된다. TestProject.zip

[C#/WINFORM/DEVEXPRESS] PivotGridControl 클래스 : CreateDrillDownDataSourceAsync 메소드를 사용해 비동기 기본 데이터 소스 생성하기

■ PivotGridControl 클래스의 CreateDrillDownDataSourceAsync 메소드를 사용해 비동기 기본 데이터 소스를 생성하는 방법을 보여준다. ▶ PopupForm.cs


using System;

using DevExpress.Data;
using DevExpress.Utils;
using DevExpress.XtraEditors;

namespace TestProject
{
    /// <summary>
    /// 팝업 폼
    /// </summary>
    public partial class PopupForm : XtraForm
    {
        //////////////////////////////////////////////////////////////////////////////////////////////////// Property
        ////////////////////////////////////////////////////////////////////////////////////////// Public

        #region 데이터 소스 - DataSource

        /// <summary>
        /// 데이터 소스
        /// </summary>
        public object DataSource
        {
            get
            {
                return this.gridControl.DataSource;
            }
            set
            {
                this.gridControl.DataSource = value;
            }
        }

        #endregion

        //////////////////////////////////////////////////////////////////////////////////////////////////// Constructor
        ////////////////////////////////////////////////////////////////////////////////////////// Public

        #region 생성자 - PopupForm()

        /// <summary>
        /// 생성자
        /// </summary>
        public PopupForm()
        {
            InitializeComponent();

            this.gridControl.DataSourceChanged += gridControl_DataSourceChanged;
        }

        #endregion

        //////////////////////////////////////////////////////////////////////////////////////////////////// Method
        ////////////////////////////////////////////////////////////////////////////////////////// Private

        #region 그리드 컨트롤 데이터 소스 변경시 처리하기 - gridControl_DataSourceChanged(sender, e)

        /// <summary>
        /// 그리드 컨트롤 데이터 소스 변경시 처리하기
        /// </summary>
        /// <param name="sender">이벤트 발생자</param>
        /// <param name="e">이벤트 인자</param>
        private void gridControl_DataSourceChanged(object sender, EventArgs e)
        {
            this.gridView.Columns["OrderDate"].SummaryItem.SummaryType  = SummaryItemType.Count;
            this.gridView.Columns["OrderDate"].DisplayFormat.FormatType = FormatType.DateTime;

            this.gridView.Columns["Country"].Group();

            this.gridView.Columns["City"].Group();

            this.gridView.Columns["ProductName"].Group();

            this.gridView.ExpandAllGroups();
        }

        #endregion
    }
}

using System;

using DevExpress.Data;

using DevExpress.Utils;

using DevExpress.XtraEditors;

namespace TestProject

{

/// <summary>

/// 팝업 폼

/// </summary>

public partial class PopupForm : XtraForm

{

//////////////////////////////////////////////////////////////////////////////////////////////////// Property

////////////////////////////////////////////////////////////////////////////////////////// Public

#region 데이터 소스 - DataSource

/// <summary>

/// 데이터 소스

/// </summary>

public object DataSource

{

get

{

return this.gridControl.DataSource;

}

set

{

this.gridControl.DataSource = value;

}

#endregion

//////////////////////////////////////////////////////////////////////////////////////////////////// Constructor

////////////////////////////////////////////////////////////////////////////////////////// Public

#region 생성자 - PopupForm()

/// <summary>

/// 생성자

/// </summary>

public PopupForm()

{

InitializeComponent();

this.gridControl.DataSourceChanged += gridControl_DataSourceChanged;

}

#endregion

//////////////////////////////////////////////////////////////////////////////////////////////////// Method

////////////////////////////////////////////////////////////////////////////////////////// Private

#region 그리드 컨트롤 데이터 소스 변경시 처리하기 - gridControl_DataSourceChanged(sender, e)

/// <summary>

/// 그리드 컨트롤 데이터 소스 변경시 처리하기

/// </summary>

/// <param name="sender">이벤트 발생자</param>

/// <param name="e">이벤트 인자</param>

private void gridControl_DataSourceChanged(object sender, EventArgs e)

{

this.gridView.Columns["OrderDate"].SummaryItem.SummaryType = SummaryItemType.Count;

this.gridView.Columns["OrderDate"].DisplayFormat.FormatType = FormatType.DateTime;

this.gridView.Columns["Country"].Group();

this.gridView.Columns["City"].Group();

this.gridView.Columns["ProductName"].Group();

this.gridView.ExpandAllGroups();

}

#endregion

}

▶ MainForm.cs


using System.Collections.Generic;

using DevExpress.XtraEditors;
using DevExpress.XtraPivotGrid;

namespace TestProject
{
    /// <summary>
    /// 메인 폼
    /// </summary>
    public partial class MainForm : XtraForm
    {
        //////////////////////////////////////////////////////////////////////////////////////////////////// Field
        ////////////////////////////////////////////////////////////////////////////////////////// Private

        #region Field

        /// <summary>
        /// 팝업 폼
        /// </summary>
        private PopupForm popupForm;

        #endregion

        //////////////////////////////////////////////////////////////////////////////////////////////////// Constructor
        ////////////////////////////////////////////////////////////////////////////////////////// Public

        #region 생성자 - MainForm()

        /// <summary>
        /// 생성자
        /// </summary>
        public MainForm()
        {
            InitializeComponent();

            this.pivotGridControl.CellClick += pivotGridControl_CellClick;

            this.linqServerModeSource.QueryableSource = new DataClasses1DataContext().Invoices;

            SetPopupForm();
        }

        #endregion

        //////////////////////////////////////////////////////////////////////////////////////////////////// Method
        ////////////////////////////////////////////////////////////////////////////////////////// Private
        //////////////////////////////////////////////////////////////////////////////// Event

        #region 피벗 그리드 컨트롤 셀 클릭시 처리하기 - pivotGridControl_CellClick(sender, e)

        /// <summary>
        /// 피벗 그리드 컨트롤 셀 클릭시 처리하기
        /// </summary>
        /// <param name="sender">이벤트 발생자</param>
        /// <param name="e">이벤트 인자</param>
        private void pivotGridControl_CellClick(object sender, PivotCellEventArgs e)
        {
            PivotGridControl pivotGridControl = sender as PivotGridControl;

            if(this.popupForm.IsDisposed)
            {
                SetPopupForm();
            }

            if(!pivotGridControl.IsAsyncInProgress)
            {
                pivotGridControl.CreateDrillDownDataSourceAsync
                (
                    e.ColumnIndex,
                    e.RowIndex,
                    25,
                    new List<string> { "ProductName","Quantity" },
                    result => {
                        this.popupForm.DataSource = (PivotDrillDownDataSource)result.Value;
                    }
                );
            }
        }

        #endregion

        //////////////////////////////////////////////////////////////////////////////// Function

        #region 팝업 폼 설정하기 - SetPopupForm()

        /// <summary>
        /// 팝업 폼 설정하기
        /// </summary>
        private void SetPopupForm()
        {
            this.popupForm = new PopupForm();

            this.popupForm.Show();
        }

        #endregion
    }
}

100

101

using System.Collections.Generic;

using DevExpress.XtraEditors;

using DevExpress.XtraPivotGrid;

namespace TestProject

{

/// <summary>

/// 메인 폼

/// </summary>

public partial class MainForm : XtraForm

{

//////////////////////////////////////////////////////////////////////////////////////////////////// Field

////////////////////////////////////////////////////////////////////////////////////////// Private

#region Field

/// <summary>

/// 팝업 폼

/// </summary>

private PopupForm popupForm;

#endregion

//////////////////////////////////////////////////////////////////////////////////////////////////// Constructor

////////////////////////////////////////////////////////////////////////////////////////// Public

#region 생성자 - MainForm()

/// <summary>

/// 생성자

/// </summary>

public MainForm()

{

InitializeComponent();

this.pivotGridControl.CellClick += pivotGridControl_CellClick;

this.linqServerModeSource.QueryableSource = new DataClasses1DataContext().Invoices;

SetPopupForm();

}

#endregion

//////////////////////////////////////////////////////////////////////////////////////////////////// Method

////////////////////////////////////////////////////////////////////////////////////////// Private

//////////////////////////////////////////////////////////////////////////////// Event

#region 피벗 그리드 컨트롤 셀 클릭시 처리하기 - pivotGridControl_CellClick(sender, e)

/// <summary>

/// 피벗 그리드 컨트롤 셀 클릭시 처리하기

/// </summary>

/// <param name="sender">이벤트 발생자</param>

/// <param name="e">이벤트 인자</param>

private void pivotGridControl_CellClick(object sender, PivotCellEventArgs e)

{

PivotGridControl pivotGridControl = sender as PivotGridControl;

if(this.popupForm.IsDisposed)

{

SetPopupForm();

}

if(!pivotGridControl.IsAsyncInProgress)

{

pivotGridControl.CreateDrillDownDataSourceAsync

(

e.ColumnIndex,

e.RowIndex,

25,

new List<string> { "ProductName","Quantity" },

result => {

this.popupForm.DataSource = (PivotDrillDownDataSource)result.Value;

}

);

}

#endregion

//////////////////////////////////////////////////////////////////////////////// Function

#region 팝업 폼 설정하기 - SetPopupForm()

/// <summary>

/// 팝업 폼 설정하기

/// </summary>

private void SetPopupForm()

{

this.popupForm = new PopupForm();

this.popupForm.Show();

}

#endregion

}

TestProject.zip

[C#/WINFORM/DEVEXPRESS] PivotGridControl 클래스 : CustomFilterPopupItems 이벤트를 사용해 필터 드롭 다운 항목 정렬 커스텀 설정하기

■ PivotGridControl 클래스의 CustomFilterPopupItems 이벤트를 사용해 필터 드롭 다운 항목의 정렬을 커스텀 설정하는 방법을 보여준다. ▶ MainForm.cs


using System;
using System.Collections;

using DevExpress.XtraEditors;
using DevExpress.XtraPivotGrid;

namespace TestProject
{
    /// <summary>
    /// 메인 폼
    /// </summary>
    public partial class MainForm : XtraForm
    {
        //////////////////////////////////////////////////////////////////////////////////////////////////// Constructor
        ////////////////////////////////////////////////////////////////////////////////////////// Public

        #region 생성자 - MainForm()

        /// <summary>
        /// 생성자
        /// </summary>
        public MainForm()
        {
            InitializeComponent();

            this.excelDataSource.FileName = "SalesPerson.xlsx";

            this.excelDataSource.Fill();

            this.alphabeticallyRadioButton.CheckedChanged += alphabeticallyRadioButton_CheckedChanged;
            this.pivotGridControl.CustomFilterPopupItems  += pivotGridControl_CustomFilterPopupItems;

            this.pivotGridControl.DataSource = this.excelDataSource;

            this.pivotGridControl.BestFit();
        }

        #endregion

        //////////////////////////////////////////////////////////////////////////////////////////////////// Method
        ////////////////////////////////////////////////////////////////////////////////////////// Private

        #region Alphabetically 라디오 버튼 체크 변경시 처리하기 - alphabeticallyRadioButton_CheckedChanged(sender, e)

        /// <summary>
        /// Alphabetically 라디오 버튼 체크 변경시 처리하기
        /// </summary>
        /// <param name="sender">이벤트 발생자</param>
        /// <param name="e">이벤트 인자</param>
        private void alphabeticallyRadioButton_CheckedChanged(object sender, EventArgs e)
        {
            this.productNameField.ShowFilterPopup();
        }

        #endregion
        #region 피벗 그리드 컨트롤 필터 팝업 항목 커스텀 설정하기 - pivotGridControl_CustomFilterPopupItems(sender, e)

        /// <summary>
        /// 피벗 그리드 컨트롤 필터 팝업 항목 커스텀 설정하기
        /// </summary>
        /// <param name="sender">이벤트 발생자</param>
        /// <param name="e">이벤트 인자</param>
        private void pivotGridControl_CustomFilterPopupItems(object sender, PivotCustomFilterPopupItemsEventArgs e)
        {
            if(this.byCaptionLengthRadioButton.Checked)
            {
                ArrayList.Adapter((IList)e.Items).Sort(new FilterItemComparer());
            }
        }

        #endregion
    }
}

using System;

using System.Collections;

using DevExpress.XtraEditors;

using DevExpress.XtraPivotGrid;

namespace TestProject

{

/// <summary>

/// 메인 폼

/// </summary>

public partial class MainForm : XtraForm

{

//////////////////////////////////////////////////////////////////////////////////////////////////// Constructor

////////////////////////////////////////////////////////////////////////////////////////// Public

#region 생성자 - MainForm()

/// <summary>

/// 생성자

/// </summary>

public MainForm()

{

InitializeComponent();

this.excelDataSource.FileName = "SalesPerson.xlsx";

this.excelDataSource.Fill();

this.alphabeticallyRadioButton.CheckedChanged += alphabeticallyRadioButton_CheckedChanged;

this.pivotGridControl.CustomFilterPopupItems += pivotGridControl_CustomFilterPopupItems;

this.pivotGridControl.DataSource = this.excelDataSource;

this.pivotGridControl.BestFit();

}

#endregion

//////////////////////////////////////////////////////////////////////////////////////////////////// Method

////////////////////////////////////////////////////////////////////////////////////////// Private

#region Alphabetically 라디오 버튼 체크 변경시 처리하기 - alphabeticallyRadioButton_CheckedChanged(sender, e)

/// <summary>

/// Alphabetically 라디오 버튼 체크 변경시 처리하기

/// </summary>

/// <param name="sender">이벤트 발생자</param>

/// <param name="e">이벤트 인자</param>

private void alphabeticallyRadioButton_CheckedChanged(object sender, EventArgs e)

{

this.productNameField.ShowFilterPopup();

}

#endregion

#region 피벗 그리드 컨트롤 필터 팝업 항목 커스텀 설정하기 - pivotGridControl_CustomFilterPopupItems(sender, e)

/// <summary>

/// 피벗 그리드 컨트롤 필터 팝업 항목 커스텀 설정하기

/// </summary>

/// <param name="sender">이벤트 발생자</param>

/// <param name="e">이벤트 인자</param>

private void pivotGridControl_CustomFilterPopupItems(object sender, PivotCustomFilterPopupItemsEventArgs e)

{

if(this.byCaptionLengthRadioButton.Checked)

{

ArrayList.Adapter((IList)e.Items).Sort(new FilterItemComparer());

}

#endregion

}

TestProject.zip

[C#/WINFORM/DEVEXPRESS] PivotGridControl 클래스 : Groups 속성을 사용해 그룹 필터 설정하기

■ PivotGridControl 클래스의 Groups 속성을 사용해 그룹 필터를 설정하는 방법을 보여준다. ▶ MainForm.cs


using DevExpress.XtraEditors;
using DevExpress.XtraPivotGrid;

namespace TestProject
{
    /// <summary>
    /// 메인 폼
    /// </summary>
    public partial class MainForm : XtraForm
    {
        //////////////////////////////////////////////////////////////////////////////////////////////////// Constructor
        ////////////////////////////////////////////////////////////////////////////////////////// Public

        #region 생성자 - MainForm()

        /// <summary>
        /// 생성자
        /// </summary>
        public MainForm()
        {
            InitializeComponent();

            this.tableAdapter.Fill(this.nwindDataSet.SalesPerson);

            PivotGridGroup orderDateGroup = this.pivotGridControl.Groups[0];

            orderDateGroup.FilterValues.BeginUpdate();

            orderDateGroup.FilterValues.FilterType = PivotFilterType.Included;

            orderDateGroup.FilterValues.Values.Add(new PivotGroupFilterValue(2014));

            orderDateGroup.FilterValues.Values.Add(2015).ChildValues.Add(1);

            orderDateGroup.FilterValues.EndUpdate();
        }

        #endregion
    }
}

using DevExpress.XtraEditors;

using DevExpress.XtraPivotGrid;

namespace TestProject

{

/// <summary>

/// 메인 폼

/// </summary>

public partial class MainForm : XtraForm

{

//////////////////////////////////////////////////////////////////////////////////////////////////// Constructor

////////////////////////////////////////////////////////////////////////////////////////// Public

#region 생성자 - MainForm()

/// <summary>

/// 생성자

/// </summary>

public MainForm()

{

InitializeComponent();

this.tableAdapter.Fill(this.nwindDataSet.SalesPerson);

PivotGridGroup orderDateGroup = this.pivotGridControl.Groups[0];

orderDateGroup.FilterValues.BeginUpdate();

orderDateGroup.FilterValues.FilterType = PivotFilterType.Included;

orderDateGroup.FilterValues.Values.Add(new PivotGroupFilterValue(2014));

orderDateGroup.FilterValues.Values.Add(2015).ChildValues.Add(1);

orderDateGroup.FilterValues.EndUpdate();

}

#endregion

}

TestProject.zip

[C#/WINFORM/DEVEXPRESS] PivotGridControl 클래스 : CustomFilterPopupItems 이벤트를 사용해 필터 드롭 다운 리스트에서 항목 삭제하기

■ PivotGridControl 클래스의 CustomFilterPopupItems 이벤트를 사용해 필터 드롭 다운 리스트에서 항목을 삭제하는 방법을 보여준다. ▶ MainForm.cs


using DevExpress.XtraEditors;
using DevExpress.XtraPivotGrid;
using DevExpress.XtraPivotGrid.Data;

namespace TestProject
{
    /// <summary>
    /// 메인 폼
    /// </summary>
    public partial class MainForm : XtraForm
    {
        //////////////////////////////////////////////////////////////////////////////////////////////////// Field
        ////////////////////////////////////////////////////////////////////////////////////////// Private

        #region Field

        /// <summary>
        /// 더미 항목
        /// </summary>
        private readonly object dummyItem = new object();

        #endregion

        //////////////////////////////////////////////////////////////////////////////////////////////////// Constructor
        ////////////////////////////////////////////////////////////////////////////////////////// Public

        #region 생성자 - MainForm()

        /// <summary>
        /// 생성자
        /// </summary>
        public MainForm()
        {
            InitializeComponent();

            this.tableAdapter.Fill(this.productReport._ProductReports);

            this.pivotGridControl.CustomFilterPopupItems += pivotGridControl_CustomFilterPopupItems;
        }

        #endregion

        //////////////////////////////////////////////////////////////////////////////////////////////////// Method
        ////////////////////////////////////////////////////////////////////////////////////////// Private

        #region 피벗 그리드 컨트롤 필터 팝업 항목 커스텀 설정하기 - pivotGridControl_CustomFilterPopupItems(sender, e)

        /// <summary>
        /// 피벗 그리드 컨트롤 필터 팝업 항목 커스텀 설정하기
        /// </summary>
        /// <param name="sender">이벤트 발생자</param>
        /// <param name="e">이벤트 인자</param>
        private void pivotGridControl_CustomFilterPopupItems(object sender, PivotCustomFilterPopupItemsEventArgs e)
        {
            if(object.ReferenceEquals(e.Field, this.categoryNameField))
            {
                for(int i = e.Items.Count - 1; i >= 0; i--)
                {
                    if(object.Equals(e.Items[i].Value, "Beverages"))
                    {
                        e.Items.RemoveAt(i);

                        break;
                    }
                }
            }
        }

        #endregion
    }
}

using DevExpress.XtraEditors;

using DevExpress.XtraPivotGrid;

using DevExpress.XtraPivotGrid.Data;

namespace TestProject

{

/// <summary>

/// 메인 폼

/// </summary>

public partial class MainForm : XtraForm

{

//////////////////////////////////////////////////////////////////////////////////////////////////// Field

////////////////////////////////////////////////////////////////////////////////////////// Private

#region Field

/// <summary>

/// 더미 항목

/// </summary>

private readonly object dummyItem = new object();

#endregion

//////////////////////////////////////////////////////////////////////////////////////////////////// Constructor

////////////////////////////////////////////////////////////////////////////////////////// Public

#region 생성자 - MainForm()

/// <summary>

/// 생성자

/// </summary>

public MainForm()

{

InitializeComponent();

this.tableAdapter.Fill(this.productReport._ProductReports);

this.pivotGridControl.CustomFilterPopupItems += pivotGridControl_CustomFilterPopupItems;

}

#endregion

//////////////////////////////////////////////////////////////////////////////////////////////////// Method

////////////////////////////////////////////////////////////////////////////////////////// Private

#region 피벗 그리드 컨트롤 필터 팝업 항목 커스텀 설정하기 - pivotGridControl_CustomFilterPopupItems(sender, e)

/// <summary>

/// 피벗 그리드 컨트롤 필터 팝업 항목 커스텀 설정하기

/// </summary>

/// <param name="sender">이벤트 발생자</param>

/// <param name="e">이벤트 인자</param>

private void pivotGridControl_CustomFilterPopupItems(object sender, PivotCustomFilterPopupItemsEventArgs e)

{

if(object.ReferenceEquals(e.Field, this.categoryNameField))

{

for(int i = e.Items.Count - 1; i >= 0; i--)

{

if(object.Equals(e.Items[i].Value, "Beverages"))

{

e.Items.RemoveAt(i);

break;

}

#endregion

}

TestProject.zip

[C#/WINFORM/DEVEXPRESS] PivotGridControl 클래스 : FieldFilterChanging 이벤트를 사용해 필터 조건 변경 방지하기

■ PivotGridControl 클래스의 FieldFilterChanging 이벤트를 사용해 필터 조건의 변경을 방지하는 방법을 보여준다. ▶ MainForm.cs


using System.Windows.Forms;

using DevExpress.XtraEditors;
using DevExpress.XtraPivotGrid;

namespace TestProject
{
    /// <summary>
    /// 메인 폼
    /// </summary>
    public partial class MainForm : XtraForm
    {
        //////////////////////////////////////////////////////////////////////////////////////////////////// Constructor
        ////////////////////////////////////////////////////////////////////////////////////////// Public

        #region 생성자 - MainForm()

        /// <summary>
        /// 생성자
        /// </summary>
        public MainForm()
        {
            InitializeComponent();

            this.tableAdapter.Fill(this.productReport._ProductReports);

            this.pivotGridControl.FieldFilterChanging += pivotGridControl_FieldFilterChanging;
        }

        #endregion

        //////////////////////////////////////////////////////////////////////////////////////////////////// Method
        ////////////////////////////////////////////////////////////////////////////////////////// Private

        #region 피벗 그리드 컨트롤 필드 필터 변경 전 처리하기 - pivotGridControl_FieldFilterChanging(sender, e)

        /// <summary>
        /// 피벗 그리드 컨트롤 필드 필터 변경 전 처리하기
        /// </summary>
        /// <param name="sender">이벤트 발생자</param>
        /// <param name="e">이벤트 인자</param>
        private void pivotGridControl_FieldFilterChanging(object sender, PivotFieldFilterChangingEventArgs e)
        {
            if(object.ReferenceEquals(e.Field, this.categoryNameField))
            {
                if
                (
                    (e.Field.FilterValues.FilterType == PivotFilterType.Excluded &&  e.Values.Contains("Beverages")) ||
                    (e.Field.FilterValues.FilterType == PivotFilterType.Included && !e.Values.Contains("Beverages"))
                )
                {
                    XtraMessageBox.Show
                    (
                        this,
                        "You are not allowed to hide the 'Beverages' value.",
                        "INFORMATION",
                        MessageBoxButtons.OK,
                        MessageBoxIcon.Information
                    );

                    e.Cancel = true;
                }
            }
        }

        #endregion
    }
}

using System.Windows.Forms;

using DevExpress.XtraEditors;

using DevExpress.XtraPivotGrid;

namespace TestProject

{

/// <summary>

/// 메인 폼

/// </summary>

public partial class MainForm : XtraForm

{

//////////////////////////////////////////////////////////////////////////////////////////////////// Constructor

////////////////////////////////////////////////////////////////////////////////////////// Public

#region 생성자 - MainForm()

/// <summary>

/// 생성자

/// </summary>

public MainForm()

{

InitializeComponent();

this.tableAdapter.Fill(this.productReport._ProductReports);

this.pivotGridControl.FieldFilterChanging += pivotGridControl_FieldFilterChanging;

}

#endregion

//////////////////////////////////////////////////////////////////////////////////////////////////// Method

////////////////////////////////////////////////////////////////////////////////////////// Private

#region 피벗 그리드 컨트롤 필드 필터 변경 전 처리하기 - pivotGridControl_FieldFilterChanging(sender, e)

/// <summary>

/// 피벗 그리드 컨트롤 필드 필터 변경 전 처리하기

/// </summary>

/// <param name="sender">이벤트 발생자</param>

/// <param name="e">이벤트 인자</param>

private void pivotGridControl_FieldFilterChanging(object sender, PivotFieldFilterChangingEventArgs e)

{

if(object.ReferenceEquals(e.Field, this.categoryNameField))

{

(

(e.Field.FilterValues.FilterType == PivotFilterType.Excluded && e.Values.Contains("Beverages")) ||

(e.Field.FilterValues.FilterType == PivotFilterType.Included && !e.Values.Contains("Beverages"))

)

{

XtraMessageBox.Show

(

this,

"You are not allowed to hide the 'Beverages' value.",

"INFORMATION",

MessageBoxButtons.OK,

MessageBoxIcon.Information

);

e.Cancel = true;

}

#endregion

}

TestProject.zip

[C#/WINFORM/DEVEXPRESS] PivotGridField 클래스 : CustomGroupInterval 이벤트를 사용해 그룹 간격 커스텀 설정하기

■ PivotGridField 클래스의 CustomGroupInterval 이벤트를 사용해 그룹 간격을 커스텀 설정하는 방법을 보여준다. ▶ MainForm.cs


using System;
using System.Data.OleDb;

using DevExpress.Data.PivotGrid;
using DevExpress.XtraEditors;
using DevExpress.XtraPivotGrid;

namespace TestProject
{
    /// <summary>
    /// 메인 폼
    /// </summary>
    public partial class MainForm : XtraForm
    {
        //////////////////////////////////////////////////////////////////////////////////////////////////// Field
        ////////////////////////////////////////////////////////////////////////////////////////// Private

        #region Field

        /// <summary>
        /// 연결
        /// </summary>
        private OleDbConnection connection;

        #endregion

        //////////////////////////////////////////////////////////////////////////////////////////////////// Constructor
        ////////////////////////////////////////////////////////////////////////////////////////// Public

        #region 생성자 - MainForm()

        /// <summary>
        /// 생성자
        /// </summary>
        public MainForm()
        {
            InitializeComponent();

            this.connection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=nwind.mdb");

            this.pivotGridControl.OptionsView.RowTotalsLocation = PivotRowTotalsLocation.Tree;

            this.pivotGridControl.CustomGroupInterval += pivotGridControl_CustomGroupInterval;

            this.pivotGridControl.DataSource = Order.GetOrderList(this.connection);

            this.pivotGridControl.RetrieveFields();

            PivotGridField countryCategoryField = new PivotGridField();

            countryCategoryField.FieldName     = "ShipCountry";
            countryCategoryField.Caption       = "Country Category";
            countryCategoryField.Area          = PivotArea.RowArea;
            countryCategoryField.GroupInterval = PivotGroupInterval.Custom;

            this.pivotGridControl.Fields.Add(countryCategoryField);

            PivotGridField shipCountryField = this.pivotGridControl.Fields["ShipCountry"];

            shipCountryField.Area = PivotArea.RowArea;

            PivotGridField orderDateField = this.pivotGridControl.Fields["OrderDate"];

            orderDateField.Area          = PivotArea.ColumnArea;
            orderDateField.GroupInterval = PivotGroupInterval.DateYear;

            PivotGridField orderIDField = this.pivotGridControl.Fields["OrderID"];

            orderIDField.Area        = PivotArea.DataArea;
            orderIDField.SummaryType = PivotSummaryType.Count;

            this.pivotGridControl.BestFit();
        }

        #endregion

        //////////////////////////////////////////////////////////////////////////////////////////////////// Method
        ////////////////////////////////////////////////////////////////////////////////////////// Private

        #region 피벗 그리드 컨트롤 그룹 간격 커스텀 설정하기 - pivotGridControl_CustomGroupInterval(sender, e)

        /// <summary>
        /// 피벗 그리드 컨트롤 그룹 간격 커스텀 설정하기
        /// </summary>
        /// <param name="sender">이벤트 발생자</param>
        /// <param name="e">이벤트 인자</param>
        private void pivotGridControl_CustomGroupInterval(object sender, PivotCustomGroupIntervalEventArgs e)
        {
            if(e.Field.Caption != "Country Category")
            {
                return;
            }

            if(Convert.ToChar(e.Value.ToString()[0]) < 'F')
            {
                e.GroupValue = "A-E";

                return;
            }

            if(Convert.ToChar(e.Value.ToString()[0]) > 'E' && Convert.ToChar(e.Value.ToString()[0]) < 'T')
            {
                e.GroupValue = "F-S";

                return;
            }

            if(Convert.ToChar(e.Value.ToString()[0]) > 'S')
            {
                e.GroupValue = "T-Z";
            }
        }

        #endregion
    }
}

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

using System;

using System.Data.OleDb;

using DevExpress.Data.PivotGrid;

using DevExpress.XtraEditors;

using DevExpress.XtraPivotGrid;

namespace TestProject

{

/// <summary>

/// 메인 폼

/// </summary>

public partial class MainForm : XtraForm

{

//////////////////////////////////////////////////////////////////////////////////////////////////// Field

////////////////////////////////////////////////////////////////////////////////////////// Private

#region Field

/// <summary>

/// 연결

/// </summary>

private OleDbConnection connection;

#endregion

//////////////////////////////////////////////////////////////////////////////////////////////////// Constructor

////////////////////////////////////////////////////////////////////////////////////////// Public

#region 생성자 - MainForm()

/// <summary>

/// 생성자

/// </summary>

public MainForm()

{

InitializeComponent();

this.connection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=nwind.mdb");

this.pivotGridControl.OptionsView.RowTotalsLocation = PivotRowTotalsLocation.Tree;

this.pivotGridControl.CustomGroupInterval += pivotGridControl_CustomGroupInterval;

this.pivotGridControl.DataSource = Order.GetOrderList(this.connection);

this.pivotGridControl.RetrieveFields();

PivotGridField countryCategoryField = new PivotGridField();

countryCategoryField.FieldName = "ShipCountry";

countryCategoryField.Caption = "Country Category";

countryCategoryField.Area = PivotArea.RowArea;

countryCategoryField.GroupInterval = PivotGroupInterval.Custom;

this.pivotGridControl.Fields.Add(countryCategoryField);

PivotGridField shipCountryField = this.pivotGridControl.Fields["ShipCountry"];

shipCountryField.Area = PivotArea.RowArea;

PivotGridField orderDateField = this.pivotGridControl.Fields["OrderDate"];

orderDateField.Area = PivotArea.ColumnArea;

orderDateField.GroupInterval = PivotGroupInterval.DateYear;

PivotGridField orderIDField = this.pivotGridControl.Fields["OrderID"];

orderIDField.Area = PivotArea.DataArea;

orderIDField.SummaryType = PivotSummaryType.Count;

this.pivotGridControl.BestFit();

}

#endregion

//////////////////////////////////////////////////////////////////////////////////////////////////// Method

////////////////////////////////////////////////////////////////////////////////////////// Private

#region 피벗 그리드 컨트롤 그룹 간격 커스텀 설정하기 - pivotGridControl_CustomGroupInterval(sender, e)

/// <summary>

/// 피벗 그리드 컨트롤 그룹 간격 커스텀 설정하기

/// </summary>

/// <param name="sender">이벤트 발생자</param>

/// <param name="e">이벤트 인자</param>

private void pivotGridControl_CustomGroupInterval(object sender, PivotCustomGroupIntervalEventArgs e)

{

if(e.Field.Caption != "Country Category")

{

return;

}

if(Convert.ToChar(e.Value.ToString()[0]) < 'F')

{

e.GroupValue = "A-E";

return;

}

if(Convert.ToChar(e.Value.ToString()[0]) > 'E' && Convert.ToChar(e.Value.ToString()[0]) < 'T')

{

e.GroupValue = "F-S";

return;

}

if(Convert.ToChar(e.Value.ToString()[0]) > 'S')

{

e.GroupValue = "T-Z";

}

#endregion

}

TestProject.zip