Designing Ad Hoc Reports: Tutorials

You can use the following tutorials to learn about ad hoc reporting features in Reporting Services. The tutorials can help you learn necessary skills for creating reports based on models. For more information about creating report models, see Model Designer How-to Topics. To find more Reporting Services tutorials, see How Do I Find Tutorials (Reporting Services).

  • Tutorial: Creating a Basic Table Report
    Follow the steps in this tutorial to learn how to create a tabular report. This tutorial shows you how to work with Report Builder to select a data source, add fields and entities, and add basic grouping and totals to the tabular report.

  • Creating a Basic Matrix Report
    Follow the steps in this tutorial to learn how to create a matrix report. This tutorial shows you how to work with Report Builder to select a data source and add fields and entities to the matrix report.

  • Creating a Basic Chart Report
    Follow the steps in this tutorial to learn how to create a chart report. This tutorial shows you how to work with Report Builder to select a data source and add fields and entities to the chart report.

  • Creating Advanced Filters and Calculated Fields
    Follow the steps in this tutorial to learn how to create new fields, apply filters to the calculations, and apply a filter to an entire report using Report Builder.

  • Adding a Parameter to a Report
    Follow the steps in this tutorial to learn how to add parameters to a report using Report Builder.

  • Tutorial: Creating Model-Based Reports in Report Designer
    Learn how to use a report model as a predefined dataset for a Report Designer report.