SSRS 2008 Architecture Slide

This is a PowerPoint slide I use in my SSRS presentations.  Feel free to grab and use it:

SSRS 2008 Architecture Overview PPTX Screen Shot

Reporting Services Architecture Diagram…

I have a standard diagram that I draw on the board when I teach reporting services classes.  I have lately however been teaching some classes online and drawing this diagram by hand on the screen gets a little tedious.  To simplify my life, I drew it in Visio so I could re-use it.  I am posting it up here so that my students, or anybody else for that matter can grab the diagram and re-use it. 

It represents a typical SQL Server 2005 native reporting services deployment.  This also describes the basic structure of a 2008 install, just replay IIS with HTTP.SYS) I may update it in the future, or create another version to include SharePoint installations. 

Use the links below to download the image.  If you update it, or have suggestions for improving it let me know! 

Reporting Services Overview Diagram for Blog

 icon_zip  Download the original Visio Diagram as well as a JPG and PDF (0.5MB)

SSAS – Report Server Action

I was creating a demo for Actions in SQL Server Analysis Services 2005 (SSAS) and was havingg a problem getting the “Server Name” and “Report Path” properties correct.

I finally got a combination that worked. Here are the values I used for a report named “EmployeeReport” in a folder named “Report Sample” on the local server (localhost)

Server Name: localhost/ReportServer/Pages/ReportViewer.aspx?
Report Path: Report Sample/EmployeeReport

To make this work in your situation you should enter the correct server name instead of “localhost”, annd the appropriate folder path on the report server to the report you want to render.