O'Reilly logo

Microsoft® SQL Server® 2008 Step by Step by Mike Hotek

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 25 Quick Reference

To

Do This

Configure SSRS

Launch SSRS Configuration Manager. The minimal configuration needs to specify settings for:

  • Web service and Report Manager URL and virtual directories

  • Service account

  • Database

If you want to utilize subscriptions and report snapshots, you need to specify an execution account. If you want users to be able to specify e-mail delivery for a subscription, you will need to specify e-mail settings.

Validate an initial SSRS configuration

Launch Internet Explorer and browse to http://machinename:8080/Reports. to verify that the SSRS Web site displays.

Create a report using a wizard

  • Launch the Report Wizard in BIDS

  • Specify data source settings

  • Enter a query or stored procedure to execute

  • Define a report type, layout, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required