Create Word 03/07 doc from .NET website with SQL data

[Guest]

Hi there.
I have a .NET 2.0 website with a SQL server backend. I want to allow the
user to select a report that will be generated & downloaded to the user on
the fly. The report will be based on a stored Word template/document. The
template/document will include either content controls or mail merge tags to
be replaced by data from the SQL database.

I can use Word 2003 or 2007.

I have looked at 2007 content controls but these do not seem to allow
repeated content controls for table data. i.e. order lines from an order. The
reports will have a mixture of single fields and some repeated fields in
tables.

Does anyone know of a suitable solution to this problem and any links to
sample code than may be of use?

Thank you for any help offered.

Please note that I have also posted this request in the mailmerge group as I
was not sure which group is the best one to go for. Apologies for any
duplication of effort on anyones part.

 

[Robert M. Franz (RMF)]

Hello Paul

I have a .NET 2.0 website with a SQL server backend. I want to allow the
user to select a report that will be generated & downloaded to the user on
the fly. The report will be based on a stored Word template/document. The
template/document will include either content controls or mail merge tags to
be replaced by data from the SQL database.

I can use Word 2003 or 2007.

Not sure what that means: are you planning to run Word itself on the
server? Highly discouraged (and unsupported).

I _think_ that generating the Word document in XML on the server and
handing that out to the user (who then needs Word 2003 pro at least)
would be the proper way to do such a thing these days. But since I'm no
developer ... I'd start looking in MSDN.

HTH
Robert