If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Create a tree view of several columns

Started by CoginAustin, 02 Mar 2006 04:02:21 PM

Previous topic - Next topic

CoginAustin

Given a table that looks like the following

     L1 L2 L3 L4 L5...
R1

I want to display the data as

L1
L2
L2
  L3
   L4
L2
L2
L1
L2
  L3

Can anyone think of an any way to do this and a way that removes all the duplicates?
I can get it like the following. It shows the entire heirarchy for each row, which is wrong.
L1
L2
  L3
L1
  L2
   L3


CoginAustin

I figured this out.

Create several nested lists. Each list having a data item of the next list down to link to. Create a master/detail for each list starting from the top

then create a huge filter because the users want optional prompts for 10 levels thats says something like
(?Param1? IS MISSING? OR <Field1>=?Param1?) AND (?Param2? Is MISSING OR <Field2>=?Param2?) etc.. etc.. etc..