Grouped column in table should appear only once

[Sagar]

Hi,

I have created a report using table. 
At present:I am getting

column1  column2  column3
-----------------------------
fruit         apple         red
fruit        banana       green
fruit        mango       yellow
car         toyota       black
car         nissan        silver

What I want is:

column1  column2  column3
-----------------------------
fruit         apple         red
              banana       green
              mango       yellow
car         toyota       black
              nissan        silver

So as you can see, grouped column is getting repeated for all grouped rows. However I want it to appear only once.
Heres my code :

// coll is a collection  & my datasource
 this.table1.DataSource = coll;

             TableGroup group = new TableGroup { Name = "Territory" };
                group.Groupings.Add(new Telerik.Reporting.Data.Grouping("=Fields.Territory"));


                //Remove the detail group
                var detailGroup = table1.RowGroups[0];
                table1.RowGroups.Clear();

                //Add the detail group as a child to the AgeGroup (nest it)
                group.ChildGroups.Add(detailGroup);
                group.GroupKeepTogether = true;
                //Add the AgeGroup
                table1.RowGroups.Add(group);

 Any suggestions ?

[Steve]

Hi Sagar,

You need to create a parent row group that groups by Column1. I've attached a sample report that shows the desired functionality.

Kind regards,
Steve
the Telerik team