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.
--
---------------------------------------------------------------------------
UUCP: ...mcsun!chx400!forty2!eichi Physics Institut