| File Name | Description |
|---|---|
| Session 1: Getting Started with SSRS | |
| SSRS_Session_1.pdf | Presentation for Session 1. |
| SSRS_Session_1_Narrative.pdf | Transcript of presentation for Session 1. |
| SSRS_Lab_1.pdf | Lab 1: Getting Started with SSRS |
| Session 2 - Adding Features to Reports | |
| SSRS_Session_2.pdf | Presentation for Session 2. |
| SSRS_Session_2_Narrative.pdf | Transcript of presentation for Session 2. |
| SSRS_Lab_2.pdf | Lab 2: Adding Features to Reports |
| Accounting_for_the_difference_between_Order_Total_amounts.pdf | Supplement to Lab 2, explains why different Order Total amounts are shown on the Territory Sales and Sales Order Detail reports. |
| For the following files, right-click, use the "Save as" option. | |
| CompanySales.sql.txt | SQL SELECT statement for the Company Sales report. |
| SalesOrderDetail_SalesOrder.sql.txt | SQL SELECT statement for the Sales Order Detail report (header section). |
| SalesOrderDetail_SalesOrderDetail.sql.txt | SQL SELECT statement for the Sales Order Detail report (details section). |
| TerritorySales.sql.txt | SQL SELECT statement for the Territory Sales report. |
| logoback.jpg | Logo for the Company Sales report background image. |
| logofull.jpg | Logo for the Sales Order Detail report. |
| Session 3 - Drilldowns and Charts | |
| SSRS_Session_3.pdf | Presentation for Session 3. |
| SSRS_Session_3_Narrative.pdf | Transcript of presentation for Session 3. |
| SSRS_Lab_3.pdf | Lab 3: Drilldowns and Charts |
| SSRS_Lab_3_Errata_1.pdf | Corrections on pages 7, 34, 35.
Page 7: change EmployeeSalesSummary_TopCustomers.sql.txt to ProductLineSales_TopCustomers.sql.txt
Page 34: change EmployeeSalesSummary_ProductCategories.sql.txt to ProductLineSales_ProductCategories.sql.txt
Page 35: change EmployeeSalesSummary_ProductSubcategories.sql.txt to ProductLineSales_ProductSubcategories.sql.txt
|
| For the following files, right-click, use the "Save as" option. | |
| ProductLineSales_ProductCategories.sql.txt | SQL SELECT statement for the ProductCategories dataset. |
| ProductLineSales_ProductSubcategories.sql.txt | SQL SELECT statement for the ProductSubcategories dataset. |
| ProductLineSales_TopCustomers.sql.txt | SQL SELECT statement for the TopCustomers dataset. |
| ProductLineSales_TopEmployees.sql.txt | SQL SELECT statement for the TopEmployees dataset. |
| tires.jpg | "Tires" jpg (purple bar) for the Product Line Sales report. |
| Session 4 - More about Charts and Visualizations | |
| SSRS_Session_4.pdf | Presentation for Session 4. |
| SSRS_Session_4_Narrative.pdf | Transcript of presentation for Session 4. |
| SSRS_Lab_4.pdf | Lab 4: More about Charts and Visualizations |
| For the following files, right-click, use the "Save as" option. | |
| EmployeeSalesSummary_EmpSalesDetail.sql.txt | SQL SELECT statement for the EmpSalesDetail dataset. |
| EmployeeSalesSummary_EmpSalesMonth.sql.txt | SQL SELECT statement for the EmpSalesMonth dataset. |
| EmployeeSalesSummary_EmpSalesYearOverYear.sql.txt | SQL SELECT statement for the EmpSalesYearOverYear dataset. |
| EmployeeSalesSummary_SalesEmps.sql.txt | SQL SELECT statement for the SalesEmps dataset. |
| logopart.jpg | Partial logo jpg for the Employee Sales Summary report. |
| Session 5 - Basic Deployment to the SSRS Report Server | |
| SSRS_Session_5.pdf | Presentation for Session 5. |
| SSRS_Session_5_Narrative.pdf | Transcript of presentation for Session 5. |
| SSRS_Lab_5.pdf | Lab 5: Deployment to the SSRS Report Server |
| SSRS_Lab_5v2.pdf | Lab 5: Deployment to the SSRS Report Server
This version was posted 2015-06-17, 7:00PM Pacific. It contains corrections for several "typos". There are no other changes to the content. |
| Other Links | |
| Microsoft Links | |
| http://www.microsoft.com/en-us/download/details.aspx?id=42299 | Microsoft SQL Server 2014 Express |
| http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=22 | .NET Framework 3.5.1 SP1 (needed for Windows Server 2008) |
| http://msdn.microsoft.com/en-us/library/dd631854(v=sql.10).aspx | SQL Server 2014 Product Documentation |
| http://msftdbprodsamples.codeplex.com/releases/view/93587 | AdventureWorks Databases downloads site. Go here to download the AdventureWorks2008R2_Database.zip. |
| http://msftdbprodsamples.codeplex.com/releases/view/89245 | AdventureWorks Sample Reports 2008 R2 downloads site. Go here to download the AdventureWorks Sample Reports 2008 R2.zip. |
| http://www.microsoft.com/en-us/download/details.aspx?id=36843 | Microsoft SQL Server Data Tools - Business Intelligence for Visual Studio 2012 |
| http://www.microsoft.com/en-us/download/details.aspx?id=36020 | Update for Microsoft Visual Studio 2012 (KB2781514) |
| http://technet.microsoft.com/en-US/library/dd255291.aspx | Exporting to a PDF File (Report Builder and SSRS) |
| http://technet.microsoft.com/en-US/library/dd255234.aspx | Exporting to Microsoft Excel (Report Builder and SSRS) |
| http://technet.microsoft.com/en-US/library/dd283105.aspx | Exporting to Microsoft Word (Report Builder and SSRS) |
| http://go.microsoft.com/fwlink/?LinkId=112024 | Formatting Types (how to format numeric, date/time values) |
| http://msdn.microsoft.com/en-us/library/ms365170.aspx | Configure a Report Server for Remote Administration |
| http://msdn.microsoft.com/en-us/library/ms160340.aspx | Configure the Report Server Service Account (SSRS Configuration Manager) |
| Other Links | |
| http://www.connectionstrings.com | connectionstrings.com, site that shows connection strings for most databases |
| http://en.wikipedia.org/wiki/List_of_TCP_and_UDP_port_numbers | Wikipedia article, list of TCP and UDP port numbers |
| http://stackoverflow.com/questions/10947098/ssrs-show-hide-parameter-pane-by-clicking-a-button | Stack Overflow article, description of how to programmatically hide/show the parameters panel |
Copyright © 2015, Craig Pelkie, ALL RIGHTS RESERVED
