=>效果
=>源码
using System;
using System.Collections.Generic;
using System.Data;
using System.Windows.Forms;
using DevExpress.XtraEditors;
using System.Data.OleDb;
using DevExpress.XtraPivotGrid;
using DevExpress.LookAndFeel;
using DevExpress.XtraCharts;
namespace HelloWorld
{
public partial class XtraForm_Main : XtraForm
{
// 图表
ChartControl chart;
ChartControl bindedChart;
public XtraForm_Main()
{
InitializeComponent();
}
private void XtraForm_Main_Load(object sender, EventArgs e)
{
// 查看图表按钮
barBtnOperate.Alignment = DevExpress.XtraBars.BarItemLinkAlignment.Right;
// 销售员汇总表
pivotGridCtrlConfig();
}
/// <summary>
/// 汇总表配置
/// </summary>
private void pivotGridCtrlConfig() {
BindingSource pivotBsource = new BindingSource(getDataSet("tableSales"), "tableSales");
pivotGridCtrlSales.DataSource = pivotBsource;
// 行区域
PivotGridField fieldRegion = new PivotGridField("salesRegion", PivotArea.RowArea) { Caption = "地区" };
PivotGridField fieldSalesName = new PivotGridField("salesName", PivotArea.RowArea) { Caption = "销售员" };