Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

Is it possible to attach a report from SSRS as PDF and send using sql mail? the server is MSSQL 2000.

share|improve this question

2 Answers 2

up vote 1 down vote accepted

Why not use email delivery built into SSRS? Underneath, this uses SQL Agent anyway.

All versions of SSRS support email delivery. Configuring email delivery for SQL 2000.

For PDF... when you set up the subscription you specify the render format. I can't test this bit, but I assume PDF is supported here because PDF is supported anyway.

BOL link: How to create an e-mail subscription

We've also tested URL Access to generate PDFs followed by using SSIS emailing as attachment to work around some corporate limitations.

share|improve this answer
    
Umm.....Duh......, needless to say I am new to SSRS. –  Christopher Kelly Jul 14 '09 at 11:00

You would need to save the report to the file system (not sure if SSRS 2000 can do that) then pick it up with the SQL Mail job.

Failing that setup a .NET app to connect to the web method that SSRS exposes (this is based on SQL 2005, so hopefully it'll work in 2000) and create the PDF and have the .NET app save it. Then have the next step of the job grab the file and email it out.

I take is SSRS 2000 doesn't support email report delivery?

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.