From the course: SQL Server: Reporting Services
Join today to access over 22,700 courses taught by industry experts or purchase this course individually.
Subscribe to a report - SQL Server Tutorial
From the course: SQL Server: Reporting Services
Subscribe to a report
- [Instructor] At the moment, anyone that wants to view a paginated report needs to login to the server and locate the one they want. To make things easier, users can subscribe to a report, and have it delivered right to their email inbox, or exported to a file share on a recurring schedule. I'd like that to happen with the People report. To set this up you'll click the ellipses button in the upper right hand corner and choose Manage. Then we'll switch to the Subscriptions page. If you have Subscriptions already created, then you'll see them listed and you can manage them from here. To create a new subscription, press the button along the top, and you'll see this error. It says that a subscription can't be created because the credentials are not stored. So what does this mean? Well every time we run a report, it uses the credentials of the logged in user to fetch the data from SQL Server. Because a subscription will require the report server to go and collect the data on its own…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.