auto generating reports

Heather Ruelas 0 Reputation points

is there a way to set up scheduled times for reports to pull and send to email addresses?

0 comments No comments
Sign in to comment

Answer recommended by moderator

Shruti Dhruv 875 Reputation points • Microsoft External Staff • Moderator

Hi Heather Ruelas,

SQL Server Reporting Services (SSRS) has a built-in feature called subscriptions that allows you to schedule reports to run automatically and send them to specified email addresses.

1.Navigate to the report you want to schedule.
2.Click on the report → Manage → Subscriptions → New Subscription.
3.Choose Standard Subscription and then select Email as the delivery method.
4..Define when and how often the report should run (daily, weekly, monthly, etc.).
(SSRS uses SQL Server Agent for scheduling, so make sure it’s running)
6.Save the subscription and test it by running manually or waiting for the schedule.

Hope this helps!
Thank You for reaching out on Microsoft Q&A Forum

  1. Shruti Dhruv 875 Reputation points • Microsoft External Staff • Moderator

    Hi Heather Ruelas,

    Just wanted to check if the explanation helped you address the query?
    If you have any questions, you can reach out here in comments.

    Thank You

Sign in to comment

1 additional answer

  1. AI answer

    Yes, you can set up scheduled times for reports to be generated and sent to email addresses in SQL Server Reporting Services (SSRS). Here’s how you can do it:

    1. Configure Email Settings: First, ensure that the email delivery extension is configured using the Reporting Services Configuration Manager. You need to specify the SMTP server and sender address.
    2. Create a Report Subscription:
      • Sign in to the Operations console with an appropriate account.
      • Navigate to the Reporting workspace and select a report you want to schedule.
      • Right-click the report and select Schedule.
      • In the Subscribe to a Report Wizard, you can specify the delivery method as Report Server E-Mail and enter the email addresses for the recipients.
      • Set the schedule for when you want the report to be sent.
    3. Verify the Subscription: After creating the subscription, ensure that it is successfully created by checking the Subscriptions node in the Reporting workspace.

    This process allows you to automate the generation and delivery of reports via email at specified intervals.

    References:

    AI-generated content may be incorrect. Read our transparency notes for more information.
Sign in to answer

Your answer