Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Creating Org type Chart in VFP?
Message
 
 
To
17/09/2004 09:23:07
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00943309
Message ID:
00943381
Views:
33
Tom,

One way to tackle this is to build a template report form. Put a box, 3 labels, a vertical line and horizontal line. Then at runtime USE TheBase.FRX and copy it to a ThisReport.FRX in a scan loop. It's easy to isolate the 3 rows you are going to replicate by having tagged them via a marker in the comments. Then you can do something like scatter name oRectangle from the source and replicate it into the output report as many times as the diagram requires. adjusting the hpos and vpos each time before the insert. Replicate the connecting lines the same. You might be able to se one long vertical line that is set to be under the boxes rather than using lots of little lines between the boxes.

>I just created some output manually using PowerPoint that resembles an organizational chart. The output is six pages long and each page starts with a single top level node then the next level down can have anywhere from 4 to 8 levels across. From each of these sub-levels, I can have anywhere from 0 to 8 levels that all go down vertically. Each box has 3 lines of text so that output kinda looks like this:
>
>
>I like the style of the ouput but with as many as 70 or so boxes that needed to be individually populated (per page) I need to automate the process. Anyone ever done something similar? I suppose I can try to automate PowerPoint, create SVG type output or try something else (I do not have Visio).
df (was a 10 time MVP)

df FoxPro website
FoxPro Wiki site online, editable knowledgebase
Previous
Reply
Map
View

Click here to load this message in the networking platform