This article is a part 2 of series of article on SQL Server Reporting Services. This will help you to get started with SQL Server Reporting Services (SSRS).

1. Getting Started with SSRS – Part 1 – SQL Server Reporting Services Overview and Installing in Windows Server 2008
2. Getting Started with SSRS – Part 2 – Designing a report using Report Wizard
3. Getting Started with SSRS – Part 3 – Designing a report using Report Designer  [more]
4. Getting Started with SSRS – Part 4 – Configuring SQL Server Reporting Services in Windows Server 2008
5. Getting Started with SSRS – Part 5 – Deploying a report to the Server
6. Getting Started with SSRS – Part 6 – Creating Deleting and Moving a folder in SSRS Server
7. Getting Started with SSRS – Part 7 – User Roles and Permissions in SSRS Server
8. Getting Started with SSRS – Part 8 – Show SSRS Report in ASP.NET Web Page
9. Getting Started with SSRS – Part 9 – Creating Matrix Report with inbuilt styles in SSRS
10. Getting Started with SSRS – Part 10 – Creating a Report with Charts and Gauges

Introduction

This article frames a guideline on how to make the use of the Report Wizard and create a simple report using the Business Intelligence Studio. A Report Wizard is the simplest form for creating a readymade report by simply selecting the data that should be displayed and by selecting the inbuilt templates available as per the requirement. Let us now see how to create the reports using the Report Wizard Template of the Business Intelligence Studio.

Steps

The first step towards our task is to open Business Intelligence Studio. To open it, navigate to Programs >> Microsoft SQL Server Denali / Microsoft SQL Server 2008 as per the installed version and then select Business Intelligence Development Studio as shown in the screen below.

Read More