• DevExpress XtraReports 入门六 控件以程序方式创建一个 交叉表 报表


    本文只是为了帮助初次接触或是需要DevExpress XtraReports报表的人群使用的,为了帮助更多的人不会像我这样浪费时间才写的这篇文章,高手不想的看请路过

    本文内容来DevExpress XtraReports帮助文档,如看过类似的请略过。

    废话少说 开始正事

    在继续本示例之前,要把所有 必需的程序集 添加到项目的 引用 列表中,并且把一个按钮拖放到窗体上。 然后,以下列方式接管此按钮的 Click 事件。

    using System;
    using System.Data;
    using System.Data.OleDb;
    using System.Windows.Forms;
    using DevExpress.XtraPivotGrid;
    using DevExpress.XtraReports.UI;
    using DevExpress.XtraReports.UI.PivotGrid;
    // ...


    namespace docXRPivotGrid {
    public partial class Form1 : Form {
    public Form1() {
    InitializeComponent();
    }

    private void button1_Click(object sender, EventArgs e) {
    // Create a cross-tab report.
    XtraReport report = CreateReport();

    // Show its Print Preview.
    report.ShowPreview();
    }

    private XtraReport CreateReport() {
    // Create a blank report.
    XtraReport rep = new XtraReport();

    // Create a detail band and add it to the report.
    DetailBand detail = new DetailBand();
    rep.Bands.Add(detail);

    // Create a pivot grid and add it to the Detail band.
    XRPivotGrid pivotGrid = new XRPivotGrid();
    detail.Controls.Add(pivotGrid);

    // Create a data connection.
    OleDbConnection connection = new
    OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=..\\..\\nwind.mdb");

    // Create a data adapter.
    OleDbDataAdapter adapter = new
    OleDbDataAdapter("SELECT CategoryName, ProductName, Country, [Sales Person], Quantity, [Extended Price] FROM SalesPerson",
    connection);

    // Creata a dataset and fill it.
    DataSet dataSet1 = new DataSet();
    adapter.Fill(dataSet1, "SalesPerson");


    // Bind the pivot grid to data.
    pivotGrid.DataSource = dataSet1;
    pivotGrid.DataMember = "SalesPerson";

    // Generate pivot grid's fields.
    XRPivotGridField fieldCategoryName = new XRPivotGridField("CategoryName",
    PivotArea.RowArea);
    XRPivotGridField fieldProductName = new XRPivotGridField("ProductName", PivotArea.RowArea);
    XRPivotGridField fieldCountry = new XRPivotGridField("Country", PivotArea.ColumnArea);
    XRPivotGridField fieldSalesPerson = new XRPivotGridField("Sales Person",
    PivotArea.ColumnArea);
    XRPivotGridField fieldQuantity = new XRPivotGridField("Quantity", PivotArea.DataArea);
    XRPivotGridField fieldExtendedPrice = new XRPivotGridField("Extended Price",
    PivotArea.DataArea);

    // Add these fields to the pivot grid.
    pivotGrid.Fields.AddRange(new PivotGridField[] {fieldCategoryName, fieldProductName,
    fieldCountry,
    fieldSalesPerson, fieldQuantity, fieldExtendedPrice});

    return rep;
    }
    }
    }
  • 相关阅读:
    Linux Shell脚本启动jar、关闭jar
    SpringBoot基于切面来拦截@PathVariable参数及抛出异常全局处理方法
    SpringBoot引用font awesome不显示问题的解决
    解决RestTemplate请求url出现301转发错误 301 Moved Permanently
    npm报错:Node Sass could not find a binding for your current environment: Windows 64-bit with Node.js 10.x
    npm 安装 chromedriver 失败的解决办法
    npm run dev报错 JS stacktrace(Node内存溢出)
    Mysql批量修改表字段名称为小写
    Ubuntu18 apt更换国内源 加快下载速度
    微信小程序如何实现支付宝支付?
  • 原文地址:https://www.cnblogs.com/springSky/p/2220343.html
Copyright © 2020-2023  润新知