Forum Moderators: open

Message Too Old, No Replies

need: a quick & dirty way to render and view a tree

for a report, ASAP

         

httpwebwitch

6:11 am on Sep 15, 2006 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



I'm just guessing that there might be someone in this forum who can offer advice...

I have a table of hierarchical data, each with
ID ¦ ParentID ¦ Name ¦ Value

The ID is used as the ParentID of other nodes... it's a basic hierarchical structure.

approx 3400 records. The tree seems to go 4-5 levels deep in places. The records are not in any particular order in the table.

I need a quick, simple way to render it in a tree-ish looking way for a report I'm doing. I don't care what format it's in, I just need it to look nice and be printed out on paper... tomorrow!

example:
¦- name,value
¦- name,value
¦ ¦- name,value
¦ ¦ ¦- name, value
¦ ¦ ¦- name, value
¦ ¦- name, value
¦ ¦- name, value
¦- name, value
¦- name, value

the prettier, the better. This is for the suits.

Anyone have ideas? Can I leverage Excel or some 3rd party tool to do this?

httpwebwitch

7:28 pm on Sep 15, 2006 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



never mind - I found a way to export a nicely ordered and indented tree with a recursive SQL stored proc