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?
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!