Cascading Report

[maliary]

Hello,

 

I am trying to convert a drill down report into a one button report where the user doesn't have to click on the links to drill down but everything is displayed all at one.

 

For instance:

 

SELECT familyname,lastname FROM Family where familyname = param

 

but in this case the data produced can be broken down further to produce more subsets of family names.

such that

 

SELECT familyname,lastname FROM Family where familyname = familyname

 

and so on.

 

The thing is I hit a snag on this one and I really don't know how to overcome this. Has someone done this before ?

 

[fenway]

Huh? What re you trying to? Check for multiple family names?

[maliary]

 

 

This is my scenario : -

 

I have the following info

 

grandparentID name,lastname,status,age,parentID

ChildID, name, lastname,status,age,parentID

GrandChildID,name,lastname,status,age,parentID

 

Currently what happens is when I enter the grandparentID I get a drilldown kind of report where I have to click on arrows and go down the levels step wise.

 

I would like to input the grandparentID and from there get all the child and grandchild records of the same parentID without having to drilldown.

 

The grandchild could also have some more children underneath, hence going down and down.

 

 

 

 

 

[fenway]

Not easy without a stored procedure of app code... parentID isn't the best way to store this -- check out the stickies.

[maliary]

 

 

I think I found a way. Using the recursive queries in SQL.

[fenway]

 

 

I think I found a way. Using the recursive queries in SQL.

That would be the other way... that's basically an SP, in app code.