Changing columns order while grouping

[Servando]

Let's suppose that I need to do row grouping but I need to change the column order.

We have the example:

Company	VAT rate	Amount with taxes	Total
Shell	7%	10	30
	10%	20
Elf	7%	30	30
Repsol	20%	40	40

I can't find a way to do this in Telerik. The total column is on the same grouping level that Company but Telerik Reports does not allow to move the column to the right-most position.

[Steve]

Hi Servando,

Find attached a sample report that shows you how to achieve the desired behavior. Give it a spin and let us know if further help is needed.

Greetings,
Steve
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.

[Servando]

How can I send you the code with the Table? I'll be very pleased if you can move the Total column to the right.

My ".designer.cs" code looks like this (a modification over your code, the rest of the code remains as It was sent).

	namespace ClassLibrary1
	{
	using System.ComponentModel;
	using System.Drawing;
	using System.Windows.Forms;
	using Telerik.Reporting;
	using Telerik.Reporting.Drawing;
	partial class CrossTabTreeLike
	{
	#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.TableGroup tableGroup1 = new Telerik.Reporting.TableGroup();
	Telerik.Reporting.TableGroup tableGroup2 = new Telerik.Reporting.TableGroup();
	Telerik.Reporting.TableGroup tableGroup3 = new Telerik.Reporting.TableGroup();
	Telerik.Reporting.TableGroup tableGroup4 = new Telerik.Reporting.TableGroup();
	Telerik.Reporting.TableGroup tableGroup5 = new Telerik.Reporting.TableGroup();
	Telerik.Reporting.TableGroup tableGroup6 = new Telerik.Reporting.TableGroup();
	Telerik.Reporting.TableGroup tableGroup7 = new Telerik.Reporting.TableGroup();
	Telerik.Reporting.TableGroup tableGroup8 = new Telerik.Reporting.TableGroup();
	Telerik.Reporting.TableGroup tableGroup9 = new Telerik.Reporting.TableGroup();
	Telerik.Reporting.TableGroup tableGroup10 = new Telerik.Reporting.TableGroup();
	Telerik.Reporting.TableGroup tableGroup11 = new Telerik.Reporting.TableGroup();
	Telerik.Reporting.TableGroup tableGroup12 = new Telerik.Reporting.TableGroup();
	Telerik.Reporting.TableGroup tableGroup13 = new Telerik.Reporting.TableGroup();
	Telerik.Reporting.TableGroup tableGroup14 = new Telerik.Reporting.TableGroup();
	Telerik.Reporting.TableGroup tableGroup15 = new Telerik.Reporting.TableGroup();
	Telerik.Reporting.TableGroup tableGroup16 = new Telerik.Reporting.TableGroup();
	Telerik.Reporting.TableGroup tableGroup17 = new Telerik.Reporting.TableGroup();
	Telerik.Reporting.TableGroup tableGroup18 = new Telerik.Reporting.TableGroup();
	Telerik.Reporting.TableGroup tableGroup19 = new Telerik.Reporting.TableGroup();
	Telerik.Reporting.TableGroup tableGroup20 = new Telerik.Reporting.TableGroup();
	Telerik.Reporting.TableGroup tableGroup21 = new Telerik.Reporting.TableGroup();
	this.detail = new Telerik.Reporting.DetailSection();
	this.crosstab1 = new Telerik.Reporting.Crosstab();
	this.textBox14 = new Telerik.Reporting.TextBox();
	this.textBox13 = new Telerik.Reporting.TextBox();
	this.textBox12 = new Telerik.Reporting.TextBox();
	this.textBox4 = new Telerik.Reporting.TextBox();
	this.textBox8 = new Telerik.Reporting.TextBox();
	this.textBox10 = new Telerik.Reporting.TextBox();
	this.textBox18 = new Telerik.Reporting.TextBox();
	this.textBox17 = new Telerik.Reporting.TextBox();
	this.textBox16 = new Telerik.Reporting.TextBox();
	this.textBox6 = new Telerik.Reporting.TextBox();
	this.textBox11 = new Telerik.Reporting.TextBox();
	this.textBox15 = new Telerik.Reporting.TextBox();
	this.textBox3 = new Telerik.Reporting.TextBox();
	this.table1 = new Telerik.Reporting.Table();
	this.textBox23 = new Telerik.Reporting.TextBox();
	this.textBox24 = new Telerik.Reporting.TextBox();
	this.textBox30 = new Telerik.Reporting.TextBox();
	this.textBox31 = new Telerik.Reporting.TextBox();
	this.textBox5 = new Telerik.Reporting.TextBox();
	this.textBox7 = new Telerik.Reporting.TextBox();
	this.textBox28 = new Telerik.Reporting.TextBox();
	this.textBox1 = new Telerik.Reporting.TextBox();
	this.textBox20 = new Telerik.Reporting.TextBox();
	this.textBox2 = new Telerik.Reporting.TextBox();
	this.textBox9 = new Telerik.Reporting.TextBox();
	this.textBox19 = new Telerik.Reporting.TextBox();
	((System.ComponentModel.ISupportInitialize)(this)).BeginInit();
	//
	// detail
	//
	this.detail.Height = new Telerik.Reporting.Drawing.Unit(4.881889820098877, Telerik.Reporting.Drawing.UnitType.Inch);
	this.detail.Items.AddRange(new Telerik.Reporting.ReportItemBase[] {
	this.crosstab1,
	this.table1});
	this.detail.Name = "detail";
	//
	// crosstab1
	//
	this.crosstab1.Body.Columns.Add(new Telerik.Reporting.TableBodyColumn(new Telerik.Reporting.Drawing.Unit(2.8208849430084229, Telerik.Reporting.Drawing.UnitType.Cm)));
	this.crosstab1.Body.Columns.Add(new Telerik.Reporting.TableBodyColumn(new Telerik.Reporting.Drawing.Unit(3.0996923446655273, Telerik.Reporting.Drawing.UnitType.Cm)));
	this.crosstab1.Body.Columns.Add(new Telerik.Reporting.TableBodyColumn(new Telerik.Reporting.Drawing.Unit(3.0996923446655273, Telerik.Reporting.Drawing.UnitType.Cm)));
	this.crosstab1.Body.Rows.Add(new Telerik.Reporting.TableBodyRow(new Telerik.Reporting.Drawing.Unit(0.25833335518836975, Telerik.Reporting.Drawing.UnitType.Inch)));
	this.crosstab1.Body.Rows.Add(new Telerik.Reporting.TableBodyRow(new Telerik.Reporting.Drawing.Unit(0.24791672825813294, Telerik.Reporting.Drawing.UnitType.Inch)));
	this.crosstab1.Body.Rows.Add(new Telerik.Reporting.TableBodyRow(new Telerik.Reporting.Drawing.Unit(0.24791666865348816, Telerik.Reporting.Drawing.UnitType.Inch)));
	this.crosstab1.Body.SetCellContent(0, 2, this.textBox14);
	this.crosstab1.Body.SetCellContent(0, 1, this.textBox13);
	this.crosstab1.Body.SetCellContent(0, 0, this.textBox12);
	this.crosstab1.Body.SetCellContent(2, 0, this.textBox4);
	this.crosstab1.Body.SetCellContent(2, 2, this.textBox8);
	this.crosstab1.Body.SetCellContent(2, 1, this.textBox10);
	this.crosstab1.Body.SetCellContent(1, 2, this.textBox18);
	this.crosstab1.Body.SetCellContent(1, 1, this.textBox17);
	this.crosstab1.Body.SetCellContent(1, 0, this.textBox16);
	tableGroup1.Name = "ColumnGroup1";
	this.crosstab1.ColumnGroups.Add(tableGroup1);
	this.crosstab1.ColumnGroups.Add(tableGroup2);
	this.crosstab1.ColumnGroups.Add(tableGroup3);
	this.crosstab1.DataMember = "";
	this.crosstab1.DataSource = typeof(ClassLibrary1.MySampleData);
	this.crosstab1.Items.AddRange(new Telerik.Reporting.ReportItemBase[] {
	this.textBox14,
	this.textBox13,
	this.textBox12,
	this.textBox4,
	this.textBox8,
	this.textBox10,
	this.textBox18,
	this.textBox17,
	this.textBox16,
	this.textBox6,
	this.textBox11,
	this.textBox15,
	this.textBox3});
	this.crosstab1.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(0.00064949196530506015, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.31496062874794006, Telerik.Reporting.Drawing.UnitType.Inch));
	this.crosstab1.Name = "crosstab1";
	tableGroup5.ReportItem = this.textBox11;
	tableGroup6.ReportItem = this.textBox15;
	tableGroup7.Grouping.AddRange(new Telerik.Reporting.Data.Grouping[] {
	new Telerik.Reporting.Data.Grouping("=Fields.Item")});
	tableGroup7.Name = "RowGroup1";
	tableGroup7.ReportItem = this.textBox3;
	tableGroup7.Sorting.AddRange(new Telerik.Reporting.Data.Sorting[] {
	new Telerik.Reporting.Data.Sorting("=Fields.Item", Telerik.Reporting.Data.SortDirection.Asc)});
	tableGroup4.ChildGroups.Add(tableGroup5);
	tableGroup4.ChildGroups.Add(tableGroup6);
	tableGroup4.ChildGroups.Add(tableGroup7);
	tableGroup4.Grouping.AddRange(new Telerik.Reporting.Data.Grouping[] {
	new Telerik.Reporting.Data.Grouping("=Fields.Company")});
	tableGroup4.Name = "Company";
	tableGroup4.ReportItem = this.textBox6;
	tableGroup4.Sorting.AddRange(new Telerik.Reporting.Data.Sorting[] {
	new Telerik.Reporting.Data.Sorting("=Fields.Company", Telerik.Reporting.Data.SortDirection.Asc)});
	this.crosstab1.RowGroups.Add(tableGroup4);
	this.crosstab1.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(5.905433177947998, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.75416672229766846, Telerik.Reporting.Drawing.UnitType.Inch));
	//
	// textBox14
	//
	this.textBox14.Name = "textBox14";
	this.textBox14.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1.2203513383865356, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.25833335518836975, Telerik.Reporting.Drawing.UnitType.Inch));
	this.textBox14.Style.BackgroundColor = System.Drawing.Color.FromArgb(((int)(((byte)(255)))), ((int)(((byte)(192)))), ((int)(((byte)(192)))));
	//
	// textBox13
	//
	this.textBox13.Name = "textBox13";
	this.textBox13.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1.2203515768051148, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.25833335518836975, Telerik.Reporting.Drawing.UnitType.Inch));
	this.textBox13.Style.BackgroundColor = System.Drawing.Color.FromArgb(((int)(((byte)(255)))), ((int)(((byte)(192)))), ((int)(((byte)(192)))));
	//
	// textBox12
	//
	this.textBox12.Name = "textBox12";
	this.textBox12.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1.1105848550796509, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.25833335518836975, Telerik.Reporting.Drawing.UnitType.Inch));
	this.textBox12.Style.BackgroundColor = System.Drawing.Color.FromArgb(((int)(((byte)(255)))), ((int)(((byte)(192)))), ((int)(((byte)(192)))));
	//
	// textBox4
	//
	this.textBox4.Name = "textBox4";
	this.textBox4.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1.1105848550796509, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.24791668355464935, Telerik.Reporting.Drawing.UnitType.Inch));
	this.textBox4.Style.BorderStyle.Default = Telerik.Reporting.Drawing.BorderType.Solid;
	this.textBox4.Style.BorderWidth.Default = new Telerik.Reporting.Drawing.Unit(1, Telerik.Reporting.Drawing.UnitType.Pixel);
	this.textBox4.Value = "=Fields.Spend";
	//
	// textBox8
	//
	this.textBox8.Name = "textBox8";
	this.textBox8.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1.2203513383865356, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.24791668355464935, Telerik.Reporting.Drawing.UnitType.Inch));
	this.textBox8.Style.BorderStyle.Default = Telerik.Reporting.Drawing.BorderType.Solid;
	this.textBox8.Style.BorderWidth.Default = new Telerik.Reporting.Drawing.Unit(1, Telerik.Reporting.Drawing.UnitType.Pixel);
	this.textBox8.Value = "=Fields.Price";
	//
	// textBox10
	//
	this.textBox10.Name = "textBox10";
	this.textBox10.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1.2203515768051148, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.24791668355464935, Telerik.Reporting.Drawing.UnitType.Inch));
	this.textBox10.Style.BorderStyle.Default = Telerik.Reporting.Drawing.BorderType.Solid;
	this.textBox10.Style.BorderWidth.Default = new Telerik.Reporting.Drawing.Unit(1, Telerik.Reporting.Drawing.UnitType.Pixel);
	this.textBox10.Value = "=Fields.Unit";
	//
	// textBox18
	//
	this.textBox18.Name = "textBox18";
	this.textBox18.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1.2203513383865356, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.24791672825813294, Telerik.Reporting.Drawing.UnitType.Inch));
	this.textBox18.Style.BorderStyle.Default = Telerik.Reporting.Drawing.BorderType.Solid;
	this.textBox18.Style.BorderWidth.Default = new Telerik.Reporting.Drawing.Unit(1, Telerik.Reporting.Drawing.UnitType.Pixel);
	this.textBox18.Value = "Price";
	//
	// textBox17
	//
	this.textBox17.Name = "textBox17";
	this.textBox17.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1.2203515768051148, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.24791672825813294, Telerik.Reporting.Drawing.UnitType.Inch));
	this.textBox17.Style.BorderStyle.Default = Telerik.Reporting.Drawing.BorderType.Solid;
	this.textBox17.Style.BorderWidth.Default = new Telerik.Reporting.Drawing.Unit(1, Telerik.Reporting.Drawing.UnitType.Pixel);
	this.textBox17.Value = "Unit";
	//
	// textBox16
	//
	this.textBox16.Name = "textBox16";
	this.textBox16.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1.1105848550796509, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.24791672825813294, Telerik.Reporting.Drawing.UnitType.Inch));
	this.textBox16.Style.BorderStyle.Default = Telerik.Reporting.Drawing.BorderType.Solid;
	this.textBox16.Style.BorderWidth.Default = new Telerik.Reporting.Drawing.Unit(1, Telerik.Reporting.Drawing.UnitType.Pixel);
	this.textBox16.Value = "Spend";
	//
	// textBox6
	//
	this.textBox6.Name = "textBox6";
	this.textBox6.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(0.00061009946512058377, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.75416672229766846, Telerik.Reporting.Drawing.UnitType.Inch));
	//
	// textBox11
	//
	this.textBox11.Name = "textBox11";
	this.textBox11.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(2.3535349369049072, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.25833335518836975, Telerik.Reporting.Drawing.UnitType.Inch));
	this.textBox11.Style.BackgroundColor = System.Drawing.Color.FromArgb(((int)(((byte)(255)))), ((int)(((byte)(192)))), ((int)(((byte)(192)))));
	this.textBox11.Value = "=Fields.Company";
	//
	// textBox15
	//
	this.textBox15.Name = "textBox15";
	this.textBox15.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(2.3535349369049072, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.24791672825813294, Telerik.Reporting.Drawing.UnitType.Inch));
	this.textBox15.Style.BorderStyle.Default = Telerik.Reporting.Drawing.BorderType.Solid;
	this.textBox15.Style.BorderWidth.Default = new Telerik.Reporting.Drawing.Unit(1, Telerik.Reporting.Drawing.UnitType.Pixel);
	this.textBox15.Value = "Item";
	//
	// textBox3
	//
	this.textBox3.Name = "textBox3";
	this.textBox3.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(2.3535349369049072, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.24791668355464935, Telerik.Reporting.Drawing.UnitType.Inch));
	this.textBox3.Style.BorderStyle.Default = Telerik.Reporting.Drawing.BorderType.Solid;
	this.textBox3.Style.BorderWidth.Default = new Telerik.Reporting.Drawing.Unit(1, Telerik.Reporting.Drawing.UnitType.Pixel);
	this.textBox3.Value = "=Fields.Item";
	//
	// table1
	//
	this.table1.Body.Columns.Add(new Telerik.Reporting.TableBodyColumn(new Telerik.Reporting.Drawing.Unit(1.918946385383606, Telerik.Reporting.Drawing.UnitType.Cm)));
	this.table1.Body.Columns.Add(new Telerik.Reporting.TableBodyColumn(new Telerik.Reporting.Drawing.Unit(2.7422926425933838, Telerik.Reporting.Drawing.UnitType.Cm)));
	this.table1.Body.Columns.Add(new Telerik.Reporting.TableBodyColumn(new Telerik.Reporting.Drawing.Unit(4.39299201965332, Telerik.Reporting.Drawing.UnitType.Cm)));
	this.table1.Body.Rows.Add(new Telerik.Reporting.TableBodyRow(new Telerik.Reporting.Drawing.Unit(0.99999988079071045, Telerik.Reporting.Drawing.UnitType.Cm)));
	this.table1.Body.Rows.Add(new Telerik.Reporting.TableBodyRow(new Telerik.Reporting.Drawing.Unit(0.99999988079071045, Telerik.Reporting.Drawing.UnitType.Cm)));
	this.table1.Body.SetCellContent(1, 1, this.textBox23);
	this.table1.Body.SetCellContent(1, 2, this.textBox24);
	this.table1.Body.SetCellContent(0, 1, this.textBox30);
	this.table1.Body.SetCellContent(0, 2, this.textBox31);
	this.table1.Body.SetCellContent(0, 0, this.textBox5);
	this.table1.Body.SetCellContent(1, 0, this.textBox7);
	tableGroup9.Name = "Group8";
	tableGroup8.ChildGroups.Add(tableGroup9);
	tableGroup8.Name = "Group5";
	tableGroup10.ChildGroups.Add(tableGroup11);
	tableGroup10.Name = "Group2";
	tableGroup12.ChildGroups.Add(tableGroup13);
	tableGroup12.Name = "Group3";
	this.table1.ColumnGroups.Add(tableGroup8);
	this.table1.ColumnGroups.Add(tableGroup10);
	this.table1.ColumnGroups.Add(tableGroup12);
	this.table1.DataMember = "";
	this.table1.DataSource = typeof(ClassLibrary1.MySampleData);
	this.table1.Items.AddRange(new Telerik.Reporting.ReportItemBase[] {
	this.textBox23,
	this.textBox24,
	this.textBox30,
	this.textBox31,
	this.textBox5,
	this.textBox7,
	this.textBox28,
	this.textBox9,
	this.textBox1,
	this.textBox20,
	this.textBox19,
	this.textBox2});
	this.table1.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(0.003199396887794137, Telerik.Reporting.Drawing.UnitType.Cm), new Telerik.Reporting.Drawing.Unit(4.1999998092651367, Telerik.Reporting.Drawing.UnitType.Cm));
	this.table1.Name = "table1";
	tableGroup17.Name = "Group7";
	tableGroup16.ChildGroups.Add(tableGroup17);
	tableGroup16.Name = "Group4";
	tableGroup16.ReportItem = this.textBox1;
	tableGroup15.ChildGroups.Add(tableGroup16);
	tableGroup15.Name = "Group9";
	tableGroup15.ReportItem = this.textBox9;
	tableGroup14.ChildGroups.Add(tableGroup15);
	tableGroup14.Name = "Group6";
	tableGroup14.ReportItem = this.textBox28;
	tableGroup21.Name = "Group1";
	tableGroup20.ChildGroups.Add(tableGroup21);
	tableGroup20.Grouping.AddRange(new Telerik.Reporting.Data.Grouping[] {
	new Telerik.Reporting.Data.Grouping("=Fields.Item")});
	tableGroup20.Name = "Item";
	tableGroup20.ReportItem = this.textBox2;
	tableGroup20.Sorting.AddRange(new Telerik.Reporting.Data.Sorting[] {
	new Telerik.Reporting.Data.Sorting("=Fields.Item", Telerik.Reporting.Data.SortDirection.Asc)});
	tableGroup19.ChildGroups.Add(tableGroup20);
	tableGroup19.Name = "Group10";
	tableGroup19.ReportItem = this.textBox19;
	tableGroup18.ChildGroups.Add(tableGroup19);
	tableGroup18.Grouping.AddRange(new Telerik.Reporting.Data.Grouping[] {
	new Telerik.Reporting.Data.Grouping("=Fields.Company")});
	tableGroup18.Name = "Company";
	tableGroup18.ReportItem = this.textBox20;
	tableGroup18.Sorting.AddRange(new Telerik.Reporting.Data.Sorting[] {
	new Telerik.Reporting.Data.Sorting("=Fields.Company", Telerik.Reporting.Data.SortDirection.Asc)});
	this.table1.RowGroups.Add(tableGroup14);
	this.table1.RowGroups.Add(tableGroup18);
	this.table1.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(14.998250961303711, Telerik.Reporting.Drawing.UnitType.Cm), new Telerik.Reporting.Drawing.Unit(1.9999997615814209, Telerik.Reporting.Drawing.UnitType.Cm));
	//
	// textBox23
	//
	this.textBox23.Name = "textBox23";
	this.textBox23.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(2.7422926425933838, Telerik.Reporting.Drawing.UnitType.Cm), new Telerik.Reporting.Drawing.Unit(0.99999988079071045, Telerik.Reporting.Drawing.UnitType.Cm));
	this.textBox23.Value = "=Fields.Unit";
	//
	// textBox24
	//
	this.textBox24.Name = "textBox24";
	this.textBox24.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(4.39299201965332, Telerik.Reporting.Drawing.UnitType.Cm), new Telerik.Reporting.Drawing.Unit(0.99999988079071045, Telerik.Reporting.Drawing.UnitType.Cm));
	this.textBox24.Value = "=Fields.Price";
	//
	// textBox30
	//
	this.textBox30.Name = "textBox30";
	this.textBox30.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(2.7422926425933838, Telerik.Reporting.Drawing.UnitType.Cm), new Telerik.Reporting.Drawing.Unit(0.99999988079071045, Telerik.Reporting.Drawing.UnitType.Cm));
	this.textBox30.Value = "Unit";
	//
	// textBox31
	//
	this.textBox31.Name = "textBox31";
	this.textBox31.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(4.39299201965332, Telerik.Reporting.Drawing.UnitType.Cm), new Telerik.Reporting.Drawing.Unit(0.99999988079071045, Telerik.Reporting.Drawing.UnitType.Cm));
	this.textBox31.Value = "Price";
	//
	// textBox5
	//
	this.textBox5.Name = "textBox5";
	this.textBox5.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1.918946385383606, Telerik.Reporting.Drawing.UnitType.Cm), new Telerik.Reporting.Drawing.Unit(0.99999988079071045, Telerik.Reporting.Drawing.UnitType.Cm));
	this.textBox5.Value = "Spend";
	//
	// textBox7
	//
	this.textBox7.Name = "textBox7";
	this.textBox7.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1.918946385383606, Telerik.Reporting.Drawing.UnitType.Cm), new Telerik.Reporting.Drawing.Unit(0.99999988079071045, Telerik.Reporting.Drawing.UnitType.Cm));
	this.textBox7.Value = "=Fields.Spend";
	//
	// textBox28
	//
	this.textBox28.Name = "textBox28";
	this.textBox28.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(2.0125358104705811, Telerik.Reporting.Drawing.UnitType.Cm), new Telerik.Reporting.Drawing.Unit(0.99999988079071045, Telerik.Reporting.Drawing.UnitType.Cm));
	//
	// textBox1
	//
	this.textBox1.Name = "textBox1";
	this.textBox1.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(2.0125365257263184, Telerik.Reporting.Drawing.UnitType.Cm), new Telerik.Reporting.Drawing.Unit(0.99999988079071045, Telerik.Reporting.Drawing.UnitType.Cm));
	this.textBox1.Value = "Item";
	//
	// textBox20
	//
	this.textBox20.Name = "textBox20";
	this.textBox20.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(2.0125358104705811, Telerik.Reporting.Drawing.UnitType.Cm), new Telerik.Reporting.Drawing.Unit(0.99999988079071045, Telerik.Reporting.Drawing.UnitType.Cm));
	this.textBox20.Value = "=Fields.Company";
	//
	// textBox2
	//
	this.textBox2.Name = "textBox2";
	this.textBox2.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(2.0125365257263184, Telerik.Reporting.Drawing.UnitType.Cm), new Telerik.Reporting.Drawing.Unit(0.99999988079071045, Telerik.Reporting.Drawing.UnitType.Cm));
	this.textBox2.Value = "=Fields.Item";
	//
	// textBox9
	//
	this.textBox9.Name = "textBox9";
	this.textBox9.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1.9189468622207642, Telerik.Reporting.Drawing.UnitType.Cm), new Telerik.Reporting.Drawing.Unit(0.99999988079071045, Telerik.Reporting.Drawing.UnitType.Cm));
	this.textBox9.Value = "Total";
	//
	// textBox19
	//
	this.textBox19.Name = "textBox19";
	this.textBox19.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1.9189468622207642, Telerik.Reporting.Drawing.UnitType.Cm), new Telerik.Reporting.Drawing.Unit(0.99999988079071045, Telerik.Reporting.Drawing.UnitType.Cm));
	this.textBox19.Value = "=Sum(Fields.Price)";
	//
	// CrossTabTreeLike
	//
	this.Items.AddRange(new Telerik.Reporting.ReportItemBase[] {
	this.detail});
	this.PageSettings.Landscape = false;
	this.PageSettings.Margins.Bottom = new Telerik.Reporting.Drawing.Unit(1, Telerik.Reporting.Drawing.UnitType.Inch);
	this.PageSettings.Margins.Left = new Telerik.Reporting.Drawing.Unit(1, Telerik.Reporting.Drawing.UnitType.Inch);
	this.PageSettings.Margins.Right = new Telerik.Reporting.Drawing.Unit(1, Telerik.Reporting.Drawing.UnitType.Inch);
	this.PageSettings.Margins.Top = new Telerik.Reporting.Drawing.Unit(1, Telerik.Reporting.Drawing.UnitType.Inch);
	this.PageSettings.PaperKind = System.Drawing.Printing.PaperKind.A4;
	this.Style.BackgroundColor = System.Drawing.Color.White;
	this.Width = new Telerik.Reporting.Drawing.Unit(15.399999618530273, Telerik.Reporting.Drawing.UnitType.Cm);
	((System.ComponentModel.ISupportInitialize)(this)).EndInit();
	}
	#endregion
	private Telerik.Reporting.DetailSection detail;
	private Crosstab crosstab1;
	private Telerik.Reporting.TextBox textBox4;
	private Telerik.Reporting.TextBox textBox8;
	private Telerik.Reporting.TextBox textBox10;
	private Telerik.Reporting.TextBox textBox3;
	private Telerik.Reporting.TextBox textBox6;
	private Telerik.Reporting.TextBox textBox14;
	private Telerik.Reporting.TextBox textBox13;
	private Telerik.Reporting.TextBox textBox12;
	private Telerik.Reporting.TextBox textBox11;
	private Telerik.Reporting.TextBox textBox18;
	private Telerik.Reporting.TextBox textBox17;
	private Telerik.Reporting.TextBox textBox16;
	private Telerik.Reporting.TextBox textBox15;
	private Table table1;
	private Telerik.Reporting.TextBox textBox23;
	private Telerik.Reporting.TextBox textBox24;
	private Telerik.Reporting.TextBox textBox30;
	private Telerik.Reporting.TextBox textBox31;
	private Telerik.Reporting.TextBox textBox20;
	private Telerik.Reporting.TextBox textBox28;
	private Telerik.Reporting.TextBox textBox1;
	private Telerik.Reporting.TextBox textBox2;
	private Telerik.Reporting.TextBox textBox5;
	private Telerik.Reporting.TextBox textBox7;
	private Telerik.Reporting.TextBox textBox9;
	private Telerik.Reporting.TextBox textBox19;
	}
	}

[Steve]

Hi Servando,

I'm not sure which is the confusing part in your case. The sample report we've sent is using dummy data, so imagine that the Price column is the Total column in your scenario. What do you mean by moving the Total column to the right?

Greetings,
Steve
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.

[Servando]

I mean from this grouping:

	Total	Item	Spend	Unit	Price
Company One	61,7	Item 1	10	kg	10,2
		Item 3	15	oz	1,5
		Item 8	20	grs	50
Company Two	61,7	Item 2	9	kg	10,2
		Item 3	15	oz	1,5
		Item 7	20	grs	50

 

 To this grouping

	Item	Spend	Unit	Price	Total
Company One	Item 1	10	kg	10,2	61,7
	Item 3	15	oz	1,5
	Item 8	20	grs	50
Company Two	Item 2	9	kg	10,2	61,7
	Item 3	15	oz	1,5
	Item 7	20	grs	50

[Steve]

Hello Servando,

Unfortunately such crosstab layout (the second one) is currently not possible to achieve with Telerik Reporting. The "sub-total" for a group is always on the left hand side or after the group.

Please excuse us for the inconvenience.

Kind regards,
Steve
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.

[Prakash Pogaru]

Hi Steve,
                I would like to ask a question regarding table grouping. I have gone through the telerik reports examples and demos you have provided, but i failed to get the solution for my problem.
                Actually my problem is ...how can we do table grouping??? i need some example code....tables should be reapeating based on a field value....for example assume there are 3 suppliers i need to display details for each of the supplier means i need to display 3 tables having supplier name on the top of the each table.
                could you please suggest me how to do??? if you send any code snippet then that i will be very much helpful.



Regards
Prakash