Emailed Reports

Question

In Reporting Services, My Subscriptions section is empty but I get emailed reports each week. How do I change which reports I get emailed?

Answer 1

"My Subscriptions" only shows ones you created. Yours were set up by someone else (an admin).

In the web portal, open the report then menu then Manage then Subscriptions. This lists all subscriptions on it. With Content Manager rights you can edit them regardless of owner.

Can't find them? In Query ReportServer DB:

SELECT c.Name, s.Description, u.UserName AS Owner
FROM Subscriptions s
JOIN [Catalog] c ON s.Report_OID = c.ItemID
JOIN Users u ON s.OwnerID = u.UserID
WHERE s.ExtensionSettings LIKE '%your.email@domain%';

Edit/delete there, or have the owner/admin do it if you lack rights.

If they're data-driven subscriptions, recipients come from a query, change the source data, not the subscription.

Answer 2

Hi Alice,

If “My Subscriptions” is empty but reports are still arriving, they are probably not subscriptions owned by your SSRS account. They may be data-driven subscriptions or standard subscriptions created by another user or an administrator with your email included as a recipient.

I would ask your SSRS administrator to check the Subscriptions for the reports you are receiving. An administrator with the appropriate permissions can view and manage subscriptions created by other users and can identify which one is sending to your address.

Once they find it, they can change the reports or recipients for you.

Thank you, and feel free to respond back for more assistance.