March 11, 2011 at 7:42 am
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.
March 11, 2011 at 8:02 am
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
March 11, 2011 at 8:16 am
Hi
March 11, 2011 at 8:22 am
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.
March 11, 2011 at 8:27 am
That should all be handled by that app that takes the order, not a job for sql server.
March 11, 2011 at 8:32 am
It Should, but I dont have the code source.
March 11, 2011 at 8:35 am
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
March 11, 2011 at 8:36 am
Then write a service or another app that process the orders and sends the pdfs.
That should NOT be handled by SQL Server.
March 11, 2011 at 8:48 am
I just need when generate mi pdf file from sql server, puta image like background into the pdf. Its that possible?
March 11, 2011 at 9:36 am
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
February 12, 2012 at 2:10 pm
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.
February 12, 2012 at 2:50 pm
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
Change is inevitable... Change for the better is not.
March 16, 2012 at 2:35 am
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
September 12, 2013 at 4:05 am
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