I'm thinking about producing a 'family tree' style report.
The table im working with (t_relationships) contains the subject and personal relationships to the subject. I've attached three family groups as sample data.
At this stage im just thinking about whether its possible in sql and if so the logic behind it.
I'm also working with a reporting tool called actuate which would allow me to dynamically position the data items on a page (based on the family composition) but i'm reluctant to take this option due to the heavy programming that this would involve. I'm therefore wondering if I can do anything in sql to get this result or at least make the task easier for when the sql is dropped into actuate.
Any ideas are apprecated.