Path: utzoo!utgpu!news-server.csri.toronto.edu!rpi!zaphod.mps.ohio-state.edu!sdd.hp.com!spool.mu.edu!uunet!mcsun!cernvax!chx400!chx400!forty2!eichi
From: eichi@forty2.physik.unizh.ch (Stefan Eichenberger)
Newsgroups: comp.databases
Subject: Clipper (dBase III) and Organigram Report Generator needed!
Message-ID: <1457@forty2.physik.unizh.ch>
Date: 4 Apr 91 10:11:44 GMT
Article-I.D.: forty2.1457
Reply-To: eichi@forty2.physik.unizh.ch (Stefan Eichenberger)
Organization: Physics Institute University Zuerich
Lines: 61


I'm looking for software to solve the following problem:

Given a database programmed in the dBase compiler Clipper (Sommer 87, not
yet version 5.0). 

One would now like to extract organigram-like reports: The user has to be
able to define the 'graphic': Who is the boss, who are the subordinates, etc.
(It won't be a fixed hierarchy, once and for all, it should be redefinable
for each report printed).

Once the hierarchy is defined, the individual boxes of the organigram should
be filled with data from a *.dbf file, that contains one record per member,
with data such as birthday, address, etc. This insertion of data is always the
same and sould therefor be automated.

Any ideas, how this could be done? Libraries for Clipper? Organigramm Packages
that could import data from *.dbf? And would allow a relatively easy 'link'?

Example: 
   The user defines:

            Max
             |
  |---------------------|
Peter                 John
  |
Eric

  Existing database:
  :
  Max    1.1.50  US Citicen
  Peter  1.1.40  Spanish
  Eric   3.3.60  Canadian
  John   2.12.55 French
  :

   Printed:
           Max
           Born 1.1.50
           US Citicen
            |
  |---------------------|
Peter                 John
Born 1.1.40           Born 2.12.55
Spanish               French
  |
Eric
Born 3.3.60
Canadian

Any help appreciated! I'll summarize, if need is.




-- 
----------------------------------------------------------------------------
iNet:      eichi@physik.unizh.ch                 Stefan Eichenberger
UUCP:      ...mcsun!chx400!forty2!eichi          Physics Institut
BITNET:    K807817@CZHRZU1A                      University of Zurich