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

Cell Merge in Grid

3 Answers 151 Views
PivotGrid
This is a migrated thread and some comments may be shown as answers.
Sengottuvel
Top achievements
Rank 1
Sengottuvel asked on 01 Nov 2012, 12:22 PM
Hi,

I want to merge common cell values to single cell(like row span)

My Data:

UserName Name Date
------------------------------------------
user somename 1/12/12
user somename 2/12/12
user somename 3/12/12
user somename1 2/11/12
user somename1 3/11/12
user somename1 4/11/12
user somename2 6/12/12
user somename2 7/12/12
user somename2 5/12/12

I want like this

UserName Name Date
------------------------------------------
1/12/12
somename 2/12/12
3/12/12
2/11/12
user somename1 3/11/12
4/11/12
6/12/12
somename2 7/12/12
5/12/12


3 Answers, 1 is accepted

Sort by
0
Andrey
Telerik team
answered on 06 Nov 2012, 09:11 AM
Hello,

I am not sure that I understand correctly what your goal is. The data you presented is like for RadGrid, but you have written this post in the RadPivotGrid forum. What control do you want to use?

If you want to use the RadGrid control, you could achieve your goal by using the Grouping functionality of RadGrid. Then you could group by UserName and then by Name. You could check this online demo application for more information on this approach.

If you want to use RadPivotGrid you should modify your datasource to have PivotData. Then you could set three column fields with DataField equal to UserName, Name, and Date.

Greetings,
Andrey
the Telerik team
If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to their blog feed now.
0
Sengottuvel
Top achievements
Rank 1
answered on 07 Nov 2012, 04:05 AM
when we using grouping function in telerik that will display all the rows

we need to display only one time at the center of the column


0
Andrey
Telerik team
answered on 09 Nov 2012, 01:02 PM
Hi,

It will display all the items if you group by one field(UserName). If you group by two fields at the same time (UserName and Name). It will bring the same layout as yours but instead of displaying the name in the middle of the row it will be displayed in the header.

I am afraid that at the moment using grouping is the only built-in way for achieving your goal. Any other layout should be created manually.

Additionally, please note that opening numerous tickets/forum post won't increase the time of the replies. It is more likely the opposite. Keeping related questions and posts in one  thread helps us and the rest of the community to provide better answers in less time.

Greetings,
Andrey
the Telerik team
If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to their blog feed now.
Tags
PivotGrid
Asked by
Sengottuvel
Top achievements
Rank 1
Answers by
Andrey
Telerik team
Sengottuvel
Top achievements
Rank 1
Share this question
or