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

Display hierarchical data in a grid

1 Answer 66 Views
GridView
This is a migrated thread and some comments may be shown as answers.
Rodney
Top achievements
Rank 1
Rodney asked on 22 Sep 2011, 03:54 PM
I looking for ideas on how display order data from my different departments.  Which sounds simply but each department may have difined custom fields specific to their needs


Base order table
DepartmentID
Customer Name
Company Name
PHone


Customized Portion
CustomField1
CustomField2
CustomField3
and so on.

The custom fields can contain text, numeric or date data.  The field descriptions can differ depening on how the department has customized the fields.


Let me show an example of what I would like to do if possbile


Department | Company Name |Customer Name | Created Date
+ Sales - East | AA Comp |John Smith | 10/1/2010
+ Sales - East | BB Comp |Jim Smith | 6/1/2010
+ Sales - West | CC Comp |Rodney Smith | 10/1/2010
+ Sales - West | DD Comp |Allen Smith | 10/1/2010


Expanded View
Deparment         | Company Name |Customer Name | Created Date
- Sales - East      | AA Comp            |John Smith        | 10/1/2010

                   Account Type |Account Stage |Client Type | Close Date
                       III-VI              |Active              |New           | 12/1/2010
                       III-XI              |Active              |Existing       | 12/15/2010

+ Sales - East      | BB Comp             |Jim Smith          | 6/1/2010
- Sales - West      | CC Comp            |Rodney Smith   | 10/1/2010

                      Probability |Estimated Revenue |Close Date
                      80%          |$250,000.00          |12/1/2010
                       25%          |$25,000.00            |12/15/2010

+ Sales - West | DD Comp |Allen Smith | 10/1/2010


As you can see from the sample the sub grid contains the departments user defined fields which can different headers and display formats. 

My main question is this even possible with the grid view control?

Thanks in advance your time.

1 Answer, 1 is accepted

Sort by
0
Julian Benkov
Telerik team
answered on 27 Sep 2011, 11:46 AM
Hi Rodney,

Thank you writing us.

RadGridView does not support this kind of functionality. You can not mix different columns schemas at a single hierarchy level. You can only use one set of columns per level.

Do not hesitate to contact us if you have further questions or issues.

Greetings,

Julian Benkov
the Telerik team

Explore the entire Telerik portfolio by downloading the Ultimate Collection trial package. Get it now >>

Tags
GridView
Asked by
Rodney
Top achievements
Rank 1
Answers by
Julian Benkov
Telerik team
Share this question
or