Create PDF file from SQL Server data

[Guest]

Hi, all:

I want to create a pdf file with data retrieved from a SQL Server database.
How can I do this? Is there any Acrobat Reader api for doing this? Can I
export data in an Excel workbook to a pdf file? Any help would be apreciated.

Thanks a lot for your help.

 

[Elton Wang]

Hi,

One option is to use crystal report export to pdf file.

Elton Wang
(e-mail address removed)

 

[Mark Fitzpatrick]

There are a number of commercial components that will let you generate PDF
files. There are also several open-source options as well. One of my
favorites is: http://sourceforge.net/projects/itextsharp/

Exporting to Excel won't work as Excel can't save to a pdf without using
Acrobat or another tool.

Hope this helps,
Mark Fitzpatrick
Microsoft MVP- FrontPage