To Create PDF from SQL stored procedure

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by M Ivica » To Create PDF from SQL stored procedure

13 posts, Page 1 of 2

1 2 »»

To Create PDF from SQL stored procedure

Rate Topic

Display Mode

Topic Options

Author

Message

kurtdevotto

Posted Friday, March 11, 2011 7:42 AM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, May 29, 2012 11:27 AM
Points: 5, Visits: 11

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.

Post #1076869

Lowell

Posted Friday, March 11, 2011 8:02 AM

SSChampion

Group: General Forum Members
Last Login: Today @ 4:59 PM
Points: 11,792, Visits: 28,078

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

--There is no spoon, and there's no default ORDER BY in sql server either.
Actually, Common Sense is so rare, it should be considered a Superpower. --my son

Post #1076894

kurtdevotto

Posted Friday, March 11, 2011 8:16 AM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, May 29, 2012 11:27 AM
Points: 5, Visits: 11

Post #1076907

kurtdevotto

Posted Friday, March 11, 2011 8:22 AM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, May 29, 2012 11:27 AM
Points: 5, Visits: 11

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.

Post #1076911

Ninja's_RGR'us

Posted Friday, March 11, 2011 8:27 AM

SSC-Insane

Group: General Forum Members
Last Login: Yesterday @ 7:02 PM
Points: 21,376, Visits: 9,584

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

Post #1076920

kurtdevotto

Posted Friday, March 11, 2011 8:32 AM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, May 29, 2012 11:27 AM
Points: 5, Visits: 11

It Should, but I dont have the code source.

Post #1076927

Lowell

Posted Friday, March 11, 2011 8:35 AM

SSChampion

Group: General Forum Members
Last Login: Today @ 4:59 PM
Points: 11,792, Visits: 28,078

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

--There is no spoon, and there's no default ORDER BY in sql server either.
Actually, Common Sense is so rare, it should be considered a Superpower. --my son

Post #1076931

Ninja's_RGR'us

Posted Friday, March 11, 2011 8:36 AM

SSC-Insane

Group: General Forum Members
Last Login: Yesterday @ 7:02 PM
Points: 21,376, Visits: 9,584

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

That should NOT be handled by SQL Server.

Post #1076932

kurtdevotto

Posted Friday, March 11, 2011 8:48 AM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, May 29, 2012 11:27 AM
Points: 5, Visits: 11

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

Post #1076950

Lowell

Posted Friday, March 11, 2011 9:36 AM

SSChampion

Group: General Forum Members
Last Login: Today @ 4:59 PM
Points: 11,792, Visits: 28,078

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

--There is no spoon, and there's no default ORDER BY in sql server either.
Actually, Common Sense is so rare, it should be considered a Superpower. --my son

Post #1077001

« Prev Topic | Next Topic »

13 posts, Page 1 of 2

1 2 »»

Permissions