automate visio document generation from central database

[Brian]

Hi, I am looking for solution for our company on generating document from our
central database.

We are looking onto if Visio 2003 can posssibly take the necessary fields of
data from our file register. It should generate a report with all the
standard fileds already filled in (to reduced human factor). The rest will be
some technicial drawings which can be done Automaticly or manually.

Is it possible?

 

[MacroChaotic]

Sure its possible. I am coding a report dashboard in Visio from data sourced
in SQL Server. My approach is to return the SQL result in an ADO recordset
and blow the values out to my Visio objects, both text and shapes. As soon
as the prototyping cycle is over I plan to use the SaveAsWeb API to generate
the web pages. Or I may blow them out to web parts first. In any case,
Visio + SQLServer is a surprisingly cool approach to this kind of work.