Suggestion for a control

  • Thread starter Thread starter BlueTrin
  • Start date Start date
B

BlueTrin

Hello guys,

I am in need for a control to embed in an Excel adding written in C#,
I need to represent a list of sales and their customers.

Is there any kind of grid that can expand/collapse and represent
childrens nodes attached to the salesman ?

Like:

+ Sales Name1 - Total Profit - Hit Ratio
Customer1 - Profit - Hit Ratio
Customer2 - Profit - Hit Ratio
+ Sales Name2 - Total Profit - Hit Ratio
Customer1 - Profit - Hit Ratio
Customer2 - Profit - Hit Ratio
 
Hello guys,

I am in need for a control to embed in an Excel adding written in C#,
I need to represent a list of sales and their customers.

Is there any kind of grid that can expand/collapse and represent
childrens nodes attached to the salesman ?

Like:

+ Sales Name1 - Total Profit - Hit Ratio
Customer1 - Profit - Hit Ratio
Customer2 - Profit - Hit Ratio
+ Sales Name2 - Total Profit - Hit Ratio
Customer1 - Profit - Hit Ratio
Customer2 - Profit - Hit Ratio
Click to expand...

How about a TreeView?
 
BlueTrin said:
Hello guys,

I am in need for a control to embed in an Excel adding written in C#,
I need to represent a list of sales and their customers.

Is there any kind of grid that can expand/collapse and represent
childrens nodes attached to the salesman ?

Like:

+ Sales Name1 - Total Profit - Hit Ratio
Customer1 - Profit - Hit Ratio
Customer2 - Profit - Hit Ratio
+ Sales Name2 - Total Profit - Hit Ratio
Customer1 - Profit - Hit Ratio
Customer2 - Profit - Hit Ratio
Click to expand...

Is there some reason that you don't want to do this in an Excel sheet? Excel
has built in pivot tables that will do EXACTLY as you need.

This was cut and paste so the + is missing next to the names.


Total Profit Avg. Hit Ratio
Jim Smith 4843 0.31
Customer 1 4543 0.16
Customer 3 300 0.46
John Brown 1802 0.32
Customer 1 200 0.05
Customer 2 434 0.54
Customer 3 1168 0.38
Grand Total 6645 0.32


PS
 
PS said:
Is there some reason that you don't want to do this in an Excel sheet?
Excel has built in pivot tables that will do EXACTLY as you need.

This was cut and paste so the + is missing next to the names.


Total Profit Avg. Hit Ratio
Jim Smith 4843 0.31
Customer 1 4543 0.16
Customer 3 300 0.46
John Brown 1802 0.32
Customer 1 200 0.05
Customer 2 434 0.54
Customer 3 1168 0.38
Grand Total 6645 0.32


PS
Click to expand...
The formatting was lost but in a nutshell this was a summary of 20 rows of 4
columns of info: sales person, company, profit and hit ratio. THe pivot
table grouped the information by the salesperson and provide a total for the
sales person and then a grand total. Next to each salesperson was a +/1 to
collapse / expand.

PS
 
Hey PS,

Yeah I do not want to use a PivotTable because it is slow and the
addin will be later used in another stand alone application as a
normal library.

Thanks for the reply.
Anthony
 
I am looking for also something that more or less looks like a grid
and where the user could try to edit the data.
 
Back
Top