Useful Reporting Services Links (good kickstart with the product)

Reporting Services 2005 useful Links

Written By:

Itay Braun                       Premier Field Engineer - SQL Server and BI                        Microsoft Services - UKE-Mail: itayb@microsoft.com       Mobile: +44-796-928-9996         Blog: http://sqlblogcasts.com/blogs/thepremiers/

Veni              Vidi              Fixit

 

Administration

Administering a Report Server Database

http://msdn.microsoft.com/en-us/library/aa972237.aspx

 Querying and Reporting on Report Execution Log Data

Reporting Services stores execution data across several tables in the report server database. Because the internal table structure does not present report execution log data in a format that is accessible to users, you should extract the log data and store it in a separate local report execution log database.

http://technet.microsoft.com/en-us/library/ms155836.aspx

 Reporting Services Log Files

A report server uses a variety of log files to record information about server operations and status.

http://technet.microsoft.com/en-us/library/ms157403.aspx

 Configuring Reporting Services for Scale-Out Deploymenthttp://sqlcat.com/technicalnotes/archive/2008/06/05/reporting-services-scale-out-architecture.aspx

Webcasts

 Introduction to SQL Server 2005 Reporting Services (Part 1 of 6) (Level 200)

This six-part series presents a comprehensive introduction to Microsoft SQL Server 2005 Reporting Services for developers. This series is heavy on demos and coding, and light on Microsoft Office PowerPoint. No previous knowledge of Reporting Services is required. In the first webcast, we provide an overview of Reporting Services.

We start by using the wizard to build a simple report. Then we learn about the design tools in the SQL Server Business Intelligence Development Studio. Additionally, we learn about report delivery options, including URL access, the Web service, and the Report Builder.

http://msevents.microsoft.com/CUI/WebCastEventDetails.aspx?EventID=1032282905&EventCategory=5&culture=en-US&CountryCode=US

 Introduction to SQL Server 2005 Reporting Services (Part 2 of 6) (Level 200)

This second webcast looks in depth at techniques for delivering canned reports to end users, including URL access, subscriptions, and the Web service. These provide both a push model of report delivery, where a report is automatically delivered, and a pull model, where a user gets a report on an as-needed basis.

http://msevents.microsoft.com/CUI/WebCastEventDetails.aspx?EventID=1032283016&EventCategory=5&culture=en-US&CountryCode=US

 Introduction to SQL Server 2005 Reporting Services (Part 3 of 6) (Level 200)

This third webcast focuses on the Report Builder, a tool for ad hoc reporting. We start by examining the Report Builder Client, the tool that helps end users to create ad hoc reports. Next, we learn about the Report Builder Model Designer, a developer tool that allows creation of the business model that represents the underlying data structure.

http://msevents.microsoft.com/CUI/WebCastEventDetails.aspx?EventID=1032283022&EventCategory=5&culture=en-US&CountryCode=US

 Introduction to SQL Server 2005 Reporting Services (Part 4 of 6) (Level 200) 

In this fourth webcast, we examine some more advanced ideas surrounding report design. Learn how to create tabular reports, matrix reports, linked reports, charts, and sub-reports. This webcast also includes reports that use cascading parameters and dynamic SQL queries.

http://msevents.microsoft.com/CUI/WebCastEventDetails.aspx?EventID=1032283046&EventCategory=5&culture=en-US&CountryCode=US

 Introduction to SQL Server 2005 Reporting Services (Part 5 of 6) (Level 200)This six-part series presents a comprehensive introduction to Microsoft SQL Server 2005 Reporting Services for developers. The fourth webcast in this series delved deeper into advanced reporting designs. This fifth webcast focuses on SQL Server Reporting Services extensibility. We demonstrate a custom data source for SQL Server Reporting Services that reads data that is not accessible through SQL queries. We also demonstrate techniques for including custom code in reports.

http://msevents.microsoft.com/CUI/WebCastEventDetails.aspx?EventID=1032283054&EventCategory=5&culture=en-US&CountryCode=US

 Introduction to SQL Server 2005 Reporting Services (Part 6 of 6) (Level 200)

This six-part series presents a comprehensive introduction to Microsoft SQL Server 2005 Reporting Services for developers.

http://msevents.microsoft.com/CUI/WebCastEventDetails.aspx?EventID=1032283061&EventCategory=5&culture=en-US&CountryCode=US

 More webcasts:·         MSDN Webcast: End-User Ad Hoc Reporting with SSRS (Level 300)·         MSDN Webcast: Integrating Windows SharePoint Services with SQL Server Reporting Services (Level 200)·         MSDN Webcast: Intelligent Reporting: Using the Visual Studio 2005 Report Viewer Controls (Level 200)  


 

 

Virtual Labs:

Last Update 2008-07-02. Check here http://msdn.microsoft.com/en-gb/virtuallabs/aa740409.aspx

 for the complete list of labs

 ·          MSDN Virtual Lab: Business Intelligence Reporting Services ·          MSDN Virtual Lab: Building Integrated Business Intelligence Solutions Leveraging SQL Server 2005 and SharePoint Server 2007 ·          MSDN Virtual Lab: Business Intelligence- Using Business Scorecard Manager 2005 and ProClarity for Performance Management ·          MSDN Virtual Lab: Business Intelligence- Report Builder ·          MSDN Virtual Lab: Business Intelligence- Integration Services ·          MSDN Virtual Lab: SQL Server 2005 Reporting Services ·          MSDN Virtual Lab: SQL Server 2005 Report Builder ·          MSDN Virtual Lab: SQL Server 2005 Report Viewer Controls   

 

Published 01 August 2008 12:22 PM by ThePremiers
Filed under:

Comments

# User links about "reportingservices" on iLinkShare said on 27 April, 2009 07:02 AM

Pingback from  User links about "reportingservices" on iLinkShare

# .NET Reporting Tutorial - Programmers Goodies said on 07 July, 2011 12:58 AM

Pingback from  .NET Reporting Tutorial - Programmers Goodies

Search

Go

This Blog

Tags

Syndication