SSRS 2014, Part 07 of 10: Programming Report Access

There are five major APIs that you can use to program report server access, and this course will cover two of them. First, we’ll look at accessing reports using a custom URL, which is the same way Report Manager provides access, although you can use a shorthand version of the URLs for easier programming. You’ll learn the structure of the URL, and see various ways to build the URLs and some of the many options available as querystring parameters. Then you’ll learn about the ReportViewer control that is available in both Web and Windows Forms .NET applications. You’ll learn how to use the control with both server and local reports, which are reports you build directly in Visual Studio for that application.

Lesson 1:

• The Reporting Services APIs
• Accessing Reports Using a URL
• URL Access
• Demo: URL Access
• Shortcut Form
• Demo: Shortcut Form.

Lesson 2:

• Executing a Report with Params
• Demo: Custom Parameters
• Rendering to an Output Format
• Demo: Output Rendering.

Lesson 3:

• Using Report Server Commands
• Demo: Report Server Commands
• Customizing the HTML Viewer
• Demo: Customize HTML Viewer
• Modifying Rendering Behavior
• Demo: Modify Render Behavior.

Lesson 4:

• Demo: Integrate Reporting Services
• Demo: Run Report
• Demo: Views
• Demo: Parameterized Report
• Demo: AWDWModel
• Demo: Options
• Demo: HomeController.

Lesson 5:

• Server vs. Local Reports
• Demo: Server Report
• Demo: Design View
• Demo: How it works.

Lesson 6:

• Demo: SalesChart
• Demo: ReportViewer
• Demo: Code Behind
• Demo: Display Report.

Lesson 7:

• Demo: Server Report
• Demo: Server Report Setup
• Demo: ReportViewer
• Demo: Load Event
• Demo: View Report Control.

Lesson 8:

• Creating a Local Report
• Demo: Dataset
• Demo: Local Report.