MS Reporting Services Training

Overview

Learn the introductory concepts of report design using database views and stored procedures that extract netFORUM data. This course covers basic formatting, grouping, expression-building, and various aspects of Reporting Services that are pertinent to operation of the formats from netFORUM. Students will also learn how to set up reports in netFORUM, including instruction on dropdown lists and listboxes for prompted parameters.

Duration

Two Days.

Agenda

Part I:

1. Overview

Part II:

1. Stored Procedure
   • Naming conversion
   • permission
2. RDL
   • Create new project
   • Create new shared data source
   • Create new report
   • Create new data source
   • Create new data set
   • Design: Text Box, Line, List
   • Preview
   • Deployment
3. Report Metadata
   • Add Report
   • Run This Report
   • Add link to Report Central

Part III:

1. Stored Procedure
   • parameter
   • null and blank
   • nolock
2. RDL
   • Report Header, Footer
   • Properties
   • Globals Collection
   • Expression
   • List vs Table, vs Matrix
   • Grouping, HTML?
   • Functions, more Expression
3. Report Metadata
   • Add Report Parameter
   • Form link

Part IV:

1. Deployment
2. Advance Example
   • Label Report
   • Dashboard Report
   • Click through Dashboard Report
   • Data Driven Subscription Report

Prerequisites

In order to benefit from this course, the student should have previously taken netFORUM Data Model Training and also have working knowledge of Transact SQL.

Can I take this class even without the prerequisites?