This is a migrated thread and some comments may be shown as answers.

Printing Across and then Down Multi-Column Report

7 Answers 338 Views

General Discussions

This is a migrated thread and some comments may be shown as answers.

Joseph Baker asked on 07 Apr 2015, 01:05 PM

shipmentlabel.png

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

7 Answers, 1 is accepted

answered on 10 Apr 2015, 11:52 AM

LabelsDemo.zip

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:

The report's PageSettings are reset;
The report's Width is based on the selected PageSettings.PaperKind and PageSettings.PaperSize;
There is List item, and the Panel item with the label is placed in its cell;
The List Item is bound to the data source component, and the report's DataSource is reset;
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;
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.

answered on 12 Jan 2016, 02:47 AM

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

answered on 14 Jan 2016, 12:28 PM

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

Product Bundles

DevCraft

Web

Mobile

Document Management

Desktop

Reporting & Mocking

Automated Testing

CMS

UI/UX Tools

Debugging

Free Tools

Support and Learning

Printing Across and then Down Multi-Column Report

7 Answers, 1 is accepted