Creating a PDF from a Stored Procedure

  • mivica

    SSC Enthusiast

    Points: 157

    Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/mivica/creatingapdffromastoredprocedure.asp

  • kenwallacedesign

    Old Hand

    Points: 385

    Wow.

    Any idea how well this would scale on a production system?

    Edited by - kenwallacedesign on 08/28/2003 10:09:41 PM

  • bredins

    Mr or Mrs. 500

    Points: 546

    Very nice procedure - but the example data you provide doesn't match the graphs you display as output - or am I missing something?

  • Andy Warren

    SSC Guru

    Points: 119655

    I'll check on it tonight, I think something went wrong in the loading process. Bear with me!

    Just guessing, I think scaling wouldnt be bad as long as the docs werent super huge. Not sure its a good idea to run on a server, but thats another story.

    Andy

    http://www.sqlservercentral.com/columnists/awarren/

  • declanm

    Old Hand

    Points: 352

    Fantastic Stored Proc, however it did start to drive my server hard when I started to increase the calls. Looks like there is a lot of overhead in the OA_create calls.

  • fred2002

    SSCrazy

    Points: 2943

    Great Proc,

    it works very fine!

    Thanks

  • jloesch

    Ten Centuries

    Points: 1004

    Where do you find the specs for the PDF format?

    I would also like to make a suggestion. I personally think that code that is shared with others should be easier to follow. One of the things that helps with that a lot is clear variable names. I have no idea what @cr, @pr, or @ti are for. Comments are also helpful. I'm not complaining, just suggesting.

    James Loesch


    James C Loesch

  • nrharisutarsan

    SSC Enthusiast

    Points: 118

    Excellent!

    Very very cute procedure for creating PDFs.

  • kiran

    SSC Veteran

    Points: 213

    a very good one !!!

  • Kishore.P

    SSCrazy Eights

    Points: 8147

    Very nice work done for PDF.

    Please provide some comments in your procedure for declaring variables for PDF Format.

  • Andy Warren

    SSC Guru

    Points: 119655

    I agree about the comments and I'll take the blame - I load the content, should have gotten it cleaned up. I'll try to do better!

    Andy

    http://www.sqlservercentral.com/columnists/awarren/

  • ivica

    Right there with Babe

    Points: 727

    Where do you find the specs for the PDF format?

    http://partners.adobe.com/asn/tech/pdf/specifications.jsp

  • amfps

    SSC Eights!

    Points: 804

    I've tried and it works quite great.

    However I would like to know if it's possible to use different letter sizes and formats (bold, italic) and if it's possible to save the file in any directory.

  • ivica-105479

    SSC Veteran

    Points: 230

    Now, you can't use different letter properties, maybe later

    to save the file in any directory

    try this EXEC sql2pdf 'backup\demo'

    backup is direcory

  • sokun2003

    Old Hand

    Points: 301

    i have the following error message :

    SYNTAXE ERROR TO CONVERT varchar 'TOTO' TO DATA COLUMN TYPE int...

    when i tried to insert the data into psopdf

    (insert psopdf(code) select nb_client + ' ' +

    tx_shor_name + ' ' +

    tx_full_name + ' ' +

    id_acco_offi + ' ' +

    cd_cli_stat from bdaccess..bsycl)

    do i miss something ?

    tks in advance

Viewing 15 posts - 1 through 15 (of 149 total)

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