CODEWITHSUNDEEP
sql-serverssrs-2008reporting-services
JsonStatham
JsonStatham

Reputation: 10364

SSRS snapshot of a report

Is it possible to create a report and have it once a month save to a .pdf or an excel automatically and email out to a list of people as a snapshot, can this be done on express edition, if at all?

Upvotes: 0

Views: 892

Answers (3)

Kyle Hale
Kyle Hale

Reputation: 8120

I realize it is the poor man's solution, but if you are limited to SSRS Express Edition, you can set up a scheduled job (via cron, SQL Server Agent, Scheduled Tasks, etc.) that simply emails out a URL link to the report with various parameters set (or to a snapshot version if applicable) that people can then click on and go to the Report Manager and view.

In a way, this can actually be an elegant solution when your reports require Windows Authentication to filter datasets (for example, when accessing a SSAS cube-based dataset) and it's not secure to have the report run with a stored credential.

Upvotes: 0

Jamie F
Jamie F

Reputation: 23789

As Diego says, you are describing SSRS subscriptions.

Data Driven subscriptions are only available with SQL Server Enterprise edition, and Express does not support any subscriptions:

  • All reports are processed on demand. Scheduled or unattended report processing is not supported.

If you need to use Express edition, then you'll need to build your own solution. But that would probably justify the cost of a standard Sql Server license.

Upvotes: 3

Diego
Diego

Reputation: 36136

what you want is a subscription (probably a Data-Driven Subscription). A subscription can deliver a report at a specific time or in response to an event.

To do that you will need to use stored credentials or no credentials (Windows Authentication is not applicable) because the subscription will run as a background process.

A snapshot is one of the 3 ways of running a report (other than "on demand" and "on demand from cache")

Upvotes: 2

Related Questions