parent level & child Levels

[sameer11]

Hi,

My thinking to this is way limited. Is it possible to do this??.
Have 2 database tables whichare related to like table1 has the summary and table2 has details
In table1 - 2 fields ( Parent level & childe level)
ex: Parent level Child level
1 1
1 2
1 3
1 4
1 5...so on abt 15 levels as of now
2 2
2 3
2 4
2 5 ...so on
3 3
3 4 ..so on

**so on abt 15 levels as of now but I will nees only upto 1-7 levels

In table2 I have details for these levels_numbers id's and description.

My user wants a report where the level will be the Parameter and they can ultimately enter any level then the report should be displaying the 3- levels down of details.
(say)it should looks like this:
?level = 2

GH1 -level 2
GH2- Level 3
GH3 - level 4 descritption units count(units) total (as details)

?level = 3
GH1 -level 3
GH2- Level 4
GH3 - level 5 descritption units count(units) total (as details)


Please advice and Thanks for your help.

Sameer

 

[lbass]

First it looks like you only want up to 7 levels, so you could limit the records in the record selection formula to:

{table.childlevel} in 1 to 7

I would create the report with groups on parent level and child level, and then display the description in the details section (although maybe there is another field within the description table that you want to group on, too?). Then use use the parameter to conditionally suppress the group header, details, and/or footer sections as appropriate, using something like the following:

{?level} = 2

Or, if you want suppression for more than one result:

{?level} in [2,3] //the particular numbers here don't relate to your example

-LB