473,320 Members | 1,976 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Suggestion for a control

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

Apr 3 '07 #1
6 1204
On Apr 3, 8:25 am, "BlueTrin" <bluet...@gmail.comwrote:
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
How about a TreeView?

Apr 3 '07 #2
PS
"BlueTrin" <bl******@gmail.comwrote in message
news:11**********************@q75g2000hsh.googlegr oups.com...
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
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

Apr 3 '07 #3
PS

"PS" <ec***********@hotmail.comwrote in message
news:eK**************@TK2MSFTNGP03.phx.gbl...
"BlueTrin" <bl******@gmail.comwrote in message
news:11**********************@q75g2000hsh.googlegr oups.com...
>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

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
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
Apr 4 '07 #4
On 3 avr, 18:54, "Bruce Wood" <brucew...@canada.comwrote:
On Apr 3, 8:25 am, "BlueTrin" <bluet...@gmail.comwrote:
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

How about a TreeView?
Hello Bruce,

I didn't find the component in the default installation of VS 2005

Thanks
Anthony

Apr 4 '07 #5
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

On 4 avr, 01:16, "PS" <ecneserpeg...@hotmail.comwrote:
"PS" <ecneserpeg...@hotmail.comwrote in message

news:eK**************@TK2MSFTNGP03.phx.gbl...
"BlueTrin" <bluet...@gmail.comwrote in message
news:11**********************@q75g2000hsh.googlegr oups.com...
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
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

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

Apr 4 '07 #6
I am looking for also something that more or less looks like a grid
and where the user could try to edit the data.

On 4 avr, 09:57, "BlueTrin" <bluet...@gmail.comwrote:
On 3 avr, 18:54, "Bruce Wood" <brucew...@canada.comwrote:
On Apr 3, 8:25 am, "BlueTrin" <bluet...@gmail.comwrote:
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
How about a TreeView?

Hello Bruce,

I didn't find the component in the default installation of VS 2005

Thanks
Anthony

Apr 4 '07 #7

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

7
by: Swilson513 | last post by:
I'm trying to make what should be a simple DB, but have done got myself confused. I'm trying to keep track of the contents of several kits that use common components. Each component has a unique...
4
by: Francesco Martinelli | last post by:
I need to create a multiple file assemby: this requires working directly with the command line compiler (no IDE support!). After a few tests I found my problem comes from the issue described below....
1
by: Robert W. | last post by:
I have a 'Controller' object that manages the interaction between its two children: a Form and a DataObject. I've written specialized code in the Controller to control how the Form updates the...
3
by: m00nm0nkey | last post by:
I'm not sure if this is a good suggestion, or perhaps just my mis-understanding, but something that seems obviously missing from the ASP.Net Repeater control, is a "no results" template. What I...
4
by: KatB | last post by:
Hi, I'm creating an asp.net application and one of the functions I need is to click on a "Where Is This Office Located?" button. In a table, each employee will have an office code location...
1
by: Hugo Flores | last post by:
Hi, The system that I'm building has some conditions, which will tell me which page to show at that time. My first thought was to have a table of controls in my DB, which will have a column...
4
by: B | last post by:
Hi, I'm working on a site where the user must log in before they see the home page. When the user logs in, I retrieve their role from the database, store it in a Session object and redirect...
3
by: Andrew Ducker | last post by:
Let's say I have an interface (IValid) I want to add to all the different Winform.Controls classes (textbox, radiobutton, etc). And I have a bunch of methods that then use these IValid Controls. ...
3
by: David Hauer | last post by:
Hi, I am evaluating 3rd party user interface controls (Grid, Treeview, Explorer bar, Ribbons, and common controls like checked-combo box, calender etc). I have 3 contenders: Infragistics...
9
by: Jonathan Wood | last post by:
Greetings, My app displays users in a GridView control. I'd like to have the name field shown in each row of this control a link that displays another page with information about that user. ...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.