Creating a PDF from a Stored Procedure in SQL Server

Question

Creating a PDF from a Stored Procedure in SQL Server

Viewing 15 posts - 91 through 105 (of 152 total)

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

Baldassarre Cesarano SSC Journeyman Points: 87 More actions · Answer 1

Link error:

The current link to "SQL2PDF.TXT" (http://www.sqlservercentral.com/columnists/mivica/files.zip) does not point to a zip containing the file "sql2pdf" s.p. creation but a "psoHTML"

I have found it in

www. tiantiansoft. com /bbs /dispbbs.asp ? boardID=66&ID=15478&page=119

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

Francisco Rodriguez-252375 SSC Enthusiast Points: 162 More actions · Answer 2

mivica (7/27/2003)
Comments posted to this topic are about the content posted at

Hi, Masar.

Great article but, the samples file doesn't match the article.

When I point to the SQL2PDF.TXT link, I download a files.zip file that doesn't contain a reference to sql2pdf (it has some graphics and a text file with a procedure psoHTML).

Where can I get the SQL2PDF proc ?

Thank a lot.

BR,

Francisco J.

Steve Jones - SSC Editor SSC Guru Points: 736183 More actions · Answer 3

Sorry, that was for another article. The link has been fixed to that procedure.

Steve

Francisco Rodriguez-252375 SSC Enthusiast Points: 162 More actions · Answer 4

Thank you Baldasarre and Steve.

Have a great day!

BR,

Francisco J.

llw Valued Member Points: 58 More actions · Answer 5

Has anyone tested this with a BLOB datatype. I have a need to use this and it works well, but I need to include an image for a certificate logo

delaneyd11 Valued Member Points: 59 More actions · Answer 6

anyone have the code for a page break for the insert statement? That way several pages could be generated via the psopdf table extract to pdf.

so instead of..

INSERT psopdf(code) SELECT SPACE(50) + '5250.0'

maybe ...

INSERT psopdf(code) SELECT PAGEBREAK

(even though this doesn't work)

suggestions??

paulmarc Mr or Mrs. 500 Points: 518 More actions · Answer 7

Masar,

Thanks so much! This will work nicely for us. I must say a little over my head at this point. I will dig in and try to understand what I can. We would like to modify it to display in landscape. I am presenting a long string and want to make sure each record fits on one page.

Paul

kristine1991 Grasshopper Points: 13 More actions · Answer 8

First of let me say THANKS!!!!!!!!!!!!!!!!!!!!!!!!! This is freaking awesome.

I have been able to modify to work with an existing table & my variables, using the sp in a dts package to create batch pdf reports for invoices & statements.

The only thing that would make this better is to be able to change to landscape - I saw a few people ask if there was a way to send as a landscape page.

Has anyone figure out how to use landscape.

paulmarc Mr or Mrs. 500 Points: 518 More actions · Answer 9

paulmarc

Mr or Mrs. 500

Points: 518

October 21, 2010 at 7:11 pm

#1240671

Agreed! I would love to see that as well..

rickee.blog Valued Member Points: 68 More actions · Answer 10

if i insert about 1000 records it gives error

there was a error reading this document (14)

pls find out the attachment

vatspoonam SSC Enthusiast Points: 110 More actions · Answer 11

Hi. I tried this stored procedure and the example given. In Sql Server 2005, it runs fine but i m not able to locate the file("demo2" in this case) created.

I even searched it but no result found.

Please tell me where is the file created and how can i locate that.

vatspoonam SSC Enthusiast Points: 110 More actions · Answer 12

I changed the directory to D: in the following line...

SELECT @pdf = 'D:\' + @filename + '.pdf'

Its working fine now.

Great work done by the creator of this sp!!

rborman Valued Member Points: 69 More actions · Answer 13

this script creates extra overhead. how do you prevent the extra overhead? file sizes are increased by 60% at least because of this.

ideas?

jalpaeol-913130 SSC Enthusiast Points: 136 More actions · Answer 14

i dont know why but it's not working for me menas not creating pdf file even no any errors saw to me any idea

please help me

jalpaeol-913130 SSC Enthusiast Points: 136 More actions · Answer 15

Hi

Could you reply me quick

this sp not working for me

any idea about it

it not display any error but also not creating pdf file for me

please help me it's urgent

Thanks in advance