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.

I have a very simple report in SSRS that is just a table with three columns, an object name, client account, and expiration date.

In my report, I include a filter by UserID to limit the data to just the logged in user's client accounts.

I store the user's client accounts in a simple table with domain\alias | client account fields which is populated from a SSIS package.

When an new alias | client account association is entered, I would also like to set up a subscription to the report for this alias so they are notified when it is updated.

Is this possible?

share|improve this question

2 Answers 2

up vote 0 down vote accepted

I'm unable to use data driven reports because I am using userID as a parameter to my reports so what I ended up doing is add a subscribe bit field to my client access table that maps user aliases to client accounts. Then in my package that populates new users/clients, I send out an email to ONLY users associated with accounts that meet a specific criteria.

User's are not able to manage their own subscriptions (which would be nice), but this will be an interim solution that should work great until we investigate our larger needs which will fit in with a billing system.

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.