Email without actually opening the Report | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Email without actually opening the Report

I have a report calling method in SQL reporting services which should only generate the reports but without viewing the report it should convert the report in a PDF file and should be available for emailing it. Like the one we have seen in Crystal reports .Action = 1 opens the reports and if we dont call it then too it still generates the report without calling it and is ready to email it.
How would it be done? Thanks in anticipation Satish
In reporting Services that is done by the engine, you should create a subscription and define ist parameters, like schedueling and format. When you define a subscription you can choose PDF format. This has a limitation, the Reporting Services server must have SMTP runnig. Rui Sousa,
correct, you can also use Data driven Subscriptions and Render to PDF or send email directly AKTHAR DILMOHAMUD