Generate pdf

  • Hi friends,

    We need to create a pdf file from SQL server preferably from a stored procedure. Application will call the stored procedure and it should generate pdf. From my research it appears it can be done using various external tools with licensing/costs. But is it possible to do this within sql server database without additional costs? I read that this can be done by SSRS in SQL server but not sure if it is a good solution and if it is additional licensing..

    Please help. THank you so much

  • Would this help?

    http://www.sqlservercentral.com/articles/Miscellaneous/creatingapdffromastoredprocedure/1104/



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • it SO depends on what you want to export.

    what is actually in the PDF? a tablular looking/rows and columns? colored headers?

    it's very easy to export to HTML from SQL, as that's text based; pdf is much more difficult.

    with a rare exception of REALLY simple data(pure ascii text, space delimited, never more than say, 100 characters wide),search for SQL2PDF),

    generally, pdf is done outside of SQL, since there's a bit of work to determine the report/formatting. there's lots of possibilities, like creating a service that polls a table for queries, and the queries get dumped into somethign like a DevExpress XtraGrid, which has built in export functions to pdf and other formats.

    all that can be automated by someone with some damn good vb.net/c#.net skills.

    any solution i can think of requires some sort of third party tool; pdf metamorphosis, etc., but the right toold depends on the requirements.

    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!

  • Thank you so much for your replies. As of now, we are just discussing the possibilities and availability of the tools/costs etc so I'm not able to look out in a confined manner. From the solutions you have noted, I believe SQL2PDF may be not for us... How about the SQL Server Reporting Services, is it a feature included with the SQL Server database environment or to be purchased seperately?

    THanks for your help

Viewing 4 posts - 1 through 3 (of 3 total)

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