Getting Started with Adobe After Effects - Part 6: Motion Blur


Upload Image Close it
Select File

This tutorial will help you to get started with SQL Server Reporting Services (SSRS)

Getting Started with SSRS (SQL Server Reporting Services)

Getting Started with SSRS - Part 2 - Designing a report using Report Wizard

Nov 11 2011 12:00AM by Karthikeyan Anbarasan   

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.

Launching SQL Server Business Intelligene Studio

This will open Visual Studio. Visual Studio is a Business Intelligence Development Studio for SQL Server and looks as shown in the screen below.

SQL Server Business Intelligence Studio

Next, select File >> New >> Project to create a new project. We can even use the shortcut Control + Shift + N directly as shown in the screen below.

Creating a New Project

Once a new project is selected, a list of templates will be available as shown in the screen below.

List of Business Intelligence Templates

As we are in Business Intelligence Studio, the list of template will not have the normal templates (C#, VB.Net, Office etc).

Now the next step is to create a report using the Report Wizard. To do this, select the Report Server Project Wizard as shown in the screen below.

Selecting the new Report Server Project

Once we select the Report Wizard and provide a valid name to the project as shown in the screen above, click on OK to create the project. Once the project is created, we can see a screen as shown below.

Report Server Wizard Launched

This is the start-up screen. To stave off the start up screen in the future, we can select the option “Don’t show this page again”. Once we are done with the above changes, click on the Next button to proceed further.

Now we can see a new window requesting for the data source input details. In this input request, we can either configure a shared data source or create a new data source as per the requirement. In our example, we will create a new data source as shown in the screen below.

Selecting New Datasource

Next, click on the Edit button and edit the connection string to connect to the database from which the data has to be retrieved to present in the reports. On clicking Edit button a window will open as shown in the screen below.

Selecting the Database

Once we have provided the above details (It may change as per your system database), click on Test Connection to test if the connection is successful. Once the connection is successful, click on OK and we can see the window as shown in the screen below.

Data source Connection string created

Clicking on Next button will move to the next step in the wizard, which is the Query Builder. With this Query builder, we can build our query based on the requirement of the report. We can use this screen in the same manner as we write a query in a Query Analyzer as shown in the screen below.

Query String window

To make use of the query builder click on the Query Builder button. It will open a new window as shown in the screen below.

Query builder launched to preview the data

Now, a query has to be written to pull up the record as shown in the screen below. Once the query is written, click on the Execute button. This will give complete details of the data for our reference to finalize the query. We can do as many executes as required to get a final data as per the business requirement. This is shown in the screen below. Once done, click on OK to close this window and navigate back to the wizard.

Expected result of data query

This will load the query that we selected back in the wizard as shown in the screen below. Now click on Next to proceed further.

Final query used to fetch data for Report

Now we can see an option to select the format in which the data can be displayed. The Wizard has two options (Tabular and Matrix) that can be used based on the requirement.

Selecting the Report Type

Once we select the required format and click on the Next button, we will get a window to select fields that has to be displayed. Here we have more control over the data display, such as; we can select the data that should be displayed at the header or to group the data in a particular format as shown in the screen below.

Selecting the Report data columns

Once selected, click on the Next button to move to the next screen. The next screen allows selecting the layout of the report as shown in the screen below.

Selecting the Table Layout

Selecting Stepped option and clicking on the Next button will open a new window to select the style. This will allow us to display the report with a good look and feel. The report wizard displays a list of styles available as shown in the screen below. Select the required style and click on Finish button to complete the wizard.

Selecting the Table Style

A summary of the options selected will be presented with the data source as shown in the screen below. Click on Finish button to complete the process.

Summary of the Report Server Wizard

Clicking on Finish button will open the report in the designer view of the Business Intelligence Development Studio as shown in the screen below.

Report Designer window launched

Now Press F5 or hit the Play button from the tool bar to start building and executing the report. Once the process is started and we can see the report generation in progress as shown in the screen above.

Reporting getting generated

Once the report generation is completed, we can see report in a nice format as shown in the screen below, which is also our expected output.

Final Report launched

Summary

Therefore, in this article we have seen how to create a report in SQL Server Reporting Services using Business Intelligence Development Studio Report Wizard template.


Karthikeyan Anbarasan
52 · 4% · 1176
9



Submit

6  Comments  

  • Hi karthik

    How to accept user input eg: like From and To dates or other filtering conditions using wizard.

    Thanks & regards Deepak

    commented on Nov 25 2011 6:34AM
    Deepak kelath
    213 · 1% · 222
  • Hi Karthik

    Thanks for nice explanation, plz post somethings for the hosting part as well so that, we can allow other user to see this app.

    Thanks and Best of Luck ! Raghu

    commented on Nov 30 2011 7:06AM
    Raghunath Bhandari
    189 · 1% · 253
  • Dear Karthikeyan Anbarasan,

    Thank you very much for this fantastic article. The explanation is so easy and appropriate. But one thing i would like to know that should i edit the Report Wizard. I found everything except the edit of report wizard. Please guide me as soon as possible.

    Thanks and regards, Saikat malakar.

    commented on Oct 15 2012 7:59AM
    saikatmalakar
    2826 · 0% · 4
  • Hi Karthikeyan,

    How to edit the report. Lets say I have selected matrix and later I want tabular report?

    commented on Dec 26 2012 4:41AM
    ojha2005
    1129 · 0% · 23
  • Hi Karthikeyan,

    Nice explanation and easy to understand.

    Thanks for your post.

    commented on Feb 8 2013 9:57AM
    Bala Krishna
    84 · 2% · 676
  • Hi Ojha2005,

    Later if you want to change it to tabular report, you can. In Design you can do modification what ever you want just like simply remove the Matrix report and drag the drop the tabular report and do necessary alignment.

    Note: We need to edit from Design plan only, i mean we can not go back and edit using Report Server Project wizard.

    I know its too late to reply to your question, hope it will give some idea.

    Thanks

    commented on Feb 8 2013 10:04AM
    Bala Krishna
    84 · 2% · 676

Your Comment


Sign Up or Login to post a comment.

"Getting Started with SSRS - Part 2 - Designing a report using Report Wizard" rated 5 out of 5 by 9 readers
Getting Started with SSRS - Part 2 - Designing a report using Report Wizard , 5.0 out of 5 based on 9 ratings
    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]