locked
Request report via email RRS feed

  • Question

  • Is it possible to request report deployed to SSWS via email?

    i.e. I will send email to SQL Server Reporting service, and Reporting service will answer me with attached report - parameter can be put in email subject.

    Tuesday, December 10, 2013 2:41 PM

Answers

  • Nope..Not exactly like that. However you can schedule report based on your convenience and report will get autogenerated and sent as email in desired format (Excel/PDF etc) to a set of receipients. This feature is called subscriptions.

    There are two types of Subscriptions available - static and data driven. static as name implies will work based on statically set values for various properties (format,receipient, etc) while data driven will give you flexibility of making all these dynamic by setting them as values inside a sql server table columns.

     

    Please Mark This As Answer if it helps to solve the issue Visakh ---------------------------- http://visakhm.blogspot.com/ https://www.facebook.com/VmBlogs

    • Proposed as answer by SathyanarrayananS Tuesday, December 10, 2013 4:08 PM
    • Marked as answer by Alisa Tang Wednesday, December 18, 2013 11:39 AM
    Tuesday, December 10, 2013 2:50 PM

All replies

  • Nope..Not exactly like that. However you can schedule report based on your convenience and report will get autogenerated and sent as email in desired format (Excel/PDF etc) to a set of receipients. This feature is called subscriptions.

    There are two types of Subscriptions available - static and data driven. static as name implies will work based on statically set values for various properties (format,receipient, etc) while data driven will give you flexibility of making all these dynamic by setting them as values inside a sql server table columns.

     

    Please Mark This As Answer if it helps to solve the issue Visakh ---------------------------- http://visakhm.blogspot.com/ https://www.facebook.com/VmBlogs

    • Proposed as answer by SathyanarrayananS Tuesday, December 10, 2013 4:08 PM
    • Marked as answer by Alisa Tang Wednesday, December 18, 2013 11:39 AM
    Tuesday, December 10, 2013 2:50 PM
  • No, this feature is not available.
    However, you could develop a third-party application to manage that

    Regards

    Tuesday, December 10, 2013 2:51 PM