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

Changing columns order while grouping

6 Answers 111 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Servando
Top achievements
Rank 1
Servando asked on 20 Jul 2009, 06:29 PM
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.

6 Answers, 1 is accepted

Sort by
0
Steve
Telerik team
answered on 21 Jul 2009, 01:54 PM
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.
0
Servando
Top achievements
Rank 1
answered on 21 Jul 2009, 02:32 PM
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;  
    }  
0
Steve
Telerik team
answered on 21 Jul 2009, 02:51 PM
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.
0
Servando
Top achievements
Rank 1
answered on 21 Jul 2009, 04:18 PM
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

0
Steve
Telerik team
answered on 24 Jul 2009, 01:23 PM
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.
0
Prakash Pogaru
Top achievements
Rank 1
answered on 11 Sep 2009, 12:37 PM
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
Tags
General Discussions
Asked by
Servando
Top achievements
Rank 1
Answers by
Steve
Telerik team
Servando
Top achievements
Rank 1
Prakash Pogaru
Top achievements
Rank 1
Share this question
or