SQLs Query result in PDF FORMAT

Question

Post reply

SQLs Query result in PDF FORMAT

Subhash-141882

Ten Centuries

Points: 1294
More actions
September 29, 2004 at 6:43 am

#59524

Hi All,

Can we export/write the result set of a query into Adobe's .PDF FORMAT directly using SQL Server.

It will be good, if it happens without using any add-on/3rd party tools. Only SQL Server and Adobe Writer have to use.

Thanks,

Subhash

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Shamshad Ali SSCarpal Tunnel Points: 4822 More actions · Answer 1

I have the same questions since many days, But am now using the SQL Reporting tool, and there is builtin functionality to get the result from browser to PFD/ HTML and email to any where or save etc ...

I had seen once a code to use PDF in QA, but i missed that, its a 6 months old story and i did not get it again.

Shamshad Ali.

AJ Ahrens SSC-Insane Points: 20676 More actions · Answer 2

AJ Ahrens

SSC-Insane

Points: 20676

September 29, 2004 at 8:19 am

#524783

research articles here for sql2pdf:

http://qa.sqlservercentral.com/columnists/mivica/creatingapdffromastoredprocedure.asp

Good Hunting!

AJ Ahrens

webmaster@kritter.net

Shamshad Ali SSCarpal Tunnel Points: 4822 More actions · Answer 3

Thanks for the reply/post. I got it wat i had seen and lost that. It is working fine except i need to embed image in PDF. How can i solve it. I will appreciate if the columnist can help me further in this regards. Also wat if i want to change the font and its colors Bold italic and tables. How to put vertical lines?

That's wat i want finally. Please help.

Thanks in advance.

Shamshad Ali.