Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Tree View in Report
Message
From
16/02/2006 20:04:01
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
 
 
To
16/02/2006 19:50:45
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Environment versions
Visual FoxPro:
VFP 8 SP1
Miscellaneous
Thread ID:
01096942
Message ID:
01096946
Views:
18
>Dear All,
>
>I want to print a report in tree view design (like treeview control).
>
>How can i do that ?
>
>Thanks a lot
>Winarto.
>
>

You can get part of the way by including a variable-sized indentation. Prepare the data appropriately, including a field "level" which indicates at what level of the hierarchy the record is. Then, print an expression similar to:
space(level * 4) + SomeField
You could also include several fields, one for each level, and print them conditionally (depending on the contents of the same "level" field). With some patience, you could also draw some lines, which would also print conditionally.

Yet another possibility is to produce the report in Excel (through Automation), and draw the connecting lines in a variable position. I never tried this, but it should be possible.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform