#1 (Rate This Post) Yesterday, 09:55 PM
mpoincare
Member Join Date: Nov 2002, Posts: 47
Reputation:

Output Sql server data to populate PDF forms via vb.net 2003

--------------------------------------------------------------------------------

Hi everyone,
I am building a small program that will connect to a sql server 2000
database,select data from two tables and use the content of that query to
populate a predefined PDF form. I need to know three things:
1- How can I implement that feature through Vb.net 2003?
2- Can I just do that from the SQL Server database 2000?
3- Can Ms access 2000 output the content of table or query as PDF? or Can we
use the content of a Ms access query to populate a predefined PDF form?
Your help is very appreciated.

Perhaps you could make use of this
http://www.sqlservercentral.com/colu...dprocedure.asp

Regards
Jamie Thomson
An SSIS blog - http://blogs.conchango.com/jamiethomson/


"Zadi Friedrich" <ZadiFriedrich (AT) discussions (DOT) microsoft.com> wrote

In message <C5D22C32-165D-4755-ADB4-00D6C27F6147 (AT) microsoft (DOT) com>, Zadi
Friedrich <ZadiFriedrich (AT) discussions (DOT) microsoft.com> writes
To use an existing form, then you'll probably need a PDF toolkit type
component to talk to the form fields. ActivePDF supports this, I seem to
remember.

A more SQL Server centric way might be to use SQL Server Reporting
Services, and generate a fresh PDF based on a report template, but that
may not be an option.


--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org