>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)