July 01, 1999 04:01 PM

Querying & Reporting: Generate Reports with Word

Rating: (0)
SQL Server Magazine
InstantDoc ID #5446
The process is easier than you think
Organizations often create applications that serve both internal and external customers. For example, an organization might need to regularly generate customized Word documents for both users and customers. Fortunately, you can use COM objects with Microsoft Office applications. Office lets you drive most of its features from a programming language such as Visual Basic (VB). This compatibility lets you automate almost any task. In this article, I show you how to use VB and Word to create custom reports from a SQL Server database.

...This article is for paid Professional Members only.

Already a Professional Member? Please log in now:

NOT A PROFESSIONAL MEMBER? YOU CHOOSE:

Professional Membership

Monthly

Annual

VIP Membership

Monthly

Annual

Add a Comment

Very good article... thanks for the nnowledge

Curtis9/10/2009 6:09:45 PM


The article is good even though it would help even more if a complete aplication souce could be included on it. For those who don´t know VB well it´s kinda complicate to use the given code and build a usefull aplication... regards...

rodrigo5/26/2004 7:56:13 AM


The article mentions certain lines of code that are not in the download, i.e.
"This data command is based on the SQL statement:
SELECT ProductID, ProductName, UnitPrice, CategoryID FROM Products WHERE (CategoryID = ?) ORDER BY ProductName DESC"

Where is this section and how can I get the COM section?

Shawn4/24/2001 8:44:10 AM


You must log on before posting a comment.

Are you a new visitor? Register Here
GOOGLE LINKS
SPONSORED LINKS
FEATURED LINKS