Passing user credentials to SSRS subscription


  • This is a combination of an SSRS and Sharepoint question. I'm running Sharepoint 2010 in SSRS intergrated mode. 

    Does anyone know of a way/work around to generated subscriptions based on a user's credential.  So that if user A sucbribes to a report, the report will be deliver with only data that he/she is authorized to see (I have a SSAS cube that uses dynamic security).  I have my subscriptions set up against datasource that use the unattended services which brings back all data regardless of which user has subscribed. Not good :-(

    Anyone have any geneous ideas that they've used to over come this? Thanks in advance

    Wednesday, January 26, 2011 10:07 PM


All replies