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.
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.