Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Export Data from SQL to .PDF format

Author  Topic 

drewgeezmoe
Starting Member

22 Posts

Posted - 2007-02-06 : 03:29:28
is there a specific command that can do this using the query analyzer?

Please help me on this.

Thank you.

Your future is made by the things you are presently doing.

Kristen
Test

22859 Posts

Posted - 2007-02-06 : 03:47:18
"is there a specific command that can do this using the query analyzer?"

No.

There are various 3rd party tools that can make a PDF file via "print" - they install as a pseudo print device, and anything you can print can therefore be sent to a PDF file instead.

I use one called pdfFactory, which I'm very happy with, but there are plenty of others

Kristen
Go to Top of Page

drewgeezmoe
Starting Member

22 Posts

Posted - 2007-02-06 : 04:03:09
ok thank you. I was just wondering if that was possible, because it needs to be coded in vb.net and it would be easier if i can export the files directly from sql.

Hope you could give me an alternative for the program that we are developing.

Your future is made by the things you are presently doing.
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-02-06 : 04:43:43
Here is at least an attempt that works.
http://www.msdnbrasil.com.br/secure/sharepedia/arquivos/sql2pdf.txt
and here http://dypso.free.fr/tech/generer_pdf_asp_sql_server_procedure-en.php



Peter Larsson
Helsingborg, Sweden
Go to Top of Page

drewgeezmoe
Starting Member

22 Posts

Posted - 2007-02-06 : 18:44:27
Peso thanks a lot. I will just try the code.

Your future is made by the things you are presently doing.
Go to Top of Page

drewgeezmoe
Starting Member

22 Posts

Posted - 2007-02-07 : 00:31:14
On the link given by peso.. In the stored procedure there is a word "code", does this mean that i have to put my codes here.

Here is an example of what i mean:

INSERT INTO #pdf (code) VALUES ('4' + @beg)

Your future is made by the things you are presently doing.
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-02-07 : 01:39:02
No, code is the column name in the temporary table created for the later output for pdf code.


Peter Larsson
Helsingborg, Sweden
Go to Top of Page

drewgeezmoe
Starting Member

22 Posts

Posted - 2007-02-07 : 01:42:37
Thanks. Its only now I have encountered a stored procedure as long as this.

Thank you very much peso, you have been very helpful.

Your future is made by the things you are presently doing.
Go to Top of Page

jezemine
Master Smack Fu Yak Hacker

2886 Posts

Posted - 2007-02-07 : 02:55:00
it's not so big. i hear there are procs in beasts like SAP that are 20000 lines.


www.elsasoft.org
Go to Top of Page

drewgeezmoe
Starting Member

22 Posts

Posted - 2007-02-07 : 03:00:11
whew thats long...

well my boss just asked me to research on this topic,
to avoid using crystal reports in vb.net to convert sql to pdf.

i dont fully understand this stored procedure yet, im still analyzing it before i go and discuss it with them.

__________________________________________________
Your future is made by the things you are presently doing.
Go to Top of Page

csteve274
Starting Member

3 Posts

Posted - 2012-02-10 : 07:37:28
Hi,

You can download the required tool which deals with pdf. Check for many more softwares and I hope this might help you.


unspammed


Thanks
Go to Top of Page
   

- Advertisement -