Your post is a bit confusing.
Sure you can create a report subscription to export a report as Excel file to a file share; so what's the problem?
https://learn.microsoft.com/en-us/sql/reporting-services/install-windows/subscription-settings-and-a-file-share-account-configuration-manager?view=sql-server-ver15
https://learn.microsoft.com/en-us/sql/reporting-services/subscriptions/file-share-delivery-in-reporting-services?view=sql-server-ver15
SSRS Report - How to save report as excel from Subscription on a schedule
Hi,
I have an SSRS report that was getting email out daily, since microsoft stopped TLS1.0 the mails no longer occur. I simply now need to get that report to save in a folder on the C: of the server, but am unable to find where to do it, and in the report server component none of the usual options are there and the developer took a job abroad and is not replying to any comms from our company.
Please could someone point me in the right direction. Thanks!
SQL Server Reporting Services
3 answers
Sort by: Most helpful
-
Olaf Helper 47,436 Reputation points
2022-03-31T05:57:23.713+00:00 -
Wesley Butler 31 Reputation points
2022-03-31T06:50:33.173+00:00 Hi Olaf -
In the web portal for SSRS there are usually those dropdown options right beside each report from where you can set up a schedule, download and so on - in the instance I am working with these simply are not there, there are only links to get into the reports 'folder' but not one of the links that I can click on have any other options available, nor are they anywhere else on the screen - so I am totally stuck. -
Joyzhao-MSFT 15,631 Reputation points
2022-03-31T07:24:39.747+00:00 Hi @Wes ,
In this case, your TLS/SSL certificate may have expired if your subscription was not delivered correctly.Are you able to open the web portal now?
If you use IIS Express Development Certificate in Configuration Manager, you need to update the binding TLS/SSL certificate, for more information, please refer to: Configure TLS connections on a native mode report server.
If you need to create a new subscription, please refer to: Create and Manage Subscriptions for Native Mode Report Servers.
If I Misunderstand what you mean, please feel free to correct me.
Best Regards,
Joy
If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.