Stack Overflow
Stack Overflow

Questions tagged [ssrs-subscription]

23 questions
2
votes
0 answers

Received duplicate emails SSRS Subscription

I have created the SSRS Subscription in the SSRS 2016 and run this subscription automatically using SQL Server Agent job. The subscription was working fine but from last 3 days, all recipients received duplicate emails. I have checked the report…
Pradnya
  • 21
  • 2
1
vote
1 answer

How do I configure SSRS server to only send a report server URL?

I need to disable the option to attach a report in an SSRS subscription in SQL 2016. The only option that should be available is to send the report URL. SSRS Subscription Setup I am curious how to perform the recommended method from MSDN to…
godfathr
  • 416
  • 5
  • 12
1
vote
1 answer

How to find the error details for an SSRS Data Driven subscription

I have a report in SSRS and I scheduled it to trigger via data driven subscription. After the schedule, I got the status as Done: 3 processed of 5 total; 2 errors. But now I want to know the details of those failed 2 errors? Is there a way to find…
Akhil
  • 41
  • 3
  • 10
0
votes
2 answers

SSRS 2019- Users in Browser Role cannot edit their own SSRS subscriptions

I am using SSRS 2019 version and noticed the issue that users in the Browser role cannot edit their own created subscription. However, they can create and delete their subscription. is there any workaround to allow users to edit their subscription…
Gajendra Singh
  • 61
  • 1
  • 9
0
votes
0 answers

Blanks showing up in SSRS email subscription for items filtered out - Help needed

I have recently adjusted an existing ssrs report to filter out clients that don't hit a certain criteria. When I look at the report on ssrs platform, it looks perfect. but once I send out a PDF from a subscription, the PDF now displays blank…
Kevin
  • 1
  • 2
0
votes
1 answer

Can we send other report file as attachment along with SSRS subscription report?

I have a monthly report which I send to users every month using SSRS subscriptions (delivered by email.) My requirement now is to attach one more report as attachment along with Monthly report. So the user has to receive Monthly report and…
user15795435
  • 1
  • 8
0
votes
0 answers

How can I parse a XML file in R, which has been generated probably using SRSS?

In my job I have to perform some analytics on data shared by external organisation through user access granted on web portal. Various reports are available there, which I can view and download in many formats. Two of these formats are very useful…
AnilGoyal
  • 25,297
  • 4
  • 27
  • 45
0
votes
1 answer

SSRS Subscription using REST API

Can we create/modify SSRS Subscription using REST API as SQL Server Reporting services 2017 supports REST API calls?
sanket
  • 59
  • 8
0
votes
1 answer

SSRS Report Parameter Pick Lists Are Disabled When Creating/Editing Subscriptions

I see a lot of similar questions posted, but none quite exactly like what I am experiencing. The parameter pick lists for the SSRS report work properly when running the report as you normally would, but certain ones do not work when trying to create…
Neil Galloway
  • 141
  • 1
  • 1
  • 5
0
votes
1 answer

Manually Setting SSRS Report Subscription Parameters and Want to Set a Parameter to NULL

I am manually setting and running an SSRS report subscription. It has worked fine up until now, but I need to make a change to the report to set one of the parameters to NULL (this is a valid selection for the parameter to select "All" options of…
Neil Galloway
  • 141
  • 1
  • 1
  • 5
0
votes
2 answers

Data-Driven subscription not working properly

I am using Data driven subscription to send report in Email body and as an excel attachment. In email,I am seeing the report as Body,but report as excel attachment is missing. The requirement is I need report to be send as an attachment and in Body…
AMDI
  • 895
  • 2
  • 17
  • 40
0
votes
0 answers

Rendering spaces in MHTML email body in SSRS subscription

I am trying to send a report using SSRS subscription which includes a text with spaces in between as shown in the picture. The problem is the spaces are ignored and my formatting is disturbed, but when I render as PDF/ WORD format the spaces are…
Pankaj hamilpurkar
  • 1
  • 1
0
votes
0 answers

Opening Visual Studio 2015 files with Visual Studio 2019 Commun

Hi I am attempting to open my files created in Visual Studion 2015 in Visual Studion Community Edition 2019. It tells me it can't find the application despite that I have installed any relevant extension like Reporting Services etc. Does anyone else…
Charlotte Bjuren
  • 1
0
votes
0 answers

Failure writing file : Report processing has been canceled by the user

I have multiple report running by creating subscription. All reports are generating PDF files to the given drive. However, one report having error: Failure writing file Filename@timestamp : Report processing has been canceled by the…
AskMe
  • 2,495
  • 8
  • 49
  • 102
0
votes
1 answer

rsElementTypeMismatch error When I Edit Subscription

I updated the scheduling options in Step 7 of a data-driven subscription. The subscription did not execute at the specified time - no error message was displayed. When I clicked "Edit", the following message appears: "The value provided for the…
jack of too many trades
  • 21
  • 2
1
2