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
6  1225 
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?
"BlueTrin" <bl******@gmail .comwrote in message
news:11******** **************@ q75g2000hsh.goo glegroups.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
"PS" <ec***********@ hotmail.comwrot e in message
news:eK******** ******@TK2MSFTN GP03.phx.gbl...
"BlueTrin" <bl******@gmail .comwrote in message
news:11******** **************@ q75g2000hsh.goo glegroups.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
On 3 avr, 18:54, "Bruce Wood" <brucew...@cana da.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
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.comwrot e:
"PS" <ecneserpeg...@ hotmail.comwrot e in message
news:eK******** ******@TK2MSFTN GP03.phx.gbl...
"BlueTrin" <bluet...@gmail .comwrote in message
news:11******** **************@ q75g2000hsh.goo glegroups.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
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...@cana da.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
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
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 number
and each kit has a unique number. I would like to be able to pull up
the kit number them choose the individual components that are included
in that kit and keep that record so if any components are changed it
would update the kit.
|
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.
Thank you in advance for any suggestion?
===
The project is a nearly empty Windows Form project, and the compilation
works fine as far as there is no bitmap in the project form.
I have to use the command line compiler and I use the following...
|
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 DataObject and vice-versa.
Normally after the user changes the value of a control, the DataObject is
instantaneously updated (via code in the Controller). But I'm having
problems when say the user enters text into a textbox and then immediately...
|
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 mean by this, is a template, to be used when the datasource for the
repeater does not contain any rows. At present, I am having to check the
number of rows in the table, and show or hide an additional <TR> depending on
the number of rows rendered...
|
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 entered.
I then need to have the office layout image load and have the name of
that person highlighted such as bold/red (in the correct office
location).
Similar to an image map, but not quite. I do not want to click on an
office "hotspot" and go...
| | |
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 for the path of a control. This way, a web form would
query the table to know which control it has to load.
However, I gave it a second thought, because in theory, one must use
user controls, only when you are going to re-use it somewhere else (not
|
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 to the homepage. The home page
contains a navigation menu (user control) which displays links
available to the user based on their role. The navigation menu/links
are generated from the database.
|
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. Sometimes
they access them as Controls, sometimes as IValids. Which means
casting back and forth. You end up with things like:
DoStuffWithControls(((Control)validControl).Controls);
rather than
DoStuffWithControls(validControl.Controls);
|
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 (Window Suit for 2.0)
Dev Express (6.0 for framework 2.0)
Janus (UI and WinForm Suit)
|
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.
But I'm not sure how to approach this. How would I tell the target page
which user to display? I'd prefer not to pass the user's ID on the URL, and
I don't know when I'd get a chance to set a Session variable.
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| | |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| | |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
