Printing Across and then Down Multi-Column Report

8 posts, 0 answers
  1. Joseph Baker
    Joseph Baker avatar
    17 posts
    Member since:
    Jul 2006

    Posted 07 Apr 2015 Link to this post

    Hello,
    I am using Telerik Reporting for web to create shipping labels and it looks great to print out one label at a time but if I want to print in a different position based on a parameter. I am using Avery label (template number is 5264) and it has 6 (2x3) labels on a sheet. Currently the label is a static design

    How can I do it? 

    For example,
    ----------
    | A | B |
    | C | D |
    | E | F |
    ---------

     I am passing over a parameter to signify where to print the label and how many. For example, I pass over parameter for starting position of 2 and how many to print of 2 then the label should start out in column B and go to C since the user wants to two copies of the label and calculate the page number for example column B would 1 of 2 and then column C would be 2 of 2.

    Shipment ID: SM00125486
    Starting Position: 3
    PageCount: 3 <-- this tells how many to print
    Orign_Name: Shipper Test
    Orign_Address_1: 1212 Spooky Spooky Avenue
    Orign_Address_2: 
    Orign_City: Kansas City
    Orign_State: MO
    Orign_Postal_Code: 64015
    Orign_Contact_Name: sender
    Orign_Contact_Phone: (123)456-7890
    Orign_Est_Date_Time: 03/09/2015 <-- Pickup Date textBox
    Reference: 1234PO

    Dest_Name: Herman Munson
    Dest_Address_1: 1234 main
    Dest_Address_2:
    Dest_City: beverly hills
    Dest_State: CA
    Dest_Postal_Code: 90210
    Dest_Contact_Name: receiver
    Dest_Contact_Phone: (1234)456-7898
    Dest_Est_Date_Time: 03/13/15 <-- Est Deliv Date
    Reference: 1234PO

    Page Number: calculate the first page number and use pagecount parameter

    Labels.Designer.cs
    namespace ReportLibrary.CommonReports
    {
        partial class Labels
        {
            #region Component Designer generated code
            /// <summary>
            /// Required method for telerik Reporting designer support - do not modify
            /// the contents of this method with the code editor.
            /// </summary>
            private void InitializeComponent()
            {
                Telerik.Reporting.Drawing.FormattingRule formattingRule1 = new Telerik.Reporting.Drawing.FormattingRule();
                Telerik.Reporting.Drawing.FormattingRule formattingRule2 = new Telerik.Reporting.Drawing.FormattingRule();
                Telerik.Reporting.Drawing.FormattingRule formattingRule3 = new Telerik.Reporting.Drawing.FormattingRule();
                Telerik.Reporting.Drawing.FormattingRule formattingRule4 = new Telerik.Reporting.Drawing.FormattingRule();
                Telerik.Reporting.Drawing.FormattingRule formattingRule5 = new Telerik.Reporting.Drawing.FormattingRule();
                Telerik.Reporting.ReportParameter reportParameter1 = new Telerik.Reporting.ReportParameter();
                Telerik.Reporting.ReportParameter reportParameter2 = new Telerik.Reporting.ReportParameter();
                Telerik.Reporting.ReportParameter reportParameter3 = new Telerik.Reporting.ReportParameter();
                Telerik.Reporting.ReportParameter reportParameter4 = 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();
                Telerik.Reporting.Drawing.StyleRule styleRule5 = new Telerik.Reporting.Drawing.StyleRule();
                this.MailingLabels = new Telerik.Reporting.SqlDataSource();
                this.detail = new Telerik.Reporting.DetailSection();
                this.panel1 = new Telerik.Reporting.Panel();
                this.textBox1 = new Telerik.Reporting.TextBox();
                this.textBox2 = new Telerik.Reporting.TextBox();
                this.textBox3 = new Telerik.Reporting.TextBox();
                this.textBox4 = new Telerik.Reporting.TextBox();
                this.textBox5 = new Telerik.Reporting.TextBox();
                this.textBox6 = new Telerik.Reporting.TextBox();
                this.textBox7 = new Telerik.Reporting.TextBox();
                this.lblShipmentId = new Telerik.Reporting.TextBox();
                this.textBox9 = new Telerik.Reporting.TextBox();
                this.textBox10 = new Telerik.Reporting.TextBox();
                this.textBox11 = new Telerik.Reporting.TextBox();
                this.textBox13 = new Telerik.Reporting.TextBox();
                this.textBox14 = new Telerik.Reporting.TextBox();
                this.textBox15 = 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.shape1 = new Telerik.Reporting.Shape();
                this.textBox20 = new Telerik.Reporting.TextBox();
                this.textBox21 = new Telerik.Reporting.TextBox();
                this.textBox22 = new Telerik.Reporting.TextBox();
                this.textBox23 = new Telerik.Reporting.TextBox();
                this.textBox24 = new Telerik.Reporting.TextBox();
                this.textBox25 = new Telerik.Reporting.TextBox();
                this.textBox26 = new Telerik.Reporting.TextBox();
                this.textBox27 = 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.lblReportInfo = new Telerik.Reporting.TextBox();
                ((System.ComponentModel.ISupportInitialize)(this)).BeginInit();
                // 
                // MailingLabels
                // 
                this.MailingLabels.ConnectionString = "ReportLibrary.Properties.Settings.RRSmartFreightSolutions";
                this.MailingLabels.Name = "MailingLabels";
                this.MailingLabels.Parameters.AddRange(new Telerik.Reporting.SqlDataSourceParameter[] {
                new Telerik.Reporting.SqlDataSourceParameter("@shipment_id", System.Data.DbType.AnsiString, "= Parameters.shipmentid.Value")});
                this.MailingLabels.SelectCommand = "GetLTLFullLabel";
                this.MailingLabels.SelectCommandType = Telerik.Reporting.SqlDataSourceCommandType.StoredProcedure;
                // 
                // detail
                // 
                this.detail.Height = Telerik.Reporting.Drawing.Unit.Inch(3.3299999237060547D);
                this.detail.Items.AddRange(new Telerik.Reporting.ReportItemBase[] {
                this.panel1});
                this.detail.Name = "detail";
                // 
                // panel1
                // 
                this.panel1.Items.AddRange(new Telerik.Reporting.ReportItemBase[] {
                this.textBox1,
                this.textBox2,
                this.textBox3,
                this.textBox4,
                this.textBox5,
                this.textBox6,
                this.textBox9,
                this.textBox10,
                this.textBox11,
                this.textBox13,
                this.textBox14,
                this.textBox15,
                this.textBox16,
                this.textBox17,
                this.textBox18,
                this.textBox19,
                this.shape1,
                this.textBox20,
                this.textBox21,
                this.textBox22,
                this.textBox23,
                this.textBox24,
                this.textBox25,
                this.textBox26,
                this.textBox27,
                this.textBox28,
                this.textBox29,
                this.textBox30,
                this.textBox31,
                this.textBox7,
                this.lblShipmentId,
                this.lblReportInfo});
                this.panel1.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(3.9418537198798731E-05D), Telerik.Reporting.Drawing.Unit.Inch(3.9659440517425537E-05D));
                this.panel1.Name = "panel1";
                this.panel1.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(4D), Telerik.Reporting.Drawing.Unit.Inch(3.3299999237060547D));
                // 
                // textBox1
                // 
                this.textBox1.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(2.6000003814697266D), Telerik.Reporting.Drawing.Unit.Inch(2.2007901668548584D));
                this.textBox1.Name = "textBox1";
                this.textBox1.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.1999603509902954D), Telerik.Reporting.Drawing.Unit.Inch(0.2000788152217865D));
                this.textBox1.Style.Font.Name = "Times New Roman";
                this.textBox1.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(9D);
                this.textBox1.Value = "= Fields.DEST_CONTACT_PHONE";
                // 
                // textBox2
                // 
                this.textBox2.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(2.8250792026519775D), Telerik.Reporting.Drawing.Unit.Inch(2.00071120262146D));
                this.textBox2.Name = "textBox2";
                this.textBox2.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(0.97488147020339966D), Telerik.Reporting.Drawing.Unit.Inch(0.20000004768371582D));
                this.textBox2.Style.Font.Name = "Times New Roman";
                this.textBox2.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(9D);
                this.textBox2.Value = "= Fields.DEST_EST_DATE_TIME.Month+\"/\"+ Fields.DEST_EST_DATE_TIME.Day+\"/\"+ Fields." +
        "DEST_EST_DATE_TIME.Year";
                // 
                // textBox3
                // 
                this.textBox3.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(2.699960470199585D), Telerik.Reporting.Drawing.Unit.Inch(0.700158417224884D));
                this.textBox3.Name = "textBox3";
                this.textBox3.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.1000003814697266D), Telerik.Reporting.Drawing.Unit.Inch(0.19999997317790985D));
                this.textBox3.Style.Font.Name = "Times New Roman";
                this.textBox3.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(9D);
                this.textBox3.Value = "= Fields.ORIGN_CONTACT_PHONE";
                // 
                // textBox4
                // 
                this.textBox4.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(2.89996075630188D), Telerik.Reporting.Drawing.Unit.Inch(0.5000794529914856D));
                this.textBox4.Name = "textBox4";
                this.textBox4.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(0.89999991655349731D), Telerik.Reporting.Drawing.Unit.Inch(0.20000004768371582D));
                this.textBox4.Style.Font.Name = "Times New Roman";
                this.textBox4.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(9D);
                this.textBox4.Value = "= Fields.ORIGN_EST_DATE_TIME.Month+\"/\"+ Fields.ORIGN_EST_DATE_TIME.Day+\"/\"+ Field" +
        "s.ORIGN_EST_DATE_TIME.Year";
                // 
                // textBox5
                // 
                this.textBox5.CanGrow = true;
                this.textBox5.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(2.9001178741455078D), Telerik.Reporting.Drawing.Unit.Inch(0D));
                this.textBox5.Name = "textBox5";
                this.textBox5.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(0.90000003576278687D), Telerik.Reporting.Drawing.Unit.Inch(0.25423699617385864D));
                this.textBox5.Style.Font.Name = "Times New Roman";
                this.textBox5.StyleName = "Data";
                this.textBox5.Value = "= Fields.CARPRO";
                // 
                // textBox6
                // 
                this.textBox6.CanGrow = true;
                this.textBox6.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(2.4999606609344482D), Telerik.Reporting.Drawing.Unit.Inch(3.9418537198798731E-05D));
                this.textBox6.Name = "textBox6";
                this.textBox6.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(0.40007838606834412D), Telerik.Reporting.Drawing.Unit.Inch(0.25419718027114868D));
                this.textBox6.Style.Font.Name = "Times New Roman";
                this.textBox6.StyleName = "Caption";
                this.textBox6.Value = "Pro:";
                // 
                // textBox7
                // 
                this.textBox7.CanGrow = true;
                this.textBox7.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(1.0792850255966187D), Telerik.Reporting.Drawing.Unit.Inch(0D));
                this.textBox7.Name = "textBox7";
                this.textBox7.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.2186709642410278D), Telerik.Reporting.Drawing.Unit.Inch(0.21670609712600708D));
                this.textBox7.Style.Font.Bold = true;
                this.textBox7.Style.Font.Name = "Times New Roman";
                this.textBox7.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(12D);
                this.textBox7.StyleName = "Data";
                this.textBox7.Value = "= Fields.SHIPMENT_ID";
                // 
                // lblShipmentId
                // 
                this.lblShipmentId.CanGrow = true;
                this.lblShipmentId.CanShrink = true;
                this.lblShipmentId.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(3.9418537198798731E-05D), Telerik.Reporting.Drawing.Unit.Inch(0.012074152939021587D));
                this.lblShipmentId.Name = "lblShipmentId";
                this.lblShipmentId.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.0791667699813843D), Telerik.Reporting.Drawing.Unit.Inch(0.21670594811439514D));
                this.lblShipmentId.Style.Font.Name = "Times New Roman";
                this.lblShipmentId.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(12D);
                this.lblShipmentId.StyleName = "Caption";
                this.lblShipmentId.Value = "Shipment ID:";
                // 
                // textBox9
                // 
                this.textBox9.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(0.033333778381347656D), Telerik.Reporting.Drawing.Unit.Inch(2.00071120262146D));
                this.textBox9.Name = "textBox9";
                this.textBox9.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.4208335876464844D), Telerik.Reporting.Drawing.Unit.Inch(0.19999973475933075D));
                this.textBox9.Style.Font.Name = "Times New Roman";
                this.textBox9.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(9D);
                this.textBox9.Value = "= Fields.DEST_NAME";
                // 
                // textBox10
                // 
                this.textBox10.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(0.033333778381347656D), Telerik.Reporting.Drawing.Unit.Inch(2.6010255813598633D));
                this.textBox10.Name = "textBox10";
                this.textBox10.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.4208335876464844D), Telerik.Reporting.Drawing.Unit.Inch(0.19976377487182617D));
                this.textBox10.Style.Font.Name = "Times New Roman";
                this.textBox10.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(9D);
                this.textBox10.Value = "= Fields.DEST_CITY+\", \"+ Fields.DEST_STATE+\" \"+ Fields.DEST_POSTAL_CODE";
                // 
                // textBox11
                // 
                formattingRule1.Filters.Add(new Telerik.Reporting.Filter("= Fields.DEST_ADDRESS_2", Telerik.Reporting.FilterOperator.Equal, "\"\""));
                formattingRule1.Style.Visible = false;
                this.textBox11.ConditionalFormatting.AddRange(new Telerik.Reporting.Drawing.FormattingRule[] {
                formattingRule1});
                this.textBox11.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(0.033333778381347656D), Telerik.Reporting.Drawing.Unit.Inch(2.4008684158325195D));
                this.textBox11.Name = "textBox11";
                this.textBox11.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.4208334684371948D), Telerik.Reporting.Drawing.Unit.Inch(0.20007848739624023D));
                this.textBox11.Style.Font.Name = "Times New Roman";
                this.textBox11.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(9D);
                this.textBox11.Value = "= Fields.DEST_ADDRESS_2";
                // 
                // textBox13
                // 
                this.textBox13.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(0.033333778381347656D), Telerik.Reporting.Drawing.Unit.Inch(2.800868034362793D));
                this.textBox13.Name = "textBox13";
                this.textBox13.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(0.5666269063949585D), Telerik.Reporting.Drawing.Unit.Inch(0.2003941535949707D));
                this.textBox13.Style.Font.Name = "Times New Roman";
                this.textBox13.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(9D);
                this.textBox13.Value = "Contact:";
                // 
                // textBox14
                // 
                this.textBox14.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(0.6375001072883606D), Telerik.Reporting.Drawing.Unit.Inch(2.8008677959442139D));
                this.textBox14.Name = "textBox14";
                this.textBox14.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.5D), Telerik.Reporting.Drawing.Unit.Inch(0.20039448142051697D));
                this.textBox14.Style.Font.Name = "Times New Roman";
                this.textBox14.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(9D);
                this.textBox14.Value = "= Fields.DEST_CONTACT_NAME";
                // 
                // textBox15
                // 
                this.textBox15.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(0.033333778381347656D), Telerik.Reporting.Drawing.Unit.Inch(3.0013411045074463D));
                this.textBox15.Name = "textBox15";
                this.textBox15.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(0.70208299160003662D), Telerik.Reporting.Drawing.Unit.Inch(0.20000012218952179D));
                this.textBox15.Style.Font.Name = "Times New Roman";
                this.textBox15.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(9D);
                this.textBox15.Value = "Reference:";
                // 
                // textBox16
                // 
                this.textBox16.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(0.73549556732177734D), Telerik.Reporting.Drawing.Unit.Inch(3.0013411045074463D));
                this.textBox16.Name = "textBox16";
                this.textBox16.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.2000001668930054D), Telerik.Reporting.Drawing.Unit.Inch(0.20031547546386719D));
                this.textBox16.Style.Font.Name = "Times New Roman";
                this.textBox16.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(9D);
                this.textBox16.Value = "= Fields.PO";
                // 
                // textBox17
                // 
                this.textBox17.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(1.9476817846298218D), Telerik.Reporting.Drawing.Unit.Inch(2.00071120262146D));
                this.textBox17.Name = "textBox17";
                this.textBox17.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(0.8522789478302002D), Telerik.Reporting.Drawing.Unit.Inch(0.20000004768371582D));
                this.textBox17.Style.Font.Name = "Times New Roman";
                this.textBox17.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(9D);
                this.textBox17.Value = "Est Deliv Date:";
                // 
                // textBox18
                // 
                this.textBox18.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(1.9476817846298218D), Telerik.Reporting.Drawing.Unit.Inch(2.2007901668548584D));
                this.textBox18.Name = "textBox18";
                this.textBox18.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(0.45227915048599243D), Telerik.Reporting.Drawing.Unit.Inch(0.2000788152217865D));
                this.textBox18.Style.Font.Name = "Times New Roman";
                this.textBox18.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(9D);
                this.textBox18.Value = "Phone:";
                // 
                // textBox19
                // 
                this.textBox19.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(0.033333778381347656D), Telerik.Reporting.Drawing.Unit.Inch(1.800632119178772D));
                this.textBox19.Name = "textBox19";
                this.textBox19.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.2000001668930054D), Telerik.Reporting.Drawing.Unit.Inch(0.20000012218952179D));
                this.textBox19.Style.Font.Bold = true;
                this.textBox19.Style.Font.Name = "Times New Roman";
                this.textBox19.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(12D);
                this.textBox19.Value = "CONSIGNEE:";
                // 
                // shape1
                // 
                this.shape1.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(0.033333778381347656D), Telerik.Reporting.Drawing.Unit.Inch(1.700553297996521D));
                this.shape1.Name = "shape1";
                this.shape1.ShapeType = new Telerik.Reporting.Drawing.Shapes.LineShape(Telerik.Reporting.Drawing.Shapes.LineDirection.EW);
                this.shape1.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(3.7666268348693848D), Telerik.Reporting.Drawing.Unit.Inch(0.1000000610947609D));
                // 
                // textBox20
                // 
                this.textBox20.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(2.0248820781707764D), Telerik.Reporting.Drawing.Unit.Inch(0.700158417224884D));
                this.textBox20.Name = "textBox20";
                this.textBox20.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(0.50007849931716919D), Telerik.Reporting.Drawing.Unit.Inch(0.19999997317790985D));
                this.textBox20.Style.Font.Name = "Times New Roman";
                this.textBox20.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(9D);
                this.textBox20.Value = "Phone:";
                // 
                // textBox21
                // 
                this.textBox21.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(2.0248820781707764D), Telerik.Reporting.Drawing.Unit.Inch(0.5000794529914856D));
                this.textBox21.Name = "textBox21";
                this.textBox21.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(0.77507781982421875D), Telerik.Reporting.Drawing.Unit.Inch(0.20000004768371582D));
                this.textBox21.Style.Font.Name = "Times New Roman";
                this.textBox21.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(9D);
                this.textBox21.Value = "Pickup Date:";
                // 
                // textBox22
                // 
                this.textBox22.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(0.837500274181366D), Telerik.Reporting.Drawing.Unit.Inch(1.5004743337631226D));
                this.textBox22.Name = "textBox22";
                this.textBox22.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.2999998331069946D), Telerik.Reporting.Drawing.Unit.Inch(0.20000012218952179D));
                this.textBox22.Style.Font.Name = "Times New Roman";
                this.textBox22.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(9D);
                this.textBox22.Value = "= Fields.PO";
                // 
                // textBox23
                // 
                this.textBox23.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(0.15625016391277313D), Telerik.Reporting.Drawing.Unit.Inch(1.5004743337631226D));
                this.textBox23.Name = "textBox23";
                this.textBox23.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(0.6437104344367981D), Telerik.Reporting.Drawing.Unit.Inch(0.20000012218952179D));
                this.textBox23.Style.Font.Name = "Times New Roman";
                this.textBox23.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(9D);
                this.textBox23.Value = "Reference:";
                // 
                // textBox24
                // 
                this.textBox24.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(0.735495388507843D), Telerik.Reporting.Drawing.Unit.Inch(1.3003953695297241D));
                this.textBox24.Name = "textBox24";
                this.textBox24.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.5D), Telerik.Reporting.Drawing.Unit.Inch(0.19999997317790985D));
                this.textBox24.Style.Font.Name = "Times New Roman";
                this.textBox24.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(9D);
                this.textBox24.Value = "= Fields.ORIGN_CONTACT_NAME";
                // 
                // textBox25
                // 
                this.textBox25.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(0.1354166716337204D), Telerik.Reporting.Drawing.Unit.Inch(1.3003953695297241D));
                this.textBox25.Name = "textBox25";
                this.textBox25.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(0.60000008344650269D), Telerik.Reporting.Drawing.Unit.Inch(0.19960515201091766D));
                this.textBox25.Style.Font.Name = "Times New Roman";
                this.textBox25.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(9D);
                this.textBox25.Value = "Contact:";
                // 
                // textBox26
                // 
                this.textBox26.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(0.13541650772094727D), Telerik.Reporting.Drawing.Unit.Inch(1.1003164052963257D));
                this.textBox26.Name = "textBox26";
                this.textBox26.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.8000000715255737D), Telerik.Reporting.Drawing.Unit.Inch(0.19999997317790985D));
                this.textBox26.Style.Font.Name = "Times New Roman";
                this.textBox26.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(9D);
                this.textBox26.Value = "= Fields.ORIGN_CITY+\", \"+ Fields.ORIGN_STATE+\" \"+ Fields.ORIGN_POSTAL_CODE";
                // 
                // textBox27
                // 
                formattingRule2.Filters.Add(new Telerik.Reporting.Filter("= Fields.ORIGN_ADDRESS_2", Telerik.Reporting.FilterOperator.Equal, "\"\""));
                formattingRule2.Style.Visible = false;
                this.textBox27.ConditionalFormatting.AddRange(new Telerik.Reporting.Drawing.FormattingRule[] {
                formattingRule2});
                this.textBox27.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(0.13742129504680634D), Telerik.Reporting.Drawing.Unit.Inch(0.90023738145828247D));
                this.textBox27.Name = "textBox27";
                this.textBox27.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.4000000953674316D), Telerik.Reporting.Drawing.Unit.Inch(0.19999997317790985D));
                this.textBox27.Style.Font.Name = "Times New Roman";
                this.textBox27.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(9D);
                this.textBox27.Value = "= Fields.ORIGN_ADDRESS_2";
                // 
                // textBox28
                // 
                this.textBox28.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(0.13541650772094727D), Telerik.Reporting.Drawing.Unit.Inch(0.700158417224884D));
                this.textBox28.Name = "textBox28";
                this.textBox28.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.4000000953674316D), Telerik.Reporting.Drawing.Unit.Inch(0.19999997317790985D));
                this.textBox28.Style.Font.Name = "Times New Roman";
                this.textBox28.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(9D);
                this.textBox28.Value = "= Fields.ORIGN_ADDRESS_1";
                // 
                // textBox29
                // 
                this.textBox29.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(0.1354166716337204D), Telerik.Reporting.Drawing.Unit.Inch(0.5000794529914856D));
                this.textBox29.Name = "textBox29";
                this.textBox29.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.3999999761581421D), Telerik.Reporting.Drawing.Unit.Inch(0.20000004768371582D));
                this.textBox29.Style.Font.Name = "Times New Roman";
                this.textBox29.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(9D);
                this.textBox29.Value = "= Fields.ORIGN_NAME";
                // 
                // textBox30
                // 
                this.textBox30.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(0.033333778381347656D), Telerik.Reporting.Drawing.Unit.Inch(0.30000051856040955D));
                this.textBox30.Name = "textBox30";
                this.textBox30.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.2000001668930054D), Telerik.Reporting.Drawing.Unit.Inch(0.20000004768371582D));
                this.textBox30.Style.Font.Bold = true;
                this.textBox30.Style.Font.Name = "Times New Roman";
                this.textBox30.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(12D);
                this.textBox30.Value = "SHIPPER:";
                // 
                // textBox31
                // 
                this.textBox31.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(0.033333778381347656D), Telerik.Reporting.Drawing.Unit.Inch(2.2007896900177D));
                this.textBox31.Name = "textBox31";
                this.textBox31.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.4208335876464844D), Telerik.Reporting.Drawing.Unit.Inch(0.19999997317790985D));
                this.textBox31.Style.Font.Name = "Times New Roman";
                this.textBox31.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(9D);
                this.textBox31.Value = "= Fields.DEST_ADDRESS_1";
                // 
                // lblReportInfo
                // 
                this.lblReportInfo.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(2.2999608516693115D), Telerik.Reporting.Drawing.Unit.Inch(3.0013411045074463D));
                this.lblReportInfo.Name = "lblReportInfo";
                this.lblReportInfo.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.5D), Telerik.Reporting.Drawing.Unit.Inch(0.2995656430721283D));
                this.lblReportInfo.Style.Font.Bold = true;
                this.lblReportInfo.Style.Font.Name = "Times New Roman";
                this.lblReportInfo.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(12D);
                this.lblReportInfo.Value = "=Parameters.CurPage.Value+\" of \"+ Parameters.PageCount.Value";
                // 
                // Labels
                // 
                formattingRule3.Filters.Add(new Telerik.Reporting.Filter("= Parameters.StartingPosition.Value", Telerik.Reporting.FilterOperator.Equal, "1"));
                formattingRule3.Style.Font.Name = "Times New Roman";
                formattingRule3.Style.Padding.Left = Telerik.Reporting.Drawing.Unit.Inch(0D);
                formattingRule3.Style.Padding.Top = Telerik.Reporting.Drawing.Unit.Inch(0D);
                formattingRule4.Filters.Add(new Telerik.Reporting.Filter("= Parameters.StartingPosition.Value", Telerik.Reporting.FilterOperator.Equal, "2"));
                formattingRule4.Style.Padding.Left = Telerik.Reporting.Drawing.Unit.Inch(0D);
                formattingRule4.Style.Padding.Top = Telerik.Reporting.Drawing.Unit.Inch(0D);
                formattingRule5.Filters.Add(new Telerik.Reporting.Filter("= Parameters.StartingPosition.Value", Telerik.Reporting.FilterOperator.Equal, "3"));
                formattingRule5.Style.Padding.Bottom = Telerik.Reporting.Drawing.Unit.Inch(0D);
                formattingRule5.Style.Padding.Left = Telerik.Reporting.Drawing.Unit.Inch(0D);
                formattingRule5.Style.Padding.Right = Telerik.Reporting.Drawing.Unit.Inch(0D);
                formattingRule5.Style.Padding.Top = Telerik.Reporting.Drawing.Unit.Inch(0D);
                this.ConditionalFormatting.AddRange(new Telerik.Reporting.Drawing.FormattingRule[] {
                formattingRule3,
                formattingRule4,
                formattingRule5});
                this.DataSource = this.MailingLabels;
                this.Items.AddRange(new Telerik.Reporting.ReportItemBase[] {
                this.detail});
                this.Name = "Detail";
                this.PageSettings.ColumnCount = 2;
                this.PageSettings.ColumnSpacing = Telerik.Reporting.Drawing.Unit.Inch(0D);
                this.PageSettings.Landscape = false;
                this.PageSettings.Margins = new Telerik.Reporting.Drawing.MarginsU(Telerik.Reporting.Drawing.Unit.Inch(0D), Telerik.Reporting.Drawing.Unit.Inch(0D), Telerik.Reporting.Drawing.Unit.Inch(0.64999997615814209D), Telerik.Reporting.Drawing.Unit.Inch(0D));
                this.PageSettings.PaperKind = System.Drawing.Printing.PaperKind.Letter;
                reportParameter1.Name = "shipmentid";
                reportParameter1.Value = "SM00125468";
                reportParameter2.Name = "StartingPosition";
                reportParameter2.Type = Telerik.Reporting.ReportParameterType.Integer;
                reportParameter2.Value = "3";
                reportParameter3.Name = "PageCount";
                reportParameter3.Type = Telerik.Reporting.ReportParameterType.Integer;
                reportParameter4.Name = "CurPage";
                reportParameter4.Type = Telerik.Reporting.ReportParameterType.Integer;
                this.ReportParameters.Add(reportParameter1);
                this.ReportParameters.Add(reportParameter2);
                this.ReportParameters.Add(reportParameter3);
                this.ReportParameters.Add(reportParameter4);
                styleRule1.Selectors.AddRange(new Telerik.Reporting.Drawing.ISelector[] {
                new Telerik.Reporting.Drawing.TypeSelector(typeof(Telerik.Reporting.TextItemBase)),
                new Telerik.Reporting.Drawing.TypeSelector(typeof(Telerik.Reporting.HtmlTextBox))});
                styleRule1.Style.Padding.Left = Telerik.Reporting.Drawing.Unit.Point(2D);
                styleRule1.Style.Padding.Right = Telerik.Reporting.Drawing.Unit.Point(2D);
                styleRule2.Selectors.AddRange(new Telerik.Reporting.Drawing.ISelector[] {
                new Telerik.Reporting.Drawing.StyleSelector("Title")});
                styleRule2.Style.Color = System.Drawing.Color.Black;
                styleRule2.Style.Font.Bold = true;
                styleRule2.Style.Font.Italic = false;
                styleRule2.Style.Font.Name = "Tahoma";
                styleRule2.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(18D);
                styleRule2.Style.Font.Strikeout = false;
                styleRule2.Style.Font.Underline = false;
                styleRule3.Selectors.AddRange(new Telerik.Reporting.Drawing.ISelector[] {
                new Telerik.Reporting.Drawing.StyleSelector("Caption")});
                styleRule3.Style.Color = System.Drawing.Color.Black;
                styleRule3.Style.Font.Name = "Tahoma";
                styleRule3.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(10D);
                styleRule3.Style.VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Middle;
                styleRule4.Selectors.AddRange(new Telerik.Reporting.Drawing.ISelector[] {
                new Telerik.Reporting.Drawing.StyleSelector("Data")});
                styleRule4.Style.Font.Name = "Tahoma";
                styleRule4.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(9D);
                styleRule4.Style.VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Middle;
                styleRule5.Selectors.AddRange(new Telerik.Reporting.Drawing.ISelector[] {
                new Telerik.Reporting.Drawing.StyleSelector("PageInfo")});
                styleRule5.Style.Font.Name = "Tahoma";
                styleRule5.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(8D);
                styleRule5.Style.VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Middle;
                this.StyleSheet.AddRange(new Telerik.Reporting.Drawing.StyleRule[] {
                styleRule1,
                styleRule2,
                styleRule3,
                styleRule4,
                styleRule5});
                this.Width = Telerik.Reporting.Drawing.Unit.Inch(4D);
                ((System.ComponentModel.ISupportInitialize)(this)).EndInit();

            }
            #endregion

            private Telerik.Reporting.SqlDataSource MailingLabels;
            private Telerik.Reporting.DetailSection detail;
            private Telerik.Reporting.Panel panel1;
            private Telerik.Reporting.TextBox textBox1;
            private Telerik.Reporting.TextBox textBox2;
            private Telerik.Reporting.TextBox textBox3;
            private Telerik.Reporting.TextBox textBox4;
            private Telerik.Reporting.TextBox textBox5;
            private Telerik.Reporting.TextBox textBox6;
            private Telerik.Reporting.TextBox textBox7;
            private Telerik.Reporting.TextBox lblShipmentId;
            private Telerik.Reporting.TextBox textBox9;
            private Telerik.Reporting.TextBox textBox10;
            private Telerik.Reporting.TextBox textBox11;
            private Telerik.Reporting.TextBox textBox13;
            private Telerik.Reporting.TextBox textBox14;
            private Telerik.Reporting.TextBox textBox15;
            private Telerik.Reporting.TextBox textBox16;
            private Telerik.Reporting.TextBox textBox17;
            private Telerik.Reporting.TextBox textBox18;
            private Telerik.Reporting.TextBox textBox19;
            private Telerik.Reporting.Shape shape1;
            private Telerik.Reporting.TextBox textBox20;
            private Telerik.Reporting.TextBox textBox21;
            private Telerik.Reporting.TextBox textBox22;
            private Telerik.Reporting.TextBox textBox23;
            private Telerik.Reporting.TextBox textBox24;
            private Telerik.Reporting.TextBox textBox25;
            private Telerik.Reporting.TextBox textBox26;
            private Telerik.Reporting.TextBox textBox27;
            private Telerik.Reporting.TextBox textBox28;
            private Telerik.Reporting.TextBox textBox29;
            private Telerik.Reporting.TextBox textBox30;
            private Telerik.Reporting.TextBox textBox31;
            private Telerik.Reporting.TextBox lblReportInfo;

        }
    }

     

    Thanks

  2. Stef
    Admin
    Stef avatar
    3036 posts

    Posted 10 Apr 2015 Link to this post

    Hello Joseph,

    The Label layout is based on the report's PageSettings for multi-column layout - How to: Create a Multi-Column Report. Thus columns are rendered down then across in Print Preview, as the settings are applied per page.

    To achieve the desired layout, and to be able to order where labels to start from (position), you can use the approach from the How to: Create Multi-Column Report - Across the Page and Then Down KB article. The groupings in the Table/List item will allow you to organize the labels in two columns rendering accross then down. The used index field from the data will allow you to order items in the rendered cells.

    The attached demo project illustrates the above suggestions and is created based on your code snippet, where:
    1. The report's PageSettings are reset;
    2. The report's Width is based on the selected PageSettings.PaperKind and PageSettings.PaperSize;
    3. There is List item, and the Panel item with the label is placed in its cell;
    4. The List Item is bound to the data source component, and the report's DataSource is reset;
    5. The data per label is organized to have Id, which is a consecutive number that will be used to group the List item's rows and columns, and to order a label in a specific cell;
    6. The Panel item has conditional formatting rule to hide its content if a field's value is null;

    The demo uses Telerik Reporting Q1 2015 SP1 v9.0.15.324, but can be run with other version after upgrading it.


    I hope the provided information is helpful.

    Regards,
    Stef
    Telerik
     

    See What's Next in App Development. Register for TelerikNEXT.

     
  3. DevCraft banner
  4. Tracy
    Tracy avatar
    13 posts
    Member since:
    Nov 2010

    Posted 19 Jun 2015 in reply to Stef Link to this post

    I'm trying to do something similar, but with images, where I want do display them 4 across and then down. I followed the instructions in the KB article for going across then down, but my result looks like this:

    A | B | C |

    E | F | G | D

     I  | J | K | H

    Can you give me any ideas as to why the fourth image for each line is appearing in the right position but one row down?

     

    Thanks,

    Tracy

  5. Stef
    Admin
    Stef avatar
    3036 posts

    Posted 23 Jun 2015 Link to this post

    Hi Tracy,

    Please check the grouping criteria for the row and column groups in the Table item.

    For example, in the How to: Create Multi-Column Report - Across the Page and Then Down KB article data has index field starting from zero. Thus a grouping based on that index modulo 3 will transfer each index divisible by 3 on a new row (group).

    Regards,
    Stef
    Telerik
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
  6. Chris
    Chris avatar
    33 posts
    Member since:
    Oct 2015

    Posted 11 Jan Link to this post

    HI

     

    Is there have the solution that How to create multi-column label report across then down without Table/Crosstab/List item ?

     

    Best regards

     

    Chris

  7. Chris
    Chris avatar
    33 posts
    Member since:
    Oct 2015

    Posted 11 Jan in reply to Chris Link to this post

    And In Generally, the real world data have no column/row seed column for list column/row - Index/3, Index%3.

    How to: Create Multi-Column Report - Across the Page and Then Down

    http://www.telerik.com/support/kb/reporting/details/how-to-create-multi-column-report---across-the-page-and-then-down

    This demo is not fit the real world application .

     

    Best regards

     

    Chris

  8. Chris
    Chris avatar
    33 posts
    Member since:
    Oct 2015

    Posted 11 Jan in reply to Chris Link to this post

    And even if the application can generate multi-column report by using Table/CrossTab/List item,

    How to filter list data while multi-column report is a subreport (how to get ReportParameters value and filter the list data), there have lots of problems need to solved.

     

    Best regards

     

    Chris

  9. Stef
    Admin
    Stef avatar
    3036 posts

    Posted 14 Jan Link to this post

    Hi Chris,

    In general, the default multi column layout settings are page settings, and can be previewed only in Pint preview of the master report. When a report is used as sub report, the sub report's PageSettings are ignored - SubReport item.

    The across then down layout can be achieve in reports via Table item, where data must have a field suitable for grouping the item - How to: Create Multi-Column Report - Across the Page and Then Down . The layout will be preserved in both interactive and print preview of the report, also if used in sub report.

    To filter data for the Table item you can use the Table item's Filters collection or the corresponding Table item's group properties - Filtering Data. To set filters for a Table item's group, you can select the Table item and use the Group Explorer in Extended mode where all groups are listed.
    To pass values to sub reports, you can configure the SubReport.ReportSource property which has also Parameters collection. The SubReport.ReportSource.Parameters collection is mapped to the sub report's ReportParameters collection by key (name). For more details check Report Sources and the scenario illustrated in How to: Create a Master-Detail Report Using a SubReport Item.


    I hope this helps.

    Regards,
    Stef
    Telerik
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
Back to Top
DevCraft banner