Current filter:
                                You should refresh the page.
                                E

                                How to convert an XtraGrid to an XtraReport at runtime

                                Tags:
                                0

                                This example demonstrates how to dynamically create a report based upon the GridControl at runtime. This means that all filtering and sorting conditions selected in the grid are also applied in a report. To accomplish this task, it is necessary to create a report with all the necessary bands, bind it to a data source and adjust all the necessary options.

                                Leave a Comment
                                You must  log in  or  register  to leave comments
                                Select file
                                • Form1.cs
                                • XtraReport1.cs
                                Select language
                                • C#
                                • VB.NET
                                Select version
                                • v2012 vol 2.4 - v2013 vol 1.2
                                • v2008 vol 1.1 - v2012 vol 1.10
                                using System;
using System.Data;
using System.Windows.Forms;
using DevExpress.XtraReports.UI;
// ...

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

        private void simpleButton2_Click(object sender, EventArgs e) {
            XtraReport1 report = new XtraReport1(checkEdit1.Checked ? FillDatasetFromGrid() : nwindDataSet, gridView1);
            ReportPrintTool printTool = new ReportPrintTool(report);
            printTool.ShowPreviewDialog();
        }

        private DataSet FillDatasetFromGrid() {
            nwindDataSet ds = new nwindDataSet();
            int rowHandle;
            DataRow gridRow;
            for (int i = 0; i < gridView1.RowCount; i++) {
                rowHandle = gridView1.GetVisibleRowHandle(i);
                if (!gridView1.IsGroupRow(rowHandle)) {
                    gridRow = gridView1.GetDataRow(rowHandle);
                    ds.Tables[0].Rows.Add(gridRow.ItemArray);
                }
            }
            return ds;
        }

        private void Form1_Load(object sender, EventArgs e) {
            this.customersTableAdapter.Fill(this.nwindDataSet.Customers);
        }

        private void simpleButton1_Click(object sender, EventArgs e) {
            XtraReport1 report = new XtraReport1(checkEdit1.Checked ? FillDatasetFromGrid() : nwindDataSet, gridView1);
            ReportDesignTool designTool = new ReportDesignTool(report);
            designTool.ShowDesignerDialog();
        }
    }
}