none
how to automate report to be send in email RRS feed

  • Question

  • I m looking for solution tips to automate a payroll report:to be send in email to each employee (100s of them) at the end of a pay period (some weekly, some monthly). SSRS report is obviously custom to each employee retrieved using on emp number containing their own payroll data. What SQL features could be leveraged to build a solution?

    platform:SQL2012 standard edition

    Thanks


    Mahesh




    Sunday, August 21, 2016 1:09 PM

All replies

  • use email subscription

    https://msdn.microsoft.com/en-us/library/ms160334.aspx?f=255&MSPPError=-2147217396


    Please click Mark As Answer if my post helped.

    Sunday, August 21, 2016 1:38 PM
  • Greetings,

    my guess would have been to use a Data-Driven Subscription but that feature is enterprise...so is an upgrade of SSRS possible?

    otherwise I would re-create the feature but as it requires editing variables in the SSRS-database, your best guess would be to google "data driven subscription without enterprise" and review the solutions you find.

    Or for a last resource; create the SSRS report with the variables and just call it by means of powershell / C# to push it into PDF and mail it.

    With regards,

    Sebastian

    Sunday, August 21, 2016 3:38 PM
  • use email subscription

    https://msdn.microsoft.com/en-us/library/ms160334.aspx?f=255&MSPPError=-2147217396


    Please click Mark As Answer if my post helped.

    There are 100s of employees, it would be very difficult and manage so many subscriptions (setting up one for each employee).



    Mahesh

    Sunday, August 21, 2016 4:33 PM
  • Greetings Mahesh,

    data driven subscription allows you to create a query and based on those results to the report-variables. So one data-driven subscription, for 1 payroll report will allow you to mail the report to 100 different users based on the individual employee's data.

    But as it is a enterprise-feature; see my last reply.

    Sebastian

    Sunday, August 21, 2016 4:55 PM
  • Hi Sebastian,

    I understand I may not be able to setup due to limitation of standard edition. But I m curious to learn how is that possible on enterprise edition? Let me know how a custom/paystub report specific to each employee can be sent to that particular employee email using subscription? Only way I understand is we need to setup subs for each employee; unless I m missing something big? Walk me thru steps, if possible.

    The payroll report takes the emp number as parameter and produces the payroll information of that specific employee.

    Thanks in adv


    Mahesh


    Sunday, August 21, 2016 6:05 PM
  • have tried SSIS for sending email.

    http://www.codeproject.com/Articles/85172/Send-Email-from-SSIS-with-option-to-indicate-Email


    Please click Mark As Answer if my post helped.

    Sunday, August 21, 2016 7:50 PM