MS SQL Server DTS - Output Sql server data to populate PDF forms via vb.net 2003

Author

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

Zadi Friedrich

2005-07-19, 8:24 pm

#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.

Jamie Thomson

2005-07-20, 1:23 pm

Perhaps you could make use of this
http://www.sqlservercentral.com/col...edprocedure.asp

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

"Zadi Friedrich" < ZadiFriedrich@discus
sions.microsoft.com> wrote in message
news:C5D22C32-165D-4755-ADB4- 00D6C27F6147@microso
ft.com...
> #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.
>

Darren Green

2005-07-20, 8:24 pm

In message <C5D22C32-165D-4755-ADB4- 00D6C27F6147@microso
ft.com>, Zadi
Friedrich < ZadiFriedrich@discus
sions.microsoft.com> writes
> #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.
>

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

Sponsored Links