Devaxpress xtrareport report development related knowledge points

1、 Background binding DataSource, grouping

   /// <summary>
        ///  Constructor with parameters 
        /// </summary>
        /// <param name="ds"> Data set to bind </param>
        public Pick_Report(DataSet ds) : this()
        {
            //if (!FormAssistant.IsDsNull(ds))
            //{
            DataSource = ds;
            DataMember = "Table1";
            FillControlValue(ds);
            dt = ds.Tables[0];
            //}
        }
        private void FillControlValue(DataSet ds)
        {

            // by XRLable Bind data set and corresponding fields 
            Company.DataBindings.Add("Text", ds.Tables[0], " factory ");
            //XQDate.DataBindings.Add("Text", ds, " Demand date ");
            MainMemo.DataBindings.Add("Text", ds, " Main table remarks ");
            //PrintCount.DataBindings.Add("Text", ds, " Number of prints ");
            BillNo.DataBindings.Add("Text", ds, " Document number ");
            Dept.DataBindings.Add("Text", ds, " department ");
            CQ.DataBindings.Add("Text", ds, " Plant area ");


            RowCode.DataBindings.Add("Text", ds.Tables[0], " Serial number ");
            MaterialId.DataBindings.Add("Text", ds.Tables[0], " Material code ");
            MaterialName.DataBindings.Add("Text", ds.Tables[0], " Material name ");
            //MaterialGroup.DataBindings.Add("Text", ds, " Item group ");
            Warehouse.DataBindings.Add("Text", ds, " Issuing warehouse ");
            //JSWarehouse.DataBindings.Add("Text", ds, " Receiving warehouse ");
            Quantity.DataBindings.Add("Text", ds.Tables[0], " Number ", "{0:f0}");
            UnitId.DataBindings.Add("Text", ds.Tables[0], " Company ");
            BatchNo.DataBindings.Add("Text", ds.Tables[0], " Batch number ");
            //PPNo.DataBindings.Add("Text", ds, " Work order No ");
            MaterialSpec.DataBindings.Add("Text", ds.Tables[0], " Specifications and models ");

            SumQty.DataBindings.Add("Text", ds.Tables[0], " Number ", "{0:f0}");
            SumQty.Summary = new XRSummary(SummaryRunning.Group, SummaryFunc.Sum, string.Empty);

            PerName.DataBindings.Add("Text", ds, " Applicant ");
            //FLName.DataBindings.Add("Text", ds, " Issuer ");
            //SLName.DataBindings.Add("Text", ds, " Receiver ");
            //PriName.DataBindings.Add("Text", ds, " Auditor ");
            GroupField df = new GroupField(" Document number ");
            GroupHeader1.GroupFields.Add(df);

        }

2、 other Form Click the button to print the preview

Pick_Report rp = new Pick_Report(ds);
PreviewLocalizer.Active = new ChineaseReportLocalizer();
rp.ShowPreview();

3、 Event after clicking the print button ：（ I'm here to change the number of prints ）

 private void Pick_Report_PrintProgress(object sender, DevExpress.XtraPrinting.PrintProgressEventArgs e)
        {
            string BillNo = "('";
            BillNo += dt.Rows[0][" Document number "].ToString();
            for (int i = 1; i < dt.Rows.Count; i++)
            {
                BillNo +=  "','"+dt.Rows[i][" Document number "].ToString() ;
            }
            BillNo += "')";
            BillNo = BillNo.Replace(",''", "");
            sql = " update MM_purPurchasePickMain set State = 20 where BillNo in "+BillNo;
            if (!DB.AF.sqlExec(sql, sqlconnSAP, out errMsg))
            {
                XtraMessageBox.Show(errMsg);
            }
        }