Organization chart on one page

[Mos]

Hi all, Im developing organization in VS.NET2005 using visio addon.
The basic code is as
VisAddOn.Run("/S-INIT")
VisAddOn.Run("/S-ARGSTR " + "/FILENAME=" + exportFilePath)
VisAddOn.Run("/S-ARGSTR " + "/NAME−FIELD=Name")
VisAddOn.Run("/S-ARGSTR " + "/MANAGER-FIELD=PID")
VisAddOn.Run("/S-ARGSTR " + "/UNIQUE-FIELD=ID")
VisAddOn.Run("/S-RUN")

The 'exportFilePath' is an excel file that has data from database. The excel
file has 51 Rows. My requirement is I want to draw all the 51 nodes on one
page but when the application runs, it distributes the shapes on 3 pages.
Anyones help will be greatly appreciated.
Thnx in advance.

 

[AlEdlund]

I think I got involved in one of these, it was a math problem. Each box took
X amount of lines, multiply that times the depth of the chart (how deep the
manager/employee count is) and divide by how many lines on a page...
Assume X is 6 lines, depth of chart is 11 deep and 33 lines per page (a
function of which font was used) = two pages..
Then you also have to figure out how wide your diagram is going to be
because it can spread horizontally

Alternatives : rethink how many people per page, restructure to multiple
diagrams, manage fonts/shapes

Of course your mileage may vary..

al

 

[Mos]

Hi AlEdlund,
Thnx for your reply. But I have solved the issue before you post. I jsut add
another command that is:
VisAddOn.Run("/S-ARGSTR " + "/PAGES=""Top Node Text""")
Thats it and not all the nodes are drawn on the same page.
Regards,