InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 18 May 2013 09:09:03 GMT20http://www.sqlservercentral.com/Forums/Topic1076869-126-1.aspxplease 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 advanceFri, 16 Mar 2012 02:35:53 GMTpardeepbachhal89http://www.sqlservercentral.com/Forums/Topic1076869-126-1.aspx[quote][b]juratan (2/12/2012)[/b][hr]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.[/quote]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. ;-)Sun, 12 Feb 2012 14:50:26 GMTJeff Modenhttp://www.sqlservercentral.com/Forums/Topic1076869-126-1.aspxIt 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.Sun, 12 Feb 2012 14:10:16 GMTjuratanhttp://www.sqlservercentral.com/Forums/Topic1076869-126-1.aspx[quote][b]kurtdevotto (3/11/2011)[/b][hr]I just need when generate mi pdf file from sql server, puta image like background into the pdf. Its that possible?[/quote]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.Fri, 11 Mar 2011 09:36:02 GMTLowellhttp://www.sqlservercentral.com/Forums/Topic1076869-126-1.aspxI just need when generate mi pdf file from sql server, puta image like background into the pdf. Its that possible?Fri, 11 Mar 2011 08:48:43 GMTkurtdevottohttp://www.sqlservercentral.com/Forums/Topic1076869-126-1.aspxThen write a service or another app that process the orders and sends the pdfs.That should NOT be handled by SQL Server.Fri, 11 Mar 2011 08:36:23 GMTNinja's_RGR'ushttp://www.sqlservercentral.com/Forums/Topic1076869-126-1.aspxnot 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?Fri, 11 Mar 2011 08:35:40 GMTLowellhttp://www.sqlservercentral.com/Forums/Topic1076869-126-1.aspxIt Should, but I dont have the code source.Fri, 11 Mar 2011 08:32:33 GMTkurtdevottohttp://www.sqlservercentral.com/Forums/Topic1076869-126-1.aspxThat should all be handled by that app that takes the order, not a job for sql server.Fri, 11 Mar 2011 08:27:41 GMTNinja's_RGR'ushttp://www.sqlservercentral.com/Forums/Topic1076869-126-1.aspxHi ThereI 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.Fri, 11 Mar 2011 08:22:12 GMTkurtdevottohttp://www.sqlservercentral.com/Forums/Topic1076869-126-1.aspxHiFri, 11 Mar 2011 08:16:20 GMTkurtdevottohttp://www.sqlservercentral.com/Forums/Topic1076869-126-1.aspxkurt 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?Fri, 11 Mar 2011 08:02:22 GMTLowellhttp://www.sqlservercentral.com/Forums/Topic1076869-126-1.aspxHelloI 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.Fri, 11 Mar 2011 07:42:22 GMTkurtdevotto