Post reply

SSRS Distribute Report by Person/Report Bursting

  • June 24, 2016 at 9:52 am

    #327395

    Can SSRS send reports out based on manager if that is a group within the report? What I want to do is have a supervisor group then employee, send the report to each supervisor so they only see their employee information.

    Any help would be greatly appreciated.

  • June 24, 2016 at 12:03 pm

    #1886821

    you are looking for a data driven subscription, which is an enterprise feature; are you using SQL enterprise or standard?

    the subscription can use a table or view to feed the parameters like emailaddress,EmployeeId,ManagerId on a per-report basis.

    400 rows in the view=400 separate , individualized emails for example.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • June 24, 2016 at 12:19 pm

    #1886824

    Thank you so much!

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

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