Last post May 11, 2009 08:08 AM by mvark
May 11, 2009 04:15 AM|badua|LINK
Everyday I have to make a market analysis report including charts, news and statistics tables. At the moment I have to copy news, statistics items and statistics tables from a Web page that extracted data from a SQL Server 2000 database, then paste them
into a template Word document file, finally print the Word file to a pdf file.
My Word file is formatted using header, footer, watermark,... I am using Micsoft Office 2007.
My question is that "Is there any way to feed a data table directly from a database into a table in a Word file?", and "Is there any software which have formatting features similar to MS Word but have data controls such as GridView in ASP.NET?"
I cannot combine all in an aspx page because when I print a Web page into a pdf file, it is not paged as correctly as when I print a Word file.
Thanks for any help in advance
May 11, 2009 07:59 AM|Nemesis116|LINK
Tbh, I think that you will get yourself into trouble doing it this way.
I suggest you take a look at
Reporting Services for SQL Server.
May 11, 2009 08:08 AM|mvark|LINK
You can generate a Word document programmatically with content from a DataTable using the Office XML & CSS technique explained here -