Stack Overflow
Stack Overflow

Questions tagged [ssrs-subscription]

23 questions
0
votes
1 answer

SSRS 2016 - Failure sending mail: The operation has timed out.Mail will not be resent

I am constantly getting the following error when sending out email subscriptions (data driven) at Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.Deliver(Notification…
Harry
  • 2,636
  • 1
  • 17
  • 29
0
votes
1 answer

SSRS automatically creates reports from list

We have distinct list of Party Keys (20000 approx.) and every week we create reports for particular party keys only which has update. Those party keys are stored in Periodic review list. Periodic Review list = Party keys which has update So for…
Addy
  • 36
  • 4
0
votes
0 answers

SSRS Subscription failed

I am trying to find out why am I getting the following Error when I sent out subscription: Failure sending mail: Mailbox unavailable. The server response was: 5.1.1 User unknown. I checked all the Email addresses in the Groups of recipients, they…
Shan
  • 13
  • 7
0
votes
1 answer

Is it possible to send a variable number of emails using SSRS subscription?

I've only ever managed to setup a fixed number of SSRS subscriptions, each corresponding to 1 email, but now I want to be able to send out x emails with different contents, where x is a variable that can be queried out from the DB along with the…
Raina
  • 99
  • 1
  • 2
  • 13
0
votes
1 answer

Could not execute procedure on remote server via Linked server

I triggered a subscription using following query on Server-A using following query and it executes correctly - On Server-A: EXEC ReportServer.dbo.AddEvent @EventType='TimedSubscription', @EventData='452e4a40-7442-4377-abe3-1b96fc953956' However,…
Rameshwar Pawale
  • 632
  • 3
  • 17
  • 35
0
votes
1 answer

How do I create a csv file in SSRS with a .txt extension in the file name?

I have a report where I have added a data driven subscription that writes the report to a folder location on a daily schedule. The report is rendered as csv. the file name comes as MyReport1234.csv. I need this to be Myreport1234.txt. How can I do…
Nandun
  • 1,802
  • 2
  • 20
  • 35
0
votes
1 answer

Error creating a subscription and/or schedule - EXECUTE permission was denied on the object

Trying to create a subscription and/or schedule in reporting services. I keep getting this error when I click ok. What's wrong?
richard
  • 12,263
  • 23
  • 95
  • 151
-1
votes
1 answer

SSRS data driven subscriptions for valid email addresses

We have a tons of daily data driven subscriptions. Sometimes these subscriptions delivery fail due to even a single invalid email address (terminated employee). My question is there any way to create a parameter/code/expression that let's…
Shan
  • 13
  • 7
1
2