Well SSRS is stil bugging you huh?
There are a few things you may need to check:
1) Make sure that you’ve stored the credentials of the data source IN the report
2) Since the data-driven subscription is running without an actual user-context, the use of
User!UserID is not allowed.
Start by adding this custom code to your report (under ‘Report Properties‘ -> ‘Code‘):
Public Function UserName()
Now you need the find:
And replace it by:
in the Code-view of the report.