To Create PDF from SQL stored procedure

  • Hello

    I Know how to create PDF file from sql stored procedure, but I want to put an image or a pic into the PDF.

    I hope you guys can help, Thanks.

  • kurt your going to have to provide a lot more information, i think you need to "think outside of the box" on this one.

    you can create a pdf from raw text, I can post an example of that, but as soon as you want formatting/images/ anything other than raw text, you are really talking about using something (Internet explorer for html, excel,word, etc),

    and then converting a saved document from that medium to a pdf. it's something i've done in .NET and other languages, but it's not a one line wonder in TSQL, AFAIK.

    tell us your real requirement...is it a report from Reporting Services you want to pdf for example?

    what are you trying to do specifically?

    Lowell


    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • Hi

  • Hi There

    I really need is send a PDF File with some information, I have a TRIGGER to tell me when the Purchase Order change to approved, so I make the PDF file with the name of the provider and the number, ok. Also I Should want the LOGO of my company into de PDF.

  • That should all be handled by that app that takes the order, not a job for sql server.

  • It Should, but I dont have the code source.

  • not enough information kurt; remember we are not in your cube, looking over your shoulder, knowing what you know.

    a purchase order is a form with a specific layout. it's not some generic object that we know what it looks like in TSQL. where does the purchase order model reside?

    RTF? Word? Quicken? Quickbooks? Great Plains? doesn't your application that takes the orders have the ability to generate/print that document?

    Lowell


    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • Then write a service or another app that process the orders and sends the pdfs.

    That should NOT be handled by SQL Server.

  • I just need when generate mi pdf file from sql server, puta image like background into the pdf. Its that possible?

  • kurtdevotto (3/11/2011)


    I just need when generate mi pdf file from sql server, puta image like background into the pdf. Its that possible?

    no. not possible.

    if it's not raw text, it must be done outside of SQL server if it must be a pdf.

    you could generate an html document in TSQL, with links to images or embedded in an email, but not a pdf.

    Lowell


    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • It is possible and works. The solution is not advanced, but stable. In our company, using SQL is generated thousands of pdf's. TSQL Procedure communicates with Webservice, who runs the Crystal Reports engine. As a result of such a solution we can achieve as a result of the SQL query the PDF document.

  • juratan (2/12/2012)


    It is possible and works. The solution is not advanced, but stable. In our company, using SQL is generated thousands of pdf's. TSQL Procedure communicates with Webservice, who runs the Crystal Reports engine. As a result of such a solution we can achieve as a result of the SQL query the PDF document.

    Heh... not if your Websevice is down or you can't get to the Crystal Reports engine. The OP was asking for a way to do it all from SQL Server. 😉

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.


    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • please may you me send stored procedure code,how generate a pdf in stored procedure , my mail id is pardeepbachhal89@gmail.com please help, n thanks in advance

  • Hello

    If you just want to put an image to pdf ,you can easily and quickly add an image to pdf[/url] Using RasterEdge C# .NET image inserting library control for PDF document,

    Besides,you can not only easily and quickly add an image, picture or logo to any position of your PDF document file, but also customize inserted image settings.

Viewing 14 posts - 1 through 13 (of 13 total)

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