Grouping by Column

[Mihai Dinculescu]

Hello

I have a report  that looks like:

col1 value 1
col1  value 2
col1 value 3

I'd like to show col1 only once. If I use the group header for this it will add an extra row like:

col1
value 1
value 2
value 3

Is there any way to have it like:

col1  value 1
  value 2
value 3

Thanks
Mihai

[Mihai Dinculescu]

Bump. I still need help on this issue.

I found that I can use DetailArea1_ItemDataBound to programmatically get around this, but in this case I'm not able to repeat the group header on the continuous pages (because I can't get the pagenumber inside the DetailArea1_ItemDataBound).

[Peter]

Hi Mihai Dinculescu,

The easiest way to achieve the desired layout is to use a CrossTab. You can create such CrossTab with the CrossTab Wizard that will guide you through the process of creating a CrossTab for your reports. Their intuitive step by step instructions would get you going in no time as no previous experience is needed when using the wizard. On the Arrange Fields step add the col1 field as Row Group. This will add a group by full name. By design the group fields are spanned. If the CrossTab suggestion is not applicable our suggestion is to set the col1 textbox.Visibility with a Binding to the following Expression: =RowNumber("col1Group")=1. Just to note that setting a Textbox.Visibility to false will leave empty space and all of the items on the right side will move to occupy this empty space. To avoid this behavior you have to add the textboxes on the right side into a Panel item and Dock it to right.

You may find useful the Working with Tables Lists and Cross Tabs video.

Greetings,
Peter
the Telerik team

[Cristian]

Hi I'm grouping by adding group header but instead of getting Mihai's result

col1
        value 1    
        value 2
        value 3
 I'm getting the following
col1
        value 1    
col2
        value 2
col3      
        value 3

How can I do to have just one header by group?
I'm using Telerik Reporting Q1 2012