Can I create PDF files with SQL Server??

Question

Can I create PDF files with SQL Server??

herrerae

Newbie

Points: 6
More actions
March 9, 2010 at 6:46 am

#217510

I'm a little new to SQL Server so I'm not to sure what it can and can't do just yet. So I was hoping someone could tell me if there was a feature in SQL server that I could use to create PDF files. Currently I use Access 2007 to create these files. Is there any way to do this through SQL Server?
Thanks
Ed

Viewing 8 posts - 1 through 8 (of 8 total)

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

Steve Jones - SSC Editor SSC Guru Points: 738693 More actions · Answer 1

Reporting Services will allow you to do this. You would have to install it and create a report, but those can be saved as PDFs.

http://msdn.microsoft.com/en-us/library/ms159273%28SQL.90%29.aspx

herrerae Newbie Points: 6 More actions · Answer 2

herrerae

Newbie

Points: 6

March 9, 2010 at 7:20 am

#1130641

Great!! Thanks

herrerae Newbie Points: 6 More actions · Answer 3

would it be better to use this reporting system or crystal reports? or are they basically the same?

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 4

Reporting Services comes with SQL Server 2005, why spend more money on Crystal Reports?

herrerae Newbie Points: 6 More actions · Answer 5

very true, but I figured I could entertain my boss and give him other pros and cons between the two.

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 6

Both have pro's and con's. In the environment I work, cost saving is important, especially since they are looking at trimming 11 to 18 million from next years budget.

Steve Jones - SSC Editor SSC Guru Points: 738693 More actions · Answer 7

Crystal works, but check and see if does something you really need that SSRS can't do before you spend the $$$.

If you can move to SQL 2K8, or SS2K8 R2, SSRS is greatly enhanced.