Multi Level grid or Treeview where Only the lowest level of children are assigned columns or fields for extra data

Question

1.00/5 (1 vote)

See more:

I have been trying to figure out how financial applications are made in such a way as to allow a multi level grid where some level of the grid (or tree) does not have columns or values to its right side. Its only the lowest level on the tree or grid level or group level that has columns or fields with values.

I need help on where to start or best options to take or example.

Thanks in advance.

Posted 20-Jun-13 22:52pm

kipchirchir

Updated 20-Jun-13 22:54pm

v3

Add a Solution

Comments

Ron Beyer 21-Jun-13 12:43pm

Can you post some links or images to what you are trying to achieve? Its difficult from the context of your question to see exactly what you are going for.

kipchirchir 23-Jun-13 4:40am

check solution 3. i have posted some link to an image

Sergey Alexandrovich Kryukov 27-Jul-13 23:59pm

This is not a solution, and posting such things as "solution" is nothing but abuse. Please don't do such things.
—SA

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

JackDingler · Answer 1 · 2013-06-21T04:30:00

Solution 1

What have you done so far to find this information?

Have you tried Google?

There are lots of code examples for custom tree controls. None may be exactly what you are looking for, but as these examples contain source code, you can modify one of them to fit your needs.

Posted 21-Jun-13 4:30am

JackDingler

kipchirchir · Answer 2 · 2013-06-21T06:40:00

Solution 2

Thanks jackDingler.. i have downloaded about 20 of the samples, and not really what i want or they are not completely re-usable code.
I thought maybe someone has a good link... i now want to start it and i think i will have to start from scratch.

Posted 21-Jun-13 6:40am

kipchirchir

Comments

JackDingler 21-Jun-13 15:15pm

I rarely ever find a source example on the internet, is already a complete solution to a problem I have.

Actually I'm not sure it's ever happened...

I don't know what you mean by 'not completely re-usable code'. Do you mean there's a licensing issue?

If you have the time, writing one from scratch is a great way to learn how to put such controls together. I think you'll enjoy the challenge. :)

kipchirchir 23-Jun-13 4:41am

check solution 3. thanks!

kipchirchir · Answer 3 · 2013-06-22T21:25:00

Solution 3

Ok. JackDingler and Ron. Am working on it now and i have tables on mysql already.
Here is the link to the tables relationship diagram and some final report:Image
I am not sure if the tables are properly designed as i was thinking they should all be in one table each record having a parent ID of the other record, and this makes me think how will i load a report like on that image?

any idea how such financial systems are organised and reported?

thanks in advance.

Posted 22-Jun-13 21:25pm

kipchirchir

Comments

JackDingler 24-Jun-13 8:36am

Your database structure and your tree structure don't have to be the same.

In memory when I have many kinds of data to display in a tree, I create a common base class that has a typedef to tell which derived class type it is. Then I can have a different set of data referenced each item in the tree.

Your database layout is going to be determined by the kind of records you need to store and look up.

In both case, make your records and your field names represent what kind of data they contain. Try not to use terms like 'SubItem'. If SubItem refers to Salary, name it Salary.

Finally, don't do direct look ups into the database by table names. Create views, and have all of the look ups use views. If you do this, you don't paint yourself into a corner with your table structures. You'll be able to change them as your understanding of the data improves, without breaking code that you have no control over. You'll simply need to adjust the view to reference the new location for the data.

kipchirchir 24-Jun-13 14:48pm

Thanks JackDingler, i appreciate your help. i will try to apply this knowledge. I have never learnt or used views before therefore i gues i have to google it and train well. thanks