Manage Learn to apply best practices and optimize your operations.

Building basic reports in SQL Server 2005

Learn how to use SQL Server 2005 Reporting Services to build a table report and matrix report without the use of the Report Wizard, and get up to speed on two new report types.

From learning about new SQL Server 2005 Reporting Services report types to building reports without the use of the Report Wizard, this collection of book excerpts from Brian Larson's Microsoft SQL Server 2005 Reporting Services 2005 will get you started. It also covers basic report items, including line control, text box control and rectangle control.

Microsoft SQL Server 2005 Reporting Services, Chapter 5, 'Removing the Training Wheels: Building Basic Reports'

Book excerpts:

  1. Transport List Report Task 1: Create the Project
  2. Transport List Report Task 2: Create a Dataset
  3. Transport List Report Task 3: Populating a Table Item
  4. Transport List Report Task 4: Add Table Grouping
  5. Repair Count By Type Report
  6. Transport Information Sheet Task 1 and 2: Create New Report and Dataset
  7. Transport Information Sheet Task 3: Populating a List Item

About the book:

Microsoft's Reporting Services product is a vital part of the SQL Server 2005 business intelligence platform, but it works with virtually any data source. This hands-on guide explains how to transform data into insightful and interactive Web-based reports using Microsoft SQL Server 2005 Reporting Services. With coverage of everything from installation to administration, the book demonstrates how to use this powerful server-based reporting solution to improve business decision-making and facilitate company-wide -- even worldwide -- communication.

Dig Deeper on Microsoft SQL Server Reporting Services (SSRS)

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.