auto send a report daily

Question

Persad, Davendra 0

how to have a report auto generate to a pdf and emailed to me and the other advisers, every morning.

report in question is the "Service Adviser Performance" report for store 2115, Mercedes Benz of North Orlando.

0 comments

2 answers

Answer 1

Prerequisite: SSRS email delivery must be configured (Report Server Configuration Manager then E-mail Settings then SMTP server).

Create the subscription:

In the SSRS web portal, navigate to the Service Adviser Performance report.
Subscribe (or Manage then Subscriptions then New Subscription).
Delivered by: E-Mail
To: enter your address and the other advisers addresses (semicolon-separated). Cc/Bcc as needed.
Render Format: PDF
Subject: e.g. Service Adviser Performance - Store 2115 - @ReportName @ExecutionTime
Include Report: checked (attaches the PDF).
Schedule: choose On a schedule then create a shared or report-specific schedule
Set any report parameters (e.g. date = yesterday/today) so each run is correct.
Save.

Answer 2

Use an SSRS email subscription on that report so it runs and sends a PDF on a schedule.

Steps (SSRS web portal):

Open the SSRS web portal where the “Service Adviser Performance” report is deployed.
Browse to the folder that contains the report for store 2115 and select that report.
Select Manage for the report.
Go to the Subscriptions tab.
Select New Subscription.
Choose Standard Subscription and set Delivery method to Email.
In the email settings:
- Enter the advisers’ email addresses in the To field.
- Set a Subject (for example, “Daily Service Adviser Performance – Store 2115”).
- Optionally add a message body.
- Choose Render format = PDF.
In the schedule section, configure it to run daily and set the time to “every morning” at the desired hour.
Save the subscription.

Notes:

SSRS uses SQL Server Agent for scheduling; ensure SQL Server Agent is running on the report server.
You can test the setup by manually triggering the subscription from the Subscriptions page.

References: