Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > ASP General > Huge challenge in retrieve data using ASP

Thread Tools

Huge challenge in retrieve data using ASP

Marco Alting
Posts: n/a

I'm developing a hierachy system that needs display data from a database,
summing from the lowest level up. The difficulty is, there are also multiple
columns across, I'll try to show it below:

col1 col2
col3 col4 col5

What I've tried to draw above is best to think of as sort of a spreadsheet.
Each value of the items at Level1.3 should be summed at Level1.3 and each
LevelX.3 should sum to the level above. Preferably the whole thing should be
collapsable in the browser, but thats another thing. The data that comes
from the database is at the Item level (each Item represents a record in the
table holding the fields col1, col2, col3, col4, col5).

I hope this makes sense to someone out here, because I doesn't to me
anymore! Please help me out here...


Reply With Quote
Mark Henri
Posts: n/a
It sounds a little bit like you're trying to do a normal level break report
but I can't tell from your description. Maybe these will help:

Check out Morten's Javascript Tree Menu at --

Check out the 'GROUP BY' clause for your SQL. It may also help to get
things close to what you need. Otherwise, you'll just be handling the
totalling yourself in the code.

Reply With Quote
Marco Alting
Posts: n/a
Thanks Mark! I think it is a level breakdown report, but my difficulty
is that I have to do it bottom up. I also looked at Tree Menu, which is
a good piece of software, but in my solution the menu-item must have
multiple columns across to show the values sort of like this:

Item col1 col2 col3 col4 col5
xxx val1 val2 val3 val4 val5

and since Tree Menu uses another frame to display the content, I will
not align properly with the menu item.

*** Sent via Developersdex ***
Don't just participate in USENET...get rewarded for it!
Reply With Quote

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Store and retrieve binary data (pdf doc etc) in sqlserver2005 using 2.0 Karl ASP .Net 3 10-07-2009 08:11 AM
How to retrieve data using sql mausimo ASP .Net 0 10-05-2009 06:32 PM
Memory error due to the huge/huge input file size Python 3 11-20-2008 07:21 PM
Pro*c - Using c++ to retrieve unicode data PRiya C++ 1 04-20-2006 01:54 PM
using narray and mmap with HUGE data sets Ara.T.Howard Ruby 0 10-02-2004 03:21 PM