Blog 

How many types of subscriptions are there in SSRS?

Kobe Glover

How many types of subscriptions are there in SSRS?

two types
SSRS allows you to create two types of subscriptions, i.e., standard subscriptions, and data-driven subscriptions. Having this kind of flexibility in SSRS subscriptions caters to all businesses and helps in their decision-making.

How do I set up subscriptions in SSRS?

To create an e-mail subscription. Browse the web portal of a report server (SSRS Native Mode). Navigate to the desired report. Right-click the report and select Subscribe.

What is SSRS report subscription?

Subscriptions are useful in SQL Server Reporting Services (SSRS) for report scheduling and delivering reports as per a defined criterion. Users might want the reports in a specific format such as Word, Excel, HTML, PDF, etc. In this tip, we are going to explore different subscription options for SQL Server 2019 SSRS.

How do I check my SSRS subscription errors?

Finding Report Subscription Errors

  1. Find the Trace Log. The Trace log files can be found on the SharePoint server, usually here: C:Microsoft SQL ServerMSRS10_50.MSSQLSERVERReporting ServicesLogFiles.
  2. Find the ScheduleID for your Subscription.
  3. Search for the ScheduleID in your Trace Log and find the Error message.
  4. Credits.

How do I stop SSRS reports subscriptions?

How to Cancel a Data-driven Subscription

  1. Open the RSReportServer.
  2. Find IsNotificationService.
  3. Set it to False.
  4. Save the file.
  5. In Report Manager, delete the data-driven subscription from the Subscriptions tab of the report or from My Subscriptions.
  6. After you delete the subscription, in the RSReportServer.
  7. Save the file.

What is difference between standard and data driven subscription in SSRS?

There are two main flavors of SSRS Subscriptions: standard and data-driven. It should be noted that data-driven subscriptions are only available in Enterprise Edition. The main difference between them is that with data-driven subscriptions you can use a query as a source for the report parameters.

What are the two methods of delivery for report subscriptions?

Subscriptions in SSRS supports two types of Delivery options: Windows File Share, and Email.

How do I enable my email subscription in SSRS?

To configure email settings in SSRS:

  1. Open the Reporting Services Configuration Manager and click E-mail Settings.
  2. Specify the email address, SMTP delivery method, and SMTP server information and click Apply.

How do I change owner in SSRS?

In a similar way, SSRS 2016 now allows you change the owner of a subscription. However, to change the subscription ownership you need to actually select and then edit each individual subscription. Subsequently, as displayed below, on the edit subscription screen you can insert the new owner for that job.

Can SSRS reports be scheduled?

Generally, SSRS subscriptions allow the user to create reports without interacting with Report Manager, BIDS or Report Builder. Shared schedule can be created if you want to use the same schedule information for many reports or subscriptions.

What is the report subscription option in SSRs?

Report Subscription is a powerful option available in SQL Reporting Services. SSRS subscriptions allows the user to generate reports without interacting with Report Manager, or Report Builder, or BIDS.

Where to find Windows file share subscription in SSRs?

Once you select the Windows File Share option, the Report manager will display the following page. And the properties of this Windows File share subscription in SSRS are: Path: Specify the Network path where you want to save the Report.

Where to find the report size in SSRs?

Under the SSRS properties tab, it will show the Report Created user, created and modified dates, and the Report size. Please navigate yourself to the Subscriptions tab and select the New Subscription option in SSRS. Once you choose the New Subscription option, the report manager will navigate to the following page.

How are subscriptions processed in the report server?

Delivery extensions. Subscriptions are processed on the report server and are distributed through delivery extensions that are deployed on the server. By default, you can create subscriptions that send reports to a shared folder or to an e-mail address.