Example #1
0
        public void AddGroup(string fieldName)
        {
            Group gr = new Group {
                GroupingFieldName = fieldName
            };

            Groups.Add(gr);
            GroupHeaderSection gh = new GroupHeaderSection {
                Name = "Group header " + gr.GroupingFieldName, Size = new Model.Size(Width, 20), Location = new Point(0, 150)
            };

            GroupHeaderSections.Add(gh);
            GroupFooterSection gf = new GroupFooterSection {
                Name = "Group footer " + gr.GroupingFieldName, Size = new Model.Size(Width, 20), Location = new Point(0, 250)
            };

            GroupFooterSections.Add(gf);
        }
        private void SetGroupHeader(Report report, List <ColumnSizeLocation> columnsSizeLocation)
        {
            var groupHeader = new GroupHeaderSection();

            groupHeader.Height           = Unit.Mm(7);
            groupHeader.PrintOnEveryPage = true;
            groupHeader.Name             = "groupHeader";
            ReportStyles.SetGeoupColumnHeaderStyle(groupHeader.Style, ReportLevel);
            report.Items.Add(groupHeader);

            var columns = ListReportReportDTO.EntityListView.EntityListViewAllColumns;
            //  var columnHeight = groupHeader.Height;

            //گروه عناوین همه ستونها
            int index = 0;

            foreach (var column in columns)
            {
                var columnTextbox = new TextBox();
                columnTextbox.CanGrow = true;
                columnTextbox.Name    = column.Column.Name;
                ReportStyles.SetColumnHeaderTextboxStyle(columnTextbox.Style);
                var columnSizeLocation = columnsSizeLocation.First(x => x.LictViewColumnID == column.ID);
                columnTextbox.Width    = columnSizeLocation.Width;
                columnTextbox.Location = new PointU(columnSizeLocation.XLocation, Unit.Cm(0));
                columnTextbox.Height   = groupHeader.Height;
                var alias = column.Alias;
                if (string.IsNullOrEmpty(alias))
                {
                    alias = column.Column.Alias;
                }
                columnTextbox.Value = alias;
                groupHeader.Items.Add(columnTextbox);
                index++;
            }

            var group = new Group();

            group.GroupHeader = groupHeader;
            report.Groups.Add(group);


            if (ListReportReportDTO.ReportGroups != null)
            {
                foreach (var reportGroup in ListReportReportDTO.ReportGroups)
                {
                    var repotGroupHeader = new GroupHeaderSection();
                    repotGroupHeader.Height = Unit.Mm(7);
                    //repotGroupHeader.PrintOnEveryPage = true;
                    repotGroupHeader.Name = "reportgroupHeader";
                    ReportStyles.SetGeoupHeaderStyle(repotGroupHeader.Style);
                    report.Items.Add(groupHeader);

                    var geoupHeaderTextbox = new TextBox();
                    geoupHeaderTextbox.CanGrow = true;
                    geoupHeaderTextbox.Name    = reportGroup.ColumnName;
                    ReportStyles.SetGroupHeaderTextboxStyle(geoupHeaderTextbox.Style);
                    var columnSizeLocation = columnsSizeLocation.First(x => x.LictViewColumnID == reportGroup.ListViewColumnID);
                    geoupHeaderTextbox.Width    = columnSizeLocation.Width;
                    geoupHeaderTextbox.Location = new PointU(columnSizeLocation.XLocation, Unit.Cm(0));
                    geoupHeaderTextbox.Height   = repotGroupHeader.Height;

                    var columnName = reportGroup.EntityListViewColumn.RelativeColumnName;
                    //if (reportGroup.EntityListViewColumn.RelationshipTailID == 0)
                    //{
                    //    columnName = reportGroup.EntityListViewColumn.Column.Name + "0";// + "'";

                    //}
                    //else
                    //{

                    //}

                    geoupHeaderTextbox.Value = string.Format("= Fields.{0}", columnName);
                    repotGroupHeader.Items.Add(geoupHeaderTextbox);

                    var newGroup = new Group();
                    newGroup.GroupHeader = repotGroupHeader;
                    newGroup.Groupings.Add(new Telerik.Reporting.Grouping(string.Format("= Fields.{0}", columnName)));
                    report.Groups.Add(newGroup);
                }
            }
        }
 /// <summary>
 /// Required method for telerik Reporting designer support - do not modify
 /// the contents of this method with the code editor.
 /// </summary>
 private void InitializeComponent()
 {
     System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(Invoice));
     Telerik.Reporting.ReportParameter reportParameter1 = new Telerik.Reporting.ReportParameter();
     Telerik.Reporting.ReportParameter reportParameter2 = new Telerik.Reporting.ReportParameter();
     Telerik.Reporting.ReportParameter reportParameter3 = new Telerik.Reporting.ReportParameter();
     this.OrderNumbersDataSource = new Telerik.Reporting.SqlDataSource();
     this.detail = new Telerik.Reporting.DetailSection();
     this.panel4 = new Telerik.Reporting.Panel();
     this.textBox14 = new Telerik.Reporting.TextBox();
     this.textBox10 = new Telerik.Reporting.TextBox();
     this.textBox9 = new Telerik.Reporting.TextBox();
     this.textBox8 = new Telerik.Reporting.TextBox();
     this.textBox6 = new Telerik.Reporting.TextBox();
     this.textBox4 = new Telerik.Reporting.TextBox();
     this.textBox12 = new Telerik.Reporting.TextBox();
     this.textBox13 = new Telerik.Reporting.TextBox();
     this.textBox11 = new Telerik.Reporting.TextBox();
     this.textBox16 = new Telerik.Reporting.TextBox();
     this.textBox17 = new Telerik.Reporting.TextBox();
     this.textBox18 = new Telerik.Reporting.TextBox();
     this.textBox19 = new Telerik.Reporting.TextBox();
     this.textBox21 = new Telerik.Reporting.TextBox();
     this.textBox28 = new Telerik.Reporting.TextBox();
     this.textBox29 = new Telerik.Reporting.TextBox();
     this.textBox30 = new Telerik.Reporting.TextBox();
     this.textBox31 = new Telerik.Reporting.TextBox();
     this.textBox32 = new Telerik.Reporting.TextBox();
     this.panel1 = new Telerik.Reporting.Panel();
     this.textBox24 = new Telerik.Reporting.TextBox();
     this.textBox23 = new Telerik.Reporting.TextBox();
     this.textBox25 = new Telerik.Reporting.TextBox();
     this.textBox26 = new Telerik.Reporting.TextBox();
     this.textBox27 = new Telerik.Reporting.TextBox();
     this.panel2 = new Telerik.Reporting.Panel();
     this.textBox7 = new Telerik.Reporting.TextBox();
     this.textBox2 = new Telerik.Reporting.TextBox();
     this.textBox3 = new Telerik.Reporting.TextBox();
     this.group1 = new Telerik.Reporting.Group();
     this.groupFooterSection1 = new Telerik.Reporting.GroupFooterSection();
     this.groupHeaderSection1 = new Telerik.Reporting.GroupHeaderSection();
     this.panel5 = new Telerik.Reporting.Panel();
     this.Text1 = new Telerik.Reporting.TextBox();
     this.Field6 = new Telerik.Reporting.TextBox();
     this.Text12 = new Telerik.Reporting.TextBox();
     this.Id1 = new Telerik.Reporting.TextBox();
     this.barcode2 = new Telerik.Reporting.Barcode();
     this.pictureBox1 = new Telerik.Reporting.PictureBox();
     this.textBox1 = new Telerik.Reporting.TextBox();
     this.panel3 = new Telerik.Reporting.Panel();
     this.Text8 = new Telerik.Reporting.TextBox();
     this.InvoicesDataSource = new Telerik.Reporting.SqlDataSource();
     this.pageFooterSection1 = new Telerik.Reporting.PageFooterSection();
     this.textBox5 = new Telerik.Reporting.TextBox();
     this.textBox22 = new Telerik.Reporting.TextBox();
     this.subReport1 = new Telerik.Reporting.SubReport();
     this.salesOrderDetails1 = new Telerik.Reporting.SalesOrderDetails();
     ((System.ComponentModel.ISupportInitialize)(this.salesOrderDetails1)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this)).BeginInit();
     //
     // OrderNumbersDataSource
     //
     this.OrderNumbersDataSource.ConnectionString = "Telerik.Reporting.Examples.CSharp.Properties.Settings.TelerikConnectionString";
     this.OrderNumbersDataSource.Name = "OrderNumbers";
     this.OrderNumbersDataSource.Parameters.AddRange(new Telerik.Reporting.SqlDataSourceParameter[] {
     new Telerik.Reporting.SqlDataSourceParameter("@ForYear", System.Data.DbType.String, "=Parameters.ForYear.Value"),
     new Telerik.Reporting.SqlDataSourceParameter("@ForMonth", System.Data.DbType.String, "=Parameters.ForMonth.Value")});
     this.OrderNumbersDataSource.SelectCommand = resources.GetString("OrderNumbersDataSource.SelectCommand");
     //
     // detail
     //
     this.detail.Height = new Telerik.Reporting.Drawing.Unit(3.2780463695526123D, Telerik.Reporting.Drawing.UnitType.Inch);
     this.detail.Items.AddRange(new Telerik.Reporting.ReportItemBase[] {
     this.panel4,
     this.subReport1});
     this.detail.KeepTogether = false;
     this.detail.Name = "detail";
     //
     // panel4
     //
     this.panel4.Items.AddRange(new Telerik.Reporting.ReportItemBase[] {
     this.textBox14,
     this.textBox10,
     this.textBox9,
     this.textBox8,
     this.textBox6,
     this.textBox4,
     this.textBox12,
     this.textBox13,
     this.textBox11,
     this.textBox16,
     this.textBox17,
     this.textBox18,
     this.textBox19,
     this.textBox21,
     this.textBox28,
     this.textBox29,
     this.textBox30,
     this.textBox31,
     this.textBox32,
     this.panel1,
     this.panel2,
     this.textBox2,
     this.textBox3});
     this.panel4.KeepTogether = false;
     this.panel4.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(0D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.0833333358168602D, Telerik.Reporting.Drawing.UnitType.Inch));
     this.panel4.Name = "panel4";
     this.panel4.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(7.5D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(2.7000000476837158D, Telerik.Reporting.Drawing.UnitType.Inch));
     this.panel4.Style.BorderColor.Default = System.Drawing.Color.FromArgb(((int)(((byte)(173)))), ((int)(((byte)(221)))), ((int)(((byte)(252)))));
     this.panel4.Style.BorderStyle.Default = Telerik.Reporting.Drawing.BorderType.Solid;
     //
     // textBox14
     //
     this.textBox14.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(1.0103377103805542D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.38954368233680725D, Telerik.Reporting.Drawing.UnitType.Inch));
     this.textBox14.Name = "textBox14";
     this.textBox14.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1.9937108755111694D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.19999997317790985D, Telerik.Reporting.Drawing.UnitType.Inch));
     this.textBox14.Value = "=Fields.Store";
     //
     // textBox10
     //
     this.textBox10.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(1.0103377103805542D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(1.8120609521865845D, Telerik.Reporting.Drawing.UnitType.Inch));
     this.textBox10.Name = "textBox10";
     this.textBox10.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1.9937108755111694D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.19999997317790985D, Telerik.Reporting.Drawing.UnitType.Inch));
     this.textBox10.Value = "=Fields.CustPhone";
     //
     // textBox9
     //
     this.textBox9.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(1.0103377103805542D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(1.5259628295898438D, Telerik.Reporting.Drawing.UnitType.Inch));
     this.textBox9.Name = "textBox9";
     this.textBox9.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1.993710994720459D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.19999997317790985D, Telerik.Reporting.Drawing.UnitType.Inch));
     this.textBox9.Value = "=Fields.CustFirstName + \" \" + Fields.CustLastName";
     //
     // textBox8
     //
     this.textBox8.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(0.099921144545078278D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(1.5259628295898438D, Telerik.Reporting.Drawing.UnitType.Inch));
     this.textBox8.Name = "textBox8";
     this.textBox8.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(0.72496062517166138D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.19999997317790985D, Telerik.Reporting.Drawing.UnitType.Inch));
     this.textBox8.Style.Font.Bold = true;
     this.textBox8.Style.Font.Name = "Verdana";
     this.textBox8.Value = "Contact:";
     //
     // textBox6
     //
     this.textBox6.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(1.0103377103805542D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(1.1898593902587891D, Telerik.Reporting.Drawing.UnitType.Inch));
     this.textBox6.Name = "textBox6";
     this.textBox6.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1.9937108755111694D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.19999997317790985D, Telerik.Reporting.Drawing.UnitType.Inch));
     this.textBox6.Value = "=Fields.BillCountryRegion";
     //
     // textBox4
     //
     this.textBox4.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(1.0103377103805542D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.98978042602539062D, Telerik.Reporting.Drawing.UnitType.Inch));
     this.textBox4.Name = "textBox4";
     this.textBox4.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1.9937108755111694D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.19999997317790985D, Telerik.Reporting.Drawing.UnitType.Inch));
     this.textBox4.Value = "=Fields.BillPostalCode + \" \" + Fields.BillCity";
     //
     // textBox12
     //
     this.textBox12.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(1.0103377103805542D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.78970146179199219D, Telerik.Reporting.Drawing.UnitType.Inch));
     this.textBox12.Name = "textBox12";
     this.textBox12.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1.9937108755111694D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.19999997317790985D, Telerik.Reporting.Drawing.UnitType.Inch));
     this.textBox12.Value = "=IsNull(Fields.BillAddress2, \'No secondary Address\')";
     //
     // textBox13
     //
     this.textBox13.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(1.0103377103805542D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.58962249755859375D, Telerik.Reporting.Drawing.UnitType.Inch));
     this.textBox13.Name = "textBox13";
     this.textBox13.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1.9937108755111694D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.19999997317790985D, Telerik.Reporting.Drawing.UnitType.Inch));
     this.textBox13.Value = "=Fields.BillAddress1";
     //
     // textBox11
     //
     this.textBox11.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(0.099921144545078278D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(1.8120609521865845D, Telerik.Reporting.Drawing.UnitType.Inch));
     this.textBox11.Name = "textBox11";
     this.textBox11.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(0.72496062517166138D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.19999997317790985D, Telerik.Reporting.Drawing.UnitType.Inch));
     this.textBox11.Style.Font.Bold = true;
     this.textBox11.Style.Font.Name = "Verdana";
     this.textBox11.Value = "Phone:";
     //
     // textBox16
     //
     this.textBox16.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(4.7736506462097168D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.389543741941452D, Telerik.Reporting.Drawing.UnitType.Inch));
     this.textBox16.Name = "textBox16";
     this.textBox16.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(2.6291275024414062D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.19999997317790985D, Telerik.Reporting.Drawing.UnitType.Inch));
     this.textBox16.Value = "=Fields.Store";
     //
     // textBox17
     //
     this.textBox17.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(4.7736506462097168D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.58962267637252808D, Telerik.Reporting.Drawing.UnitType.Inch));
     this.textBox17.Name = "textBox17";
     this.textBox17.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(2.6291275024414062D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.19999997317790985D, Telerik.Reporting.Drawing.UnitType.Inch));
     this.textBox17.Value = "=Fields.ShipAddress1";
     //
     // textBox18
     //
     this.textBox18.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(4.7736506462097168D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.78970146179199219D, Telerik.Reporting.Drawing.UnitType.Inch));
     this.textBox18.Name = "textBox18";
     this.textBox18.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(2.6291275024414062D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.19999997317790985D, Telerik.Reporting.Drawing.UnitType.Inch));
     this.textBox18.Value = "=IsNull(Fields.ShipAddress2, \'No secondary Address\')";
     //
     // textBox19
     //
     this.textBox19.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(4.7736506462097168D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.98978042602539062D, Telerik.Reporting.Drawing.UnitType.Inch));
     this.textBox19.Name = "textBox19";
     this.textBox19.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(2.6291275024414062D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.19999997317790985D, Telerik.Reporting.Drawing.UnitType.Inch));
     this.textBox19.Value = "=Fields.ShipPostalCode + \" \" + Fields.ShipCity + \", \" + Fields.ShipStateProvince " +
         "";
     //
     // textBox21
     //
     this.textBox21.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(4.7736506462097168D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(1.18985915184021D, Telerik.Reporting.Drawing.UnitType.Inch));
     this.textBox21.Name = "textBox21";
     this.textBox21.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(2.6291275024414062D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.19999997317790985D, Telerik.Reporting.Drawing.UnitType.Inch));
     this.textBox21.Value = "=Fields.ShipCountryRegion";
     //
     // textBox28
     //
     this.textBox28.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(5.7430548667907715D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(2.332122802734375D, Telerik.Reporting.Drawing.UnitType.Inch));
     this.textBox28.Name = "textBox28";
     this.textBox28.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1.6736117601394653D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.19999997317790985D, Telerik.Reporting.Drawing.UnitType.Inch));
     this.textBox28.Style.VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Middle;
     this.textBox28.Value = "=Fields.ShipMethod";
     //
     // textBox29
     //
     this.textBox29.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(4.3639674186706543D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(2.332122802734375D, Telerik.Reporting.Drawing.UnitType.Inch));
     this.textBox29.Name = "textBox29";
     this.textBox29.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1.3790086507797241D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.19999997317790985D, Telerik.Reporting.Drawing.UnitType.Inch));
     this.textBox29.Style.VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Middle;
     this.textBox29.Value = "=Fields.PurchaseOrderNumber";
     //
     // textBox30
     //
     this.textBox30.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(2.3792455196380615D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(2.332122802734375D, Telerik.Reporting.Drawing.UnitType.Inch));
     this.textBox30.Name = "textBox30";
     this.textBox30.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1.9846428632736206D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.19999997317790985D, Telerik.Reporting.Drawing.UnitType.Inch));
     this.textBox30.Style.VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Middle;
     this.textBox30.Value = "=Fields.SalesFirstName + \" \" + Fields.SalesLastName";
     //
     // textBox31
     //
     this.textBox31.Format = "{0:d}";
     this.textBox31.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(0.099921144545078278D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(2.332122802734375D, Telerik.Reporting.Drawing.UnitType.Inch));
     this.textBox31.Name = "textBox31";
     this.textBox31.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1.1395833492279053D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.19999997317790985D, Telerik.Reporting.Drawing.UnitType.Inch));
     this.textBox31.Style.VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Middle;
     this.textBox31.Value = "=Now()";
     //
     // textBox32
     //
     this.textBox32.Format = "{0:d}";
     this.textBox32.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(1.2395831346511841D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(2.332122802734375D, Telerik.Reporting.Drawing.UnitType.Inch));
     this.textBox32.Name = "textBox32";
     this.textBox32.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1.1395833492279053D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.19999997317790985D, Telerik.Reporting.Drawing.UnitType.Inch));
     this.textBox32.Style.VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Middle;
     this.textBox32.Value = "=Fields.OrderDate";
     //
     // panel1
     //
     this.panel1.Items.AddRange(new Telerik.Reporting.ReportItemBase[] {
     this.textBox24,
     this.textBox23,
     this.textBox25,
     this.textBox26,
     this.textBox27});
     this.panel1.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(0.099921144545078278D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(2.05200457572937D, Telerik.Reporting.Drawing.UnitType.Inch));
     this.panel1.Name = "panel1";
     this.panel1.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(7.316746711730957D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.2800394594669342D, Telerik.Reporting.Drawing.UnitType.Inch));
     this.panel1.Style.BackgroundColor = System.Drawing.Color.FromArgb(((int)(((byte)(229)))), ((int)(((byte)(245)))), ((int)(((byte)(255)))));
     //
     // textBox24
     //
     this.textBox24.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(0D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0D, Telerik.Reporting.Drawing.UnitType.Inch));
     this.textBox24.Name = "textBox24";
     this.textBox24.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1.1395833492279053D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.2800000011920929D, Telerik.Reporting.Drawing.UnitType.Inch));
     this.textBox24.Style.Font.Bold = true;
     this.textBox24.Style.Font.Name = "Verdana";
     this.textBox24.Style.Font.Size = new Telerik.Reporting.Drawing.Unit(10D, Telerik.Reporting.Drawing.UnitType.Point);
     this.textBox24.Style.VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Middle;
     this.textBox24.Value = "Date";
     //
     // textBox23
     //
     this.textBox23.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(1.1396621465682983D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0D, Telerik.Reporting.Drawing.UnitType.Inch));
     this.textBox23.Name = "textBox23";
     this.textBox23.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1.1395833492279053D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.2800000011920929D, Telerik.Reporting.Drawing.UnitType.Inch));
     this.textBox23.Style.Font.Bold = true;
     this.textBox23.Style.Font.Name = "Verdana";
     this.textBox23.Style.VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Middle;
     this.textBox23.Value = "Order Date";
     //
     // textBox25
     //
     this.textBox25.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(2.2793638706207275D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0D, Telerik.Reporting.Drawing.UnitType.Inch));
     this.textBox25.Name = "textBox25";
     this.textBox25.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1.9846034049987793D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.2800000011920929D, Telerik.Reporting.Drawing.UnitType.Inch));
     this.textBox25.Style.Font.Bold = true;
     this.textBox25.Style.Font.Name = "Verdana";
     this.textBox25.Style.VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Middle;
     this.textBox25.Value = "Sales Person";
     //
     // textBox26
     //
     this.textBox26.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(4.2640457153320312D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0D, Telerik.Reporting.Drawing.UnitType.Inch));
     this.textBox26.Name = "textBox26";
     this.textBox26.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1.3790086507797241D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.2800000011920929D, Telerik.Reporting.Drawing.UnitType.Inch));
     this.textBox26.Style.Font.Bold = true;
     this.textBox26.Style.Font.Name = "Verdana";
     this.textBox26.Style.VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Middle;
     this.textBox26.Value = "Purchase Order";
     //
     // textBox27
     //
     this.textBox27.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(5.6431331634521484D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0D, Telerik.Reporting.Drawing.UnitType.Inch));
     this.textBox27.Name = "textBox27";
     this.textBox27.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1.6736125946044922D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.2800000011920929D, Telerik.Reporting.Drawing.UnitType.Inch));
     this.textBox27.Style.Font.Bold = true;
     this.textBox27.Style.Font.Name = "Verdana";
     this.textBox27.Style.VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Middle;
     this.textBox27.Value = "Shipment Method";
     //
     // panel2
     //
     this.panel2.Items.AddRange(new Telerik.Reporting.ReportItemBase[] {
     this.textBox7});
     this.panel2.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(0.099921144545078278D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.099464893341064453D, Telerik.Reporting.Drawing.UnitType.Inch));
     this.panel2.Name = "panel2";
     this.panel2.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(7.3028569221496582D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.29003939032554626D, Telerik.Reporting.Drawing.UnitType.Inch));
     this.panel2.Style.BackgroundColor = System.Drawing.Color.FromArgb(((int)(((byte)(229)))), ((int)(((byte)(245)))), ((int)(((byte)(255)))));
     //
     // textBox7
     //
     this.textBox7.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(0D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0D, Telerik.Reporting.Drawing.UnitType.Inch));
     this.textBox7.Name = "textBox7";
     this.textBox7.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(2.9041273593902588D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.28999999165534973D, Telerik.Reporting.Drawing.UnitType.Inch));
     this.textBox7.Style.Font.Bold = true;
     this.textBox7.Style.Font.Name = "Verdana";
     this.textBox7.Style.VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Middle;
     this.textBox7.Value = "Customer Details";
     //
     // textBox2
     //
     this.textBox2.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(0.099921144545078278D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.38958317041397095D, Telerik.Reporting.Drawing.UnitType.Inch));
     this.textBox2.Name = "textBox2";
     this.textBox2.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(0.800000011920929D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.19999997317790985D, Telerik.Reporting.Drawing.UnitType.Inch));
     this.textBox2.Style.Font.Bold = true;
     this.textBox2.Style.Font.Name = "Verdana";
     this.textBox2.Value = "Address:";
     //
     // textBox3
     //
     this.textBox3.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(4.0519428253173828D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.389543741941452D, Telerik.Reporting.Drawing.UnitType.Inch));
     this.textBox3.Name = "textBox3";
     this.textBox3.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(0.72162878513336182D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.19999997317790985D, Telerik.Reporting.Drawing.UnitType.Inch));
     this.textBox3.Style.Font.Bold = true;
     this.textBox3.Style.Font.Name = "Verdana";
     this.textBox3.Value = "Ship to:";
     //
     // group1
     //
     this.group1.GroupFooter = this.groupFooterSection1;
     this.group1.GroupHeader = this.groupHeaderSection1;
     this.group1.Name = "group1";
     //
     // groupFooterSection1
     //
     this.groupFooterSection1.Height = new Telerik.Reporting.Drawing.Unit(0.23541705310344696D, Telerik.Reporting.Drawing.UnitType.Inch);
     this.groupFooterSection1.Name = "groupFooterSection1";
     this.groupFooterSection1.Style.Visible = false;
     //
     // groupHeaderSection1
     //
     this.groupHeaderSection1.Height = new Telerik.Reporting.Drawing.Unit(1.2865371704101563D, Telerik.Reporting.Drawing.UnitType.Inch);
     this.groupHeaderSection1.Items.AddRange(new Telerik.Reporting.ReportItemBase[] {
     this.panel5});
     this.groupHeaderSection1.Name = "groupHeaderSection1";
     //
     // panel5
     //
     this.panel5.Items.AddRange(new Telerik.Reporting.ReportItemBase[] {
     this.Text1,
     this.Field6,
     this.Text12,
     this.Id1,
     this.barcode2,
     this.pictureBox1,
     this.textBox1,
     this.panel3,
     this.Text8});
     this.panel5.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(0.010456085205078125D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(3.9339065551757812E-05D, Telerik.Reporting.Drawing.UnitType.Inch));
     this.panel5.Name = "panel5";
     this.panel5.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(19.023441314697266D, Telerik.Reporting.Drawing.UnitType.Cm), new Telerik.Reporting.Drawing.Unit(3.2677044868469238D, Telerik.Reporting.Drawing.UnitType.Cm));
     this.panel5.Style.BackgroundColor = System.Drawing.Color.FromArgb(((int)(((byte)(216)))), ((int)(((byte)(240)))), ((int)(((byte)(255)))));
     this.panel5.Style.BorderColor.Default = System.Drawing.Color.FromArgb(((int)(((byte)(173)))), ((int)(((byte)(221)))), ((int)(((byte)(252)))));
     this.panel5.Style.BorderStyle.Default = Telerik.Reporting.Drawing.BorderType.Solid;
     //
     // Text1
     //
     this.Text1.CanGrow = false;
     this.Text1.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(5.0309247970581055D, Telerik.Reporting.Drawing.UnitType.Cm), new Telerik.Reporting.Drawing.Unit(0.9893181324005127D, Telerik.Reporting.Drawing.UnitType.Cm));
     this.Text1.Name = "Text1";
     this.Text1.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(4.852510929107666D, Telerik.Reporting.Drawing.UnitType.Cm), new Telerik.Reporting.Drawing.Unit(1.523809552192688D, Telerik.Reporting.Drawing.UnitType.Cm));
     this.Text1.Style.BackgroundColor = System.Drawing.Color.Empty;
     this.Text1.Style.BorderColor.Default = System.Drawing.Color.Black;
     this.Text1.Style.BorderStyle.Default = Telerik.Reporting.Drawing.BorderType.None;
     this.Text1.Style.Color = System.Drawing.Color.Black;
     this.Text1.Style.Font.Bold = false;
     this.Text1.Style.Font.Italic = false;
     this.Text1.Style.Font.Name = "Verdana";
     this.Text1.Style.Font.Size = new Telerik.Reporting.Drawing.Unit(8D, Telerik.Reporting.Drawing.UnitType.Point);
     this.Text1.Style.Font.Strikeout = false;
     this.Text1.Style.Font.Underline = false;
     this.Text1.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Left;
     this.Text1.Style.VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Top;
     this.Text1.Style.Visible = true;
     this.Text1.Value = "275 Grove St., Suite 2-400, Newton, MA 02466\r\nPhone: +1.888.365.2779\r\nFax: +1.617" +
         ".249.2116";
     //
     // Field6
     //
     this.Field6.CanGrow = false;
     this.Field6.Format = "{0:d}";
     this.Field6.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(16.280376434326172D, Telerik.Reporting.Drawing.UnitType.Cm), new Telerik.Reporting.Drawing.Unit(2.2130587100982666D, Telerik.Reporting.Drawing.UnitType.Cm));
     this.Field6.Name = "Field6";
     this.Field6.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(2.7429654598236084D, Telerik.Reporting.Drawing.UnitType.Cm), new Telerik.Reporting.Drawing.Unit(0.5D, Telerik.Reporting.Drawing.UnitType.Cm));
     this.Field6.Style.BackgroundColor = System.Drawing.Color.Empty;
     this.Field6.Style.BorderColor.Default = System.Drawing.Color.Black;
     this.Field6.Style.BorderStyle.Default = Telerik.Reporting.Drawing.BorderType.None;
     this.Field6.Style.Color = System.Drawing.Color.OrangeRed;
     this.Field6.Style.Font.Bold = true;
     this.Field6.Style.Font.Italic = false;
     this.Field6.Style.Font.Name = "Verdana";
     this.Field6.Style.Font.Size = new Telerik.Reporting.Drawing.Unit(10D, Telerik.Reporting.Drawing.UnitType.Point);
     this.Field6.Style.Font.Strikeout = false;
     this.Field6.Style.Font.Underline = false;
     this.Field6.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Left;
     this.Field6.Style.VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Bottom;
     this.Field6.Style.Visible = true;
     this.Field6.Value = "=Now()";
     //
     // Text12
     //
     this.Text12.CanGrow = false;
     this.Text12.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(10.177068710327148D, Telerik.Reporting.Drawing.UnitType.Cm), new Telerik.Reporting.Drawing.Unit(2.2130589485168457D, Telerik.Reporting.Drawing.UnitType.Cm));
     this.Text12.Name = "Text12";
     this.Text12.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(2.6963250637054443D, Telerik.Reporting.Drawing.UnitType.Cm), new Telerik.Reporting.Drawing.Unit(0.5D, Telerik.Reporting.Drawing.UnitType.Cm));
     this.Text12.Style.BackgroundColor = System.Drawing.Color.Empty;
     this.Text12.Style.BorderColor.Default = System.Drawing.Color.Black;
     this.Text12.Style.BorderStyle.Default = Telerik.Reporting.Drawing.BorderType.None;
     this.Text12.Style.Color = System.Drawing.Color.Black;
     this.Text12.Style.Font.Bold = true;
     this.Text12.Style.Font.Italic = false;
     this.Text12.Style.Font.Name = "Verdana";
     this.Text12.Style.Font.Size = new Telerik.Reporting.Drawing.Unit(10D, Telerik.Reporting.Drawing.UnitType.Point);
     this.Text12.Style.Font.Strikeout = false;
     this.Text12.Style.Font.Underline = false;
     this.Text12.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Right;
     this.Text12.Style.VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Bottom;
     this.Text12.Style.Visible = true;
     this.Text12.Value = "Sales Order:";
     //
     // Id1
     //
     this.Id1.CanGrow = false;
     this.Id1.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(12.8735933303833D, Telerik.Reporting.Drawing.UnitType.Cm), new Telerik.Reporting.Drawing.Unit(2.2130589485168457D, Telerik.Reporting.Drawing.UnitType.Cm));
     this.Id1.Name = "Id1";
     this.Id1.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(2.0355603694915771D, Telerik.Reporting.Drawing.UnitType.Cm), new Telerik.Reporting.Drawing.Unit(0.5D, Telerik.Reporting.Drawing.UnitType.Cm));
     this.Id1.Style.BackgroundColor = System.Drawing.Color.Empty;
     this.Id1.Style.BorderColor.Default = System.Drawing.Color.Black;
     this.Id1.Style.BorderStyle.Default = Telerik.Reporting.Drawing.BorderType.None;
     this.Id1.Style.Color = System.Drawing.Color.OrangeRed;
     this.Id1.Style.Font.Bold = true;
     this.Id1.Style.Font.Italic = false;
     this.Id1.Style.Font.Name = "Verdana";
     this.Id1.Style.Font.Size = new Telerik.Reporting.Drawing.Unit(11D, Telerik.Reporting.Drawing.UnitType.Point);
     this.Id1.Style.Font.Strikeout = false;
     this.Id1.Style.Font.Underline = false;
     this.Id1.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Left;
     this.Id1.Style.VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Bottom;
     this.Id1.Style.Visible = true;
     this.Id1.Value = "=Fields.SalesOrderID";
     //
     // barcode2
     //
     this.barcode2.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(12.792195320129395D, Telerik.Reporting.Drawing.UnitType.Cm), new Telerik.Reporting.Drawing.Unit(0.24975340068340302D, Telerik.Reporting.Drawing.UnitType.Cm));
     this.barcode2.Name = "barcode2";
     this.barcode2.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(6.2312464714050293D, Telerik.Reporting.Drawing.UnitType.Cm), new Telerik.Reporting.Drawing.Unit(1.7093372344970703D, Telerik.Reporting.Drawing.UnitType.Cm));
     this.barcode2.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Center;
     this.barcode2.Style.VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Bottom;
     this.barcode2.Value = "=Fields.PurchaseOrderNumber";
     //
     // pictureBox1
     //
     this.pictureBox1.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(0.18954388797283173D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.078749977052211761D, Telerik.Reporting.Drawing.UnitType.Inch));
     this.pictureBox1.MimeType = "image/jpeg";
     this.pictureBox1.Name = "pictureBox1";
     this.pictureBox1.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1.6123565435409546D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.71079403162002563D, Telerik.Reporting.Drawing.UnitType.Inch));
     this.pictureBox1.Style.BorderColor.Default = System.Drawing.Color.FromArgb(((int)(((byte)(173)))), ((int)(((byte)(221)))), ((int)(((byte)(252)))));
     this.pictureBox1.Style.BorderStyle.Default = Telerik.Reporting.Drawing.BorderType.Solid;
     this.pictureBox1.Style.BorderWidth.Default = new Telerik.Reporting.Drawing.Unit(1D, Telerik.Reporting.Drawing.UnitType.Point);
     this.pictureBox1.Value = ((object)(resources.GetObject("pictureBox1.Value")));
     //
     // textBox1
     //
     this.textBox1.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(1.9809513092041016D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.0983281135559082D, Telerik.Reporting.Drawing.UnitType.Inch));
     this.textBox1.Name = "textBox1";
     this.textBox1.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1.9106760025024414D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.29121589660644531D, Telerik.Reporting.Drawing.UnitType.Inch));
     this.textBox1.Style.Color = System.Drawing.Color.FromArgb(((int)(((byte)(44)))), ((int)(((byte)(90)))), ((int)(((byte)(184)))));
     this.textBox1.Style.Font.Size = new Telerik.Reporting.Drawing.Unit(16D, Telerik.Reporting.Drawing.UnitType.Point);
     this.textBox1.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Left;
     this.textBox1.Value = "AdventureWorks";
     //
     // panel3
     //
     this.panel3.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(3.9418537198798731E-05D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(1.0682121515274048D, Telerik.Reporting.Drawing.UnitType.Inch));
     this.panel3.Name = "panel3";
     this.panel3.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(7.4895052909851074D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.21828572452068329D, Telerik.Reporting.Drawing.UnitType.Inch));
     this.panel3.Style.BackgroundColor = System.Drawing.Color.FromArgb(((int)(((byte)(192)))), ((int)(((byte)(229)))), ((int)(((byte)(255)))));
     //
     // Text8
     //
     this.Text8.CanGrow = false;
     this.Text8.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(14.909354209899902D, Telerik.Reporting.Drawing.UnitType.Cm), new Telerik.Reporting.Drawing.Unit(2.2130589485168457D, Telerik.Reporting.Drawing.UnitType.Cm));
     this.Text8.Name = "Text8";
     this.Text8.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1.3708218336105347D, Telerik.Reporting.Drawing.UnitType.Cm), new Telerik.Reporting.Drawing.Unit(0.5D, Telerik.Reporting.Drawing.UnitType.Cm));
     this.Text8.Style.BackgroundColor = System.Drawing.Color.Empty;
     this.Text8.Style.BorderColor.Default = System.Drawing.Color.Black;
     this.Text8.Style.BorderStyle.Default = Telerik.Reporting.Drawing.BorderType.None;
     this.Text8.Style.Color = System.Drawing.Color.Black;
     this.Text8.Style.Font.Bold = true;
     this.Text8.Style.Font.Italic = false;
     this.Text8.Style.Font.Name = "Verdana";
     this.Text8.Style.Font.Size = new Telerik.Reporting.Drawing.Unit(10D, Telerik.Reporting.Drawing.UnitType.Point);
     this.Text8.Style.Font.Strikeout = false;
     this.Text8.Style.Font.Underline = false;
     this.Text8.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Right;
     this.Text8.Style.VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Bottom;
     this.Text8.Style.Visible = true;
     this.Text8.Value = "Date:";
     //
     // InvoicesDataSource
     //
     this.InvoicesDataSource.ConnectionString = "Telerik.Reporting.Examples.CSharp.Properties.Settings.TelerikConnectionString";
     this.InvoicesDataSource.Name = "Invoices";
     this.InvoicesDataSource.Parameters.AddRange(new Telerik.Reporting.SqlDataSourceParameter[] {
     new Telerik.Reporting.SqlDataSourceParameter("@SalesOrderNumber", System.Data.DbType.String, "=Parameters.OrderNumber.Value")});
     this.InvoicesDataSource.SelectCommand = resources.GetString("InvoicesDataSource.SelectCommand");
     //
     // pageFooterSection1
     //
     this.pageFooterSection1.Height = new Telerik.Reporting.Drawing.Unit(0.1875D, Telerik.Reporting.Drawing.UnitType.Inch);
     this.pageFooterSection1.Items.AddRange(new Telerik.Reporting.ReportItemBase[] {
     this.textBox5,
     this.textBox22});
     this.pageFooterSection1.Name = "pageFooterSection1";
     this.pageFooterSection1.Style.BorderColor.Default = System.Drawing.Color.FromArgb(((int)(((byte)(173)))), ((int)(((byte)(221)))), ((int)(((byte)(252)))));
     this.pageFooterSection1.Style.BorderStyle.Default = Telerik.Reporting.Drawing.BorderType.Solid;
     this.pageFooterSection1.Style.BorderWidth.Default = new Telerik.Reporting.Drawing.Unit(1D, Telerik.Reporting.Drawing.UnitType.Pixel);
     //
     // textBox5
     //
     this.textBox5.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(0D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0D, Telerik.Reporting.Drawing.UnitType.Inch));
     this.textBox5.Name = "textBox5";
     this.textBox5.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(3.40625D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.1875D, Telerik.Reporting.Drawing.UnitType.Inch));
     this.textBox5.Style.BackgroundColor = System.Drawing.Color.Empty;
     this.textBox5.Style.Color = System.Drawing.Color.FromArgb(((int)(((byte)(44)))), ((int)(((byte)(90)))), ((int)(((byte)(184)))));
     this.textBox5.Style.Font.Italic = false;
     this.textBox5.Value = "=PageExec(\"lineTotalDataTextBox\",Count(Fields.ProductNumber)) + \" products, \" + P" +
         "ageExec(\"lineTotalDataTextBox\",Sum(Fields.OrderQty)) + \" items on page  \" + Page" +
         "Number";
     //
     // textBox22
     //
     this.textBox22.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(5.2715086936950684D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(3.9418537198798731E-05D, Telerik.Reporting.Drawing.UnitType.Inch));
     this.textBox22.Name = "textBox22";
     this.textBox22.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(2.1312694549560547D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.18742115795612335D, Telerik.Reporting.Drawing.UnitType.Inch));
     this.textBox22.Style.Color = System.Drawing.Color.FromArgb(((int)(((byte)(44)))), ((int)(((byte)(90)))), ((int)(((byte)(184)))));
     this.textBox22.Style.Font.Italic = false;
     this.textBox22.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Right;
     this.textBox22.Value = "=PageExec(\"lineTotalDataTextBox\",sum(LineTotal))";
     this.textBox22.Format = "{0:C2}";
     //
     // subReport1
     //
     this.subReport1.KeepTogether = false;
     this.subReport1.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(7.8837074397597462E-05D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(2.8858587741851807D, Telerik.Reporting.Drawing.UnitType.Inch));
     this.subReport1.Name = "subReport1";
     this.subReport1.Parameters.Add(new Telerik.Reporting.Parameter("SaledOrderID", "=Fields.SalesOrderID"));
     this.subReport1.ReportSource = this.salesOrderDetails1;
     this.subReport1.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(7.4999217987060547D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.27500006556510925D, Telerik.Reporting.Drawing.UnitType.Inch));
     //
     // salesOrderDetails1
     //
     this.salesOrderDetails1.Name = "salesOrderDetails1";
     //
     // Invoice
     //
     this.DataSource = this.InvoicesDataSource;
     this.Filters.AddRange(new Telerik.Reporting.Data.Filter[] {
     new Telerik.Reporting.Data.Filter("=Fields.SalesOrderNumber", Telerik.Reporting.Data.FilterOperator.Equal, "=Parameters.OrderNumber.Value")});
     this.Groups.AddRange(new Telerik.Reporting.Group[] {
     this.group1});
     this.Items.AddRange(new Telerik.Reporting.ReportItemBase[] {
     this.groupHeaderSection1,
     this.groupFooterSection1,
     this.detail,
     this.pageFooterSection1});
     this.PageSettings.Landscape = false;
     this.PageSettings.Margins.Bottom = new Telerik.Reporting.Drawing.Unit(0.5D, Telerik.Reporting.Drawing.UnitType.Inch);
     this.PageSettings.Margins.Left = new Telerik.Reporting.Drawing.Unit(0.5D, Telerik.Reporting.Drawing.UnitType.Inch);
     this.PageSettings.Margins.Right = new Telerik.Reporting.Drawing.Unit(0.5D, Telerik.Reporting.Drawing.UnitType.Inch);
     this.PageSettings.Margins.Top = new Telerik.Reporting.Drawing.Unit(0.5D, Telerik.Reporting.Drawing.UnitType.Inch);
     this.PageSettings.PaperKind = System.Drawing.Printing.PaperKind.Letter;
     reportParameter1.AutoRefresh = true;
     reportParameter1.AvailableValues.DataSource = this.OrderNumbersDataSource;
     reportParameter1.AvailableValues.DisplayMember = "SalesOrderNumber";
     reportParameter1.AvailableValues.Sortings.AddRange(new Telerik.Reporting.Data.Sorting[] {
     new Telerik.Reporting.Data.Sorting("=Fields.SalesOrderNumber", Telerik.Reporting.Data.SortDirection.Asc)});
     reportParameter1.AvailableValues.ValueMember = "SalesOrderNumber";
     reportParameter1.Name = "OrderNumber";
     reportParameter1.Text = "Order #";
     reportParameter1.Value = "=First(Fields.SalesOrderNumber)";
     reportParameter1.Visible = true;
     reportParameter2.Name = "ForYear";
     reportParameter2.Type = Telerik.Reporting.ReportParameterType.Integer;
     reportParameter2.Value = "=2003";
     reportParameter3.Name = "ForMonth";
     reportParameter3.Type = Telerik.Reporting.ReportParameterType.Integer;
     reportParameter3.Value = "=7";
     this.ReportParameters.Add(reportParameter1);
     this.ReportParameters.Add(reportParameter2);
     this.ReportParameters.Add(reportParameter3);
     this.Style.BackgroundColor = System.Drawing.Color.White;
     this.Width = new Telerik.Reporting.Drawing.Unit(7.5000009536743164D, Telerik.Reporting.Drawing.UnitType.Inch);
     ((System.ComponentModel.ISupportInitialize)(this.salesOrderDetails1)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this)).EndInit();
 }
 /// <summary>
 /// Required method for telerik Reporting designer support - do not modify
 /// the contents of this method with the code editor.
 /// </summary>
 private void InitializeComponent()
 {
     System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(SalesOrderDetails));
     Telerik.Reporting.ReportParameter reportParameter1 = new Telerik.Reporting.ReportParameter();
     Telerik.Reporting.Drawing.StyleRule styleRule1 = new Telerik.Reporting.Drawing.StyleRule();
     Telerik.Reporting.Drawing.StyleRule styleRule2 = new Telerik.Reporting.Drawing.StyleRule();
     Telerik.Reporting.Drawing.StyleRule styleRule3 = new Telerik.Reporting.Drawing.StyleRule();
     Telerik.Reporting.Drawing.StyleRule styleRule4 = new Telerik.Reporting.Drawing.StyleRule();
     this.labelsGroupHeader = new Telerik.Reporting.GroupHeaderSection();
     this.panel1 = new Telerik.Reporting.Panel();
     this.productNumberCaptionTextBox = new Telerik.Reporting.TextBox();
     this.nameCaptionTextBox = new Telerik.Reporting.TextBox();
     this.orderQtyCaptionTextBox = new Telerik.Reporting.TextBox();
     this.unitPriceCaptionTextBox = new Telerik.Reporting.TextBox();
     this.lineTotalCaptionTextBox = new Telerik.Reporting.TextBox();
     this.labelsGroupFooter = new Telerik.Reporting.GroupFooterSection();
     this.textBox1 = new Telerik.Reporting.TextBox();
     this.textBox2 = new Telerik.Reporting.TextBox();
     this.labelsGroup = new Telerik.Reporting.Group();
     this.detail = new Telerik.Reporting.DetailSection();
     this.productNumberDataTextBox = new Telerik.Reporting.TextBox();
     this.nameDataTextBox = new Telerik.Reporting.TextBox();
     this.orderQtyDataTextBox = new Telerik.Reporting.TextBox();
     this.unitPriceDataTextBox = new Telerik.Reporting.TextBox();
     this.lineTotalDataTextBox = new Telerik.Reporting.TextBox();
     this.sqlDataSource1 = new Telerik.Reporting.SqlDataSource();
     ((System.ComponentModel.ISupportInitialize)(this)).BeginInit();
     //
     // labelsGroupHeader
     //
     this.labelsGroupHeader.Height = new Telerik.Reporting.Drawing.Unit(0.30000004172325134, Telerik.Reporting.Drawing.UnitType.Inch);
     this.labelsGroupHeader.Items.AddRange(new Telerik.Reporting.ReportItemBase[] {
     this.panel1});
     this.labelsGroupHeader.Name = "labelsGroupHeader";
     this.labelsGroupHeader.PrintOnEveryPage = true;
     //
     // panel1
     //
     this.panel1.Items.AddRange(new Telerik.Reporting.ReportItemBase[] {
     this.productNumberCaptionTextBox,
     this.nameCaptionTextBox,
     this.orderQtyCaptionTextBox,
     this.unitPriceCaptionTextBox,
     this.lineTotalCaptionTextBox});
     this.panel1.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(0, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0, Telerik.Reporting.Drawing.UnitType.Inch));
     this.panel1.Name = "panel1";
     this.panel1.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(7.5, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.30000004172325134, Telerik.Reporting.Drawing.UnitType.Inch));
     this.panel1.Style.BackgroundColor = System.Drawing.Color.FromArgb(((int)(((byte)(229)))), ((int)(((byte)(245)))), ((int)(((byte)(255)))));
     //
     // productNumberCaptionTextBox
     //
     this.productNumberCaptionTextBox.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(0, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(3.9378803194267675E-05, Telerik.Reporting.Drawing.UnitType.Inch));
     this.productNumberCaptionTextBox.Name = "productNumberCaptionTextBox";
     this.productNumberCaptionTextBox.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1.3000000715255737, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.30000004172325134, Telerik.Reporting.Drawing.UnitType.Inch));
     this.productNumberCaptionTextBox.Style.Font.Bold = true;
     this.productNumberCaptionTextBox.StyleName = "Caption";
     this.productNumberCaptionTextBox.Value = "ProductNumber";
     //
     // nameCaptionTextBox
     //
     this.nameCaptionTextBox.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(1.3000787496566773, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0, Telerik.Reporting.Drawing.UnitType.Inch));
     this.nameCaptionTextBox.Name = "nameCaptionTextBox";
     this.nameCaptionTextBox.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(2.7999212741851807, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.30000004172325134, Telerik.Reporting.Drawing.UnitType.Inch));
     this.nameCaptionTextBox.Style.Font.Bold = true;
     this.nameCaptionTextBox.StyleName = "Caption";
     this.nameCaptionTextBox.Value = "Name";
     //
     // orderQtyCaptionTextBox
     //
     this.orderQtyCaptionTextBox.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(4.100039005279541, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(-1.2417634032146907E-08, Telerik.Reporting.Drawing.UnitType.Inch));
     this.orderQtyCaptionTextBox.Name = "orderQtyCaptionTextBox";
     this.orderQtyCaptionTextBox.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(0.91025900840759277, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.30000004172325134, Telerik.Reporting.Drawing.UnitType.Inch));
     this.orderQtyCaptionTextBox.Style.Font.Bold = true;
     this.orderQtyCaptionTextBox.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Right;
     this.orderQtyCaptionTextBox.StyleName = "Caption";
     this.orderQtyCaptionTextBox.Value = "Quantity";
     //
     // unitPriceCaptionTextBox
     //
     this.unitPriceCaptionTextBox.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(5.0103774070739746, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0, Telerik.Reporting.Drawing.UnitType.Inch));
     this.unitPriceCaptionTextBox.Name = "unitPriceCaptionTextBox";
     this.unitPriceCaptionTextBox.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1.222798228263855, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.30000004172325134, Telerik.Reporting.Drawing.UnitType.Inch));
     this.unitPriceCaptionTextBox.Style.Font.Bold = true;
     this.unitPriceCaptionTextBox.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Right;
     this.unitPriceCaptionTextBox.StyleName = "Caption";
     this.unitPriceCaptionTextBox.Value = "Unit Price";
     //
     // lineTotalCaptionTextBox
     //
     this.lineTotalCaptionTextBox.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(6.2332539558410645, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0, Telerik.Reporting.Drawing.UnitType.Inch));
     this.lineTotalCaptionTextBox.Name = "lineTotalCaptionTextBox";
     this.lineTotalCaptionTextBox.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1.2666666507720947, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.30000004172325134, Telerik.Reporting.Drawing.UnitType.Inch));
     this.lineTotalCaptionTextBox.Style.Font.Bold = true;
     this.lineTotalCaptionTextBox.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Right;
     this.lineTotalCaptionTextBox.StyleName = "Caption";
     this.lineTotalCaptionTextBox.Value = "Line Total";
     //
     // labelsGroupFooter
     //
     this.labelsGroupFooter.Height = new Telerik.Reporting.Drawing.Unit(0.30000004172325134, Telerik.Reporting.Drawing.UnitType.Inch);
     this.labelsGroupFooter.Items.AddRange(new Telerik.Reporting.ReportItemBase[] {
     this.textBox1,
     this.textBox2});
     this.labelsGroupFooter.Name = "labelsGroupFooter";
     this.labelsGroupFooter.Style.BackgroundColor = System.Drawing.Color.FromArgb(((int)(((byte)(192)))), ((int)(((byte)(229)))), ((int)(((byte)(255)))));
     this.labelsGroupFooter.Style.Visible = true;
     //
     // textBox1
     //
     this.textBox1.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(5.010338306427002, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0, Telerik.Reporting.Drawing.UnitType.Inch));
     this.textBox1.Name = "textBox1";
     this.textBox1.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1.2228368520736694, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.30000004172325134, Telerik.Reporting.Drawing.UnitType.Inch));
     this.textBox1.Style.Font.Bold = true;
     this.textBox1.Style.Font.Size = new Telerik.Reporting.Drawing.Unit(11, Telerik.Reporting.Drawing.UnitType.Point);
     this.textBox1.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Right;
     this.textBox1.Value = "Total";
     //
     // textBox2
     //
     this.textBox2.Format = "{0:C2}";
     this.textBox2.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(6.2332935333251953, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0, Telerik.Reporting.Drawing.UnitType.Inch));
     this.textBox2.Name = "textBox2";
     this.textBox2.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1.2666668891906738, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.30000004172325134, Telerik.Reporting.Drawing.UnitType.Inch));
     this.textBox2.Style.Font.Bold = true;
     this.textBox2.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Right;
     this.textBox2.Value = "=Sum(Fields.LineTotal)";
     //
     // labelsGroup
     //
     this.labelsGroup.GroupFooter = this.labelsGroupFooter;
     this.labelsGroup.GroupHeader = this.labelsGroupHeader;
     this.labelsGroup.Name = "labelsGroup";
     //
     // detail
     //
     this.detail.Height = new Telerik.Reporting.Drawing.Unit(0.30000004172325134, Telerik.Reporting.Drawing.UnitType.Inch);
     this.detail.Items.AddRange(new Telerik.Reporting.ReportItemBase[] {
     this.productNumberDataTextBox,
     this.nameDataTextBox,
     this.orderQtyDataTextBox,
     this.unitPriceDataTextBox,
     this.lineTotalDataTextBox});
     this.detail.Name = "detail";
     //
     // productNumberDataTextBox
     //
     this.productNumberDataTextBox.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(0, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0, Telerik.Reporting.Drawing.UnitType.Inch));
     this.productNumberDataTextBox.Name = "productNumberDataTextBox";
     this.productNumberDataTextBox.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1.3000000715255737, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.30000004172325134, Telerik.Reporting.Drawing.UnitType.Inch));
     this.productNumberDataTextBox.Style.Padding.Left = new Telerik.Reporting.Drawing.Unit(2, Telerik.Reporting.Drawing.UnitType.Point);
     this.productNumberDataTextBox.StyleName = "Data";
     this.productNumberDataTextBox.Value = "=Fields.ProductNumber";
     //
     // nameDataTextBox
     //
     this.nameDataTextBox.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(1.3000787496566773, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0, Telerik.Reporting.Drawing.UnitType.Inch));
     this.nameDataTextBox.Name = "nameDataTextBox";
     this.nameDataTextBox.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(2.7999212741851807, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.30000004172325134, Telerik.Reporting.Drawing.UnitType.Inch));
     this.nameDataTextBox.StyleName = "Data";
     this.nameDataTextBox.Value = "=Fields.Name";
     //
     // orderQtyDataTextBox
     //
     this.orderQtyDataTextBox.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(4.10007905960083, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0, Telerik.Reporting.Drawing.UnitType.Inch));
     this.orderQtyDataTextBox.Name = "orderQtyDataTextBox";
     this.orderQtyDataTextBox.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(0.91018062829971313, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.30000004172325134, Telerik.Reporting.Drawing.UnitType.Inch));
     this.orderQtyDataTextBox.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Right;
     this.orderQtyDataTextBox.StyleName = "Data";
     this.orderQtyDataTextBox.Value = "=Fields.OrderQty";
     //
     // unitPriceDataTextBox
     //
     this.unitPriceDataTextBox.Format = "{0:C2}";
     this.unitPriceDataTextBox.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(5.010338306427002, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0, Telerik.Reporting.Drawing.UnitType.Inch));
     this.unitPriceDataTextBox.Name = "unitPriceDataTextBox";
     this.unitPriceDataTextBox.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1.2228771448135376, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.30000004172325134, Telerik.Reporting.Drawing.UnitType.Inch));
     this.unitPriceDataTextBox.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Right;
     this.unitPriceDataTextBox.StyleName = "Data";
     this.unitPriceDataTextBox.Value = "=Fields.UnitPrice";
     //
     // lineTotalDataTextBox
     //
     this.lineTotalDataTextBox.Format = "{0:C2}";
     this.lineTotalDataTextBox.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(6.2332539558410645, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0, Telerik.Reporting.Drawing.UnitType.Inch));
     this.lineTotalDataTextBox.Name = "lineTotalDataTextBox";
     this.lineTotalDataTextBox.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1.2666666507720947, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.30000004172325134, Telerik.Reporting.Drawing.UnitType.Inch));
     this.lineTotalDataTextBox.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Right;
     this.lineTotalDataTextBox.StyleName = "Data";
     this.lineTotalDataTextBox.Value = "=Fields.LineTotal";
     //
     // sqlDataSource1
     //
     this.sqlDataSource1.ConnectionString = "Telerik.Reporting.Examples.CSharp.Properties.Settings.TelerikConnectionString";
     this.sqlDataSource1.Name = "sqlDataSource1";
     this.sqlDataSource1.Parameters.AddRange(new Telerik.Reporting.SqlDataSourceParameter[] {
     new Telerik.Reporting.SqlDataSourceParameter("@SalesOrderID", System.Data.DbType.Int32, "=Parameters.SaledOrderID.Value")});
     this.sqlDataSource1.SelectCommand = resources.GetString("sqlDataSource1.SelectCommand");
     //
     // SalesOrderDetails
     //
     this.DataSource = this.sqlDataSource1;
     this.Filters.AddRange(new Telerik.Reporting.Data.Filter[] {
     new Telerik.Reporting.Data.Filter("=Fields.SalesOrderID", Telerik.Reporting.Data.FilterOperator.Equal, "=Parameters.SaledOrderID.Value")});
     this.Groups.AddRange(new Telerik.Reporting.Group[] {
     this.labelsGroup});
     this.Items.AddRange(new Telerik.Reporting.ReportItemBase[] {
     this.labelsGroupHeader,
     this.labelsGroupFooter,
     this.detail});
     this.PageSettings.Landscape = false;
     this.PageSettings.Margins.Bottom = new Telerik.Reporting.Drawing.Unit(0.25, Telerik.Reporting.Drawing.UnitType.Inch);
     this.PageSettings.Margins.Left = new Telerik.Reporting.Drawing.Unit(0.5, Telerik.Reporting.Drawing.UnitType.Inch);
     this.PageSettings.Margins.Right = new Telerik.Reporting.Drawing.Unit(0.5, Telerik.Reporting.Drawing.UnitType.Inch);
     this.PageSettings.Margins.Top = new Telerik.Reporting.Drawing.Unit(0.25, Telerik.Reporting.Drawing.UnitType.Inch);
     this.PageSettings.PaperKind = System.Drawing.Printing.PaperKind.Letter;
     reportParameter1.Name = "SaledOrderID";
     reportParameter1.Value = "=43860";
     this.ReportParameters.Add(reportParameter1);
     this.Style.BackgroundColor = System.Drawing.Color.White;
     styleRule1.Selectors.AddRange(new Telerik.Reporting.Drawing.ISelector[] {
     new Telerik.Reporting.Drawing.StyleSelector("Title")});
     styleRule1.Style.Color = System.Drawing.Color.Black;
     styleRule1.Style.Font.Bold = true;
     styleRule1.Style.Font.Italic = false;
     styleRule1.Style.Font.Name = "Tahoma";
     styleRule1.Style.Font.Size = new Telerik.Reporting.Drawing.Unit(20, Telerik.Reporting.Drawing.UnitType.Point);
     styleRule1.Style.Font.Strikeout = false;
     styleRule1.Style.Font.Underline = false;
     styleRule2.Selectors.AddRange(new Telerik.Reporting.Drawing.ISelector[] {
     new Telerik.Reporting.Drawing.StyleSelector("Caption")});
     styleRule2.Style.Color = System.Drawing.Color.Black;
     styleRule2.Style.Font.Name = "Tahoma";
     styleRule2.Style.Font.Size = new Telerik.Reporting.Drawing.Unit(11, Telerik.Reporting.Drawing.UnitType.Point);
     styleRule2.Style.VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Middle;
     styleRule3.Selectors.AddRange(new Telerik.Reporting.Drawing.ISelector[] {
     new Telerik.Reporting.Drawing.StyleSelector("Data")});
     styleRule3.Style.Font.Name = "Tahoma";
     styleRule3.Style.Font.Size = new Telerik.Reporting.Drawing.Unit(11, Telerik.Reporting.Drawing.UnitType.Point);
     styleRule3.Style.VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Middle;
     styleRule4.Selectors.AddRange(new Telerik.Reporting.Drawing.ISelector[] {
     new Telerik.Reporting.Drawing.StyleSelector("PageInfo")});
     styleRule4.Style.Font.Name = "Tahoma";
     styleRule4.Style.Font.Size = new Telerik.Reporting.Drawing.Unit(11, Telerik.Reporting.Drawing.UnitType.Point);
     styleRule4.Style.VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Middle;
     this.StyleSheet.AddRange(new Telerik.Reporting.Drawing.StyleRule[] {
     styleRule1,
     styleRule2,
     styleRule3,
     styleRule4});
     this.Width = new Telerik.Reporting.Drawing.Unit(7.5, Telerik.Reporting.Drawing.UnitType.Inch);
     ((System.ComponentModel.ISupportInitialize)(this)).EndInit();
 }
Example #5
0
 public static void GenerateHeaderFooters()
 {
     for (int i = 0; i < 50; i++)
     {
         HeaderSections[i] = new GroupHeaderSection();
         FooterSections[i] = new GroupFooterSection();
         AllGroups[i] = new Telerik.Reporting.Group();
         HeaderSections[i].Height = Unit.Inch(TBHeight);
         HeaderSections[i].Style.BackgroundColor = Color.FromArgb(224, 224, 224);
         FooterSections[i].Height = Unit.Inch(TBHeight);
         AllGroups[i].GroupFooter = FooterSections[i];
         AllGroups[i].GroupHeader = HeaderSections[i];
     }
 }
Example #6
0
        /// <summary>
        /// Builds the report.
        /// </summary>
        /// <param name="reportDocument">The report document.</param>
        public void BuildReport(ICustomReport reportDocument)
        {
            var currentReport = reportDocument.Reports.First();

            SetIdentity(currentReport);
            //_originalPageHeaderHeight = ((PageHeaderSection) currentReport.Items["pageHeader"]).Height;

            //This report parameter holds the current template system name.
            _processName = currentReport.ReportParameters["processName"].Value.ToString();

            //This report parameter holds the currently visible columns of the grid and in what order they're in
            var cols = currentReport.ReportParameters["columns"].Value.ToString();

            var columns = cols.Split(';').ToList();
            _columns = new List<ColumnInfo>();
            foreach (var col in columns)
            {
                _columns.Add(new ColumnInfo(col));
            }

            var groupsStr = currentReport.ReportParameters["groups"].Value.ToString();
            _groups = (string.IsNullOrEmpty(groupsStr) ? new string[0] : groupsStr.Split(';')).ToList();

            //TODO: Uncomment if needed
           // _columns.AddRange(_groups);

            if (reportDocument.FitToPage)
            {
                if (currentReport.GetType().Name.ToLower().Contains("landscape"))
                {
                    FitToPageColumnWidth = Math.Min(1, 10.0 / _columns.Count);
                    FitToPageColumnCount = (short) Math.Max(10, _columns.Count);
                }

                if (currentReport.GetType().Name.ToLower().Contains("portrait"))
                {
                    FitToPageColumnWidth = Math.Min(1.1, 7.0 / _columns.Count);
                    FitToPageColumnCount = (short) Math.Max(7, _columns.Count);
                }

                currentReport.Width = new Unit(_columns.Count * FitToPageColumnWidth, UnitType.Inch);
            }

            _groupColumn = currentReport.ReportParameters["groupColumn"].Value.ToString();

            var fldList = new List<FieldInfo>(_columns.Count);

            var processProperties = new Dictionary<PropertyInfo, string>();
            var processType = TheDynamicTypeManager.GetInfoType<IInfoClass>(_processName);

            if (processType != null)
            {
                processProperties = processType.GetAllPropertiesWithPaths();
                var properties = processProperties.Where(p => _columns.Any(c=>c.SystemName == p.Value));

                foreach (var column in _columns)
                {
                    foreach (var property in properties)
                    {
                        if (property.Value == column.SystemName)
                        {
                            fldList.Add(new FieldInfo(property.Key, column));
                            break;
                        }
                    }
                }

                _fieldAttrDict = GetFieldAttributes(processProperties.Select(x => x.Key));
            }

            if (_fieldAttrDict == null)
                _fieldAttrDict = new Dictionary<PropertyInfo, FieldParametres>();

            _colDict = new SortedDictionary<int, string[]>();

            //Grouping            
            foreach (var colName in _groups)
            {
                var group = new Telerik.Reporting.Group();
                group.Name = colName;
                var groupHeaderSection = new GroupHeaderSection();
                var groupFooterSection = new GroupFooterSection();
                group.GroupHeader = groupHeaderSection;
                group.GroupFooter = groupFooterSection;

                var txt = new TextBox();
                txt.Style.Font.Size = new Unit(10, UnitType.Point);
                txt.Style.Font.Bold = true;
                txt.Style.BackgroundColor = Color.FromArgb(255, 225, 225, 225);
                txt.Style.TextAlign = HorizontalAlign.Left;
                txt.Style.VerticalAlign = VerticalAlign.Middle;
                groupHeaderSection.Items.Add(txt);
                groupHeaderSection.Height = new Unit(21);
                groupHeaderSection.Style.BorderStyle.Default = BorderType.Solid;
                groupHeaderSection.Style.BorderColor.Default = Color.White;
                groupHeaderSection.Style.BorderColor.Left = Color.Transparent;

                var panel = new Panel();
                panel.Height = new Unit(20);
                panel.Style.LineStyle = LineStyle.Solid;
                panel.Style.LineWidth = new Unit(2.0);
                panel.Style.BorderColor.Default = Color.Black;
                panel.Style.BorderWidth.Default = new Unit(2.0);
                panel.Style.BorderStyle.Default = BorderType.None;
                panel.Style.BorderStyle.Top = BorderType.Solid;
                panel.Style.BorderStyle.Bottom = BorderType.Solid;
                groupFooterSection.Items.Add(panel);
                groupFooterSection.Height = new Unit(25);
                //groupFooterSection.Style.BorderStyle.Default = BorderType.Solid;
                //groupFooterSection.Style.BorderColor.Default = Color.White;
                groupFooterSection.Style.BorderColor.Left = Color.Transparent;
                groupFooterSection.Style.Padding.Top = new Unit(2);
                groupFooterSection.Style.Padding.Bottom = new Unit(2);

                //if you need to filter the data, apply filtering
                //group1.Filters.Add(new Telerik.Reporting.Data.Filter("=Fields.ProductID", Telerik.Reporting.Data.FilterOperator.Equal, "=10"));

                currentReport.Groups.Add(group);
            }

            var aggregateData = currentReport.ReportParameters["aggregates"].Value.ToString();
            _aggregateDict = ParseAggregateData(aggregateData);

            var nextLeft = _groups.Count > 0 ? (_groups.Count - 1) * 0.15 : 0;
            var availableWidth = currentReport.Width.Value - nextLeft;
            var ctrlSize = availableWidth / (fldList.Count() - _groups.Count);

            _indentOffset = 0;

            _reportItemCounter = new Dictionary<string, int>();

            var counter = 0;
            double fitToPageFooterLocationX = 0;

            //posess fields
            foreach (var fld in fldList)
            {
                if (_reportItemCounter.ContainsKey(fld.Property.Name))
                {
                    continue;
                }

                var fieldValueMap = GetFieldValueMap(currentReport, fld.Property, processProperties[fld.Property]);

                if (_groups.Contains(processProperties[fld.Property] ?? string.Empty))
                {
                    //create group
                    var fieldGroup = currentReport.Groups.FirstOrDefault(x => x.Name == processProperties[fld.Property]);
                    if (fieldGroup != null)
                    {
                        _indentOffset = 0.15 * _groups.IndexOf(processProperties[fld.Property]);

                        fieldGroup.Groupings.Add(new Grouping(fieldValueMap));
                        ((TextBox)fieldGroup.GroupHeader.Items[0]).Value = string.Format("='  ' + {0} + '    Total: ' + Exec('{1}', Count(IsNull({0},1)))", fieldValueMap.TrimStart('='), fieldGroup.Name);
                        ((TextBox)fieldGroup.GroupHeader.Items[0]).Location = new PointU(new Unit(_indentOffset, UnitType.Inch), new Unit(0, UnitType.Inch));
                        ((TextBox)fieldGroup.GroupHeader.Items[0]).Size = new SizeU(new Unit(currentReport.Width.Value - _indentOffset, UnitType.Inch), new Unit(20, UnitType.Pixel));
                        //AddGroupLevelLines(fieldGroup.GroupHeader.Items);

                        ((Panel)fieldGroup.GroupFooter.Items[0]).Location = new PointU(new Unit(_indentOffset, UnitType.Inch), new Unit(0, UnitType.Inch));
                        ((Panel)fieldGroup.GroupFooter.Items[0]).Size = new SizeU(new Unit(currentReport.Width.Value - _indentOffset, UnitType.Inch), new Unit(20, UnitType.Pixel));
                        //AddGroupLevelLines(fieldGroup.GroupFooter.Items);                    
                    }

                    continue;
                }

                var cPoint = new PointU(new Unit(nextLeft, UnitType.Inch), new Unit(0.4, UnitType.Inch));
                var uSize = new SizeU(new Unit(ctrlSize, UnitType.Inch), new Unit(0.2, UnitType.Inch));

                var attr = fld.Property.GetCustomAttributes(false);
                var displayAttr = attr.FirstOrDefault(x => x is DisplayAttribute) as DisplayAttribute;

                string colName = "<NoName>";
                if (displayAttr == null)
                {
                    colName = fld.Column.Header;
                    //var infoInstance = Activator.CreateInstance(processType);
                    //if (infoInstance != null)
                    //{
                    //    var field = processType.GetField(fld.Name + "Property");
                    //    if (field != null)
                    //    {
                    //        var fieldValue = field.GetValue(infoInstance) as IPropertyInfo;
                    //        if (fieldValue != null)
                    //        {
                    //            colName = fieldValue.FriendlyName;
                    //        }
                    //    }
                    //}
                }
                else
                {
                    colName = displayAttr.GetName();
                }

                var headerLabel = new TextBox { Value = colName, Location = cPoint, Size = uSize, StyleName = "Caption", Multiline = true, CanGrow = true };
                headerLabel.Style.BackgroundColor = Color.Transparent;
                headerLabel.Style.Font.Size = new Unit(10, UnitType.Point);
                headerLabel.Style.VerticalAlign = VerticalAlign.Top;

                var dataTextBox = new TextBox();
                var dataTextBoxName = string.Format("{0}TextBox", processProperties[fld.Property]);
                dataTextBox.Name = dataTextBoxName;

                var propertyName = processProperties[fld.Property];
                var isExistsBackgroudColor = processProperties.Any(x => x.Key.Name == propertyName + Constants.FieldBackColorPostfix);

                dataTextBox.TextWrap = true;
                dataTextBox.Location = new PointU(new Unit(nextLeft, UnitType.Inch), new Unit(0, UnitType.Inch));
                dataTextBox.Size = uSize;
                dataTextBox.CanGrow = true;

                if (isExistsBackgroudColor)
                {
                    if (fieldValueMap.StartsWith("="))
                    {
                        fieldValueMap = fieldValueMap.Remove(0, 1);
                        fieldValueMap = string.Format("=GetValueWithBackgroundColor({0}, Fields.[{1}{2}])", fieldValueMap, processProperties[fld.Property], Constants.FieldBackColorPostfix);

                        EventHandler itemDataBoundHandler = (sender, args) =>
                            {
                                var textBox = sender as Telerik.Reporting.Processing.TextBox;
                                if (textBox == null)
                                {
                                    return;
                                }

                                var colorAsLong = ((KeyValuePair<object, long>)textBox.Value).Value;
                                if (colorAsLong != 0)
                                {
                                    var bytes = BitConverter.GetBytes(colorAsLong);
                                    if (bytes[3] == 0) bytes[3] = 255;
                                    var color = Color.FromArgb(bytes[3], bytes[2], bytes[1], bytes[0]);

                                    ((Telerik.Reporting.Processing.ProcessingElement)sender).Style.BackgroundColor = color;
                                }

                                textBox.Value = ((KeyValuePair<object, long>)textBox.Value).Key;

                            };
                        dataTextBox.ItemDataBound += itemDataBoundHandler;

                        EventHandler dataTextBoxDisposedHandler = null;
                        dataTextBoxDisposedHandler = (sender, args) =>
                        {
                            dataTextBox.ItemDataBound -= itemDataBoundHandler;
                            dataTextBox.Disposed -= dataTextBoxDisposedHandler;
                        };
                        dataTextBox.Disposed += dataTextBoxDisposedHandler;
                    }
                }

                dataTextBox.Value = fieldValueMap;

                if (!reportDocument.FitToPage)
                {
                    dataTextBox.ItemDataBound += OnItemDataBound;

                    EventHandler dataTextBoxDisposedHandler = null;
                    dataTextBoxDisposedHandler = (sender, args) =>
                    {
                        dataTextBox.ItemDataBound -= OnItemDataBound;
                        dataTextBox.Disposed -= dataTextBoxDisposedHandler;
                    };
                    dataTextBox.Disposed += dataTextBoxDisposedHandler;
                }

                var pictureBox = new PictureBox { Value = fieldValueMap };
                pictureBox.Name = string.Format("{0}TextBox", processProperties[fld.Property]);
                pictureBox.Sizing = ImageSizeMode.ScaleProportional;

                if (!reportDocument.FitToPage)
                {
                    pictureBox.ItemDataBound += OnItemDataBound;

                    EventHandler pictureBoxDisposedHandler = null;
                    pictureBoxDisposedHandler = (sender, args) =>
                        {
                            pictureBox.ItemDataBound -= OnItemDataBound;
                            pictureBox.Disposed -= pictureBoxDisposedHandler;
                        };
                    pictureBox.Disposed += pictureBoxDisposedHandler;
                }

                nextLeft = nextLeft + ctrlSize;

                if (reportDocument.FitToPage)
                {
                    currentReport.Items["labelsGroupHeaderSection"].Items.Add(headerLabel);
                }
                else
                {
                    currentReport.Items["pageHeader"].Items.Add(headerLabel);
                }

                if (_fieldAttrDict[fld.Property].FieldEditor == "Image")
                {
                    currentReport.Items["detail"].Items["rowPanel"].Items.Add(pictureBox);
                }
                else
                {
                    currentReport.Items["detail"].Items["rowPanel"].Items.Add(dataTextBox);
                }

                _reportItemCounter.Add(processProperties[fld.Property], 0);

                if (reportDocument.FitToPage)
                {
                    _colDict.Add(currentReport.Items["labelsGroupHeaderSection"].Items.Count - 1, new[] { processProperties[fld.Property], headerLabel.Value });
                }
                else
                {
                    _colDict.Add(currentReport.Items["pageHeader"].Items.Count - 1, new[] { processProperties[fld.Property], headerLabel.Value });
                }

                if (reportDocument.FitToPage)
                {
                    fitToPageFooterLocationX = counter % FitToPageColumnCount == 0 ? 0 : fitToPageFooterLocationX;

                    if (_aggregateDict.Keys.All(x => x != fld.Property.Name))
                    {
                        var footerTextBox = new TextBox
                        {
                            Name = string.Format("{0}{1}FooterTextBox", fld.Property.Name, fldList.IndexOf(fld)),
                            Location = new PointU(new Unit(fitToPageFooterLocationX, UnitType.Inch), new Unit(0, UnitType.Inch)),
                            Size = new SizeU(new Unit(FitToPageColumnWidth, UnitType.Inch), new Unit(0.15, UnitType.Inch))
                        };

                        currentReport.Items["pageFooter"].Items.Add(footerTextBox);
                    }

                    //calculate server-side aggregates
                    var aggregateDefinitions = _aggregateDict.ToList()
                        .SelectMany(i => i.Value)
                        .Where(d => !AggregateHelper.IsPageAggregateType(d.SummaryType))
                        .ToList();

                    var queryCriteria = new AggregateDataSourceQueryCriteria
                    {
                        ProcessName = _processName,
                        FilterDefinition = GetFilterDefinition(currentReport)
                    };
                    var serverAggregateResults = AggregateProcessor.CalculateAggregates(aggregateDefinitions, queryCriteria);

                    foreach (var aggregateItem in _aggregateDict)
                    {
                        if (aggregateItem.Key != fld.Property.Name)
                        {
                            continue;
                        }

                        double fitToPageFooterLocationY = 0;

                        for (var i = 0; i < aggregateItem.Value.Count; i++)
                        {
                            var footerTextBox = new TextBox
                                {
                                    Name = string.Format("{0}{1}FooterTextBox", fld.Property.Name, aggregateItem.Value[i].SummaryType), // telerik recommends set unique names for all controls
                                    Size = new SizeU(new Unit(GetWidthFitToPage(fld.Property.Name, i), UnitType.Inch), new Unit(0.15, UnitType.Inch)),
                                    Location = new PointU(new Unit(fitToPageFooterLocationX, UnitType.Inch), new Unit(fitToPageFooterLocationY, UnitType.Inch))
                                };

                            if (AggregateHelper.IsPageAggregateType(aggregateItem.Value[i].SummaryType))
                            {
                                footerTextBox.Value = string.Format(@"='{0}: ' + AfterCalculateAggregates(PageExec('{1}TextBox', {2}(BeforeCalculateAggregates(Fields.[{1}], ""{2}"", ""{3}"", ""{4}"", ""{5}"", ""{6}""))), ""{2}"", ""{3}"", ""{4}"", ""{5}"", ""{6}"")",
                                        AggregateProcessor.GetAggregateFunctionShortName(aggregateItem.Value[i].SummaryType), aggregateItem.Key, aggregateItem.Value[i].SummaryType, aggregateItem.Value[i].CustomConverter, aggregateItem.Value[i].TargetType, aggregateItem.Value[i].TypeName, aggregateItem.Value[i].ConverterParameter);
                            }
                            else
                            {
                                var result = serverAggregateResults.FirstOrDefault(r => r.ColumnName == aggregateItem.Key && r.SummaryType == aggregateItem.Value[i].SummaryType);
                                footerTextBox.Value = string.Format("{0}: {1}", AggregateHelper.GetAttribute(aggregateItem.Value[i].SummaryType).ShortName, result != null ? result.Value : Constants.Empty);
                            }

                            if (aggregateItem.Value[i].SummaryType == SummaryTypes.Count)
                            {
                                footerTextBox.Bindings.Add(new Binding("Visible", string.Format(@"=IIf(PageExec(""{0}"", Count(Fields.{1})) = 0, False, True)", dataTextBoxName, fld.Property.Name)));
                            }

                            if (aggregateItem.Value[i].SummaryType == SummaryTypes.Min || aggregateItem.Value[i].SummaryType == SummaryTypes.Max)
                            {
                                if (fld.Property.PropertyType != typeof(bool) && fld.Property.PropertyType != typeof(bool?))//VRN-5079
                                {
                                    footerTextBox.Bindings.Add(new Binding("Visible", string.Format(@"=FooterTextBoxVisibilityWithValue(PageExec(""{0}"", Min(Fields.{1})))", dataTextBoxName, fld.Property.Name)));
                                }
                            }

                            fitToPageFooterLocationY += 0.15;
                            currentReport.Items["pageFooter"].Items.Add(footerTextBox);
                        }
                    }

                    fitToPageFooterLocationX += FitToPageColumnWidth;
                    counter++;
                }
            }

            if (reportDocument.FitToPage)
            {
                var max = _aggregateDict.Count == 0 ? 0 : _aggregateDict.Max(x => x.Value.Count);
                if (max != 0)
                {
                    ((PageFooterSection) currentReport.Items["pageFooter"]).Height = new Unit(max*0.15 + 0.2, UnitType.Inch);
                }

                currentReport.Items["pageFooter"].Items["currentTimeTextBox"].Visible = false;
                currentReport.Items["pageFooter"].Items["pageInfoTextBox"].Visible = false;
            }

            _indentOffset = _groups.Count > 0 ? (_groups.Count - 1) * 0.15 : 0;

            //AddGroupLevelLines(currentReport.Items["detail"].Items["rowPanel"].Items);
        }